Bug with field named MIN or MAX

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for InterBase & Firebird in Delphi and C++Builder
Post Reply
ricolebo
Posts: 40
Joined: Tue 12 Feb 2008 12:30

Bug with field named MIN or MAX

Post by 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: 40
Joined: Tue 12 Feb 2008 12:30

Re: Bug with field named MIN or MAX

Post by 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.

Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by 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.

ricolebo
Posts: 40
Joined: Tue 12 Feb 2008 12:30

Post by ricolebo » Wed 13 Feb 2008 10:16

I have send a little project ...

Post Reply