[DUG] Importing Data

[Bob Pawley]

I have a PostgreSQL database holding two tables Drawings and Devices.

Each of the drawings holds devices numbering between 0 - 100.

I also have a Delphi interface with which a user can select a device, the application then performs a procedure then updates the Devices table with an interface generated ID number. This, single device, import works well.

What I want to do is import all of the devices from a Drawing, one at a time,  perform the procedure on each device and update the table with the ID.

I have attempted Declare Cursor. 

Unfortunately, the version of POstgreSQL that I am running doesn't support updating a table with the interface's ID number while using a temporary cursor either in Fetch or Move.

If someone could suggest a method of importing these devices, based on Drawings, that allows updating the tables it would be much appreciated.

Bob Pawley
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.adventureeducation.co.nz/pipermail/delphi/attachments/20071011/fe9cccdb/attachment.html