SELECTNAME, UPDATENAME, INSERTNAME

Top  Previous  Next

The NAME attribute of a field or a blob in an SQL table can contain any of the following:

 

| SELECTNAME=value

| UPDATENAME=value

| INSERTNAME=value

 

This allows you to specify alternate names for the column the driver will use when generating a SELECT, UPDATE, or INSERT statement.

 

Example:

 

hid STRING(4001),NAME('hid | SELECTNAME=hid.ToString()')

 

This will cause the driver to generate "hid.ToString()" when issuing a SELECT statement, but just "hid" when issuing an INSERT or UPDATE statement.