Arsip: gimana sich cara Sql update tapi datanya Integer
more 15 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:
more 15 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??
more 15 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
more 15 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
more 15 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...
more 15 years ago
AndyK
:D
sama'', masih tahap belajar..., dan terus belajar..., dan belajar...
Amien....,
more ...
- Pages:
- 1
reply |
Report Obsolete
Last Articles
Last Topic
- PascalTalk #6: (Podcast) Kuliah IT di luar negeri, susah gak sih?
by LuriDarmawan in Tutorial & Community Project more 3 years ago - PascalTalk #5: UX: Research, Design and Engineer
by LuriDarmawan in Tutorial & Community Project more 3 years ago - PascalTalk #4: Obrolan Ringan Seputar IT
by LuriDarmawan in Tutorial & Community Project more 3 years ago - PascalTalk #2: Membuat Sendiri SMART HOME
by LuriDarmawan in Tutorial & Community Project more 3 years ago - PascalTalk #3: RADically Fast and Easy Mobile Apps Development with Delphi
by LuriDarmawan in Tutorial & Community Project more 3 years ago - PascalTalk #1: Pemanfaatan Artificial Intelligence di Masa Covid-19
by LuriDarmawan in Tutorial & Community Project more 3 years ago - Tempat Latihan Posting
by LuriDarmawan in OOT more 4 years ago - Archive
- Looping lagi...
by idhiel in Hal umum tentang Pascal Indonesia more 11 years ago - [ask] koneksi ke ODBC user Dsn saat runtime dengan ado
by halimanh in FireBird more 11 years ago - Validasi menggunakan data tanggal
by mas_kofa in Hal umum tentang Pascal Indonesia more 11 years ago
Random Topic
- list index out of bound
by rizu in Tip n Trik Pemrograman more 15 years ago - input data di postgres
by ferry in Lain-lain more 15 years ago - Error web service di Delphi 2007
by EkoIndri in Delphi.NET more 16 years ago - Ada yang pernah coba Zeos + SQLite3 + Delphi 2010?
by mambamaestro in Hal umum tentang Pascal Indonesia more 13 years ago - bikin mapping untuk perumahan
by dney in Bedah Kasus more 16 years ago - Gimana Taruh Checkbox skin di DBGrid ?
by R-One in MySQL more 16 years ago - Menghitung Jumlah hari minggu
by grounders in Enginering more 18 years ago - analisa isi kolom buat database
by sandy in Tip n Trik Pemrograman more 15 years ago - TButton dikawinkan dengan TShape
by EkoIndri in Tip n Trik Pemrograman more 17 years ago - resize image
by sulth4n in Multimedia & Graphic Enhancement more 18 years ago