Re: ADO Join Recordset


"Jack" <jl@xxxxxxxxxx> ¼¶¼g©ó¶l¥ó·s»D:uPa$WrsMGHA.3708@xxxxxxxxxxxxxxxxxxxxxxx
Hi,
I have 2 tables, but want to join them into one recordset
So that I can manipulate it easily.
Table 1
Key data foreignkey
11 hello 15

Table 2
foreignkey data2
15 hello2

So that I can have a recordset like this
Key data foreignkey data2
11 hello 15 hello2

How do you code that in VB6?
Sorry for this dumb question, but I used to be a C++ programmer :)
Thanks
Jack

Dear Gurus,
The problem I am having now is I have to access to 2 different tables (each
with a flag in it)
Am I forced to join them together? or is there a better way of doing it?
Table 1
Key Flag1 Foreign key
11 True 15

Table 2
Foreign Key Flag2
15 False

I'm using ADO, Jet Database Engine for an Access Database
There is a function called willmove which is the ADO defined method which
only permits one recordset to pass into it.
Somethin' like
Private function adodc1_willmove(..., pRecordset as ADODB.Recordset)
So I couldn't add a second recordset for it. I still thinking about a join
as the solution. What's your opinion?
Thanks
Jack







.

Relevant Pages

  • Re: ADO Join Recordset
    ... but want to join them into one recordset ... Key data foreignkey key2 data2 ... I can't write SQL cos I'm a graphics programmer:)) ...
    (microsoft.public.vb.controls)
  • Re: ADO Join Recordset
    ... but want to join them into one recordset ... Key data foreignkey key2 data2 ...
    (microsoft.public.vb.controls)
  • ADO Join Recordset
    ... but want to join them into one recordset ... So that I can manipulate it easily. ... Key data foreignkey key2 data2 ...
    (microsoft.public.vb.controls)
  • ADO Join Recordset
    ... but want to join them into one recordset ... So that I can manipulate it easily. ... Key data foreignkey data2 ...
    (microsoft.public.data.oledb)