[Firebird-odbc-devel] ODBC issue 2.0.0-Win32.exe Duplicating Data

[Grant C. <Gra...@sk...>]

Hi

 

I am very new to Firebird ODBC but here goes

 

We are using Firebird ODBC 2.0.0 Win32.exe on Win XP, Firebird database
1.5 on Win Ser 2003 R2 on a virtual. This is used for the ResPAK
application and configured per the Regedit export, see below for more
detail of configuration but with security attributes removed .

 

When I run a MS Excel 2007 Query using Firebird ODBC 2.0.0 148 against
the Firebird 1.5 database at least 2 of the columns contents duplicate
across unrelated rows. 

 

If I run this same MS Excel 2007 Query with Easysoft 1.03.00.00 then
there is no duplication of column contents to unrelated rows

 

When we run the Firebird ODBC 2.0.0 on an ODBC compliant application
Wherescape Red 5.6.4.0 the same issue occurs with duplicated column
contents. We can reduce the issue to a degree by replacing Nulls and
Blanks in the SQL with a constant character e.g. 'Unknown'. See SQL
below

 

Comments ?

 

Thanks Grant

 

Select CUSTOMER.cust_id

, CUSTOMER.title

, CUSTOMER.fname

, CUSTOMER.lname

, CUSTOMER.phone

, CUSTOMER.mobile

, CUSTOMER.other

, CUSTOMER.rating_r

, CUSTOMER.rating_f

, CUSTOMER.flags

, CUSTOMER.booked

, CUSTOMER.arrived

, CUSTOMER.totalspent

, CUSTOMER.visits

, CUSTOMER.manual_r

, CUSTOMER.manual_f

, NULL

, CUSTOMER.prefsbyarea

, CUSTOMER.lastdate_r

, CUSTOMER.lastdate_f

, CAST(CUSTOMER.LASTTIME as VARCHAR(13))

, CUSTOMER.org_id

, CUSTOMER.dep_id

, CUSTOMER.na_count

, CUSTOMER.na_lastreset

, CUSTOMER.na_total

, CUSTOMER.na_resetby

, CUSTOMER.rna_flag

, CUSTOMER.account_id

, CUSTOMER.phone_idx

, CUSTOMER.mobile_idx

, CUSTOMER.gratuity_level

, CUSTOMER.totalgratuity

, CUSTOMER.manual_grat

, CUSTOMER.vipdiner

, case 

when CUSTOMER.email is null then 'Unknown'  

when CUSTOMER.email = '' then 'blank'

else CUSTOMER.email 

end

, CUSTOMER.totalpoints

, CUSTOMER.privacyflags

, CAST(CUSTOMER.DATE_MODIFIED AS DATE)

, CAST(CUSTOMER.date_created AS DATE)

, NULL

, CUSTOMER.dob_day

, CUSTOMER.dob_month

, CUSTOMER.dob_year

, CUSTOMER.doa_day

, CUSTOMER.doa_month

, CUSTOMER.doa_year

, CUSTOMER.first_visit_date

, CUSTOMER.first_visit_id

, CUSTOMER.cust_lid

, CUSTOMER.f_bookings

, CUSTOMER.f_regular

, CUSTOMER.notes

, CUSTOMER.lname_idx

, CUSTOMER.fname_idx

, CUSTOMER.roomno

, CUSTOMER.res_notes

, CUSTOMER.external_id

>From CUSTOMER WHERE LNAME like 'R%'

; 

 

 

Windows Registry Editor Version 5.00

 

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\RESPAK_PRD]

"Driver"="C:\\WINDOWS\\system32\\OdbcFb.dll"

"Description"="Respak"

"Dbname"="akspres01:C:\\ResPAKD\\Database\\RESPAK.GDB"

"Client"=""

"Role"=""

"CharacterSet"="NONE"

"JdbcDriver"="IscDbc"

"ReadOnly"="Y"

"NoWait"="Y"

"LockTimeoutWaitTransactions"=""

"Dialect"="3"

"QuotedIdentifier"="Y"

"SensitiveIdentifier"="N"

"AutoQuotedIdentifier"="N"

"UseSchemaIdentifier"="0"

"SafeThread"="Y"

 

Grant Coburn | Senior Datawarehouse Analyst | SKYCITY Auckland Tel +64 9
363 6357 |  Mob +64 21 675 822  |  Fax +64 9 363 6041  | Web
www.skycity.co.nz
<file:///C:\Documents%20and%20Settings\gcoburn\Application%20Data\Micros
oft\Signatures\www.skycity.co.nz>  P Please consider the environment
before printing this e-mail


Attention:This message has been scanned by a reputable SMTP Security Scanner and is believed to be clean, but the sender gives no warranty that it is clean, and excludes any liability for damage caused by unintended attachments. The information contained in this message and/or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender, delete the material from any system and destroy any copies. Nothing in this e-mail designates an information system for the purposes of Section 11(a) of the New Zealand Electronic Transactions Act 2002, unless expressly stated otherwise.