$loadcols $colcount

[Martin Obongita]

 Hi Kelly,By your help, I have managed to load the data into a list in a SQL statement using a switch(depending on the number of columns) and to display the content in a datagrid.
I noticed that the grid only displays columns defined as kCharacter,kSimpleChar,99.But columns defined as kBoolean,#null,#null do not display any column or it's values.

If I check the values in lTableClassColsList, the Boolean columns are set to kFalse.How do I resolve this?
Rgds, Martin.
    On Tuesday, April 19, 2022, 03:07:35 AM GMT+3, Kelly Burgess <kellyb at montana.com> wrote:  
 
 Hi Martin,

>How do I use the columns defined in iDataList, in a PostgreSQL statement, to "select"?

I build my select statement in a loop, the same way I add the user-selected columns to the row variable, so it selects the same subset of columns.  Then I add the Where clause if any, and do a stmt.$execdirect() followed by a $fetch into iDataList.

Kelly
_____________________________________________________________
Manage your list subscriptions at https://lists.omnis-dev.com
Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com