// Initialize CustomDataTable Data are loaded from specified CustomLibrary source file (XML).
// Source file must be save in folder "Public Documents\DesignForms_4\CustomLibrary\"
// Data in CustomDataTable are converted (method "Convert()" to strongly-typed
// values (number, string, boolean or structure)
// This makes selection easier
object DT →000001= new CustomDataTable("EC_Reinf.xml").Convert();
// Select rows (records) by specified conditions.
// Visit online help for details: http://msdn.microsoft.com/en-us/library/System.Data.DataTable.Select.aspx
object Selection →000023= DT.Select("Column1>=600000000 AND Column2=1.5");
// print the selection to the 'table'
→000009BLOCK {
→000015BLOCK {
// Print column names
FOR(j, 0, DT.Columns.Count-1) { →000014TEXT(DT.Columns[j].ColumnName); }
}
// Iterate over all selected rows
FOR(i, 0, Selection.Length-1) {
→000008BLOCK {
// Print all items in specific row
FOR(j, 0, DT.Columns.Count-1) { →000005TEXT(Selection[i].ItemArray[j]); }
}
}
}
// work with selected row - option A
object Str →000019= DT.GetStructure(Selection[0]); // convert whole the selected row to structure
f↓yd← →000024= Str.fyd1; // access properties directly, by their name
// work with selected row - option B
f↓yd← →000017= Selection[0].ItemArray[5]; // access properties by zero-based index, without converting row to structure
→000010TEXT("End of sample");
Layout 0
Layout 1
Layout 2
Layout 3
Layout 4
Layout 5
http://sciadesignforms.com/
Selection[i].ItemArray[j]
"End of sample"
DT.Columns[j].ColumnName