Zeoslib Portal

Zeos ver. 6.6.2 rc and D5, D6

function TZSybaseDatabaseMetadata.GetTableTypes: IZResultSet;

...

Before,
Bad result (errors):

Result.BeforeFirst;
with GetStatement.ExecuteQuery(

{Format('select c.colid, c.name, c.type, c.prec, c.scale, c.status'
+ ' from syscolumns c inner join sysobjects o on (o.id = c.id)'
+ ' where o.name = "%s" order by colid',
[TableNamePattern])) do}

After,
Best result!!!:

Format('select c.colid, c.name, c.type, c.prec, c.scale, c.status'
+ ' from syscolumns c inner join sysobjects o on (o.id = c.id)'
+ ' where o.name = %s order by colid',
[AnsiQuotedStr(TableNamePattern, '''')])) do

begin
while Next do ...

Edit and Compile: ZDbcDbLibSybaseMetadata.pas

Corrected in SVN rev. 364. Looks allright. Didn't test.

Please use the bug tracker next time. Otherwise bugs and fixes may disappear in the mass before they are applied.

Mark