[firebird-support] Modify Existing FDB

2013-10-23 Thread John W. (Jack) Cane
Would like a pointer to a guide for modifying an existing FDB without having to rebuild from scratch. For example, adding one or more tables, perhaps linked with FK relationships to existing tables, adding fields to an existing table, increasing lengths of fields of existing tables, etc. What is

[firebird-support] Return PK Value

2013-08-22 Thread John W. (Jack) Cane
I would like to learn the primary key value of successful SQL Insert command. The following syntax was picked up from (I think) a reliable source, cannot recall where. It generates an error at 'Output'. Could you please show me the correct syntax. 'Insert into table( column set ) Values(value s

[firebird-support] Return PK Value on Insert

2013-08-10 Thread John W. (Jack) Cane
After performing an insert I need to know the value of the primary key of the newly inserted record. If there is a way to get that without performing another select query after the insert, would you please give me or point me to an example. Best, jwc from iMac [Non-text portions of this mess

[firebird-support] Re: Manual Deletion Question

2013-08-10 Thread John W. (Jack) Cane
Please cancel (deleted by "Drop" in FB_SQL). Best, jwc from iMac On Aug 9, 2013, at 6:27 PM, John W. (Jack) Cane wrote: > During development, we generate a number of empty databases with the same > file name, each to replace the previous version. > > Question: Is it

[firebird-support] Manual Deletion Question

2013-08-09 Thread John W. (Jack) Cane
During development, we generate a number of empty databases with the same file name, each to replace the previous version. Question: Is it required, or desirable, manually to delete an existing, empty FB table prior to generating a new one with the same file name and location (path)? Best, jwc