Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to get ONLY buffered records?
Message
 
À
13/06/2004 02:39:56
Suhas Hegde
Dental Surgeon
Sirsi, Inde
Information générale
Forum:
Visual FoxPro
Catégorie:
Visual FoxPro Beta
Divers
Thread ID:
00913176
Message ID:
00913179
Vues:
21
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform