Select SQLBase Long varchar into ChildTable column fails

Johann · Post by **Johann** » 28 Dec 2015, 11:40

Hi,

when we select a SQLBase (9.x) Long varchar into a ChildTable column (defined with length of 5000), it fails when the SB column content is longer than 2000 Bytes!!!!!

The application crashes!!!!

Regards
Johann

MWegner · Post by **MWegner** » 28 Dec 2015, 15:09

Hey Johann,

your column must be defined as long string. Is this the case?

Best regards
Martin

Johann · Post by **Johann** » 28 Dec 2015, 16:28

Yes Martin, it is a long string....

Mike Vandine · Post by **Mike Vandine** » 07 Jan 2016, 06:48

Hi Hans,

As always, a reproducible testcase will help us to determine what might be going wrong. A script to create a database table and a small .apt that shows this would be great!

Best regards,

Geert_Schröder · Post by **Geert_Schröder** » 21 Jan 2016, 20:31

Hello Hans,
did you use SqlSetLongBindDatatype() ?

Best Regards
Geert

Johann · Post by **Johann** » 22 Jan 2016, 12:39

Geert_Schröder · Post by **Geert_Schröder** » 23 Jan 2016, 10:16

Hello Hans,
what about selecting in a variable and then setting the column to the contents of that variable.
If this works I would guess, that there is a bug in selecting directly into the column.

Best Regards
Geert

Team Developer SQLWindows Community Forum

Select SQLBase Long varchar into ChildTable column fails

Select SQLBase Long varchar into ChildTable column fails

Re: Select SQLBase Long varchar into ChildTable column fails

Re: Select SQLBase Long varchar into ChildTable column fails

Re: Select SQLBase Long varchar into ChildTable column fails

Re: Select SQLBase Long varchar into ChildTable column fails

Re: Select SQLBase Long varchar into ChildTable column fails

Re: Select SQLBase Long varchar into ChildTable column fails

Who is online