Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Enhancement Requests and Suggestions » View Thread |
Messages 11 to 11 of 11 total |
IF (NOT) EXISTS |
Wed, Jun 25 2008 9:51 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< 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. >> You're executing an SQL statement on the fly with an EXECUTE IMMEDIATE call in both cases. Both are strings, and the only difference is that one has to be built, and the other can be specified in one chunk (possibly, you may want to control a CREATE TABLE statement parameters such as the BLOB block size, etc.). -- Tim Young Elevate Software www.elevatesoft.com |
« Previous Page | Page 2 of 2 | |
Jump to Page: 1 2 |
This web page was last updated on Wednesday, August 14, 2024 at 03:12 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |