Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Paul,
The STR() function by default creates strings of 10 characters.
In my previous life when I did accounting software, I always used type character for the chart of accounts. Made things much easier, as I could combine any fields I wanted in an index.
>I am having a problem dealing with index's on numeric fields.
>
>I have a chart of accounts file with three fields. 2 numeric fields coa_glno(ledger#) with a width set to 3 and coa_glsub(ledger sub#) with a width set to 2 and a character description field.
>
>I have a candidate index called coa_glno with the following expression "str(coa_glno)+str(coa_glsub)". If I have a record in the table with a coa_glno of 123 and coa_glsub of 45 I notice that the index expression yields " 123 45". I am not sure why I have all of these leading spaces. This is causing great headaches in trying to do searches on this table with this particular index. I was considering using alltrim in the index. However, how would it distinguish between 123-45 and 12-345?
>
>I am struggling with the best way to handle these indexes and then, also the best way to search on these indexes.
>
>Thanks,
>Paul Acton
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement