Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Tableupdate Problem
Message
De
17/03/2001 01:21:53
 
 
À
17/03/2001 01:19:31
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00486210
Message ID:
00486219
Vues:
11
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform