Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Incident Reports » Incident Reports Reported for Version 4.00 » View Incident Report |
Serious |
Reported By: Tiago Ameller Reported On: 12/15/2003 For: Version 4.00 Build 1 |
/********* sample incorrect script **************/ DROP TABLE IF EXISTS "SCUSER.DAT"; CREATE TABLE IF NOT EXISTS "SCUSER.DAT" ( "Codigo" SMALLINT DESCRIPTION 'Código' NOT NULL DEFAULT '1' MIN '1' MAX '99', "Nombre" CHARACTER(20) NOT NULL, "Password" CHARACTER(8) DESCRIPTION 'Contraseña', "RepitaPassword" CHARACTER(8) DESCRIPTION 'Repita Contraseña', "F000" INTEGER NOT NULL DEFAULT 2147483647, "F001" INTEGER NOT NULL DEFAULT 2147483647, "F002" INTEGER NOT NULL DEFAULT 2147483647, "F003" INTEGER NOT NULL DEFAULT 2147483647, "F004" INTEGER NOT NULL DEFAULT 2147483647, "F005" INTEGER NOT NULL DEFAULT 2147483647, PRIMARY KEY ("Codigo") COMPRESS FULL DESCRIPTION 'Fichero Usuarios' ); CREATE NOCASE INDEX IF NOT EXISTS ixNombre ON 'SCUSER' /* must be double, not single quotes */ ("Nombre") COMPRESS FULL; INSERT INTO SCUSER (Codigo, Nombre) VALUES (1, "Master"); /* must be single, not double quotes */
This web page was last updated on Wednesday, March 20, 2024 at 07:22 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |