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: 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.
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.