Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL not seeing all records
Message
From
12/01/2000 20:41:04
 
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00315081
Message ID:
00317363
Views:
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.

I don't have buffering explicity set on. The form property is no buffering and the cursor is "use form setting" but apparently VFP ignores this in certain cases!
Previous
Reply
Map
View

Click here to load this message in the networking platform