J another idea
Can you turn it inside out, if you are going for 3. Then get the guys who wrote it to port to MS SQL etc (clarion will drive ODBC) or how I'd do it (quick and dirty) You continuously scan the Clarion table, and check against your own local copy which can be in any db you like, when you encounter a diff, do your stuff and update your copy and resume the scan, Your max update time would be the time required to scroll the DB, since you have the Topspeed table R/O it shouldn't be to onorous HTH N ----- 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/
