Recent content by psilva

This function in the Oracle.pas unit // Remove SQL Comment from a string function RemoveSQLComment(const ASQL: string): string; remove all the comments. But not all that starts with /* is a comment. It can be a sql hint so I don't think that is a good idea to remove all, because when you do a...

I Solved by changng the sql, but I still doesn't understand why it different executing the same sql...

When I say on a TOracleDataSet query window I mean during design time and getting the result by pressing the run button. It as the same speed retrieving the first 3600 records but after that it starts getting chunks of 25 records and taking about 2 seconds per 25 records. Is exactly the same...

Is there any reason why a query on a pl-sql window takes 3.6 seconds to retreive about 5200 records and using a TOracleDataSet takes about 5 minutes (paste of the same SQL on a sql window of a TOracleDataSet)? If necessary I can provide a small example of the sql (it is quite complex). Thanks

Ok Thanks. I'll wait...

I just started working with version 4. Problems: * In order to be able to acess the QBEDefinition window it is necessary to have all fields added to the dataset field editor. Why? * It is not possible to qbe for a numeric field (in the QBE definition window pressing test button I get - ORA...

The problem as to do with Oracle 9i, because on Oracle 8i the same debug works well. It only hapens on some packages, not all. In others words: in the debug wiwdow it opens the package, shows the line with the debug point, but it doesn't stop there. it finish the task and commits the transaction...

it hangup on the server because the pc as 0% CPU usage. Thanks

I have Oracle 9i R2 When trying to debug it stops (?) at de debug point but hangs. It is not possible to continue (F8 or F9) and the cursor keeps an hourglass