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
|
|
Beginner questions; Open Office; Delphi; SQL syntax |
Author |
Message |
|
Posted : 2009-02-06 13:16:25 |
I'm making some progress. I have found that testing SQL syntax from a TQuery in the Delphi IDE is much faster than using Open Office's database mode.
A few things still puzzle me about the qodbc driver.
1. This works
select TxnID, RefNumber from SalesReceipt NOSYNC where (RefNumber = '5058')
but this does not
select * from SalesReceipt NOSYNC where (RefNumber = '5058')
Why isn't * supported for selecting all fields? Or if you cannot say exactly WHY, can you confirm that is a limitation?
2. I'm referencing the table documentation for SalesReceipt in order to list out the fields individually ( from http://doc.qodbc.com/qodbc/20/tables/table_detail_usc0cf.html?details_id=68&tn_us=TRUE )
So far, two fields that I have tried cannot be selected: BillAddressBlockAddr1 and IsPending.
Could you explain to me how that chart tells me that those fields are not available? I see 'False' for some entries for BillAddressBlockAddr1 but oddly not in the QRY column. For IsPending, I do not see False.
3. I took a detour yesterday to explore the IIF format, because it seemed simpler and FREE. Now, I'm back to qodbc. Is this correct, in general: QODBC is far more powerful because it can allow the insertion of linked data, far beyond the limits of the IIF file format?
The task that I'm working on is to insert sales receipts with associated line items, with payment via credit card, ideally with the bank deposit done at the same time. I imagine this can be done by QODBC and cannot see a way to do it with IIF. Would be great if you could confirm that.
Lastly, some notes for other Delphi users. I'm using Delphi 7, TDataSource, TQuery (BDE), and TDBGrid. I am doing all my testing in the Delphi IDE by changing the SQL property of the TQuery component; I have not even compiled yet. I have EurekaLog installed and it is giving me very clear error messages (which presumably would be visible even if EurekaLog were not installed).
Ann
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2009-02-06 16:16:59 |
|
|
|
|
Posted : 2009-02-06 16:56:12 |
1. Thanks. Turns out that this is a difference between VBDemo (works for me) and Delphi 7 (fails on select * and fails on selecting the bit field). My platform is Windows XP Pro, Dot Net 2, latest BDE (and that's not saying much). I will try again with Delphi 2009 in a week or so (pending hardware changes).
2. Thanks for the reminder. I finally ran the VBDemo, I see.
3. QuickBooks Pro 2008 (USA) still has File > Import from IIF as a feature, hence the question. Ok.
Ann |
|
|
|
|