devxlogo

Executing SQL by attaching code to click() method

Executing SQL by attaching code to click() method

Question:
Power Objects to Oracle 7 server query…

I thought this would be straightforward. I havea simple query to perform when the button isclicked — find and load info. on this id.
code attached to click() follows:

exec sql at session# select * from tablename whereid = some id #
It does nothing, and returns noerror, yet the initial form load shows everythingwith the scroll. Can you suggest anything?

Answer:
I’m not sure what you mean by “returns no error.” The EXEC SQLcommand never returns an error — you have to explicitly use theSqlErrCode to find out if it executed correctly.

It sounds like you are trying to use the EXEC SQL command topopulate objects on a form. You can’t do that with the EXEC SQLcommand.

Try binding the objects to the table and setting theDefaultCondition to apply your selection condition.

devx-admin

Share the Post: