SqlDbx
You are not logged in.
Pages: 1
I use an ODBC to an Access database, on an older version (3.47) I have no problems to concatenate strings :
SELECT FieldA+'/'+FieldB AS CONCAT FROM Table
On the newer version of SqlDbx, the application just crashes when I launch the query.
I don't know if this happens woth other ODBC pilots.
Please ask if you need more details, logs or examples!
Last edited by Tym (2012-06-30 13:05:17)
Offline
I am not able to reproduce this behavior.
Are you using the latest version (3.57)?
Offline
Yes I'm using 3.57, I think the issue is related to the length of the fields : on older versions of SqlDbx you get a warning telling you the string has been truncated and the result field is empty.
I'm talking about strings at least 100 chars long.
Crashes with Access ODBC driver
SELECT
'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'+'bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb'
AS Concat
FROM Table1
Same thing with Excel ODBC driver
SELECT
'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'+'bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb'
AS Concat
FROM "Feuil2$"
Tested with direct MS Sql Server and MS Sql ODBC driver : no issue.
Last edited by Tym (2012-07-04 03:40:27)
Offline
Thanks, Tym
I was able to reproduce the error. It will be fixed in a next release.
Offline
Pages: 1