Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Tableupdate Problem
Message
From
17/03/2001 01:09:27
 
 
To
17/03/2001 01:03:16
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00486210
Message ID:
00486217
Views:
13
OK, here's a complete shot in the dark :-)

When and how are you creating the cursor from the view? If it's a parameterized view and you have NoDataOnLoad set to .T. and you haven't requeried the view when you create the copy, then your problem becomes apparent: There are no records in the copy of the view, hence the REPLACE's and all that are only happening on the SCAN through the view because the SCAN in the copy immediately bounces out because there are no records.


>Hi John,
>
>Sorry, int_doc_vnd_stk, is not view, it's a cursor that is view copy.
>
>select * from int_doc_vnd into cursor int_doc_vnd_stk nofilter
>
>
>Thnak's
>
>João Batista
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform