Why not store the largest PK you have read up to in the table. Then check the table (every x seconds) and see if any records with larger PKs have been inserted, if so do stuff with them and upddate the largest PK. This should work OK so long as records are only added to the file. To take account of edits you proably need some sort of comparison table. Hope this makes some sort of sense.
Rob Software engineer Wild Software Ltd Ph 03 338-1407 ----- Original Message ----- From: "vss" <[EMAIL PROTECTED]> To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]> Sent: Friday, October 11, 2002 11:11 AM Subject: [DUG]: Whats going to be best thing to do? > Hi all. > > I have a client who has a Clarion databse (Topspeed dbs) and we have now > brought the TopSpeed ODBC driver, and can access the files. > > What we are trying ot do is when some data goes into a specific table, > it has to get that record, and do something with it. > > Whats going to be the best way to do this do you think? > My thoughts have been:- > > (1). do a record count and when the count is diff. go and get the new > record.....BUT what if 3 entries have been added...how do you know 3 > have been added? what about, you go to get the last record, but another > 2 have been added since you did the r/count....dont think this is an > option > > (2). SOMEHOW monitor the table so that as stuff is added do something. > > (3). Get the people who wrote the app. to make a mod that writes the > data to an identical table (structurally) and then r/count this. if its > >0 then it loop the records. > > #3 seems to me the best...just costly. > The other problem IS, that we are trying to makeit as quick as poss. as > the data is being posted onto a webpage, and at the moment usething the > method we are using not, its about 1-2 mins before the new appears. > > Anyone else got any other Ideas? > > Jeremy > > -------------------------------------------------------------------------- - > New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] > Website: http://www.delphi.org.nz > To UnSub, send email to: [EMAIL PROTECTED] > with body of "unsubscribe delphi" > Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ > --------------------------------------------------------------------------- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of "unsubscribe delphi" Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
