Visual SQL and Database Elements

This topic describes the limitations of using Visual SQL when creating database elements for mobile applications in the Database Element wizard.

Using the Visual SQL painter, you can write a query(SELECT statement) and use the visual SQL to edit it. The query written could have an @OP syntax of:

"SELECT au_id  FROM authors  WHERE 
            		( au_id =@OP["my_au_id"= "175"]) AND 
            		( au_phone =@OP["my_au_phone"= "1002004755" ]) AND  
            		( au_lname="White" )  AND  
            		( au_fname='@OP["my_au_fname"="Jim "]    ' ) AND 
            		( au_address="Address White" ) AND 
            		( au_state='@OP["my_au_state"="ca"]' )

Note

If the @OP entry is a numeric, it must be in the form:

sqlColumn = @OP["name"= "value"]

If it is a string it must be in the form:

sqlColumn = '@OP["name"= "value"]'

Notice the single quotes.

Creating Database Elements