Bug in ZDbcDbLibMsSqlMetadata.pas

[fcolak]

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.

[fduenas]

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