Recent content by stevemagruder

I just ran into this problem myself with 3.4.6.4. Will this be fixed soon? Thanks, Steve

Looks like 8.0.6 is installed here. I think that it's the same issue, as it's also only happening in debug mode here as well. At least, it's good to know it's an Oracle issue, and once we've upgraded to 8.1.7 or above, it will go away. Thank you for your quick reply.

This was tested in D5-SP1 and D7. In a new application, drop a TOracleSession on a form. Set the Logon... properties to connect to a valid database. Then set Connected to True. Launch the app. Now, close it. There's a CPU Debug window. I believe this also occurred in 3.4.6.1, as I was...

Well, of course they are. A limited SQL, but SQL nonetheless. Now, how about an answer to my question? Steve

What if the session has multiple queries hooked into it? If BreakExecution stops all currently running queries (possible in a multithreaded system), but we're only interested in stopping one, how would one go about handling that? Or does TOracleSession only handle one query execution at a...

Question: Why is the SQL allowed in TOracleDataSet.Filter not consistent with Borland's Local SQL? Two differences (off the top of my head) are: 1) not allowing the "like" predicate but instead allowing "field = value*"--this is nice but it would also be nice to be able to use standard SQL...

I think I answered my own question today. Just realized that I needed 'begin' and 'end;' around my SQL statements. Problem appears to be solved.

I forgot to mention tech details: Oracle8i Enterprise Edition Release 8.1.7.2.1, DOA 3.4.6.1, Delphi 5 SP2. ------------------ Steve Magruder [This message has been edited by stevemagruder (edited 28 June 2002).]

Here's the code (simplified from the real thing): with TOracleQuery.Create(nil) do try Session := Data2.ARCSession; SQL.Text := 'select CITSEQUENCE.nextval into :CIT_CIT_CITID from dual; ' + 'insert into CIT_CITATION (CIT_CIT_CITID) values (:CIT_CIT_CITID);'...