All,
We have developed an ADDIN that fetches information from database into a gridview. So far ADDIN prompts user for Database connection details and forms a OLEDB connection string to connect to the database.
I would like to know of any API or Database Key-in Utility to execute SQL's using the default Oracle Connection. Could someone help me out on this?
In the MicroStation MDL API you could use the mdlDB_processSQL function to submit general non-SELECT SQL statements to the database server.
You can also use SQL pass-thru processing by forming a keyin that starts with the pipe (vertical bar "|") character such as follows:
|update myTable a set a.myValue=100 where a.myKey=1;
Regards,
Jeff Bielefeld [Bentley]