|
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
|
|
| Iterators and invalid list ids |
| Author |
Message |
|
|
| Posted : 2007-09-22 13:26:34 |
Problem 1:
I am getting the "invalid iterator" error. After using Google to search your support site (because your built in search returned no results) I came upon the suggestion to clear the "Use Iterators" checkbox on the advanced tab. I did so. I saved the preference. The same error persisted. After a lot of cursing I double checked the settings and found that the "Use Iterators" checkbox had been re-checked. I cleared it. Saved it. Same error. Same trouble--the checkbox is rechecked every time even after I clear it and save the settings.
Problem 2:
I discovered if I merely click "Apply" but leave the preferences window open, I am able to run a query against QODBC without seeing that damnable "invalid iterator" error. My celebration was short-lived: "The given object ID "" in the field "list id" is invalid." This, I gather, is the result of trying to insert a null value into an ID column, but as you can see from the query below, no null values are being passed, and as far as I can tell from your schema reference I'm not omitting any required columns. (If it's relevant, the query below is the last of a series of queries in which an invoice's line items are inserted using FQSaveToCache as described here.)
I could sure use some good news here. Hope you can help! Here is the query:
INSERT INTO Invoice ( RefNumber, CustomerRefListID, TxnDate, ShipAddressAddr1, ShipAddressAddr2, ShipAddressAddr3, ShipAddressCity, ShipAddressState, ShipAddressPostalCode, IsPending, PONumber, TermsRefListID, Memo) VALUES ( ' 161058', '800008D5-1190415265', {d'2006-03-30'}, 'BEAR SUPPLY OUTDOORS ', '390 S SHORE RD ', ' ', 'ATKINS ', 'AR ', '72823 ', 0, 'TR32406 ', '80000004-1182372526', 'SBT ship method: APOLLO ') |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-09-23 08:32:06 |
| You cannot change any of the QODBC global settings while the QODBC driver is running. You also cannot do any inserts into the Invoice table without first creating VALID cached InvoiceLine inserts first. Invoices use "TxnID"s and not ListIDs, so any error with ListIDs must be in reference with a lookup like CustomerRefListID etc. |
|
|
|
|