Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating a Cursor from 2 tables, related or not
Message
From
27/12/1999 20:04:28
 
 
To
27/12/1999 19:48:46
Jill Derickson
Software Specialties
Saipan, CNMI
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00309015
Message ID:
00309026
Views:
30
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform