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

what is the scatter used for?

> scatter memvar memo

why is the report in the scan loop?

> report form licencas to printer prompt noconsole
>

the following if/endif is unnecessary because scan/endcan does it

> 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

try this:
select (vfich1)

report  form  licencas to printer prompt noconsole for deleted()

lcSetDeleted = set("deleted")
set deleted off
UPDATE (VFICH1) Set  impressa=.t. Where impressa=.f.   and Deleted()
set deleted &lcSetDeleted
Previous
Reply
Map
View

Click here to load this message in the networking platform