Executing SQL by attaching code to click() method

Executing SQL by attaching code to click() method

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?

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.

See also  Why ChatGPT Is So Important Today

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist