Search found 6 matches

Go to advanced search

by Cirunz
16.04.2007, 12:45
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: GetTableNames and System Tables
Replies: 0
Views: 653

GetTableNames and System Tables

Hi, I'm writing a simple db viewer with BDS 2006 and ZeosLib, for personal use, and when I open a database with it I fill out a listbox with the tables contained in the DB. On MSSQL 2005 however I've a lot of system tables that I want to filter when I need to use only the user tables of the database...
by Cirunz
13.07.2006, 17:02
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: GetTableNames refresh error
Replies: 8
Views: 2764

Ok I've tried to use the Metadata directly in this way:

Code: Select all

_di_IZDatabaseMetadata MD;

MD = zconmain->DbcConnection->GetMetadata();
MD->ClearCache();
And it worked :)
by Cirunz
13.07.2006, 11:54
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: GetTableNames refresh error
Replies: 8
Views: 2764

Uhm, I've tried this (On C++Builder 6), but the compiler sai it's not a member of IZConnection.

I see that DbcConnection is a _di_IZConnection, that is the Delphi interface for IZConnection. How it's correlated to ZDbcMetaData?
by Cirunz
03.07.2006, 09:45
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: GetTableNames refresh error
Replies: 8
Views: 2764

Ok thanks for the answer Terence, I'll try it for the moment and hope to see the specialized clearcache in the future :)
by Cirunz
27.06.2006, 14:02
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: GetTableNames refresh error
Replies: 8
Views: 2764

GetTableNames refresh error

I've a problem with the GetTableNames function of the ZConnection. I'm using firebird 1.5: after I've created some tables, if I use the GetTableNames function without disconnect and reconnect the ZConnection object, the newly created tables doesn't appears in the list. On BDE I'm used to resolve a s...
by Cirunz
31.03.2006, 15:19
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Newbe - How to lookup databases on server
Replies: 2
Views: 2239

Newbe - How to lookup databases on server

Hi, I have a MSSQL server with various databases on it and I'd like to fill a combo with the list of this databases so the user can choose wich one he want to connect. There is a way to do such a thing? I think there is because at design time if I select host and protocol in the Object Inspector tha...

Go to advanced search