-=-
.
.....
  
| 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, 3 weeks ago
RE: تَقَبَّلَ اللهُ مِنَّا وَمِنْكَ - Selamat Hari Raya Idul Fitri
8 months, 3 weeks ago
Lintas Situs
«
free web site stats and visitor tracking
•   Forum FAQ  •  Search  • 

perintah update dari 2 tabel di paradox
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
masimam_hOffline
Location:
5 Post subject: perintah update dari 2 tabel di paradox  PostPosted: 15/Dec/2007 16:57
onNewBie


Joined: 15-Dec-2007
Posts: 2

Status: Offline
temen2x, saya punya permasalahan, sy punya 2 tabel paradox, yaitu tabel A dan tabel B. sy ingin mengupdate tabel A dari tabel B, sy menggunakan sql explorer tp nggak bisa2x, sy udah jg pake perintah inner join tp ngk bs jg, tolongin donk pencerahannya. terima kasih.
 
 View user's profile Send private message  
Reply with quote Back to top
muktaf
Location:
Post subject:   PostPosted: 15/Dec/2007 23:17
onKnowledgeable


Joined: 12-Jan-2007
Posts: 204
UPDATE A
SET name = B.name
FROM B
WHERE A.id = B.id;

atau bisa pake

UPDATE Table1
SET UpdateField = (SELECT SourceField FROM Table2
WHERE Table2.KeyField = Table1.KeyField)
WHERE EXISTS (SELECT SourceField FROM Table2
WHERE Table2.KeyField = Table1.KeyField)
 
 View user's profile Send private message Visit poster's website Yahoo Messenger  
Reply with quote Back to top
masimam_hOffline
Location:
Post subject:   PostPosted: 21/Dec/2007 12:06
onNewBie


Joined: 15-Dec-2007
Posts: 2

Status: Offline
terima kasih atas bantuannya...
saya udah coba tp msh nggak bisa2x jg kenapa ya?
sy coba gunakan perintah ini:

UPDATE reklama.DB
SET tbayar = (SELECT tbayar FROM rekselisih
WHERE rekselisih.notabul = reklama.notabul)
WHERE EXISTS (SELECT tbayar FROM rekselisih
WHERE rekselisih.notabul = reklama.notabul)

keluar pesan:
invalid field name notabul

tolongin donk.. trims atas bantuannya
 
 View user's profile Send private message  
Reply with quote Back to top
heraOffline
Location:
Post subject:   PostPosted: 24/Aug/2008 16:23
onBeginner


Joined: 14-Aug-2008
Posts: 6

Status: Offline
Klo punya 2 tabel trus mo ambil isi field dari tabel1 untuk ditampilin / dimasukkan tabel2 gmn caranya . tolong kasih tahu cara Koneksi terus gimana procedure nya. Tp sy buat ga pake alias. Tolong dikasi solusi.Makasih....
 
 View user's profile Send private message  
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 ? |