NetTalk Central

Author Topic: NT 9 APP, converting a TABLE and populate GUID, TS, TSS  (Read 3299 times)

walter.dasilva

  • Sr. Member
  • ****
  • Posts: 314
  • SOFTVALE
    • MSN Messenger - walter@softvale.com.br
    • View Profile
    • SOFTVALE
NT 9 APP, converting a TABLE and populate GUID, TS, TSS
« on: March 17, 2016, 10:36:34 AM »
Hi Bruce,

I´m trying to convert a table and populate GUID, TS, TSS. I followed all step in NT 9 APP docs to include those fields on my tables and set options for GUID to SetIfNew with ' & glo:st.MakeGuid() & ', and TS to SetIfNew with ' & glo:SyncDesktop.GetElapsedTimeUTC() & ' but all records got the same value.

I´m using MSSQL.

Thanks
Walter - SOFTVALE

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11250
    • View Profile
Re: NT 9 APP, converting a TABLE and populate GUID, TS, TSS
« Reply #1 on: March 18, 2016, 05:14:24 AM »
SetIfNew? so FM3?
SetIfNew does not populate for GUID values for MsSQL driver.
You will need to run a process on the table to populate it with random guid values.

cheers
Bruce