Re: [DUG]: Whats going to be best thing to do?

[Terry Johnson]

If you only have to be aware of new data (v. edited data) then create a new column in the database. Their program won't do anything with it, so it should be left null. Then select for newcol is null to find new records, and write something in to flag it's been handled.

Terry

vss wrote:

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/