|
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
|
|
| Error S1002 - Invalid column id |
| Author |
Message |
|
|
| Posted : 2008-06-12 02:05:35 |
Hi,
Am receiving this error when executing the following query.
Select TxnId,TxnDate,DueDate,RefNumber,CreditRemaining from CreditMemo calldirect where CustomerRefListId = '5360001-1190060714' and CreditRemaining > 0
It works perfectly in the VB demo, but not in my system., developed in Clarion 6.3.
This query for instance works in VB demo and my system
Select TxnId,TxnDate,DueDate,RefNumber,Subtotal,BalanceRemaining,AppliedAmount from invoice calldirect where CustomerRefListId = '5360001-1190060714' and IsPaid = 0
What could possibly cause this problem?
Are there any settings in the configuration of QODBC that might prevent this?
thanks
Johan |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2008-06-12 07:22:02 |
Try changing the SQL Statement to find the offending item:
Select TxnId,TxnDate from CreditMemo calldirect where CustomerRefListId = '5360001-1190060714'
|
|
|
|
|
|
| Posted : 2008-06-13 00:08:29 |
Hi Tom
I have tried that, but you gave me another idea and what I have found is that, if I connect and run this query it works.
Then I do another query an then it gives the error. almost as if a buffer that stores column info fills up and then gives the column id error.
The really interesting thing is that the query on invoices always works.
Perhaps the columns that are being used there are the most generic or something similiar.
If i run the invoice query and then the query on the credit memos, then the query on invoices work, but the credit memo returns errors.
Any ideas would really be appreciated.
thanks
Johan |
|
|
|
|
|
| Posted : 2008-06-13 01:56:19 |
Hi Tom
I think I have solved the problem.
Between before and after every query, I connect and disconnect.
This seems to clear and inti everything cleanly.
It's not ideal as there is an overhead in this method of connection and reconnecting with every query, but seems to be fine.
I am still testing , will let you know.
If you have comments please let me know.
TIA
Johan |
|
|
|
|