Well the only slight problem with your idea would be, (1). I would need to update the comparision table, and (2). there are 94000 + records...might be sow. I might just get these guys to output to a table and look at that.
Thanks for the ideas. Jeremy -----Original Message----- From: "Neven MacEwan" <[EMAIL PROTECTED]> To: Multiple recipients of list delphi <[EMAIL PROTECTED]> Date: Fri, 11 Oct 2002 11:46:10 +1300 Subject: Re: [DUG]: Whats going to be best thing to do? > 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/ --------------------------------------------------------------------------- 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/
