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
- Aplikasi tetap jalan saat form menu utama ditutup
by hendrahongdexin in Hal umum tentang Pascal Indonesia more 13 years ago - table / query di form DLL
by dell-phi in MySQL more 14 years ago - Instal Delpi gimana?
by Handoyo in Tip n Trik Pemrograman more 17 years ago - Scanner
by clark in Hal umum tentang Pascal Indonesia more 17 years ago - Menentukan Peringkat
by mima in Hal umum tentang Pascal Indonesia more 16 years ago - ada yang tau keunggulan Delphi 7 dibanding Delphi6?
by alvonz in Hal umum tentang Pascal Indonesia more 15 years ago - Tanya Tentang Filter Database Paadox
by tAtA in Tip n Trik Pemrograman more 16 years ago - Ngurangi konsumsi cpu?
by labaga in Tip n Trik Pemrograman more 18 years ago - Teks recognation
by tamara in Delphi.NET more 14 years ago - duh kenapa y qo program running tapi tampilan g ada??
by fafa in Tip n Trik Pemrograman more 16 years ago