Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Scatter memvar causes datatype mismatch?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00538234
Message ID:
00538238
Vues:
10
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform