Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Tableupdate Problem
Message
From
17/03/2001 01:21:53
 
 
To
17/03/2001 01:19:31
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00486210
Message ID:
00486219
Views:
10
Well, hmmmm....that's the only thing I can think of: the SCAN failing on one of the loops. Nothing else makes sense for two SCANS with only one set of REPLACEs taking effect.


>>OK, here's a complete shot in the dark :-)
>
>>When and how are you creating the cursor from the view?
>
>(This view is my child table for my form invoices), when the user type DocType and DocNumber, i requery the view and build the cursor, but the cursor is build only if the view have records.
>
>
>>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.
>
>You are right, but i only build the cursor if the view have records, the var pnNovDoc is for that if it's '0' i don't scan to the int_doc_vnd_stk
>
>About your last post, both tables are buffering=5.
>
>
>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