Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update - SQL
Message
From
18/05/1998 14:03:45
Carla Silva
Http - Produtos Informaticos, Lda.
Odivelas, Portugal
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
Update - SQL
Miscellaneous
Thread ID:
00100150
Message ID:
00100150
Views:
95
I`m using Scan........Endscan to print all records in a table marked for deleted.

select (vfich1)

Scan for deleted()
scatter memvar memo
report form licencas to printer prompt noconsole

if eof()
exit
endif
endscan

After the loop I`m i using the UPDATE - SQL to update all records marked for deleted in this table.

UPDATE (VFICH1) Set impressa=.t. Where impressa=.f. and Deleted()

The problem is that all records are eliminated and not updated

How can I`do to resolve this situaction ?


Thanks
Carla
Carla Silva
Next
Reply
Map
View

Click here to load this message in the networking platform