Kyle
|
| Posted: 02/13/2003, 4:19 PM |
|
HOPE SOME ONE CAN HELP
I HAVE A PROJECT THAT NEED TO INSERT A FRESH RECORD IN A SEPERATE TABLE, WHEN THE EXISTING RECORD IS INSERTED
I AM USING CCS 1.07 ASP AND ACCESS.
I HAVE PLAYED WITH THE DBCONNECTION.EXECUTE FUNCTION IN THE AFTER INSERT EVENT OF THE FORM, BUT IT DOES NOT DO ANYTHING, DOES NOT ADD AND DOES NOT GIVE ERRROR.
DBConnection.execute "insert into calendar (user_id,case_id,event_details,event_date,review_date,completed) values ("& CCGetUserId()& ", "&CCGetParam("Case_id","")&", "&"TEST"&", "&Dt&","&"YES"&")"
I AM HOPING I AM DOING SOMTHING STUPID, AND SOMEONE CAN HELP
THNX IN ADVANCE
KYLE
|
|
|
 |
Per Jansson
|
| Posted: 02/14/2003, 2:45 AM |
|
Search for "Inserting sequential records" in this forum (without quotes).
I solved this problem for php and MySQL. The steps are detailed for you, it might help to see if you miss something.
Per
|
|
|
|
|
