Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Creating new update function
Message
De
04/05/2007 20:18:52
 
 
À
Tous
Information générale
Forum:
ASP.NET
Catégorie:
The Mere Mortals .NET Framework
Titre:
Creating new update function
Versions des environnements
Environment:
VB 8.0
OS:
Windows XP SP2
Network:
Windows XP
Database:
MS SQL Server
Divers
Thread ID:
01222682
Message ID:
01222682
Vues:
70
Hi Kevin,
I have a form that should update the sql tables (using stored procedures) passing only a few fields of a table. I can create the update function in the business object, and call that (passing only the required fields) rather then the save command, but I'm assuming that defeats the design goals and it wouldn't call the error checking routines first.

Could you tell me what the proper approach would be?

Or put another way: using Northwind as an example, suppose I had a form that only displayed CustomerID, ContactName and Phone. After the user updates the data I'd call save, however this will halt stating missing parameters -- the stored procedure for update is looking for every field, not just CustomerID, ContactName and Phone. I can create the additional update stored procedure with just the required parameters, but I'm missing the correct approach to calling it (or rather to have save call it).

Suggestions?

thanks,
Larry
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform