User Tools

Site Tools


dynamiczip:install:mods:sql_table_exists_function

Improved SQL TableExists() function

Modified January 22, 2015

After this modification DynamicZip tests for the existence of a SQL table by using the following query:

select * from sys.tables where name = {table name}

If this query returns a row, then the table exists otherwise it does not.

Prior to this modification DynamicZip tested for the existence of a SQL table by executing a select query on the table in question and checking to see if the query returned an error. If no error, then the table exists, otherwise it was considered to not exist.

This fix was made in the following builds:


Modifications

dynamiczip/install/mods/sql_table_exists_function.txt · Last modified: 2015/02/11 18:03 by 127.0.0.1

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki