Hello,

I building an inteface in VB6.0 to access SQL 7.0
Database.  I'm using the Data Environment to
create my connection and commmand objects.  I'm
using the datagrid 6.0 control and checked
allowadd, allowedit, allowdelete on the property
page. I also set other properties to point to my
data source.  It displays the data records and
will allow me to delete, edit and add, but it
never commits the information to the database.
What I'm I doing wrong.

Thanks

Robert.

Sent via Deja.com http://www.*-*-*.com/
Before you buy.

I think by default the DE creates a forward-only rs.  you need to chage that
to dynamic or key-set.
Also DE probably opens rs as read-only as well.  Change that too.

Hello,

My Parent Command Objects are read/write but my command objects which
represent the child tables and are related to the Parent Command
Objects seemed to readonly because the grid won't commit their
changes.  How do I check or set their property.  I can'nt even get to
them when I type in the connection object, only the parent objects show
up as recordsets.  Is their a better way to create my connection and
recordset objects when designing a one-to-many relationship interface.

Sent via Deja.com http://www.deja.com/
Before you buy.