Screen Painter - Set a query for a DataTable don't work

[Former Member]

Hi!

I have a matrix with 3 columns:

1) Type - CheckBox; Table - DT_0; Alias - CheckBox

2) Type - LinkButton; Table - DT_0; Alias - CardCode

3) Type - Edit; Table - DT_0; Alias - CardName

I need to load the DataTable with a query. I tried

select 'N' as CheckBox, CardCode, CardName from ocrd where cardType = 'S'

After I pressed "Set".

When I click on "Preview mode" I get the following error message:

Viewing form in Preview Mode Failed. Error: Data Table - invalid data 66000-136

Thanks

Edited by: Gianluca D'Alessandro on Mar 19, 2010 4:18 PM

[Former Member]

Hi,

You may check these threads first:

Thanks,

Gordon

[Former Member]

Thanks Gordon,

my problem is not to set the CheckBox through the UI-API but to create a DataTable using a query within the ScreenPainter (In the ScreenPainter you can create a DataTable either manually or with a query).