mousmoul
Posts: 11
|
| Posted: 03/24/2006, 2:52 PM |
|
Is it possible to update (or insert) into multiple tables with out writing any custom code from a Record form?
I know using the Visual Query Builder one can use multiple tables as the Data Source. Is there a similar way to update multiple tables?
I looked at Custom Update and I was only able to select one table. Is there another way?
Thank you in advance.
|
 |
 |
WKempees
|
| Posted: 03/24/2006, 2:57 PM |
|
No.
Your investigation was correct multiple table update is not supported the
way you ask here.
You can however do any SQL update supported by your database, handcoded in
the after(insert/update) embed points.
But that wasnot your question.
Walter
"mousmoul" <mousmoul@forum.codecharge> schreef in bericht
news:24424784605d54@news.codecharge.com...
> Is it possible to update (or insert) into multiple tables with out writing
> any
> custom code from a Record form?
> I know using the Visual Query Builder one can use multiple tables as the
> Data
> Source. Is there a similar way to update multiple tables?
> I looked at Custom Update and I was only able to select one table. Is
> there
> another way?
> Thank you in advance.
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
Benjamin Krajmalnik
|
| Posted: 03/25/2006, 12:06 PM |
|
Sure you can.
Write a stored procedure which updates all the tables and call it ;)
|
|
|
|
WKempees
|
| Posted: 03/26/2006, 10:38 AM |
|
Benjamin,
Sneaky but true.
Although if you read the post closely, my answer stands.
Grin.
Walter
"Benjamin Krajmalnik" <kraj@illumen.com> schreef in bericht
news:e047rl$q0r$1@news.codecharge.com...
> Sure you can.
> Write a stored procedure which updates all the tables and call it ;)
>
>
|
|
|
|
