Member Login

Username
Password
Forget Password
New Sign Up
Search Forum

Buy Support
Incidents

If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:

Click Here
If you can't login and post questions or you are having trouble viewing forum posts:
 Click Here
Callback
Support

If you live in USA, UK, Canada, Australia or New Zealand, you can leave us details on your question and request us to call you back and discuss them with you personally  (charges apply).

Click Here
 
Buy Support
Incidents
If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:
Click Here

Forum : Error loading BillExpenseLine to a recordsetSearch Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC v6 Forum

 New Topic 
 
 Post Reply 
[1]  
 Error loading BillExpenseLine to a recordset 
 Author   Message 
  Patricio Carpio 
  
 Group: Members 
 Posts: 3 
 Joined: 2006-10-25 
 Profile
 Posted : 2006-10-31 09:49:30
Hi:
I have the follow code:
    oPOS.AbrirRecordset rsPOS1, sSQL
    Do While Not rsPOS1.EOF
        sSQL = "SELECT * FROM BillExpenseLine WHERE RefNumber='" & rsPOS1.Fields("PONumber") & "'"
        oQB.AbrirRecordset rsQB, sSQL
        If Not rsQB.EOF Then
            sExpId = rsQB.Fields("ExpenseLineAccountRefListID")
            sExpName = rsQB.Fields("ExpenseLineAccountRefFullName")
            ...
        End If
        rsPOS1.MoveNext
    Loop
oPOS is the object of my POs system, and QB of QuickBooks. When I run the code with the SQL stament "SELECT * FROM BillExpenseLine" it returns me an empty recordset. Just for try, I changed the SQL stament to "SELECT * FROM Cutomer" and it works fine.

Can somebody told me why the BillExpenseLine table returns me an empty recordset?

Thanks for your help!!!

Patricio 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-10-31 10:33:49

Sorry you haven't said what version of QODBC or what version of QuickBooks you are using? As far as using the BillExpenseLine table, everything is fine using QODBC v7.00.00.199 as far as I can tell:

 

  Top 
  Patricio Carpio 
  
 Group: Members 
 Posts: 3 
 Joined: 2006-10-25 
 Profile
 Posted : 2006-10-31 12:12:15
I'm using the trial version of QODBC.
On the VBDemo I'm able to see records:

Also, I'm using QuickBooks Pro 2006. On my code (VB) I'm able to open a recordset with the customer table, but when I tried BillExpenseLine or Check it give me an empty recordset.
 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-10-31 14:02:23
Are you using QODBC v7.00.00.199? Or are you still using v7.00.00.194? I also have issues logged with using ADO 2.8, what rev are you running? 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to