10/31/2025 4:31:34 AM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.
|
|
|
|
SQL statement syncing
Posted: 26 Jun 10 5:54 PM
|
I'm working on trying to reduce the remote users sync times, and one thing I see examining TEF files, is that SQL update statements in my scripts are getting synced to more databases than is necessary.
What my testing seems to indicate is that if a SQL statement references the id of a single record, that SQL statement will only get synced to database with that record in it. If the SQL statement does NOT specify a record id, then that SQL statement gets synced out to all databases. I thought maybe I could control this by using application.basicfunctions.logsetglobalid but that seems to have no effect.
Does anyone know of a way to control which databases a SQL statement will sync out to when not using the record id? In most cases theses statements are designed to affect a number of records but records which reside in just one database - not all databases. I could change out all these SQL statement out for loops that use recordsets to update, but that's a lot of re-writing and I thought I'd checked for a less painful method. |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|