Recent content by Peter Zolja

Ahhh, how stupid of me! Found it hidden somewhere in my code. Thank you!

try this: http://groups.google.com/groups?q=WINDOWS%20SOCKET%20ERROR%2010048&hl=en&lr=&sa=N&tab=wg

Perhaps I don't understand correctly how dbms_output.disable works, but if I disable it (TOracleSession.DBMS_Output.Disable), it still works; meaning that I can access the output (DBMS_Output.Get_Lines). If all I run is a PL/SQL block and I call "disable" from the same block it works, but...

If you pass this query to the Oracle script: with q as (select 1 from dual) select * from q the script parser breaks it into two queries: with q as (select 1 from dual) -and- select * from q which, of course is not correct... Now, if you pass it as a single line (no CRLF before the...

"works fine this way: select 'line1'||chr(13)||chr(10)||'line2'||chr(13)||chr(10)||'line3' from dual" sorry, I should've read the whole post before replying :-)

I believe it has to do with the chr(10)||chr(13); if you put the correct CRLF, which is chr(13}||chr(10), it works just fine...

I ran across a funky query: select 'line1'||chr(10)||chr(13)||'line2' from dual; it seems to be cutting off the last two characters ("e2"). Any ideas? (the same query used with the ADO components - D7 - works fine). Thanks. (I think my version is 4.0.5.0, has this been fixed since?)

I have a TOracleDataSet with QueryAllRecords set to false. The user can try to fetch all rows (OracleDataSet.Last) but can also stop the fetching. This all works ok. My question is: What is the best way to know if there are no more records to pull from the database? I tried checking for Eof on...

Thanks, that did it...

Hi guys, I want to be able to run a query, but only return a few rows in a DBGrid; then when the user wants to fetch the rest of the rows it should happen automatically -- like in SQL Navigator, or even PLSQL Developer but more automated. How can I do this with DOA? I'm (very) new to DOA, but...