Robert Viehouser
|
| Posted: 07/10/2002, 2:47 PM |
|
I am working on a project that needs to update two more more tables an the
same time.. I would like to use two more statements in ccs to make a traking
table to the database to I can know you has change the data.
UPDATE users SET cpny_ID='{newcpny_ID}', offc_ID='{newoffc_ID}',
user_ID='{newuser_ID}', usgp_ID='{newusgp_ID}',
user_Log_On_Name='{user_Log_On_Name}', user_Pass='{user_Pass}',
user_FName='{user_FName}', user_LName='{user_LName}',
user_PName='{user_PName}', user_Email='{user_Email}',
user_Phone='{user_Phone}', user_Phone1='{user_Phone1}',
user_Phone2='{user_Phone2}', user_Phone3='{user_Phone3}',
user_Photo='{user_Photo}', user_Default_Account_ID='{newacct_ID}' WHERE
cpny_ID = '{newcpny_ID}' And user_ID = '{newuser_ID}';
insert into users_link_accounts
(cpny_ID,user_ID,acct_ID,usla_Leader,usla_Active,usla_Create)
values ('{newcpny_ID}','{newuser_ID}','{newacct_ID}','Yes','Yes',now());
|
|
|
 |
Geert van der Ploeg
|
| Posted: 07/12/2002, 4:43 AM |
|
You could add an "After Insert" and an "After Update" event, doing another
query.
Alternatively you could do a custom insert and a custom update.
That way you can do 2 queries.
This is all in custom code. There's no possibility to do 2 queries in a
"table/view" or "sql" mode.
HTH.
Regards
--
Geert van der Ploeg
Triple IT
"Robert Viehouser" <Robert_Viehouser@hotmail.com> wrote in message
news:agia2e$32e$1@news.codecharge.com...
> I am working on a project that needs to update two more more tables an the
> same time.. I would like to use two more statements in ccs to make a
traking
> table to the database to I can know you has change the data.
<snip code>
|
|
|
|
|
