Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to get ONLY buffered records?
Message
 
To
13/06/2004 02:39:56
Suhas Hegde
Dental Surgeon
Sirsi, India
General information
Forum:
Visual FoxPro
Category:
Visual FoxPro Beta
Miscellaneous
Thread ID:
00913176
Message ID:
00913179
Views:
23
Hi Suhas,

>Hi,
>
>how to get only buffered records ?

Try this:
Create Cursor abcd (abc C(10))
insert into abcd values('xyz')
insert into abcd values('xyz1')
cursorsetprop("buffering",5)
insert into abcd values('xyz2')
insert into abcd values('xyz3')
replace abc WITH 'xyz4' FOR abc='xyz1'
** Get all records with changed values (or new empty records)
select * from abcd with (buffering = .t.) WHERE !EMPTY(CHRTRAN(GETFLDSTATE(-1),"1",""))
** Get all new records
select * from abcd with (buffering = .t.) WHERE RECNO()<0
hth,
Frank Camp
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform