[bug_fixed] Zeos 6.6.2 rc: Invalid column name ASE 12.5.3

Forum related to Sybase ASE

Moderators: gto, cipto_kh, EgonHugeist

Post Reply
LEm
Fresh Boarder
Fresh Boarder
Posts: 2
Joined: 15.04.2008, 14:12

[bug_fixed] Zeos 6.6.2 rc: Invalid column name ASE 12.5.3

Post by LEm »

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 ...
LEm
Fresh Boarder
Fresh Boarder
Posts: 2
Joined: 15.04.2008, 14:12

Post by LEm »

Edit and Compile: ZDbcDbLibSybaseMetadata.pas
User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Post by mdaems »

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
Image
Post Reply