Arsip: Ask table exist di zeos

more 13 years ago
ferry
mohon bantuannya para master delphi
saya pake :
delphi 6
zeos 6
postgre 8.1
gimana caranya ngecek table nya ada apa nggak. kalo di BDE bisa pake if table.exist kalo di zeos gimana caranya ya??
sudah coba cari di artikel belum nemu.
thanks & best regards

more 13 years ago
ImanD
@ferry
ini salah satu cara di MySQL, sapa tau bisa di postgre 8.1
[sql]SHOW TABLES WHERE Tables_in_DATABASENAME='TABLENAME'[/sql]

more 13 years ago
ferry
masih bingung neh...caranya gmana ya?pake zmetadata?apa gimana.
simplenya saya mau query data di table tapi ngecek dulu table nya ada apa nggak. kalo ada querynya dijalanin kalo nggak showmessage aja

more 13 years ago
ImanD
@ferry
nah lo, sql tadi maksudnya u/ cek apakan ada ga table tersebut
sample simple
with ZQuery1 do
begin
Close;
SQL.Text:='SHOW TABLES WHERE Tables_in_databasecobacoba='+QuotedStr('tabelbarang');
Open;
if not isEmpty then
// silakan mo ngapain
else
ShowMessage('ga ada tuh tablenya');
end;

more 13 years ago
ImanD
coba nama database nya apa dan table yg akan di cari apa?
ni sample di MySQL ya mudah2an jalan di Postgre

more 13 years ago
DelphiExpert
@ferry: sampean kurang explorasi... komponen DBConnection zeos sudah menyediakan basic metadata info, misal: DB.GetTableNames() ... silahkan explore methods / property komponent tsb...

more 13 years ago
ferry
Case Closed
try
zquery1.Close;
zquery1.SQL.text:='select from Table1';
zquery1.Open;
except
zquery1.Close;
try
showmessage('tablenotfoud');
zquery1.SQL.text:='select from Table2';
zquery1.ExecSQL;
zquery1.Open;
except
end;
Thanks buat Saran nya

more 13 years ago
ichan29
@ferry: Case Closed try zquery1.Close; zquery1.SQL.text:='select from Table1'; zquery1.Open; except zquery1.Close; try showmessage('tablenotfoud'); zquery1.SQL.text:='select from Table2'; zquery1.ExecSQL; zquery1.Open; except end;kok malah gini???, oh nyari fields kali ya, bukan table.. ato di postgre 8.1 apa memang nyari table spt itu

more 13 years ago
ferry
cari table bos.. table1 itu table yg di cek ada apa nggak, kalo ada jalanin query, kalo gak ada ganti pake table 2
more ...
- Pages:
- 1
- 2
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 1 years ago - PascalTalk #5: UX: Research, Design and Engineer
by LuriDarmawan in Tutorial & Community Project more 1 years ago - PascalTalk #4: Obrolan Ringan Seputar IT
by LuriDarmawan in Tutorial & Community Project more 1 years ago - PascalTalk #2: Membuat Sendiri SMART HOME
by LuriDarmawan in Tutorial & Community Project more 1 years ago - PascalTalk #3: RADically Fast and Easy Mobile Apps Development with Delphi
by LuriDarmawan in Tutorial & Community Project more 1 years ago - PascalTalk #1: Pemanfaatan Artificial Intelligence di Masa Covid-19
by LuriDarmawan in Tutorial & Community Project more 1 years ago - Tempat Latihan Posting
by LuriDarmawan in OOT more 2 years ago - Archive
- Looping lagi...
by idhiel in Hal umum tentang Pascal Indonesia more 9 years ago - [ask] koneksi ke ODBC user Dsn saat runtime dengan ado
by halimanh in FireBird more 9 years ago - Validasi menggunakan data tanggal
by mas_kofa in Hal umum tentang Pascal Indonesia more 9 years ago
Random Topic
- gimana cara mindahin kursor ADO sebelum cancel update
by shindo in Hal umum tentang Pascal Indonesia more 15 years ago - nanya buat function wait event
by Tiramitzu in Tip n Trik Pemrograman more 15 years ago - tool utk baca & cetak struktur database
by shindo in Hal umum tentang Pascal Indonesia more 15 years ago - Find field
by saysansay in Paradox more 16 years ago - Tanya font/component barcode
by kacungdelphi24 in Bedah Kasus more 14 years ago - Mengganti nama CLASS saat Runtime
by ondelphi in Hal umum tentang Pascal Indonesia more 16 years ago - Pencarian Tanggal
by galih in Tip n Trik Pemrograman more 15 years ago - Form Show dengan Variabel
by Lamsidjan in Tip n Trik Pemrograman more 15 years ago - dbgrid ke dblookupcombobox
by keylock in Tip n Trik Pemrograman more 13 years ago - fungsi count
by novicute in Paradox more 15 years ago