Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Detect Modified records in Table from VB?

Status
Not open for further replies.
NicoleM

NicoleM

Programmer
Oct 18, 2001
23
ZA
Hi!

I would like to know what the best method would be to detect whether records have been added / modifided to a database table (SQL server) from a visual basic application (not residing on the server hosting the database)

Regards,
Nicole
 
Sort by date Sort by votes
add a col;umn to the database called _transfered with 0 and 1 the only add able values. then create a trigger on the table that when a record is added the value is cahnged to true.

Hope this helps
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BobThornton
  • Locked
  • Question
Drop a table based on the count of records in another table
Replies
13
Views
219
Chris Miller
Chris Miller
bharons
  • Locked
  • Question
Pick up value from combobox
Replies
0
Views
247
bharons
bharons
WomanPro
  • Locked
  • Question
Insert into query adds records to unreadable format, how do I change that? 1
Replies
5
Views
234
Chris Miller
Chris Miller
grnzbra
  • Locked
  • Question
How Do I Add Column to Middle of Table
Replies
4
Views
330
BobSuruncle
BobSuruncle
eboughey1008
  • Locked
  • Question
Import columns from one table into another table with dissimilar field layout
Replies
7
Views
163
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top