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:
00317362
Vues:
43
Sorry Barbara, I wasn't able to test SKIP 0, but I now believe you're right about the buffering. I have the form buffering set to 0, "none" and the cursor in the data environment set to 1, "use form setting". There's a bug in VFP whereby the cursor will sometimes ignore the form setting in this case. I've run against that one before but had forgotten. Must be getting too old.

So I'll test that shortly.
Thanks again


>David,
>I'm sorry I wasn't clear - the 'bound control' I mentioned was in my analogy to a textbox not updating a table. I'd still be curious if a SKIP 0 command worked.
>
>I know you said this is a free table, but what about buffering? A row buffered table would save every record when you insert the next record, but the last one wouldn't yet be saved to disk.
>
>Barbara
>
>
>>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform