Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Autoincrementing according to sample
Message
From
02/10/2001 07:32:25
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
02/10/2001 06:47:42
Victor Verheij
International Film Festival Rotterdam
Rotterdam, Netherlands
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00562909
Message ID:
00562912
Views:
17
>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
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform