Ask L.J. -------Original Message------- From: TOM HART Date: 02/04/09 11:10:50 To: RBASE-L Mailing List Subject: [RBASE-L] - SConnect database question I have Sconnected exact database that I am wanting to sync, everything seems to work except the following: THIS PART WORKS update SalesTab set ConsignNum = T2.ConsignNum,BrandName = T2.BrandName,+ ItemSize = T2.ItemSize,ItemDate = T2.ItemDate,StyleName = T2.StyleName descipt = T2.descipt,+ ConComm = T2.ConComm,ItemCost = T2.ItemCost+ from SalesTab T1, tmpItab T2 where T1.ProdNum = T2.ProdNum and T1.ItemDate is null
THIS DOES NOT update zSalesTab set ConsignNum = T4.ConsignNum,BrandName = T4.BrandName,+ ItemSize = T4.ItemSize,ItemDate = T4.ItemDate,StyleName = T4.StyleName descipt = T4.descipt,+ ConComm = T4.ConComm,ItemCost = T4.ItemCost+ from zSalesTab T3, tmpItab T4 where T3.ProdNum = T4.ProdNum and T3.ItemDate is null zSalesTab is sAttached from other database, both tables and databases are identical, just different data What am I doing wrong Tom
