Senin, 29 Juni 2015

Menampilkan Data ke Grid di FoxPro


Masukan funsi dibawah ini :

SELECT field1,field2 FROM namatabel ORDER BY field1; 
into CURSOR CrsNamatabel;
thisform.GrdNamatabel.RecordSource = "CrsNamatabel"
apabila ingin mencari karakter tertentu :

SELECT field1,field2 FROM namatabel;
WHERE field1 LIKE '%'+ALLTRIM(UPPER(THISFORM.txtField1.value))+'%';
into CURSOR CrsNamatabel;
thisform.GrdNamatabel.RecordSource = "CrsNamatabel"

0 komentar:

Posting Komentar