Problem refreshing SQL Server 7.0 joins in ADO 
Author Message
 Problem refreshing SQL Server 7.0 joins in ADO

Hi SQL Server folks;

I have a join between two tables Vendors and Coutries:

Select Vendors.Code,Vendors.Name,Vendors.CountryCode,Countries.Name As
From Vendors INNER JOIN Countries
 ON Vendors.CountryCode = Countries.Code

I want to show the result in a DATAGRID in VB6. As you know the
recordset has to be Bookmarkable in order for the DataGrid to be able to
display the results. I have tested ClientSide/Static and
ServerSide/Keyset recordsets and both are the same. My problem is this:
When I update the Vendors.CountryCode to a different value, the value
for the Countries.Name does not reflect the change. When I use the
Dynamic recordset, it works but then the DataGrid can not display the
recordset since it is not bookmarkable.
I have used this kind of joins so many times in DAO/Access and it works
with no problem. Then what is the problem here. I am using SQL Server 7
and VB 6 SP2.
Please help since I am very frustrated. I have checked everything but
I can not find the problem. Please help.


Sent via http://www.*-*-*.com/
Share what you know. Learn what you don't.

Thu, 13 Dec 2001 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. ado SP problem in SQL Server 7.0 and 2000

2. Problem on SQL-Update Statement with a Data-Control in VB 5 and SQL Server 7.0

3. VB Sql Server Via ADO Problem: [Microsoft][ODBC Sql Server Driver]

4. Using ado recordset in an SQL Server inner join

5. ado connection to SQL Server 7.0

6. SQL Server 7.0 , ADO & VB 6.0

7. Need to Save .rpt files in SQL Server 7.0 with ADO 2.1

8. SQL Server 7.0 and ADO Cursors

9. Ado Save & Open with SQL server 7.0

10. ADO and SQL Server 7.0

11. ADO vs ODBC (SQL Server 7.0)

12. Using ADO 2.5 Streams on SQL Server 7.0


Powered by phpBB® Forum Software