GetTableNames syntax ?

[kuma]

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]

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]

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]

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()) ;-)