Hiya, I have a problem in that when accessing one of our oracle databases,
I'm getting an error saying "field 'release_ref' not found", yet when I look
at the table using something like TOAD, its there. Now, the field's not
mentioned in the fields editor, but is being added manually in the
OnBeforeOpen event of TClientDataSet (linked to a provider, linked to a
query) *pauses and enters into a "ahh I think I have it" mood*. The
OnBeforeOpen handler is creating a TIntegerField for the ClientDataSet, I'm
guessing I need to create them -also- for the TQuery?
Although, it works fine on some databases...
mmm
Actually, what I was going to ask is whats the case sensitivity of Oracle?
I had one query which didn't work when ran against our oracle db, but
putting it all in uppercase did, so I have a wee fudge for that, but from
what I can tell, sql itself should be case insensitive (at least any sql i
type into TOAD is).
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
