Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Enhancement Requests and Suggestions » View Thread |
Messages 1 to 10 of 11 total |
IF (NOT) EXISTS |
Tue, Jun 24 2008 3:15 AM | Permanent Link |
Heiko Knuettel | CREATE ... IF NOT EXISTS
ALTER ... IF EXISTS DROP ... IF EXISTS ADD ... IF NOT EXISTS etc. pp. I know I can query the information schema, but I am missing them. They were very handy. Any chance to get them back ? TIA, Heiko |
Tue, Jun 24 2008 5:22 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Heiko
I know the answer to that since I argued long, hard and passionately for them - its NO. Roy Lambert [Team Elevate] |
Tue, Jun 24 2008 7:41 AM | Permanent Link |
Heiko Knuettel | Roy
>>I argued long, hard and passionately for them do you remember the thread ? Heiko |
Tue, Jun 24 2008 1:09 PM | Permanent Link |
"David Cornelius" | > I know I can query the information schema, but I am missing them. They
> were very handy. > Any chance to get them back ? You could build a function pretty easily. -- David Cornelius CorneliusConcepts.com |
Tue, Jun 24 2008 1:53 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Heiko
It was off newsgroup. Roy Lambert |
Tue, Jun 24 2008 1:53 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | David
The whole table ones yes, the column ones no. Roy Lambert [Team Elevate] |
Tue, Jun 24 2008 3:24 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< The whole table ones yes, the column ones no. >> How are they different ? Both rely on simply querying the Information schema and building a DDL statement accordingly. -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Jun 24 2008 4:50 PM | Permanent Link |
"David Cornelius" | > The whole table ones yes, the column ones no.
See new submissions in the elevatedb.extensions group. -- David Cornelius CorneliusConcepts.com |
Tue, Jun 24 2008 4:56 PM | Permanent Link |
Heiko Knuettel | David
>>See new submissions in the elevatedb.extensions group. Cool...thanks for that ! |
Wed, Jun 25 2008 2:59 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
><< The whole table ones yes, the column ones no. >> > >How are they different ? Both rely on simply querying the Information >schema and building a DDL statement accordingly. I was looking at it from a viewpoint of I could write a function to carry out the table level ones, but you need to build the sql for the column level ones. So I could have a function CreateTableIfNotExists(tablename) and it is self contained much as the DBISAM syntax is but I couldn't write the equivalent of ADD COLUMN IF NOT EXISTS. If I want to do that I have to create the whole sql statement. Roy Lambert [Team Elevate] |
Page 1 of 2 | Next Page » | |
Jump to Page: 1 2 |
This web page was last updated on Thursday, April 18, 2024 at 10:42 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |