String Length In Db Query Module

[Guest mmckenna_itpro@hotmail.com]

Hi,

 

I am using a database query module to get a string field out of a database. The query crashes when I have the string field in the database set to a 750 character field, but is OK at 200 characters. What is the exact limit for this 'feature'.

 

Mike.

[SupportTeam]

Is the 750 character field still defined as 'char' or is it a 'text' type filed?

 

Are you using the database via ODBC or are you running a local MS Access database?

 

Others have reported problems when retrieving "Text" fields over ODBC (although it works fine when retrieving it from a local MS Access database).;

 

See: http://voiceguide.com/forums/index.php?showtopic=104

[Guest mmckenna_itpro@hotmail.com]

Hi,

 

The string length limit using ODBC is 512 characters. I have the SQL database field defined as nvarchar, length of 512. Longer string fields may require the use of GetChunk to access the field.

 

Mike.

[SupportTeam]

Which database are you using? (MS SQL Server?)