VB and JOINS do mix 
Author Message
 VB and JOINS do mix

I have this joined:

                Set qdf5 = dbsNoLoad.CreateQueryDef("", _
                                    "SELECT stock_data.ticker _
                                     FROM ((types _
                                    LEFT JOIN category ON types.id =
category.type) _
                                    LEFT JOIN subcategories ON category.id =
subcategories.category) _
                                    LEFT JOIN (ticker _
                                            LEFT JOIN stock_data ON
ticker.ticker = stock_data.ticker) ON subcategories.id = ticker.subcategory
                                    WHERE (((types.id)=4) AND
((category.id)=3) AND ((subcategories.id)=22));")

                Set rst5 = qdf5.OpenRecordset(dbOpenSnapshot)

VB 6.0 returns a "type mismatched in join description".  My goal with this
query is to find out whether or not there is any data returned from the
[stock_data] table based on a 'type', 'category', and 'subcategory'.

I have other joins defined in my VB code which are working properly. I can't
seem to find the error in my coding with this one.

Thank you for your time.


Wed, 20 Mar 2002 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Doing Join, how to reference common fields?

2. Cannot access fields using recordset property when doing a self-join

3. VB5 and VB.NET Mix

4. Problem with references when mixing VB and C#

5. VB.NET and C# mix

6. Automating Mail Merge with VB.Net and Office XP and Office 2000 produces mixed results

7. Mixing graphics and multiplefonts in vb .net printing

8. mixed feelings about VB#

9. Mixed Programming with C and VB/Dos

10. Join 6 Join


12. Mixing VB and Visual FoxPro code?


Powered by phpBB® Forum Software