GTD 6.3 and SqlBase 9: any issues ?

Discussion forum about all things SqlBase.
User avatar
Charlie
Canada
Posts: 595
Joined: 07 Mar 2017, 18:52
Location: Fredericton, New Brunswick, Canada

GTD 6.3 and SqlBase 9: any issues ?

Post by Charlie » 04 Aug 2021, 17:33

Although GTD 6.3 is not certified to work with SqlBase 9, I wonder if they do function happily together.

Does anybody know? So far, it seems fine just selecting data (except for images stored in the database ... not sure if that is a database compatibility issue, or something wrong with the GTD 6.3 code migrated for GTD 4.1)

Thank-you in advance, and best regards !

User avatar
Steve Leighton
Site Admin
Site Admin
New Zealand
Posts: 287
Joined: 05 Mar 2017, 20:57
Location: Tauranga, New Zealand <--> Stroud, England

Re: GTD 6.3 and SqlBase 9: any issues ?

Post by Steve Leighton » 04 Aug 2021, 22:15

.
SQLBase 9 was old before I was born. So cant really comment on the TD6.3 v SB9 combination.
Can vouch for SB 11.7 and 12.2 against TD6.3

However for your Image problem, try "SqlSetLongBindDatatype( nBindVariableNumber, nDatatype )"
(if Column Datatype is Long Varchar).
Without SqlSetLongBindDatatype, TD converts the data to Unicode.
Try SqlSetLongBindDatatype before SQLFetchNext, but after the SqlExecute ( the order you use it is important )
Greetings from New Zealand
Steve Leighton

Bankside Systems Ltd.
UK ♦ Australia ♦ New Zealand

www.banksidesystems.co.uk

Image

Igor Ivanovic
Site Admin
Site Admin
Croatia
Posts: 1406
Joined: 05 Mar 2017, 12:37
Location: Zagreb, Croatia

Re: GTD 6.3 and SqlBase 9: any issues ?

Post by Igor Ivanovic » 05 Aug 2021, 12:25

Hi,

Long, long time ago I had the same combination on one of my clients installations, as they were not willing to upgrade to a newer SQLBase, and the same application worked Ok with multiple versions of SQLBase, v9.x, v11.x and v12.x.
Igor Ivanovic
Image

User avatar
Charlie
Canada
Posts: 595
Joined: 07 Mar 2017, 18:52
Location: Fredericton, New Brunswick, Canada

Re: GTD 6.3 and SqlBase 9: any issues ?

Post by Charlie » 06 Aug 2021, 15:31

Steve, thank-you so much(!!!) for that bit of info (re SqlSetLongBindDatatype).)

GTD 6.3 app is loading up images A-1.

Return to “General Discussion”

Who is online

Users browsing this forum: No registered users and 0 guests