At 14.10 19/03/2001 +0100, you wrote:

>Jason and list,
>we want to insert, edit and delete a 3-way-joined query. We can put several
>statements in the UpdateSQL and DeleteSQL property without any problems, but
>if we try to put more then one statement in InsertSQL then preparing of the
>query fails. So what is the simplest way to insert in a join like this?

Write a stored proced that does this for u
(the three inserts/updates/delete)
then from insertsql, modifysql and deletesql
use it.
Regards,
Marco

>Regards,
>Tilo Muetze
>IQ Compusulting
>www.iq-c.de
>
>
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/