Bug with field named MIN or MAX

Bug with field named MIN or MAX

Postby ricolebo » 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
Last edited by ricolebo on Tue 12 Feb 2008 13:25, edited 2 times in total.
ricolebo
 
Posts: 30
Joined: Tue 12 Feb 2008 12:30

Re: Bug with field named MIN or MAX

Postby ricolebo » Tue 12 Feb 2008 13:19

The better I can do in my case is to raname the field if you can't do anything.
ricolebo
 
Posts: 30
Joined: Tue 12 Feb 2008 12:30

Postby Plash » Wed 13 Feb 2008 09:25

In our tests the table cannot be updated also with the standard Borland driver. Please send to dbxida*crlab*com a complete small sample that demonstrates the situation when the standard driver woks and Core Lab driver does not, and include script to create database objects.
Plash
Devart Team
 
Posts: 2844
Joined: Wed 10 May 2006 07:09

Postby ricolebo » Wed 13 Feb 2008 10:16

I have send a little project ...
ricolebo
 
Posts: 30
Joined: Tue 12 Feb 2008 12:30


Return to dbExpress driver for InterBase & Firebird