I can not Update a MS SQL Server table

Luis Enrique

Delphi Developer

I can not Update a MS SQL Server table

2004-07-05 02:37:17 AM
delphi42
Hi All
I have a error that have me crazy.
I have a database MS SQL Server 7.0, all well, except to migrate by code a table, the program in the half of the table (in Paradox) to insert in the SQL table, give mi the error :
"Value of character is invalid for cast especification" (My SQL is in spanish, sorry for the traduction)
Why ocurrs this ? if the process run ok, in many one hundreds of record, but in a groups de record give mi the error. I revised the data and not find any thing different.
WHY this error please.
Team B, help me, please.
Thanx
Luis Enrique
P.D. : I use Delphi 6

Luis Enrique

Delphi Developer

2004-07-05 03:54:11 PM

Re:I can not Update a MS SQL Server table

OK, solved, one field of Tdatetime type have year=202 not 2002
"Luis Enrique" <XXXX@XXXXX.COM>writes:

Quote

Hi All
I have a error that have me crazy.
I have a database MS SQL Server 7.0, all well, except to migrate by code a table, the program in the half of the table (in Paradox) to insert in the SQL table, give mi the error :
"Value of character is invalid for cast especification" (My SQL is in spanish, sorry for the traduction)
Why ocurrs this ? if the process run ok, in many one hundreds of record, but in a groups de record give mi the error. I revised the data and not find any thing different.
WHY this error please.
Team B, help me, please.

Thanx
Luis Enrique

P.D. : I use Delphi 6