In-Reply-To: <[EMAIL PROTECTED]>
Paul,
Can you give us an example (ie the code or SQL) of a write that won't
work?
----------Original Message------------------
> We are having problems writing to Foxpro dbc tables for numeric or
> integer values with remote CF-based SQL queries. CF reports a data type
> mismatch.
> We have tried many procedures, such as: retrieving integer data as a
> string, converting to numeric with CF [NumberFormat(), Val(), or
> ParseNumber()] incrementing while setting a new variable name
> [retrieval + 1 or IncrementValue()], testing the result [IsNumeric()]
> for conditional display (*always successful*), and then committing the
> results -- both with and without various single or nested SQL functions
> appended to the query [int(#variable#) or val(int(#variable#)) for
> integer and numeric fields respectively, for instance].
> No combination has thus far returned a single successful query write.
> Anyone taken on Foxpro sources?
Terry Riley
Riley Varea Associates, London, UK
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.