Thread: Can I insert two different variables from form into different tables using one SQL query ?
Can I insert two different variables from form into different tables using one SQL query ?
From
"Sapenov"
Date:
Can I insert two different variables from form into different tables using one SQL query ? -- Regards, Sapenov Khazretgali System Engineer CMS 20 Eglinton Ave West Toronto, ON M4R 1K8 sapenov@cmsrecruit.com tel. 416 487-0290 fax. 416 487-5771 toll free :1-888-244-1340
Re: Can I insert two different variables from form into different tables using one SQL query ?
From
"Jeff Eckermann"
Date:
Yes, if you use a custom function: no, if you just want to use SQL. You can wrap as many insert statements as you like into a pl/pgsql function, using values passed in as arguments to your function. Hard to see the point of doing this, though. Surely harder to maintain than actual SQL. "Sapenov" <sapenov@timscanada.com> wrote in message news:5ZSn7.22167$BS1.2402844@news20.bellglobal.com... > Can I insert two different variables from form into different tables using > one SQL query ? > > > > > -- > Regards, > > Sapenov Khazretgali > System Engineer > CMS > 20 Eglinton Ave West > Toronto, ON M4R 1K8 > sapenov@cmsrecruit.com > tel. 416 487-0290 > fax. 416 487-5771 > toll free :1-888-244-1340 >
Sapenov wrote: > > Can I insert two different variables from form into different tables using > one SQL query ? > If what you are trying to achieve is to make sure that one is not inserted without the other (another way of saying "data integrity"), perhaps you should look into transactions.