Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Finding the right table
Message
From
21/04/2005 13:17:48
 
 
To
21/04/2005 12:40:28
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01007092
Message ID:
01007128
Views:
19
>hi there,
>
>Is there a way to determine if a person chooses the right table? I mean when the user gets a GETFILE('DBF') and he/she chooses a VFP table. How can I check if it's the right table (I need in that specific procedure) the user have chosen? I think I can check the structure of the table, but how can I do that? Anybody have an idea?
>
>Thanks in advance,
>Ron
* open the table
m.expectedCrcTable = 10609773987 && MATCH NUMBER
SELECT getTableAlias
tempName=ADDBS(SYS(2023))+FORCEEXT( SYS(2015),"tmp")
COPY STRUCTURE EXTENDED TO (m.tempName)
USE (m.tempName) IN 0 ALIAS CRC_table EXCLUSIVE
PRIVATE crcTable
CALCULATE IN CRC_table  SUM(VAL(SYS(2017,'',0,3))) TO crcTable
USE IN CRC_table
ERASE (m.tempName)
? crcTable
? m.crcTable=m.expectedCrcTable
Previous
Reply
Map
View

Click here to load this message in the networking platform