[fpc-pascal] Database Metadata proposal

LacaK lacak at zoznam.sk
Mon Jun 2 08:01:59 CEST 2014

Hi Daniel,
If I understand correctly, when you will use new GetObjectNames then you 
must itterate throught returned collection to obtain "schema names" + 
"object names" (f.e. "table names").

IMO very similar result you can get also with existing implementation, 
when you use:

with SQLQuery1 do begin
  SetSchemaInfo(stTables); // here you can set type of schema query like 
stTables, stColumns, stProcedures, stSchemata etc.
  Open; // here is opened dataset with requested schema query
  while not Eof do begin
    // here you can use FieldByName('SCHAME_NAME').AsString , 
FieldByName('TABLE_NAME').AsString, etc.


> An Issue was created with the patch:
> http://bugs.freepascal.org/view.php?id=26254
> On Sun, Jun 1, 2014 at 11:28 AM, Daniel Gaspary <dgaspary at gmail.com> wrote:
>> I see no problem. It was just a wrong impression that I had about
>> TCollectionItem.
> _______________________________________________
> fpc-pascal maillist  -  fpc-pascal at lists.freepascal.org
> http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freepascal.org/pipermail/fpc-pascal/attachments/20140602/0d2ad24e/attachment.html>

More information about the fpc-pascal mailing list