I receive the following message after

'Generated INSERT statement'
'Generated UPDATE statement'
'Generated DELETE statement'

"The original query has a select list that has columns from multiple tables.
The statement cannot be generated automatically for this type of query."

Here's my Oracle databse query:

select car_master.car_id,
car_master.year,car_master.vehicle,car_detail.car_id AS EXPR1,
car_detail.price,car_detail.mileage,car_detail.body,car_detail.body FROM
car_master,car_detail where car_master.car_id=car_detail.car_id;

Any suggestions would be appreciated.

Thanks.

bebop

Your FROM has more then one table in it. The command builder (and the wizard
in VS.NET) does not support that because in theory you could be selecting
column from different tables, and updating them. Then it has to update all
the rows from different table, and it has no way of figuring out which row
because of the joins.

If you want to use a command builder at run time, you can change the SELECT
statement on the adapter prior to creating the command builder to be just
from the table you want to update to, and only include the columns that
belong to that table. That should work ok.

If you are using the wizard, then my suggestion would be to never ever use
it.

"cwbp17" <(E-Mail Removed)> wrote in message
news:020565BA-2934-4542-9413-(E-Mail Removed)...
>I receive the following message after
>
> 'Generated INSERT statement'
> 'Generated UPDATE statement'
> 'Generated DELETE statement'
>
> "The original query has a select list that has columns from multiple
> tables.
> The statement cannot be generated automatically for this type of query."
>
> Here's my Oracle databse query:
>
> select car_master.car_id,
> car_master.year,car_master.vehicle,car_detail.car_id AS EXPR1,
> car_detail.price,car_detail.mileage,car_detail.body,car_detail.body FROM
> car_master,car_detail where car_master.car_id=car_detail.car_id;
>
> Any suggestions would be appreciated.
>
> Thanks.
>
> bebop

Like Marina mentions, none of the tools that autogenerate CRUD logic can
generate all 4 commands if you use a JOIN. Your best bet is to fire
multiple queries and use then use a DataRelation between the tables in a
dataset to maintain integrity.
"cwbp17" <(E-Mail Removed)> wrote in message
news:020565BA-2934-4542-9413-(E-Mail Removed)...
>I receive the following message after
>
> 'Generated INSERT statement'
> 'Generated UPDATE statement'
> 'Generated DELETE statement'
>
> "The original query has a select list that has columns from multiple
> tables.
> The statement cannot be generated automatically for this type of query."
>
> Here's my Oracle databse query:
>
> select car_master.car_id,
> car_master.year,car_master.vehicle,car_detail.car_id AS EXPR1,
> car_detail.price,car_detail.mileage,car_detail.body,car_detail.body FROM
> car_master,car_detail where car_master.car_id=car_detail.car_id;
>
> Any suggestions would be appreciated.
>
> Thanks.
>
> bebop

Thanks for the responses.

I'll keep the queries separate.

bebop


"W.G. Ryan MVP" wrote:

> Like Marina mentions, none of the tools that autogenerate CRUD logic can
> generate all 4 commands if you use a JOIN. Your best bet is to fire
> multiple queries and use then use a DataRelation between the tables in a
> dataset to maintain integrity.
> "cwbp17" <(E-Mail Removed)> wrote in message
> news:020565BA-2934-4542-9413-(E-Mail Removed)...
> >I receive the following message after
> >
> > 'Generated INSERT statement'
> > 'Generated UPDATE statement'
> > 'Generated DELETE statement'
> >
> > "The original query has a select list that has columns from multiple
> > tables.
> > The statement cannot be generated automatically for this type of query."
> >
> > Here's my Oracle databse query:
> >
> > select car_master.car_id,
> > car_master.year,car_master.vehicle,car_detail.car_id AS EXPR1,
> > car_detail.price,car_detail.mileage,car_detail.body,car_detail.body FROM
> > car_master,car_detail where car_master.car_id=car_detail.car_id;
> >
> > Any suggestions would be appreciated.
> >
> > Thanks.
> >
> > bebop
>
>
>