Issue with string size in power builder

Question

I am trying to create dynamic data store at run time from code.

Syntax is like:

SQLCA.SyntaxFromSQL(ls_all_sql,"style(type=tabular)",ls_error)

There is only one column returning from it and the data type is long varchar. But when it created data store, it is taking max char(32766) and rest of the data are lost.

Please advice to resolve this issue.

Thanks in advance.

Answer 1

It seems that the string limit in a text column of a datawindow / datastore is 32k.

Anything bigger must be accessed using a select blob statement.