Forum Stats

  • 3,750,526 Users
  • 2,250,188 Discussions
  • 7,866,998 Comments

Discussions

in forms12c in the datablock if you have where clause only followed by other sql statement

user4877447
user4877447 Member Posts: 1 Red Ribbon
edited May 14, 2021 5:13PM in Forms

in forms12c in the datablock property pallete if you have where clause only followed by other sql statement  in the next line, execute query fails. did anybody face this and any solution for this.

for example

this gives error

where

1=1

and 2=2

this works

where 1=1

and 2=2

Answers

  • Michael Ferrante-Oracle
    Michael Ferrante-Oracle Senior Principal Product Manager USMember Posts: 6,803 Employee

    In the future, please be specific when mentioning the version(s) you are using. Also, it is unclear what you are saying. Can be please describe exactly what you are doing or share working example code and indicate how/where you are inserting it into the form?