Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Getting reference back after an insert.
Message
De
04/03/1998 10:06:26
Steve Camsell
Windmill Associates
Bath, Royaume Uni
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Getting reference back after an insert.
Divers
Thread ID:
00082474
Message ID:
00082474
Vues:
71
I am writing my first c/s app using VFP5 and SQL Server 6.5. My problem is this:

I want to add, for an example, a new record into my customer table. My fox app contains a remote view containing all fields in the customer table, parameterised so that it fetches back only one record, any record. I then do an INSERT into the view, to insert the basic information, allowing my user to fill in the rest.

I do not fill in the cust_id field, as this is automatically populated by SQL Server using IDENTITY. Therefore in my view it is zero (although the record that has just been added on the server has a cust_id). How do I find out the cust_id of the customer that I have just added?
Steve Camsell
Development Consultant
Steve.Camsell@Windmill-DBM.Co.Uk
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform