Datagrid 6.0 won't commit changes to 7.0 SQL Database 
Author Message
 Datagrid 6.0 won't commit changes to 7.0 SQL Database

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.



Mon, 22 Apr 2002 03:00:00 GMT  
 Datagrid 6.0 won't commit changes to 7.0 SQL Database
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.
Quote:

> 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.deja.com/
> Before you buy.



Tue, 23 Apr 2002 03:00:00 GMT  
 Datagrid 6.0 won't commit changes to 7.0 SQL Database
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.



Sun, 28 Apr 2002 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. How do I get the DataGrid 6.0 to commit changes to SQL Database

2. Bound datagrid won't commit changes

3. can't debug sql server 7.0 in win 2000 pro

4. VB4 RDO Won't detect an error in an SQL Server 6.0 stored procedure

5. SQL Database won't take Apostrophe (')

6. Help: Committing changes in DataGrid (bound to access db)

7. How to commit changes in DataGrid?

8. How to commit datagrid's current row?

9. Oracle commits vs Sybase/SQL-Server commits

10. Insert date type varible through ODBC SQL server driver to SQL 7.0 database

11. Forcing Database Changes from ADOCE to Commit - new deVBuzz tutorial

12. SQL Server 7.0 , ADO & VB 6.0

 

 
Powered by phpBB® Forum Software