Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL not seeing all records
Message
De
12/01/2000 12:31:18
 
 
À
11/01/2000 21:03:02
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00315081
Message ID:
00317059
Vues:
50
>Hi Barbara,
>There's no bound control. It's all happening in code.
>
>select C_Seri   && A cursor
>cc= 0
>scan
>   cc= m.cc + 1
>   insert into SeriNo ;   && a "real" table
>      (SeriNo, JNum , ItemID, Part) ;
>      values ;
>      (C_Seri.SeriNo, .jnum, C_Seri.ItemID, C_Seri.Part)
>endscan
>select JNum, ItemId, SeriNo, Part ;
>   from SeriNo ;
>   where JNum = .jnum ;
>   into table T_Seri   && the most recently insert line from SeriNo doesn't make it!
>
>
>If I move the record pointer prior to the query it works fine!
>
>>David,
>>What happens if you use "Skip 0"? I think this is analogous to making a change in a textbox but not moving off the control - the data never gets to the bound control because VFP is still waiting for you to tell it "I'm done with this change".
>>
>>
>>>>If you move the record point off of the newly inserted record, does this help?
>>>
>>>Yes it does. That's my work around. But I am worried about where else I might be getting stung.


Do you really need buffering on the SeriNo table? Maybe you could turn buffering off for just that one table with CURSORSETPROP(). If you need buffering, you could do a TABLEUPDATE() after the inserts.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform