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.
Search found 7 matches
- 28.04.2009, 11:06
- Forum: 6.6 - stable
- Topic: Input parameter count is less then expected
- Replies: 8
- Views: 1415
- 03.04.2009, 08:03
- Forum: 6.6 - stable
- Topic: SQLServer default fieldlength incorrect
- Replies: 6
- Views: 674
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 ...
- 27.03.2009, 08:30
- Forum: 6.6 - stable
- Topic: SQLServer default fieldlength incorrect
- Replies: 6
- Views: 674
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 ...
- 26.03.2009, 13:56
- Forum: 6.6 - stable
- Topic: SQLServer default fieldlength incorrect
- Replies: 6
- Views: 674
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. ...
- 26.03.2009, 09:43
- Forum: 6.6 - stable
- Topic: SQLServer default fieldlength incorrect
- Replies: 6
- Views: 674
- 24.03.2009, 12:08
- Forum: 6.6 - stable
- Topic: SQLServer default fieldlength incorrect
- Replies: 6
- Views: 674
SQLServer default fieldlength incorrect
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...
- 24.03.2009, 12:01
- Forum: 6.6 - stable
- Topic: Conversion failed when converting from a character string to
- Replies: 1
- Views: 401
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...