Hi Lucas,
A simple solution to you question can be this :
Property numDossiersMER As list Of %Integer(SQLPROJECTION = "table/column", STORAGEDEFAULT = "array");
Index numDossiersMERIdx On numDossiersMER(ELEMENTS);
With those parameters you can achieve :
- 'As list Of %Integer' allows you to use the Insert() in ObjectScript and 'for some %element' in SQL command
- 'SQLPROJECTION = "table/column"' allows you to display the table as a column (note, the column does not appear in a select * it must be specified : select numDossierMER, numDossiersMER from User_TestList_Data.Titre )
- 'STORAGEDEFAULT = "array"' allows a separate table for the normalized representation
- 'Index numDossiersMERIdx On numDossiersMER(ELEMENTS);' bring the ability to use index on values with this SQL query :
select numDossierMER, numDossiersMER from User_TestList_Data.Titre
where
for some %element(numDossiersMER) (%Value in (345))
- Log in to post comments