Hi Alan,
I must be particularly thick skulled, although I am close to getting
it. In this case, because my view only draws on one table, I can do
insert into this view using isql or Marathon equivalent, but I cannot do
it via ODBC

So using ODBC I cannot insert into a view as though it were any other
table, but as long as I arrange for the SQL to go directly to Firebird
(ExecSQLDirectW), then I can insert into my view as I please (provided
the view accepts insert into). Is this correct?

Thanks again, and sorry to be taking a while to get it.

Cheers,

Eric

>It's not a case of the ODBC "should" know -for very good reason the view is
>considered a table by the driver. It's up to you, the programmer, to know
>that you are inserting into a view. A view can be a join across multiple
>tables. You need to know how to insert records into al/some of those tables
>and construct the SQL to just what you want.
>Alan
>
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>