>Would you post the exact error message?
>
>-Mike
Michael,
It's pretty terse, up comes one of those little boxes saying "Data type mismatch", "Suspend, Ignore, Cancel" and that's it.
From VFP Help:
--------------------------------------------------------------------------------
Visual FoxPro Reference
Data type mismatch (Error 9)
An expression is invalid because it is composed of data types that Visual FoxPro cannot evaluate together.
You have either specified an inappropriate data type, or the two fields specified in an operation between two tables (such as UPDATE, REPLACE, SET RELATION) did not have the same data type.
© 2001 Microsoft Corporation. All rights reserved.
--------------------------------------------------------------------------------
I have fooled around with it a bit, and it seems if I
INSERT INTO MyTable... STR(MyInteger) neither VFP nor SQL Server complain, and the data actually make it into the back-end.
Which, all things being equal, is a little weird, to say the least.
In the meantime I have resolved that simple Int will most likely be good enough, and redefined the BigInt fields to Int.
While the other approach may be a workaround, I'm not comfortable about it.
Peter Pirker
Whosoever shall not fall by the sword or by famine, shall fall by pestilence, so why bother shaving?
(Woody Allen)