Showing related tags and posts across the entire site.
-
on the web portal, some "donors" appear as numeric values. discovered that we have .. 551 that have this condition.. select donorid , description -- 551 rows returned from donor where 1=1 and isnumeric(description) = 1 they are also in the DesigDonor table.. select * -- 556 rows returned. from...
-
Hi Troy, We could try that but we have many users in this situation. Would it be feasible or advisable to take a snapshot, delete the data server and re sync/re import using our custom access database that we have set up? Basically deleting all designations in the sql data base and re syncing. Thanks...
-
Hi Troy, Correct me if I'm wrong but we believe this might be a problem with the TNT application itself not querying the Sql database properly? We believe this because: 1. We've pumped Web Users and Webuser Profiles/Designations multiple times during the same day and on different days. 2. We...
-
We run pumps to sync our Access database of Missionary info with the TntMPD SQL database. This hasn't happened in the past but now there are duplicated uses in our TntMPD SQL database even though our Access database has all the correct information and is free of duplicates. Logging in as admin>right...