SqlColumnNumber (Property Keyword)
Usage
To specify the SQL column number for the property, use the following syntax:
Property name As classname [ SqlColumnNumber = 4 ];
Where n is a positive integer.
Details
This keyword lets you explicitly set the SQL column order for this property. The SQL column order is used when querying the table through a SELECT * statement, or using an INSERT or LOAD DATA command without specifying the column order explicitly.
Setting this property keyword enables you to decouple the order implied by your class definition from the SQL projection of this class as a table.
Default
The default is an empty string.
See Also
-
“Property Definitions” in this book
-
“Defining and Using Literal Properties” in Defining and Using Classes
-
“Working with Collections” in Defining and Using Classes
-
“Working with Streams” in Defining and Using Classes
-
“Defining and Using Object-Valued Properties” in Defining and Using Classes
-
“Defining and Using Relationships” in Defining and Using Classes
-
“Introduction to Compiler Keywords” in Defining and Using Classes
