Arsip: gimana sich cara Sql update tapi datanya Integer

 
user image
more 12 years ago

dody

Hallo.. Ada yang bisa bantu ak g....?? ak mw update stok yang tipenya numerik ak pakai Paradoks.. Ak coba listing ini gak bisa2... ada yang tau g??? Tolong perbaiki y??? edit2.Text:=inttostr(table8['stok']+table3['quantity']); edit3.Text:=table3['kd_product']; query3.SQL.Clear; stok1:=strtoint(edit2.Text); query3.SQL.Add('update barang2 set stok='''+edit2.Text+'''where nm_cus='''+ecustomer.Text+'''and kd_barang='+quotedstr(edit3.Text)); query3.Active:=true; Pleasee.... :wink: ak g punya :idea:
user image
more 12 years ago

AndyK

ga bisanya kenapa??
user image
more 12 years ago

dody

isi-nya "ERROR CREATING CURSOR HANDLE" gmn dong...??? Tolong y???
user image
more 12 years ago

AndyK

klo gini

with Query3 do
begin
  SQL.Clear;
  SQL.Add(update barang2 set stok='''+edit2.Text+'''where nm_cus='''+ecustomer.Text+'''and kd_barang='+quotedstr(edit3.Text)');
  ExecSQL;
end;
gmn??
user image
more 12 years ago

dody

with Query3 do begin SQL.Clear; SQL.Add('update barang2 set stok='''+edit2.Text+'''where nm_cus='''+ecustomer.Text+'''and kd_barang='+quotedstr(edit3.Text)); ExecSQL; end; gak eror sich... tapi kok gak bertambah stpknya y?? 1 Kali Lagiii Boleh...???? Tolong Pak andi... :D
user image
more 12 years ago

AndyK

tambain aza om...

with Query3 do
begin
SQL.Clear;
SQL.Add('update barang2 set stok=stok+'''+edit2.Text+'''where nm_cus='''+ecustomer.Text+'''and kd_barang='+quotedstr(edit3.Text));
ExecSQL;
end;
gmn?? oh.. saya blum bapak",he.. :D
user image
more 12 years ago

dody

UUHuiiii... Finally Bisa... Wehhhh Hebat juga y Bhs Sql-nya... Thanks... Berat... Banget... Hebat..... Kasih Tips Donk....??? Sql masih sedikit rumit... Makasih Banyak.... Semoga Mendapatkan Rezeki... yang banyak, Istri Cantik... Dll Deh...
user image
more 12 years ago

AndyK

:D sama'', masih tahap belajar..., dan terus belajar..., dan belajar... Amien....,
more ...
  • Pages:
  • 1
Share to

Random Topic

Local Business Directory, Search Engine Submission & SEO Tools FreeWebSubmission.com SonicRun.com