Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL not seeing all records
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00315081
Message ID:
00316626
Views:
38
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform