Print Page - Do dbGet() has a size limitation?

Title: Do dbGet() has a size limitation?
Post by: Ficko on January 29, 2007, 06:08:44 AM

I have a little problem here may somebody already encountered with it and can give me some hint. ;)

I have a MySQL Table with a field type
VARCHAR (1000 Char long) and another type
TEXT (65535 Char).

Using Connector/ODBC 3.51.12.

I am trying to bind an Istring variable with the corresponding length or longer but I am getting only 254 Characters back. :'(

DEF Text[65536] AS Istring

dbBindVariable(hstmt, 1, Text)
dbGet(hstmt)

Is it dbGet() who is cutting my field or should I look somewhere else?

Thanks for any help!

Title: Re: Do dbGet() has a size limitation?
Post by: LarryMc on January 29, 2007, 06:13:13 AM

Look at dbBindVariable in the help file.

Title: Re: Do dbGet() has a size limitation?
Post by: Ficko on January 29, 2007, 06:47:01 AM

Cool !
I had missed that one!

Thanks Larry!

;)

Title: Re: Do dbGet() has a size limitation?
Post by: Ionic Wind Support Team on January 29, 2007, 07:01:12 AM

For those that are just perusing the topic dbBindVariable has an optional parameter to specify the maximum size of the data to be returned.

dbBindVariable(hstmt, 1, Text, NULL, 65535)

IonicWind Software

IWBasic => Database => Topic started by: Ficko on January 29, 2007, 06:08:44 AM