Subject | Re: [firebird-support] Select data into a table |
---|---|
Author | Thomas Miller |
Post date | 2005-02-03T20:56:21Z |
To bad because it is a great short cut for developers. I would love to see
this added as well as *cascade constraints*
Ann W. Harrison wrote:
Thomas Miller
Wash DC Delphi SIG Chairperson
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork
http://www.bss-software.com
http://www.cpcug.org/user/delphi/index.html
https://sourceforge.net/projects/uopl/
http://sourceforge.net/projects/dbexpressplus
this added as well as *cascade constraints*
Ann W. Harrison wrote:
>Martin Catherall wrote:--
>
>
>>
>>I am using firebird 1.03.
>>I would like to select data from a table / stored procedure into another
>>table that does not exist.
>>
>>
>
>That's not possible. You'll have to define the table first, then use
>the insert ... select syntax. The other database has make a proprietary
>extension to the SQL language which is not generally supported.
>
>Regards,
>
>
>Ann
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
Thomas Miller
Wash DC Delphi SIG Chairperson
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork
http://www.bss-software.com
http://www.cpcug.org/user/delphi/index.html
https://sourceforge.net/projects/uopl/
http://sourceforge.net/projects/dbexpressplus