| Author |
Message |
hera |
| Location: |
|
Post subject: Akses field
 Posted: 24/Aug/2008 17:19
|
|
onBeginner
Joined: 14-Aug-2008
Posts: 6
Status: Offline
|
|
| Saya punya 2 tabel. Cara ambil isi field dari tabel1 untuk dimasukkan tabel2 gimana.Thanks.. |
|
|
| |
|
|
|
 |
|
ichan29 |
| Location: |
|
|
Post subject: Re: Akses field
Posted: 25/Aug/2008 09:31
|
|
onProfessional
Joined: 23-Feb-2007
Posts: 603
Status: Offline
|
|
|
hera wrote:
Saya punya 2 tabel. Cara ambil isi field dari tabel1 untuk dimasukkan tabel2 gimana.Thanks..
banyak cara utk itu, bisa dg cara
Code:
1.Select Table1- Insert Table2
2.BatchExecute
3.SQLDump etc
jd tergantung expore dikau maunya spt apa.. |
|
|
| |
|
|
|
|
|
am4tiranDelphian |
| Location: nGaLam |
|
 |
Post subject: RE: Re: Akses field
Posted: 25/Aug/2008 09:56
|
|
onConfident
Joined: 09-Feb-2008
Posts: 30
|
|
memang cara utk masalh itu tergantung kebutuhan kalo butuhnya cuman buat laporan z mendingan di query z ga usah disimpan [select tabel1.namafield, tabel2.namafield from tabel1, tabel2 where kondisi]
atau kalo data dari tabel1 disimpan permanent ketabel2 bisa gunakan perintah insert z, btw hera pake database apa? |
_________________
drEam Maker cOmmunity "buT dOn't ForgEt to mAkE It rEaL" ^_^
|
| |
|
|
|
|
|
hera |
| Location: |
|
|
Post subject: RE: Re: Akses field
Posted: 25/Aug/2008 14:37
|
|
onBeginner
Joined: 14-Aug-2008
Posts: 6
Status: Offline
|
|
| pke database paradox. Tp ga pake alias. So masih bingung jg. Lha koneksinya gmn ya? Thanks bapak2 sekalian.. |
|
|
| |
|
|
|
|
|
|
|
Post subject: RE: Re: Akses field
Posted: 25/Aug/2008 16:00
|
|
onMage
Joined: 06-Feb-2006
Posts: 2401
|
|
| ngga' pake alias = databasename = full_path |
_________________
Dude, if you don't understand the basics and just want to get someone else write the code for you, it means you really shouldn't study computer science. Find a different field.
 http://delphiexpert.wordpress.com
|
| |
|
|
|
|
|
mas_kofa |
| Location: New York Arto |
|
|
Post subject: RE: Re: Akses field
Posted: 25/Aug/2008 16:37
|
|
onElite
Joined: 18-Mar-2006
Posts: 1753
Location: New York Arto
|
|
|
|
|
|
|
_aa_ |
| Location: |
|
|
Post subject: RE: Re: Akses field
Posted: 26/Aug/2008 01:52
|
|
onKnowledgeable
Joined: 16-Dec-2005
Posts: 129
Status: Offline
|
|
kalo maksudnya duplikasi db, gampangan begini;
masuk ke C:\ prompt (run.. cmd),
lalu ketik: copy source.db destination.db [ENTER]
 |
|
|
| |
|
|
|
|
|
nizar |
| Location: |
|
|
Post subject: RE: Re: Akses field
Posted: 27/Aug/2008 17:44
|
|
onConfident
Joined: 12-Dec-2005
Posts: 31
Status: Offline
|
|
sebenarnya pertanyaanya apa ya? bisa enggak gini
pertama pilih dari tabel satu :
Select field1,field2,field3 from tabel1 where field1='x'
terus dimasukkan ke tabel dua untuk field4,field5,field6
total jadinya :
Insert into tabel1(field4,field5,field6)
select field1,field2,field3 from tabel2 where field1='x' |
|
|
| |
|
|
|
|
|
|
