NetTalk Central

Author Topic: Netsync.clw and Sql tables records count  (Read 4285 times)

Alberto

  • Hero Member
  • *****
  • Posts: 1873
    • MSN Messenger - alberto-michelis@hotmail.com
    • View Profile
    • ARMi software solutions
    • Email
Netsync.clw and Sql tables records count
« on: September 10, 2019, 10:07:56 AM »
When calculating the records count it uses

Self.ViewTable{prop:sql} = 'Select Max(' & clip(stsname) & '), Count(*) from ' & clip(self.TableLabel)

That is TableLabel instead of Table Name, it comes from the template wich builds the sync queue.

My table label is opecontactos and the external name is ope_contactos and then the record count is always zero

see pic

besides, Its doing: if fRecords = 0 or errorcode()
and no records is not the same of an error()

PS: see my "Netsync method file boundary name" post, its related
« Last Edit: September 10, 2019, 10:51:15 AM by michelis »
-----------
Regards
Alberto