timothy

I’m currently updating product information in [DToolsProducts50].[dbo].[MasterDataTable] from the SQL back end, and I am trying to figure out which fields I need to update in order for LanSync to recognize that the rows need to be pushed into MMPD.

For example, I would run a query to update all products all Sony products to taxable. I would run the following query:
UPDATE [DToolsProducts50].[dbo].[MasterDataTable]
SET [Taxable] = 1
WHERE [Manufacturer] = N'Sony'

I’m having trouble figuring out what flags LanSync to propagate the database's changes to the D-Tools client’s local database.
I’ve experimented with updating various (and all) date fields. I also suspect that [UserID] and [MachineName] have an affect. However, I have not come to a solid conclusion, and arrive at inconsistent results.

Has anyone else experimented with this, or learned anything?

grichards

try [Synchronize] in combination with the [GMTDatetimeXXX] fields.
i.e. Price changes would be [GMTDateTimePrice]

__________________
Systems Technician/Crestron Certified Programmer
www.ccisolutions.com
[SIGPIC][/SIGPIC]

NareshN

Timothy,

Richards is correct.

You need to set [Synhronize] to true and the appropriate [GmtdateTimexxx] field to the current utc date time.
Your statement would look like this --

UPDATE [DToolsProducts50].[dbo].[MasterDataTable]
SET [Taxable] = 1,
[Synchronize] = 1,
[GMTDateTimePrice] = GetUTCDate()
WHERE [Manufacturer] = N'Sony'

Make sure to back up your database before making these wholesale changes.

fryeguy

Timothy,

You are a brave man.

Take the advice of master Naresh! He is like a Jedi...