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
Edited by: Gianluca D'Alessandro on Mar 19, 2010 4:18 PM
You're not alone. I'm having the exact same problem here in 2012 when I set a DataSources to a form created in Screen Painter and then Add a column in the matrix. I don't know what the problem is yet but I'm working on it. If I find anything I'll let you know.
The error occurs immediately when I add a column in the matrix.