Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Scatter memvar causes datatype mismatch?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00538234
Message ID:
00538238
Views:
9
>Hi,
>
>I have a view, created of some remote views and local tables. The remoet views is ODBC Access tables.
>
>The following couses an error:
>
>SCATTER MEMVAR
>APPEND BLANK
>BROW
>** Here I change the few index keys in the browse
>? TABLEUPDATE(.T.) && Prints .F.
>=AERROR(laerror)
>display memory like aerror && gives error 9, Data type mismatch
>
>** What is happening here???
>
>Anyone has a proposal where to look ???
>
>Many Thanks in advance.
>
>Lasse


The first place I would look is a field by field examination of the types you are scattering and what you are forcing into with the TABLEUPDATE command. Manually do your scatter then type all memory variables you are using to update the table with. Sounds like a field is the wrong type, which is easy thing to happen if the data is coming from another source.
Bret Hobbs

"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform