Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SCAN and DELETE command
Message
From
23/06/2006 13:37:17
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
SCAN and DELETE command
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP1
Network:
Windows 98
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01131259
Message ID:
01131259
Views:
60
Is this code correct? Before deleting a record from fileA I would like to insert one record into fileB where some fields are based on record that is being deleted on fileA. What will happen with record pointer of fileA when the record is deleted?

select fileA
SCAN FOR ......
IF ....
insert into fileB ....
ENDIF
delete in fileA
ENDSCAN
Antonio Carlos Kleinübing
Systems Analyst
Next
Reply
Map
View

Click here to load this message in the networking platform