dbExpress Plus will have this capability shortly. email me directly for
more info or continue the
conversation on the Borland / Delphi / dbExpress forum.

M Tuttle wrote:

>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]
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>

--
Thomas Miller
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork

http://www.bss-software.com
http://sourceforge.net/projects/dbexpressplus