GetTableNames syntax ?
lazarus / 16-Databases

----------------------------------------------------------------------
kuma · 2006-08-17 07:17

Someone knows what different of the GetTableNames whit Delphi and
Lazarus.

I use the component of Zeos-6.5.1_alpha.TZConnection and the procedure
GetTableNames to get Firebird table structure.

But I found this procedure have some different with
Delphi.ADOConnection.

The Zeos-6.5.1_alpha.TZConnection.GetTableNames syntax is ..

GetTableNames(const pattern:string; List:TStrings;)

Who can explain what is the pattern or who can give some documents for
reference.

Thanks and please don't concerned my english too bad.

----------------------------------------------------------------------
JanH · 2006-08-17 10:51

in the past I used this function in delphi. if I remind right, you can
call
Code: [Select]GetTableNames( 'a*', sl )
to get all tables starting with 'a'.

----------------------------------------------------------------------
kuma · 2006-08-18 06:45

I Tried by your example. But it didn't worked by my think.
Nevertheless the procedure retuen all tables name.

My function is ..

procedure TFDelNull.GetDataBaseStructure;
var I : Integer;
begin
  ListBox1.Clear;
  ZConnection1.GetTableNames('A*', ListBox1.Items);
  for I := 0 to ListBox1.Items.Count-1 do
      begin
      TIComboBox1.Items.Add(Trim(Trim(ListBox1.Items)));
      end;
end;    

The Zeos-6.5.1_alpha.TZConnection.GetTableNames syntax is ..
GetTableNames(const pattern:string; List:TStrings);
   
The ADOConnection1.GetTableNames syntax is ..
GetTableNames(List:TStrings; SystemTables:Boolean=False);

I think both is different.

----------------------------------------------------------------------
JanH · 2006-08-22 11:01

ADO and Zeos are two different packages. So why the syntax have to be
the same? It's mere chance that the functions has the same name - I
think. The zeos-function returns table names like a pattern, and the
ADO-function returns either system-tables or user-tables.

What is your problem?

Tip: one trim() is the same as trim(trim()) ;-)