On 16-12-2012 14:55, Michael Van Canneyt wrote: > > > On Sun, 16 Dec 2012, Reinier Olislagers wrote: > >> On 16-12-2012 2:27, John wrote: >>> @Reinier: >>>>> Analysis: >>>>> As far as I can work out, a call to GetTableNames calls GetDBInfo, >>>>> with >>>>> parameters >>>>> ASchemaType : TSchemaType - This specifies what info we want - user >>>>> tables, sys tables, procedures, columns etc >>>>> ASchemaObjectName - Doesn't seem to be used, it is specified as "" >>>> No, it's not used for GetTableNames; it is used e.g. to specify the >>>> table name if you want to know info about columns. >>> Yes, I saw that, but there seems no reason why it could not be used as a >>> schema selection. >> I understand; just wanted to let you know what it was used for. >> >>> I also had a flip through the previous discussion, but it was indeed a >>> long and tortuous thread to follow! >> Agreed. AFAIR, there was a decision in the end... but it was a long >> thread and a long while ago. >> I've incorporated some of Lacak's proposal into >> http://wiki.lazarus.freepascal.org/Database_metadata#Proposal_for_extension.2Funiformization >> >> ... and will update that page going through that thread. >> If anybody gets to it earlier, please feel free to update the page ;) > > It would be good to add a link to the 'standard sql' referred to ? > Also, e.g. PostgreSQL and Mimer have very good documentation on what these information_schema views contain. I vaguely recall this was covered in our previous thread...
_______________________________________________ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal