Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
>>>>>>Check and fix your data
>>>>>
>>>>>Don't see any problem with the data - so what might need fixing?
>>>>
>>>>2313 is error for difference in type of transfered data in our code
>>>>For example if you transfer Date, some of the data are correct but some is not in correct format, neverthless that you used Char field to store it for example.
>>>
>>>The table only has a bunch of char(10) fields, 2 integers, 1 numeric and 1 logical field. The logical field has all .F.'s. The SQL table that is created has a matching structure. Allowing nulls in the SQL table doesn't doesn't help. Anything else I can check?
>>>TIA,
>>>Viv
>>
>>May be the problem is in the Numeric field
>
>Tried filling the numeric value in all rows with a 1 but still got the error :-{
It have to be compared data types of fields in SQL and VFP
to mark for possible differences in both filed types
and to check data
Without review of both tables I couldn't advice
but this is usual problem
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement