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

Forum related to Sybase ASE

Moderators: gto, cipto_kh, EgonHugeist

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

Postby LEm » 15.04.2008, 14:23

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

Postby LEm » 15.04.2008, 15:12

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:

Postby mdaems » 15.04.2008, 20:25

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


Return to “Sybase ASE”

Who is online

Users browsing this forum: No registered users and 1 guest