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
_______________________________________________ NZ Borland Developers Group - Delphi mailing list Post: delphi@delphi.org.nz Admin: http://delphi.org.nz/mailman/listinfo/delphi Unsubscribe: send an email to [EMAIL PROTECTED] with Subject: unsubscribe
