Skip to Content
Former Member
May 24, 2013 at 07:54 PM

syntaxfromsql fails if column is blob


I am creating a datawindow at run time where i don't know the column types or names.

ls_sql = "select * from <tablename>'

SyntaxFromSQL(ls_sql, 'Style(Type=Form)', ls_error)

I don't suppose there is a setting to create the syntax from sql while ignoring columns that it can't handle (such as blobs). I get the error: "This column's data type (columname) requires the use of an embedded SQL statement."

Powerbuilder itself can do this when it creates a datawindow via the ide.