DataControl On Line Update with SQL Passthrough
Does any one konw whether or not a data control based on a pass-through
stored procedure (in a SQL Server database via ODBC) that selects records
from multiple tables using JOINs can do on-line edit to the records? Can
use Data1.Recordset.AddNew? can use Data1.Recordset.Delete? ...
I am talking about VB v3.0 and the data control is definitely not
READONLY. The database tables are updateable.
I got error messages saying those operations were illegal when I tried to
do so. But no VB user manuals or other books talk about you CAN NOT do
so. And as matter of fact, this is the way a data control is used -
connecting to data source via ODBC and you can do on-line edit on it.
All examples I've read just talk about simple ones like a data control
connecting to a single table or a pass-through SQL selecting records from
a single table, etc...
Any information is welcome and appreciated!