Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append from and Deleted()
Message
From
30/07/1999 13:05:11
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00247953
Message ID:
00248266
Views:
13
Hmmm... I was pretty sure the dele flag did work, it was only when you were trying to test it that you ran into problems, iirc.

append from myfile.dbf && appends all records w/dele() flag
append from myfile.dbf for !dele() && appends all records, don't remember dele() flag

The problem was that the record gets "pseudo" appended before the condition is checked, but the deleted flag wasn't part of the "pseudo" append.

I may be remembering this completely wrong...

>>>I have been working on a data conversion PRG for bringing in data from a FPD 2.6 app to VFP 6 SP3 database. I just noticed that if I have SET DELETED OFF and append from SomeTable, the Deleted mark also comes over now. I do not beleive this to always have been the case prior to VFP6 and maybe is even new with SP3. I do know this was a problem in FPD 2.6.
>>>
>>>Yahoo! Now I can bring over all records with much less conversion code if I need to keep my deleted records.
>>
>>No, this has been possible for a long time now, at least since vfp5, I'm quite sure. You may well be right about the FPD, though...
>>
>>BTW, I just noticed my frames in the UT are all resizable. That's great, I hadn't noticed this before in IE...this is something new?
>
>I know this was not true in FPD 2.6. Tried before this post to make sure I was not hallucinating. I am almost certain the deleted did not come over in VFP 3. I can not remember about 5. I do know that my first data conversion from 2.6 to VFP opened the 2.6 tables exclusively to pack them before appending from them for that very reason. I was having trouble with deleted records not being handled properly regardless of the SET DELETED setting.
>
>I have been able to resize frames for a while now. I am using NS 4.5
--Todd Sherman
-Wake Up! Smell the Coffee!
Previous
Reply
Map
View

Click here to load this message in the networking platform