Bug with field named MIN or MAX
Posted: Tue 12 Feb 2008 12:43
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
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