Recent content by twilson

Is doa version 3.4.6 supported for Kylix3 Open Edition as we are having problems installing, or do we need to purchase the enterprise edition of Kylix.

Created a test application that justs logs onto the database passing OSConnection.connected := true when username, password, database are not null, all other properties were left as default. It took 45 seconds to gain the connection first time, subsequent logins take from 10 secs to 20 on a...

The configuration settings for SQLNET.AUTHENICATON are all comments in the sqlnet.ora file. bugger...

Thanks for the reply Marko, Only one oracle_home exists for the installation of oracle reports and it is using NET80. But sqlnet.ora setting rings a bell from something Ive read sometime ago, So I will give it a go and report back.

We are using 3.4.5 DOA and Delphi 5 Enterprise, Our application is working but we seem to have a small problem when connecting (it may also happen elsewhere and this why I have addressed the forum, we think this may also be causing delays with inserts, updates and commits). Oracle SQLPLUS or...

Originally posted by mkalter: This is a design-time problem? You modify the SQL property, and even though the property is set correctly, the "old" SQL is executed? I'm sure we are missing something here, because there is simply no way that the old SQL is buffered. I think you may be right, I...

Originally posted by mkalter: >>How exactly do you modify the SQL property >>and reopen or refresh the dataset in your >>application code? SQL is modified at design time using either the SQL property in the object inspector or using the right click function and selecting the sql editor. I have...

Sorted the SQL Monitor, I am retrieving 321 records only the first (25 records in buffer)execution displays the executed SQL all other fetches ( 25 records) are executing but not showing the executed sql. Is it possible then, that SQL Monitor could be modified to display is executed SQL...

Originally posted by mkalter: >>I can only imagine that this SQL statement >>is not executed. Marko, if the sql is not executed where are the dbgrid results coming from, the dataset is active, results are returned but not the results that were expected. >>Your remark about the SQL in the...

I have a dataset in a datamodule, my original sql code was :- select * from report_parameter_controls where status = 'I' order by report_completed desc This returns all rows from the rdbms, so I modified the above to return all records completed within the last 3 days :- select * from...