Accessing Accpac SQL database 2

[Bluejay07]

Hello,

I am creating a program using VB6 and COMAPI. The program will be run from within the accpac environment.

When accpac is running, it has a ODBC connection to the SQL database. What would be the best way to query the database from within my program.

For example, how could I accomplish: Select * from ARCUS WHERE IDCUST = 'XXX'. In addition how would I access each of the fields?

Thanks.

If at first you don't succeed, then sky diving wasn't meant for you!

 

[Jay Converse]

You need an EMPLOYEE and an EARNDED to .Browse.

 

[Bluejay07]

Two questions:
1. Why did I not need an employee before the compositions? It worked perfectly then!
2. How do I accomplish this since I want all employees with EARNDED = SAL?

If at first you don't succeed, then sky diving wasn't meant for you!

 

[Jay Converse]

Then try setting UPEMPD.Order = 3 before you .Browse