Hello again,
I have a problem with Delphi and Postgres (not) working together.
Using the Delphi-Components to acces my tables, I get an error whenever I
have a float or numeric field.
When updating a record, the generates SQL-Statement does not have the
values quoted.
I have asked in a Delphi-Newsgroup how/if I can change that.
Just in case it is not possible: Can I tweak Postgres to less picky about
the quotes?
The query looks like:
UPDATE inv_artikel SET bezeichnung='Asbach Uralt' WHERE nr=1 AND
bezeichnung='Asbach Uralt' AND gebinde='Flasche' AND inhalt='3 ltr' AND
anzahl=1 AND preis=81.45 AND gruppe='sp' AND subgruppe='' AND anz=1
---> ERROR: Unable to identify an operator '=' for types 'numeric' and
'float8' You will have to retype this query using an explicit cast
Thanks,
Stefan