Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Creating a Cursor from 2 tables, related or not
Message
De
27/12/1999 20:04:28
 
 
À
27/12/1999 19:48:46
Jill Derickson
Software Specialties
Saipan, CNMI
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00309015
Message ID:
00309026
Vues:
29
>2. Select all the relations for the defendants in the case into a cursor, cTempRelations, then create an INDEX ON ALLTRIM( STR( DefID ) ) + ALLTRIM( STR( VictimsID ) ) Tag DefID [is there a better way to create a tag on 2 integer fields?]


Watch it here, if you want to concatenate to integers to get a unique tag, you can't trim them. IOW

"123" + "321" = "12" + "3321"

Leaving out the ALLTRIM() will ensure that both integers are represented with the same precision.
Erik Moore
Clientelligence
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform