Arsip: INNER joint di DBF
more 17 years ago
nurez
hii all, mohon bantuannya yha :)
mau melakukan update di database DBF dgn perintah :
UPDATE TBLMSTUSR INNER JOIN tbf014buki ON TBLMSTUSR.MSTUSR= tbf014buki.UIDSGN SET TBLMSTUSR.MSTLOK= tbf014buki.UIDLOK
dgn koneksi ODBC via ADO
ada error :" keyword INNER not expected valid tokens : SET"
harusnya ganti apa yha..?
@ b4 ...makasih ats tanggapan dan perhatiaannya :)
more 17 years ago
zieborg
UPDATE T1 SET T1.MSTLOK= T2.UIDLOK
FROM TBLMSTUSR T1, tbf014buki T2 WHERE T1.MSTUSR= T2.UIDSGN
more 17 years ago
nurez
hmm msh salah masz.. "column qualifier or table T1 underfined
MODE ON MOMOD..
more 17 years ago
zieborg
coba aliasnya ilangin semua, jadi
UPDATE TBLMSTUSR SET TBLMSTUSR.MSTLOK= tbf014buki.UIDLOK
FROM TBLMSTUSR , tbf014buki WHERE TBLMSTUSR.MSTUSR= tbf014buk.UIDSGN
kira2 begitu deh, kutak-katik lagi aja, btw JOIN itu hanya untuk perintah SELECT
more 17 years ago
ImanD
@nurez
ini panduan yg menurut saya bagus.....
http://www.foxite.com/search.aspx?q=update-inner-join
more 17 years ago
nurez
makasih kang imand...
mw dicoba dlu nich.. doain ya.. :)
mmm.. pusinkk kgg ada :( bhsnya ndeso smua..
more 17 years ago
nurez
klo spt ini hasilnya sama apa ngga yha..?
INSERT into TBLMSTUSR (MSTlok) SELECT tbf014buki.uidlok FROM tbf014buki
LEFT OUTER JOIN TBLMSTUSR ON tbf014buki.uidsgn =
TBLMSTUSR.MSTUSR WHERE TBLMSTUSR.MStlok IS NULL
gmn kawan2..? hmmm
more 17 years ago
zieborg
Baru sempet nyobain nih..
Untuk MSSQL syntax yg saya post diatas ngga masalah, jalan
DBF/Paradox tidak support update menggunakan metode tsb, kamu harus looping tablenya dalam delphi.
kesimpulannya : dbf/paradox ngga fully kompatibel dg SQL-92
more ...
- Pages:
- 1
- 2
reply |
Report Obsolete
AI Forward
🚀 We're thrilled to partner with Alibaba Cloud for "AI Forward - Alibaba Cloud Global Developer Summit 2025" in Jakarta! Join us and explore the future of AI. Register now:
https://int.alibabacloud.com/m/1000400772/
#AlibabaCloud #DeveloperSummit #Jakarta #AIFORWARD
Last Articles
Last Topic
- PascalTalk #6: (Podcast) Kuliah IT di luar negeri, susah gak sih?
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #5: UX: Research, Design and Engineer
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #4: Obrolan Ringan Seputar IT
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #2: Membuat Sendiri SMART HOME
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #3: RADically Fast and Easy Mobile Apps Development with Delphi
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #1: Pemanfaatan Artificial Intelligence di Masa Covid-19
by LuriDarmawan in Tutorial & Community Project more 4 years ago - Tempat Latihan Posting
by LuriDarmawan in OOT more 5 years ago - Archive
- Looping lagi...
by idhiel in Hal umum tentang Pascal Indonesia more 12 years ago - [ask] koneksi ke ODBC user Dsn saat runtime dengan ado
by halimanh in FireBird more 12 years ago - Validasi menggunakan data tanggal
by mas_kofa in Hal umum tentang Pascal Indonesia more 12 years ago
Random Topic
- Query Processing Integrated with ProgressBar
by n3o_cybertech in Hal umum tentang Pascal Indonesia more 17 years ago - Komponen tidak terlihat dipalette
by rusli_chow in Tip n Trik Pemrograman more 17 years ago - tanya: baca/tulis sector dihardisk?
by labaga in Enginering more 19 years ago - DIsplay kasir
by agoes in Tip n Trik Pemrograman more 17 years ago - BANTU ENE BUAT PROGRAM BATREY STATUS
by dedidavidbala in Hal umum tentang Pascal Indonesia more 13 years ago - [ask] Pesan Error EDBEngineError "corrupt index....
by yusdi in Enginering more 17 years ago - memunculkan data di lembar kedua saja (qreport)..??
by imunk in Hal umum tentang Pascal Indonesia more 18 years ago - read assembler di delphi dengan CPORTLIB
by w4rek in Enginering more 17 years ago - Program zoom in/out images
by zed1308 in Tip n Trik Pemrograman more 15 years ago - Versi QuickReport di Delphi 7.0
by reminder2k1 in Reporting more 17 years ago