View the changes in the database by DATA SET...
-
HAI DATABASE : SQLSERVER 2005 VB : 2008 TYPE PROJECT : NETWORK Use a separate DATASET in the draft and when I update the data or start I update the data also DATASET so you do not need to reopen Aldtasi of the new data because the size of a very large and cause slow in the project How can I find records that have been updated or deleted, or added? Because the project network
-
HAI DATABASE : SQLSERVER 2005 VB : 2008 TYPE PROJECT : NETWORK Use a separate DATASET in the draft and when I update the data or start I update the data also DATASET so you do not need to reopen Aldtasi of the new data because the size of a very large and cause slow in the project How can I find records that have been updated or deleted, or added? Because the project network
Vb Rnd wrote:
Use a separate DATASET in the draft and when I update the data or start I update the data also DATASET so you do not need to reopen Aldtasi of the new data because the size of a very large and cause slow in the project How can I find records that have been updated or deleted, or added?
Sounds like you're abusing the dataset as a local cache. If you want to cache your data locally, consider using a local database and a synchronization framework; it'd save you a lot of redundant calls. Alternatively, you can find all that has been added using plain SQL; perform a
SELECT WHERE NOT INand pass the values for the primary keys of the records in your dataset. Deleting would be something similar. For updates, one could use a timestamp (think "lastmodified"-field).Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]