Re: Updating and Deleting

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

<jtnpham@xxxxxxxxx> schreef in bericht news:1185806528.547160.147610@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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! =)


.

Relevant Pages

  • Re: updating and deleting
    ... Let's say I have in the authTable I have the following (shop order no, ... For the dbo table I have the following shop order no's: ... there a way to put in the auth no column a 0? ... Do you have a process now that adds entries from dbo into authtable or is that what you are asking for? ...
    (microsoft.public.vb.database)
  • Re: updating and deleting
    ... Let's say I have in the authTable I have the following (shop order no, ... For the dbo table I have the following shop order no's: ... 501, so when these two entries are added to the authtable from dbo, is ... there a way to put in the auth no column a 0? ...
    (microsoft.public.vb.database)