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 : I am using Delphi and am getting some column not found errors on long field names. Why?Search Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC Frequently Asked Questions

 New Topic 
 
 Post Reply 
[1]  
 I am using Delphi and am getting some column not found errors on long field names. Why? 
 Author   Message 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-02-22 12:15:17

Delphi is one of the development environments that requires the field names to be shorter. In the QODBC Setup Screen, on the "Advanced" tab screen. If you put 32 in the "Maximum Field Name Length:" field (instead of the default of 50) it will fix the problem.

 

  Top 
  Roo 
  
 Group: Members 
 Posts: 2 
 Joined: 2006-06-29 
 Profile
 Posted : 2006-06-29 02:11:03

Tom,

I'm using an evaluation copy of QODBC version 6.00.00.155 with Quickbooks Pro 2006.  I am developing applications with Delphi Enterprise 7.0.

I have tried the solution provided, (Max field name length = 32), but am still having the problem.  I have tried different values and that causes different fields to report the error.

My client plans to purchase the licenced version, provided I can get this working.

Thanks in advance!

 

 

 
rjmagar "Roo" - Delphi Developer 
 
  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-06-29 08:25:11

Sorry, you haven't stated any details on the errors you are getting or what tables and columns are still affected?

Have you established a connection using VB Demo yet? See: How do I connect to QuickBooks for the first time? 

 

  Top 
  Roo 
  
 Group: Members 
 Posts: 2 
 Joined: 2006-06-29 
 Profile
 Posted : 2006-07-06 07:13:41

Yes, the VB demo works fine.  The problem is encountered from within various wizzards within the IDE, as well as application output, such as assigning DBEdit boxes to variables.  Rather than to delve into complex explanations and scripts that would require the devepoper IDE, let me produce one simple example:

I have the following code, that dumps the data to a Memo as a debugging tool.  Here is the code:

procedure TForm1.ShowMemo;
var  i: integer;
begin
  InvMemoForm.Memo1.Clear;
  for i:= 0 to QbDm.QBDataMod.InvQuery.FieldCount -1 do
    if QbDm.QBDataMod.InvQuery.Fields.Fields[i].AsString <> '' then
      InvMemoForm.Memo1.Lines.Add(QbDm.QBDataMod.InvQuery.Fields.Fields[i].FieldName + ' = ' + QbDm.QBDataMod.InvQuery.Fields.Fields[i].AsString);
  InvMemoForm.ShowModal;
end;

Here is partial output, copied from the Memo:

InvoiceLineSeqNo = 1
InvoiceLineTxnLineID = 1639C-1110204422
InvoiceLineItemRefListID = 20000-1001006699
InvoiceLineItemRefFullName = DESTRUCTIVE TESTING
InvoiceLineDesc = DESTRUCTIVE TEST
InvoiceLineRate = 110
InvoiceLineAmount = 110
InvoiceLineSalesTaxCodeRefListI = 20000-1135001387
InvLnSalesTaxCodeRefFlNm = Non
FQSaveToCache = False
FQPrimaryKey = 1639A-1110204422|1639C-1110204422|

Note on line 8 "InvoiceLineSalesTaxCodeRefListI" should be "InvoiceLineSalesTaxCodeRefListID"

 

 

 
rjmagar "Roo" - Delphi Developer 
 
  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-07-06 10:31:38
Try setting the "Maximum Field Name Length:"  to 33. 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to