SqlListType (Property Keyword)
Specifies the values of this field are represented in memory in SQL and stored on disk. Applies only to list properties in persistent classes. For use only by legacy applications.
Usage
Property Name As List Of Classname [ SqlListType = sqllisttype ];
Where sqllisttype is one of the following:
-
LIST — the list is stored in $List() format in memory and on disk. This is the default.
-
DELIMITED — the list is stored as a delimited string in memory and on disk. The delimiter is specified by SqlListDelimiter keyword.
-
SUBNODE — the list is stored in subnodes on disk; that is, each list element in a separate global node. The in-memory value of the field is $List format if SqlListDelimiter is not specified. If SqlListDelimiter is specified, the in-memory format is a delimited string.
Details
SqlListType controls how the values of a field are represented in memory in SQL, and how they stored on disk.
This keyword is provided to support legacy applications.
Default
The default is LIST.
