> From experience, Field and Table names can be upper, lower or
> of mixed case regardless of the case of the identifier during declaration.
After a little more snooping, I find that PostgreSQL does allow me to use
upper/lower case in my queries fine, however, after looking deeper I found
the problem was this...
Whilst the BDE was reporting "table MeasuredData not found", the error
should have actually been "table MeasuredData.db not found". Upon opening
my datamodules .dfm I noticed that all the TField entries were listed as
'Souce = "MeasuredData.db".FieldName' and this was causing the problem.
However, now I'm finding I can't do cached updates to the server, it's
reporting its read only :( arrrg.
Mark
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
