From: | Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com> |
---|---|
To: | Bob Pawley <rjpawley(at)shaw(dot)ca> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Postgresql to Delphi |
Date: | 2007-03-20 22:07:29 |
Message-ID: | 46005B21.70808@amsoftwaredesign.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Bob Pawley wrote:
> Listen/notify implies a dynamic table that is constantly on the
> change. Am I correct?
>
> The table I am talking about is completed through one interface then
> imported as a relatively static information base for the application
> in which I am seeking help.
>
Yes,
you would have to define a rule on the table and when the table changed
it would send a notification back to who ever is listening.
Why don't you just run a query against the table, then loop through the
result set and then trigger your devices from inside the loop?
myquery.sql.add('select * from mytable where bla = bla;');
myquery.open;
While not myquery.eof do
begin
if myquery.fieldbyname('somefield').asstring = 'something' then
//signal your device.
myquery.next;
end;
I guess that is the best I can come up without knowing more.
Later,
--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2007-03-20 22:10:15 | Re: Lifecycle of PostgreSQL releases |
Previous Message | Bob Pawley | 2007-03-20 21:49:56 | Re: Postgresql to Delphi |