-=-
.
.....
  
| messages |
 
RSS
Direkomendasikan menggunakan brower Opera/Chrome/Firefox. Resolusi minimal 1024x768 | Powered by ____ |
 
KiOSS.Com
  
| Switch to Default View |
  
Nikmati Delphi-ID dalam berbagai versi tampilan :
Basic View (LOW Bandwidth)
Default View (Full)
Mobile Edition
Main Menu
..:: onWebTools ::..
..:: onLastPosts ::..
goto Postjumlah komponen maksimal dalam sebuah project(6)
 by d4mnf1y32
 on 21.May at 12:16
goto Posttanya grayscale to biner dengan scanline(1)
 by luckynvic
 on 20.May at 20:44
goto Posttanya looping biner to matriks(1)
 by luckynvic
 on 20.May at 20:10
goto Postsql error:acces denied for user....(2)
 by nasbms
 on 19.May at 16:54
goto Postpemanggilan frame(4)
 by nasbms
 on 19.May at 16:14
goto Posttanya AvLock(0)
 by azuriza
 on 19.May at 11:24
goto PostGet TDBEdit Value Menggunakan LookUp Grid(10)
 by henry_sys
 on 18.May at 11:27
goto Postmenghitung record dalam perulangan(4)
 by idhiel
 on 16.May at 13:53
goto Posttanya ascii(4)
 by mas_kofa
 on 16.May at 12:11
goto PostRawPrint Untuk Delphi XE2(0)
 by adewijaya
 on 15.May at 22:34
goto Postdatabase error..(4)
 by idhiel
 on 15.May at 15:57
goto Postbekasi, pt arila putra mahkota(3)
 by mas_kofa
 on 15.May at 15:37
goto Postbagaimana cara membaca file *.doc dg delphi?(0)
 by ficky
 on 15.May at 06:14
goto Posttanya biner to matriks(13)
 by diandewi
 on 14.May at 20:30

..:: onLast Articles ::..
..:: New Download ::..
Pascal-id.Org
Feeds -  Popular -  Latest
RE: The Longue
8 months, 3 weeks ago
RE: belajar pascal
8 months, 3 weeks ago
RE: The Longue
8 months, 3 weeks ago
RE: belajar pascal
8 months, 3 weeks ago
RE: Perkenalan dan Absen
8 months, 3 weeks ago
RE: Alhamdulillah Buka Puasa Bersama
8 months, 4 weeks ago
RE: تَقَبَّلَ اللهُ مِنَّا وَمِنْكَ - Selamat Hari Raya Idul Fitri
8 months, 4 weeks ago
Lintas Situs
«
free web site stats and visitor tracking
•   Forum FAQ  •  Search  • 

gimana sich cara Sql update tapi datanya Integer
Delphi Indonesia Forum Index » Database » Paradox
Post new topic   Reply to topic
View previous topic Printable version Log in to check your private messages View next topic
Author Message
dodyOffline
Location:
19 Post subject: gimana sich cara Sql update tapi datanya Integer  PostPosted: 12/Jan/2009 14:51
onNovice


Joined: 23-Oct-2008
Posts: 15

Status: Offline
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
 
 View user's profile Send private message  
Reply with quote Back to top
AndyK
Location: Bandung
Post subject: RE: gimana sich cara Sql update tapi datanya Integer  PostPosted: 12/Jan/2009 15:05
onUber-Skilled


Joined: 31-Jan-2008
Posts: 275
Location: Bandung
ga bisanya kenapa??

_________________
= too much DELPHI will not kill you =
 
 View user's profile Send private message Yahoo Messenger  
Reply with quote Back to top
dodyOffline
Location:
Post subject: RE: gimana sich cara Sql update tapi datanya Integer  PostPosted: 12/Jan/2009 15:13
onNovice


Joined: 23-Oct-2008
Posts: 15

Status: Offline
isi-nya "ERROR CREATING CURSOR HANDLE"
gmn dong...???
Tolong y???
 
 View user's profile Send private message  
Reply with quote Back to top
AndyK
Location: Bandung
Post subject:   PostPosted: 12/Jan/2009 15:25
onUber-Skilled


Joined: 31-Jan-2008
Posts: 275
Location: Bandung
klo gini

      Code:

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??
 
 View user's profile Send private message Yahoo Messenger  
Reply with quote Back to top
dodyOffline
Location:
Post subject:   PostPosted: 12/Jan/2009 15:52
onNovice


Joined: 23-Oct-2008
Posts: 15

Status: Offline
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... Very Happy
 
 View user's profile Send private message  
Reply with quote Back to top
AndyK
Location: Bandung
Post subject:   PostPosted: 12/Jan/2009 16:00
onUber-Skilled


Joined: 31-Jan-2008
Posts: 275
Location: Bandung
tambain aza om...

      Code:

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.. Very Happy
 
 View user's profile Send private message Yahoo Messenger  
Reply with quote Back to top
dodyOffline
Location:
Post subject:   PostPosted: 12/Jan/2009 16:16
onNovice


Joined: 23-Oct-2008
Posts: 15

Status: Offline
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...
 
 View user's profile Send private message  
Reply with quote Back to top
AndyK
Location: Bandung
Post subject:   PostPosted: 12/Jan/2009 16:20
onUber-Skilled


Joined: 31-Jan-2008
Posts: 275
Location: Bandung
Very Happy

sama'', masih tahap belajar..., dan terus belajar..., dan belajar...

Amien....,

_________________
= too much DELPHI will not kill you =
 
 View user's profile Send private message Yahoo Messenger  
Reply with quote Back to top
Display posts from previous:     
Jump to:  
All times are GMT - 12 Hours
Post new topic   Reply to topic
View previous topic Printable version Log in to check your private messages View next topic
 Delphi Indonesia Forum Index » Database »  Paradox





Powered by PNphpBB2 © 2003-2009 The Zafenio Team
Credits


| Register | Lost Password ? |