Updating and Deleting

  • Thread starter Thread starter jtnpham
  • Start date Start date
J

jtnpham

I have two tables with the following components:

1. authTable - shop order no, auth no, work center id
2. dbo_shopOrder - shop order no, work center id

I would like to do a few things but I am not sure where to start.

First thing is, I would like to have all of the shop order no's in the
dbo table to be in the authTable.
*But if the authTable does not have that shop order no, to give it an
auth no of 0. If the authTable has the shop order no, then nothing.

Second is, after the first thing, if there are shop order no's in the
authTable that are NOT in the dbo table, I would like that row to be
deleted.

Any suggestions?

Thanks! =)
 
Hi jtnp,

Can you explain a little bit the problem beside the technical way you want
to make a solution from it, it looks as database desigining whereabout
nobody here will probably give your advice about afraid loosing his good
name.

However, I can of course be wrong about that.

Cor
 
I am not sure where to begin for the coding in my asp.net project. I
want this to "run" as the page loads. I am not sure what you want me
to say as for as the problem?
 
jtnpham,

First of all, you gave important information in your short message. It is
for an asp.net project, default it is in this newsgroup about a windowsform
project. You did not tell yet, what your databaseServer is.

Beside that, what is your idea how you application would look like, what are
the dialogs between user and database, which is forever an important factor
but extra with an asp.net application.

Cor
 
Back
Top