Invalid SQL: INSERT INTO `swsessions` (`sessionid`, `ipaddress`, `lastactivity`, `useragent`, `isloggedin`, `sessiontype`, `typeid`, `dateline`, `status`) VALUES('463f8c194b0901071cdaf7c2cbf8c92f', '54.81.154.223', '1498227680', 'CCBot/2.0 (http://commoncrawl.org/faq/)', '0', '40', '0', '1498227680', '0'); (The table 'swsessions' is full)
Warning: Cannot modify header information - headers already sent by (output started at C:\Inetpub\support.inm.com\includes\functions.php:410) in C:\Inetpub\support.inm.com\includes\functions.php on line 1612
Modifying a V12 Database file structure - Support Center
inm logo
Corporate Website | Contact | Store | Support | Login  
     


Knowledgebase
View categorized listing of all common frequently asked questions.
Downloads
View our categorized library of downloads for all necessary manuals, software, etc.
 Article Options
Support Center » Knowledgebase » INM V12 Database for Director » Modifying a V12 Database file structure
Support Page Banner
 Modifying a V12 Database file structure
Product:Platform:Area:Version:
INM V12 Database for Director Windows, Macintosh Structure and indexes All

Summary

Once a V12 Database file is created, modifying its structure is not an easy task. Because V12 Databse files are optimized both for speed and file size, only a limited number of modifications are allowed to an existing database. For example, to add a field to an existing table, you must first create a new table, create all fields and indexes in it including your new field, import all your records to the new table and finally delete the old table.

Example

The methods used to modify an existing V12 Database are:

1. Dump the structure of your initial database (see Viewing the Structure of a Database in the
    user manual) and modify the returned database descriptor.
2. Create a new V12 Database file based on the modified descriptor.
3. Import the content of each table to the new V12 Database file (see the section on Importing from V12 Database).

The above steps can be executed either through Lingo handlers, or using the INM V12 Database Editor.



Article Details
Article ID: 109
Created On: 26 Sep 2006 02:35 PM

 This answer was helpful  This answer was not helpful

inm general footer
Services Xtras Go Products Support Gallery Store Download About Us Contact Newsroom