General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>I have an index on a date field that looks like thie: dtoc(< date >).
>I have a view which I use in a form that is used to add/update that table.
>
>When I call the tableupdate I get the following message.
>Error building key for index "< cdx file >" tag "< tag name >".
>
>Is there a setting or a work around for this problem?
I found it.
"DTOC(dExpression | tExpression [, 1])
1
Returns the date in a format suitable for indexing. This is particularly useful for maintaining the table records in chronological sequence.
For example, to order table records in entry sequence, you could issue this command:
INDEX ON DTOC(gdInvDate, 1) + gnInvTime TAG Timeindx"
This resolved the issue.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only