Bug in ZDbcDbLibMsSqlMetadata.pas

In this forum all bug reports concerning the 6.x branch will be gahtered. You have the possibility to track the bug fix process.

Moderators: EgonHugeist, mdaems

fcolak
Fresh Boarder
Fresh Boarder
Posts: 1
Joined: 03.11.2006, 18:45
Location: Turkey-Istanbul

Bug in ZDbcDbLibMsSqlMetadata.pas

Postby fcolak » 03.11.2006, 18:52

I am working on ZDbcDbLibMsSqlMetadata.pas and have a problem with
method GetColumns() that I expalin below

1-with

Code: Select all

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

On this method, my data (%s) not includes single qoutation marks.
Because of this reason program asssumes that o.name parameter is a
column and program crashes.

2- Also on the same unit and the same method, I have another problem.
With

Code: Select all

Result.UpdateShortByName('DATA_TYPE',Ord(ConvertODBCToSqlType(GetShortByName('DATA_TYPE'))));

I took out the rem of this line and added this partial code

Code: Select all

Result.UpdateNullByName('DATA_TYPE');

Otherwise, it doesn't capture the field types.

User avatar
fduenas
Zeos Dev Team
Zeos Dev Team
Posts: 132
Joined: 26.08.2005, 08:12
Location: Cancún

Postby fduenas » 03.11.2006, 21:12

Hi Plz tell us what version of Zeos you´re using and what developement evironment and database base protocol and version


Return to “Bug Reports”

Who is online

Users browsing this forum: No registered users and 1 guest