Designing queries and other VB BS 
Author Message
 Designing queries and other VB BS

I'm haveing a hell of a bad time trying to design a query to do what I
want.  In the on-line docuemntation there is this thing called a query
builder that looks a lot better that the lame query builder in the
Visual Data Manager.  M$ raves on and on about it, but how the hell do
you find it??

By the way, what does the Query menu do?  All of my choices are grayed
out.

Oh, this is what I want to do.  Both tables in the same DB file.

        Customers                       Transactions
        ---------                       ------------    
        CustID                          CustID
        CustName                        DatePurch
                                        ItemCode
                                        Amount

        (This is the org. of the recordset orderd by Customer name)
        CustName  DatePurch  ItemCode  Amount
        --------  ---------  --------  ------
        Jones     10/12/00   1234      $ 41.96
                  10/30/00   1253      $121.02
        Smith     10/01/00   1001      $  7.99

Thanks for any help!
Dennis,



Sun, 13 Jul 2003 10:49:20 GMT
 Designing queries and other VB BS

Hint:  Drop the attitude.  It's OK to be frustrated, but you come across as
somewhere between grumpy and hostile... :->

The best query builder I have used is the one that is in MS Access.  Use it
to create your SQL statement and paste the statement in where you are going
to use it.

Or better yet, learn SQL and forget about the query builders...

HTH,
Tore.


Quote:
> I'm haveing a hell of a bad time trying to design a query to do what I
> want.  In the on-line docuemntation there is this thing called a query
> builder that looks a lot better that the lame query builder in the
> Visual Data Manager.  M$ raves on and on about it, but how the hell do
> you find it??

> By the way, what does the Query menu do?  All of my choices are grayed
> out.

> Oh, this is what I want to do.  Both tables in the same DB file.

> Customers Transactions
> --------- ------------
> CustID CustID
> CustName DatePurch
> ItemCode
> Amount

> (This is the org. of the recordset orderd by Customer name)
> CustName  DatePurch  ItemCode  Amount
> --------  ---------  --------  ------
> Jones   10/12/00   1234      $ 41.96
>   10/30/00   1253      $121.02
> Smith   10/01/00   1001      $  7.99

> Thanks for any help!
> Dennis,



Sun, 13 Jul 2003 13:25:26 GMT
 Designing queries and other VB BS
Previous advice might not always work, as Access does not use standard SQL.

You want:

SELECT CustName, DatePurch, ItemCode, Amount FROM Customers LEFT INNER JOIN Transactions ON Customers.CustId = Transactions.CustId ORDER BY CustName

The rest is a formatting problem.  (Nice to see data names without spaces or other stupid characters for a change.)
--
----------------------------------------------------------------------


  Clark Security Products

----------------------------------------------------------------------

Quote:

> I'm haveing a hell of a bad time trying to design a query to do what I
> want.  In the on-line docuemntation there is this thing called a query
> builder that looks a lot better that the lame query builder in the
> Visual Data Manager.  M$ raves on and on about it, but how the hell do
> you find it??

> By the way, what does the Query menu do?  All of my choices are grayed
> out.

> Oh, this is what I want to do.  Both tables in the same DB file.

>         Customers                       Transactions
>         ---------                       ------------
>         CustID                          CustID
>         CustName                        DatePurch
>                                         ItemCode
>                                         Amount

>         (This is the org. of the recordset orderd by Customer name)
>         CustName  DatePurch  ItemCode  Amount
>         --------  ---------  --------  ------
>         Jones     10/12/00   1234      $ 41.96
>                   10/30/00   1253      $121.02
>         Smith     10/01/00   1001      $  7.99

> Thanks for any help!
> Dennis,



Tue, 15 Jul 2003 07:57:01 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. [BS] - Informatica - PROGRAMMATORE VB 6.0 E SQL SERVER

2. FPW26 Application Design -- Codebook and Others

3. Enterprise Manager Hangs in Design Table and others on SQL Server 7.0

4. VB Program design query

5. Recommendations? VB, PowerBuilder, others

6. Using ADO via VB, a record shows one fields value to be correct, but the others

7. Update query blocks others users

8. passthru queries work on some servers not others

9. BS/1 Source Code

10. 10 year BS!

11. B.S. Delphi SQL Error?


 
Powered by phpBB® Forum Software