ceds98
asked on
How to process SQL statement by Database Server not by BDE or Delphi?
I'd like to code SQL statement and process it by Database Server but now I must code it in Delphi SQL statement or SQL-92. Am I right?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I do not understand how to set that Jacco told me. And I set like this pls tell me what's wrong.
I set 2 BDE aliases to the same instance(database) of ORACLE
Properties of 2 BDE
aliasname PIS THRUPIS
SQL passthroughmode Shared autocommit Not Shared
and I have 2 database components
Properties of 2 database components
databasename dbPIS dbTHRUPIS
alias PIS THRUPIS
and I have 2 TQuery
Properties of 2 Tquery components
database dbPIS dbTHRUPIS
SQL SQL statement in SQL-92 format
SQL statement in ORACLE format
But the second query failed. How to write the SQL statement in ORACLE format and process it by ORACLE not by BDE?
I set 2 BDE aliases to the same instance(database) of ORACLE
Properties of 2 BDE
aliasname PIS THRUPIS
SQL passthroughmode Shared autocommit Not Shared
and I have 2 database components
Properties of 2 database components
databasename dbPIS dbTHRUPIS
alias PIS THRUPIS
and I have 2 TQuery
Properties of 2 Tquery components
database dbPIS dbTHRUPIS
SQL SQL statement in SQL-92 format
SQL statement in ORACLE format
But the second query failed. How to write the SQL statement in ORACLE format and process it by ORACLE not by BDE?
How does the second query fail ?
I suppose that you have to use explicit transaction control
with DataBase.StartTransAction and DataBase.Commit.
I suppose that you have to use explicit transaction control
with DataBase.StartTransAction and DataBase.Commit.
ASKER
Forget my above comment. My sql statement failed because its complex so I applied some tricks with it and it work fine.
Ciao, Mike