Fox-id.org :: Komunitas FoxPro Indonesia

General Category => General/Umum/OOT => Topic started by: Yaku on August 01, 2019, 05:50:51 PM

Title: RV
Post by: Yaku on August 01, 2019, 05:50:51 PM
malam semua,

sy menggunakan database Access dan ada masalah dgn pemakaian RV, yaitu saat insert/update data terhadap RV. tabel RVnya berubah tetapi database Access nya tidak ikut berubah saat itu juga, menunggu tabel RV d close dulu baru database Access menyimpan perubahannya.
sy membutuhkan agar saat RV di rubah database Access juga langsung ikut berubah saat itu juga, bagai mana caranya ya ?

Terima kasih sebelumnya....
Salam Fox-id
Title: Re: RV
Post by: Pujianto on August 02, 2019, 09:24:37 AM
Saya Pakai itu..
Semoga sukses..


Code: [Select]
=AddProperty(_Screen,"nHandle",Sqlstringconnect('Driver={Microsoft Access Driver (*.mdb)};Dbq=c:\dataku.mdb;Exclusive=0;Uid=admin;Pwd='))

=SQLEXEC(_screen.nHandle,"UPDATE CHECKINOUT SET status='SUKSES' WHERE status=?proses")
Title: Re: RV
Post by: Yaku on August 02, 2019, 04:48:25 PM
Saya Pakai itu..
Semoga sukses..


Code: [Select]
=AddProperty(_Screen,"nHandle",Sqlstringconnect('Driver={Microsoft Access Driver (*.mdb)};Dbq=c:\dataku.mdb;Exclusive=0;Uid=admin;Pwd='))

=SQLEXEC(_screen.nHandle,"UPDATE CHECKINOUT SET status='SUKSES' WHERE status=?proses")




kenapa muncul kotak pertanyaan : Enter the value for proses :
Title: Re: RV
Post by: Pujianto on August 03, 2019, 11:58:32 AM
proses itu suatu variable..

Code: [Select]
Public proses

proses = 'SIAP'

=AddProperty(_Screen,"nHandle",Sqlstringconnect('Driver={Microsoft Access Driver (*.mdb)};Dbq=c:\dataku.mdb;Exclusive=0;Uid=admin;Pwd='))

=SQLEXEC(_screen.nHandle,"UPDATE CHECKINOUT SET status='SUKSES' WHERE status=?proses")
Title: Re: RV
Post by: Yaku on August 03, 2019, 04:54:50 PM
proses itu suatu variable..

Code: [Select]
Public proses

proses = 'SIAP'

=AddProperty(_Screen,"nHandle",Sqlstringconnect('Driver={Microsoft Access Driver (*.mdb)};Dbq=c:\dataku.mdb;Exclusive=0;Uid=admin;Pwd='))

=SQLEXEC(_screen.nHandle,"UPDATE CHECKINOUT SET status='SUKSES' WHERE status=?proses")


Terima kasih Pak  :icon_thumright: :icon_thumright: :icon_thumright: