Hi,
I test the last version of the driver and I have found a bug.
I use Delphi 7 and firebird 2.1.
To reproduce it you must have a field named MIN in your table.
Command text is by example : select id,"MIN" from myTable;
On update the query is : update myTable set id = ? and min = ?
=> SQL error because MIN is not quoted and uppercase like that : "MIN"
This error doesn't exist with the standard Borland driver because all the fields are quoted
Note : The field become case sensitive when quoted
Thank you
Eric
Bug with field named MIN or MAX
Bug with field named MIN or MAX
Last edited by ricolebo on Tue 12 Feb 2008 13:25, edited 2 times in total.
Re: Bug with field named MIN or MAX
The better I can do in my case is to raname the field if you can't do anything.