Zeoslib Portal

Any updates to this problem?

I've the same problem.

timeout=x only sets the login timeout, but not query timeout.

Hi, I've a very complex table-value function in MS-SQL (ADO protocol) which takes a long time to complete/send the first resultset row. For example: SELECT * FROM MY_FUNC(param1, param2, ...); Sometimes it takes more than 60 seconds (using SQL Management Studio) until the server returns the first ro...

Yes, it works correctly with Tables containing TEXT columns.

Hi, I have a script which contains all CREATE statements for my views, procedures and indicies. This script is an export from IBExpert (Firebird 2.0 DB). That's not a special format, it's just a list of multiline CREATE statements: SET TERM ^ ; CREATE PROCEDURE FOOO.... BEGIN ........ END^ CREATE PR...

Hi, I'm using TZMetadata on a Firebird 2.0 database to receive the tables, views, procedures. etc. mdTables works fine for TABLE objects, but not for VIEWs. Examples: Some VIEWs are returned correnct: one row, containing the VIEW name and the type "VIEW". This VIEWs have a VIEW_CONTEXT = 0...

Oops, my fault - sorry :roll: I have only uncommented Result.UpdateShortByName('DATA_TYPE', Ord(ConvertAdoToSqlType(GetShortByName('DATA_TYPE')))); but not the rest of the code which checks the column flags reported by the server. At my first post, there wasn't any blob fields in my database, so unc...

This effect is strange, as that code didn't change... Mark The point is, the exception is only raised if I uncomment the code showed in my first post. In the official version, the exception is not raised! The Metadata Resultset column "COLUMN_SIZE" is initialized with GetIntByName('CHARAC...

ColumnInfo.Precision is for text datatypes 2147483647 UPDATE: I have found the reason why the exception is raised: FColumnLengths[I] := GetColumnSize(Current); FColumnOffsets[I] := FColumnsSize; Inc(FColumnsSize, FColumnLengths[I] + 1); FColumnsSize is the size of all columns. So, adding 2147483647+...

I have tried my "fixed" zeoslib in some existing projects. Every attempt to open a query, an integer overflow exception is raised. The exception is raised in ZDbcCache on line 323 in method TZRowAccessor.GetColumnSize. stString: Result := ColumnInfo.Precision + 1; So, uncommenting the code...

Hi, I've just tried to request the column type of an mdColumns metadata request. I have many different datatypes used in my tables, but every request to self.FMetadata.FieldByName('DATA_TYPE').AsInteger returns 0 (for MSSQL/ADO connections). On line 1584 in ZDbcAdoMetadata.pas I have found the follo...

I'm only use Firebird or MSSQL and the Stored Procedures are only procs with input params and one result set.

The current API spec. requires the exact type, so if I always assume the type is string, the application allways calls set_param_asString. But I think I can change the API so the application must call set_param(index, datatype, databuf); because you're right - the application should know the exact t...

Hm okay, an Integer param can be set with asString := '2' and asInteger := 2;.

But how can I set a date value? I have tried asString := '24.12.2008' and many other formats, but none works.

UAHH

okay, but what about myapi_get_paramtype()?

With paramCheck := true the Params are added, but the type is 0 (unknow).