Qualifiers tell the access service how to format data that is inserted for a placeholder. If you do not supply a qualifier, the access service applies default transformations.
Qualification is required for date and time values. You can use the ?T, ?t, ?D, and ?d qualifiers for dates, or you can create a custom qualifier using special qualifiers. For information about special qualifiers, see “Special date and time qualifiers”.
The following table defines valid datatype qualifiers.
The following three tables show the effects of qualifiers on datatypes.
For each table, special circumstances are detailed in the text following the table.
The first table shows the effects of the ?C, ?N, ?D, and ?T qualifiers.
For CS_CHAR, CS_VARCHAR, AND CS_TEXT used with the ?D qualifier:
If the source is an ISO TIMESTAMP, it is converted to ‘Mon dd yyyy hh:mm:ss:nnn’.
If it is an ISO DATE, it is converted to ‘Mon dd yy’.
If it is an ISO TIME, it is converted to ‘Mon dd yy hh:mm:ss’ using the value from the DefaultDate property as the date portion of the value.
For CS_CHAR, CS_VARCHAR, AND CS_TEXT used with the ?T qualifier:
If the source is an ISO DATE or TIME, the DefaultDate and DefaultTime property values are used to fill in missing information.
The following table shows the effects of the ?y, ?d, ?t, and ?x qualifiers.
For CS_CHAR, CS_VARCHAR, AND CS_TEXT used with the ?y qualifier:
If the source is an ISO DATE, TIME, or TIMESTAMP, it is converted to ‘yy/mm/dd’.
For CS_CHAR, CS_VARCHAR, AND CS_TEXT used with the ?d qualifier:
If the source is an ISO DATE, TIME, or TIMESTAMP, it is converted to ‘mm/dd/yy’.
For CS_CHAR, CS_VARCHAR, AND CS_TEXT used with the ?t qualifier:
If the source is an ISO DATE, TIME, or TIMESTAMP, it is converted to ‘hh:mm:ss’.
For all datatypes used with the ?x qualifier:
If the target database is ODBC , ?x converts the data to the standard ODBC hexadecimal format (a quoted hexadecimal number with a leading X).
The following table shows the effects of the ?X and ?O qualifiers.
For CS_BINARY, CS_VARBINARY, AND CS_IMAGE datatypes used with the ?X qualifier:
If the target database is ODBC, ?x converts the data to the standard ODBC hexadecimal format (a quoted hexadecimal number with a leading X).
Copyright © 2005. Sybase Inc. All rights reserved. |