Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL not seeing all records
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00315081
Message ID:
00316626
Vues:
37
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform