Re: [indoprog-vb] Re: Gimana cara menyimpan nama yg memiliki lambang ' contoh : Sudja'i

[David Joyo Mulyono]

Pakai perintah Replace(txt,"'","''")

contoh :

SQL="Insert into TblA (Kode,Nama) Values ('" & replace(txtkode,"'","''") &
"','" & replace(txtNama,"'","''") & "'"

Best Regards,
David J M

Advess
ISV and IT Consultant