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
|
|
Questions About Syncing |
Author |
Message |
|
Posted : 2007-10-26 15:44:14 |
Balances are very important to me, I need a little clarification on the Nulls/Dirty Read/Real Time setting. If I set it to real time, does that mean if I run sp_optimizeupdatesync ALL it will update those fields or do I have to initial a query that requests the balance fields?
Thanks in advance |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-10-29 08:26:47 |
|
|
|
|
Posted : 2007-10-29 09:25:26 |
That is what is confusing me, I have the driver set to real time but those tables are null in the affected columns. I was actually referencing the article you linked to when I asked the question. Is there anyway to get these fields to update when sp_optimizeupdatesync is called? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-10-29 14:53:39 |
No, those optimized fields/columns are only updated by doing either sp_optimizefullsync All or tablename, or by using the verify tag like this:
Select * from Customer verify |
|
|
|
|
Posted : 2007-10-29 14:57:30 |
I am actually setting up an intricate system of queries to update the data manually. What do you think would run faster
Select * From Customers CallDirect Select ListID, Balance, TotalBalance From Customers CallDirect
I would assume the later would be faster since it is not referencing every column |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-10-29 15:22:46 |
Actually you don't have to do that as you can check the Multi-Table Sync option instead. This option is unchecked by default for all non-USA enterprise users. If checked, the QODBC optimizer will use other tables to re-sync tables, however, this will slow down performance. When off all Multi-Table Sync fields become Real-Time fields. (Similar to version 7.0.x) Note: This feature is basically ignored and set to unchecked if the version is QBOE or SDK is less than v3 (used by QuickBooks 2004 USA and all QuickBooks versions outside USA). Prior to SDK v3 the other multi-sync tables did not exists so using real data for those fields is safer. |
|
|
|
|