>Hi, i'am just learning the basics about foxpro so i hope you forgive me if i this is a very stupid question.
>
>I'm trying to get autoincrementing according to the solutions sample database in the msdn, to work.
>
>I copied the necessary code en tables into my own project. So far it works fine. when i ad a table of my own (say table3) in my database and try to append blank on this table i get a datatype mismatch. As far as i can see this new table is exactly the same as one of the original tables. (including index)
>
>What am i missing here????
>thanks
Victor,
Each datatype of field must match value datatypes you're trying to put into. You issue an 'append blank' and get the error. Then comes to mind on one or more fields there is 'default' defined (check your table with modify structure) and returning an uncomatible type for the field (probably .t.).
BTW you're saying autoincrementing, probably you're talking about NewId(). If so you should have Ids table as shown and a stored procedure in your database with a NewId function (you could copy code from VFP's).
Cetin