Greetings,

Does anyone know of a tool that create an insert script based on data in an Interbase table?

In other words, I would like to be able to select a table, click a button where an open dialog is presented to me, enter the file name to save the insert script to, then have an insert script written for me based on the data in this table. Alternately I would like to have the whole database do this.

I would like it to look like this...

/*
* ACTIVITY_TYPE
*/
INSERT INTO ACTIVITY_TYPE (ACTIVITY_TYPE_CODE, DESCRIPTION, IMAGE_INDEX, COMPANY_ID)
VALUES ('E', 'E-mail', 27, 1);
INSERT INTO ACTIVITY_TYPE (ACTIVITY_TYPE_CODE, DESCRIPTION, IMAGE_INDEX, COMPANY_ID)
VALUES ('F', 'Fax', 34, 1);
INSERT INTO ACTIVITY_TYPE (ACTIVITY_TYPE_CODE, DESCRIPTION, IMAGE_INDEX, COMPANY_ID)
VALUES ('L', 'Letter', 23, 1);
INSERT INTO ACTIVITY_TYPE (ACTIVITY_TYPE_CODE, DESCRIPTION, IMAGE_INDEX, COMPANY_ID)
VALUES ('P', 'Phone', 51, 1);
INSERT INTO ACTIVITY_TYPE (ACTIVITY_TYPE_CODE, DESCRIPTION, IMAGE_INDEX, COMPANY_ID)
VALUES ('N', 'Note', 36, 1);
INSERT INTO ACTIVITY_TYPE (ACTIVITY_TYPE_CODE, DESCRIPTION, IMAGE_INDEX, COMPANY_ID)
VALUES ('S', 'System', 37, 1);
commit;

Any ideas welcomed.

Thanks

Michael Tuttle
Software Technologies, Inc.
Topeka, KS

[Non-text portions of this message have been removed]