Arsip: Ask table exist di zeos
                
                   more 17 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 17 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 17 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 17 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 17 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 17 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 17 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 17 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 17 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
                  
                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 5 years ago - PascalTalk #5: UX: Research, Design and Engineer
by LuriDarmawan in Tutorial & Community Project more 5 years ago - PascalTalk #4: Obrolan Ringan Seputar IT
by LuriDarmawan in Tutorial & Community Project more 5 years ago - PascalTalk #2: Membuat Sendiri SMART HOME
by LuriDarmawan in Tutorial & Community Project more 5 years ago - PascalTalk #3: RADically Fast and Easy Mobile Apps Development with Delphi
by LuriDarmawan in Tutorial & Community Project more 5 years ago - PascalTalk #1: Pemanfaatan Artificial Intelligence di Masa Covid-19
by LuriDarmawan in Tutorial & Community Project more 5 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 13 years ago - [ask] koneksi ke ODBC user Dsn saat runtime dengan ado
by halimanh in FireBird more 13 years ago - Validasi menggunakan data tanggal
by mas_kofa in Hal umum tentang Pascal Indonesia more 13 years ago 
Random Topic
- Get The Computer Name
by kabuki_enemy in Tip n Trik Pemrograman more 17 years ago - ask - edit posting tidak berhasil
by cyber_hecker in Moderator Only more 18 years ago - chart di excel
by lela in Hal umum tentang Pascal Indonesia more 18 years ago - konfigurasi Jedi VCS di untuk database SQL server
by Brams in Tip n Trik Pemrograman more 18 years ago - error rave
by ard33 in Reporting more 17 years ago - Pindah Control Dengan Panah / Enter
by cyber_hecker in Tip n Trik Pemrograman more 20 years ago - Installer untuk Delphi (7)
by langithitam in Tip n Trik Pemrograman more 18 years ago - sekedar mau tanya nihhhh masalah file
by barong in Reporting more 14 years ago - tentang MDI Application...
by Indr@ in Tip n Trik Pemrograman more 15 years ago - TIP: Meningkatkan Proses Startup IDE Delphi 2005
by deLogic in Tip n Trik Pemrograman more 19 years ago