Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SCATTER / GATHER NAME and NULL dates
Message
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Database:
Firebird
Application:
Desktop
Miscellaneous
Thread ID:
01381731
Message ID:
01381758
Views:
21
>Hi Borislav
>
>See my previous reply. I took it forward. New the simply created record was SCATTERed / GATHERed and it is generating and error
>---------------------------
>X-cize - Professionals Customs and Cen. Ex. Appeals Docu.
>---------------------------
>Dynamic SQL Error
>SQL error code = -303
>conversion error from string ""
>---------------------------
>OK
>---------------------------
>the error that is at the client. The backend has rejected the GATHERed record and the GATHERed data is lost.
>


Maybe you have a routine which convert EMPTY/BLANK date fields to NULL, but because fields containing NULL is not EMPTY that is why you get error.




>UPDATE: There are no contraints on the backend I just confirmed it
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform