We're currently using QODBC V9 against QB UK Accountant 2005 (Multicurrency) and need to be able to modify the exchange rate used on a large number of transactions for a previous year.  As far as I can see from the documentation and playing around this can't be done unfortunately.

Does anyone know if there is a way that we can do this - ie. go back and modify exchange rates, or would it be possible with a different version of QB e.g. QB Enterprise? 

Thanks

Richard

Hi Tom

I hate to ask but are you sure about that?  I realise that I can see the exchange rate but when I try to modify it I am not allowed.  Also the technical reference for qodbc suggests that that field is not updateable.   Your link was just for viewing exchange rate unless I missed something.  I would be very happy if it were possible to do.

thanks for your help

Rich

No, in How do I create an Invoice using Exchange Rates? I set my own exchange rate. It's just a matter of using a UPDATE statement, for example:

Update InvoiceLine set ExchangeRate = 1.5
where TxnID= '2476-1071504523' and InvoiceLineTxnLineID= '247A-1071504523'

Thanks Tom.  I still can't see an UPDATE statement following your link - only an INSERT, but following your example I have tried both of the following with no success:

UPDATE CheckItemLine SET ExchangeRate=2 WHERE TxnID = '8E4F-1228915837' and ItemLineTxnLineID='8E51-1228915837'

UPDATE Check SET ExchangeRate=1 WHERE TxnID = '8E4F-1228915837'

In both cases I get the following error:

ODBC -- update on a linked table 'CheckItemLine' failed

[QODBC] Not supported (#10003)

For reference I am using an SQL pass through query in Access 2003 to QODBC V9 and QB UK 2005 (multicurrency).  I can successfully use a SELECT query to see the data - just not modify the Exchange rate.

I also tried to use an UPDATE statement to modify the RefNumber for the transaction as a test but got the same error so it may not be related specifically to the Exchange rate.

For reference I've being using QODBC very happily for over a year now to create accounts and insert new transactions.  This is just the first time that I have tried to update and existing transaction and I don't seem to be able to make it work.  I've tried it with QB open and QB closed in both single and multiuser mode with no luck.

Thanks again

Richard

Thanks, that explains it.  Two further questions if I may.  Can I use QODBC with the Enterprise version of QB (which is multicurrency I believe)?  and also do I actually need QODBC to make an ODBC connection to the Enterprise version or does it come come with QODBC as standard?

Thanks

Richard