Recent content by Jim Ashton

Hello - I am seeing this error message persistently when I am the only user connected to the database (Oracle 8i, Delphi 5 App.). The statement generating the exception is attempting to execute the Edit method of a TOracleDataset. What could be causing this? Thanks Jim Ashton

I could take issue with these suggestions (the QuickReport hasn't been built when the query executes, the DOA & BDE versions issue identical SQL anyway...) and my PC doesn't have multiple Oracle Homes. However I have stumbled upon a workaround which is to issue the query 'select 1 from dual'...

I'm not sure what you're driving at here. I've been working with a number of Delphi 5 projects in my current hardware/OS/Oracle environment for several months (in fact a couple of years) now and I have not seen this error before. Admittedly, DOA components were introduced into the mix...

In my Delphi 5 application users can tick boxes on a screen and hit a button to run a query based on their selections. A new table is first created by building an SQL text string in a TOracleQuery object (eg 'create table X as select count (*), col_a, col_b from...where...group by col_a...

YES - that's fixed it! I hadn't quite read the documentation closely enough and had included an extra column in the DetailFields property. So a testing version of the module has just gone to the customer for appraisal - doubtless there will be a few issues still to be sorted, but I'm confident...

OK Marco - thanks for that. Unfortunately it doesn't help solve my problem, which I will now briefly describe. In the Application there is a form featuring two TDBGrid components plus some TDBEdit and TEdit boxes. Grid 1 is read-only and displays master table data - its DataSource property is...

Marco - thank you for that last reply, which was most helpful. I have now almost finished the conversion! However I am still having problems with Master/Detail relationships. My question now is this: for master/detail relationships to work between two TOracleDatasets, must a Foreign Key...

Marco: we have now managed to make the 'Field must have a value' error go away by setting the Required property of all relevant TStringfield objects to false. Could I now refer you back to my earlier question re. detail synchronisation please. To repeat, my TOracleDatasets don't seem to have...

Hi Marco - just wondering if there's been any progress on this - my customer is getting a little edgy! Thanks Jim

Marco: In regard to your last reply, my TOracleDatasets don't seem to have BeforeRefresh or AfterRefresh events. The only *Refresh* event is AfterRefreshRecord, which does not appear to be triggered by detail synchronisation - at least according to my testing. Is there any other event I could...

Thanks for that Marco. I just need to clarify the options here - could you please list the TOracleDataset events which are triggered by: 1. TOracleSession.ApplyUpdates([TOracleDataset], false) ie no commit 2. Refresh (eg following detail synchronization) Thanks again Jim

Somehow I thought it was too good to be true... OK, it appears that setting TOracleSession.Preferences.TrimStringFields to False has dealt with most of the cases where one or more existing database rows are being edited and then re-saved. In the case where a brand new set of rows is being...

Well it's a little early to be certain (loads more testing to be done!) but at this stage it looks like your suggestion has cured most (& possibly all) of the problems. Many thanks Jim

My apologies, AutoGenerateValue and DefaultExpression are properties of TStringField. Jim

I am in the process of converting a fairly complex BDE-based application to DOA, running against an Oracle 8i database. Almost all of the original updateable TQuery objects have become TOracleDatasets, around 14 of which are opened concurrently using CachedUpdates. When the user hits Save the...