Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Autoincrementing according to sample
Message
De
02/10/2001 07:32:25
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
02/10/2001 06:47:42
Victor Verheij
International Film Festival Rotterdam
Rotterdam, Pays-Bas
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00562909
Message ID:
00562912
Vues:
18
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform