Zeoslib Portal

I got this error message too on Firebird.
Somehow the names of the parameters, in your case :veiculos_id,:proxima_troca, where different from the names shown in the Params property editor.

The patch is ok. CodeGear did the same thing. But I did try to add the TGuidField to the source. This would be a better solution, because this field type is for this kind of field. But then a very very old bug in delphi makes it useless. :roll: It is just impossible to use a TGuidField. So the only ...

I have also tried to add the TGuidField type to the source. This does work, but another bug in the delphi library gives an error :shock: An error Incorrect field length comes up. Searching internet I found the same error as a bug in Delphi 8 :shock: ( I'm using delphi 2007) This bug prevents adding ...

After some debugging and google-ing I have discoverd some strange things. The ADO struct indeed gives a length of 16. I did not found another property with the correct length. I found this site: http://doc.ddart.net/mssql/sql70/impt_bcp_14.htm The length depends on the storage kind, char or native. ...

Well Ado was new for me too.
But MSSQL from 2005 on does not standard use the dblib anymore.
For 2005 it can be done by manually copy the dll, but it's not recomended.

So the only option left is ADO I think.

I'll try to debug it and see what is happening.

Jan

Hello all, I'm using the Zeos 6.6.4 stable and Delphi 2007. To connect to MSSql I used the ADO setting of the connection component. My query is generated at runtime. In a query is an uniqieuidentifier field. This field is created as a stringfield with a lentgh of 16 characters. So the field is to sh...

Normaly the value for a uniqueidentifier is generated bij de server. This can be done in a trigger, setting the default value for the field to newid(). Have you added persistent fields to the table component? In that case Delphi will fill the field with something like '' (empty string). And the defa...