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 #

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.

Charlie Frank

Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.

See also  Five Early Architecture Decisions That Quietly Get Expensive

Related Posts

• Fei-Fei Li: AI Pioneer and Visionary Author
• How to Compute the Fibonacci Number Recursively
• Optimize ng-repeat with the Track by Feature in Angular
• OurSky Raises Funds for Telescope Network Expansion
• Kaspi.kz Pursues US IPO, Targeting Global Expansion