sirichai
Posts: 22
|
| Posted: 10/27/2006, 2:58 AM |
|
Hi,
Any one please help me. I would like to use the store procedure in MSSQL 2000 for updating the data by click something.
Thanks
Sirichai
|
 |
 |
Edd
Posts: 547
|
| Posted: 10/27/2006, 7:58 AM |
|
Look at the Custom Updates and Inserts and point the values to controls on your form.
I use this all the time.
Edd
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
|
|
|
sirichai
Posts: 22
|
| Posted: 10/27/2006, 6:20 PM |
|
Thanks edd. Do you have sample some custom code for me to followup?
Thanks
Sirichai
|
|
|
|
Edd
Posts: 547
|
| Posted: 10/27/2006, 8:55 PM |
|
sirichai
Have you coded update / insert stored procedures before? If so have you created the stored procedure to perform the update / inserts?
Edd
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
|
|
|
sirichai
Posts: 22
|
| Posted: 10/27/2006, 9:47 PM |
|
Hi Edd,
Just has a little experience on MSSQL about add/update/delete (on store procedure). For coding I'm no experience. Can you place the example code for me? or otherway for non coding and using store procedure and justing the parameter for add/update/delete on database.
Thanks
sirichai
|
|
|
|
Edd
Posts: 547
|
| Posted: 10/28/2006, 6:26 PM |
|
sirichai,
To take you through a tutorial is a longer process that I can do in a quick exercise, so to start you off you will need to understand some basics on an easy database.
Start off by creating a new project that has the "pubs" database (installed with MSSQL) as it's database connection.
Before you do anything have a look at the publishers table in Enterprise Manager and look at it's contraints, specifically that a "pub_id" is char(4) but will only accept numeric and 4 digit values. Any additions can only be within the range 9000 - 9999. You may want to build some rules about this in your app. Also look if has any dependencies.
Create a List and Maintenance screen for the publishers table, test that it is operational.
You will notice that blank fields are filled with NULLS.
When you have done that step post a reponse here and I will give you a stored procedure on doing updates and take you through the next steps.
Edd
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
|
|
|
