Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread Error 700 on sql script produced by EDB Manager
Tue, Feb 27 2007 3:15 PMPermanent Link

Dave M
Included below is script, unmodified after being produced by reverse engineering on a
dbisam v4 table, using edb manager.
Script produces 700 error using edb manager v1.

Dave M
------------------------------------------------------------------------------------------------------------------

CREATE TABLE "AddressRelate"
(
"RecordID" INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 0, INCREMENT BY 1) NOT NULL,
"A1" INTEGER NOT NULL,
"A2" INTEGER NOT NULL,
CONSTRAINT "PrimaryKey" PRIMARY KEY ("RecordID")
)

VERSION 1
UNENCRYPTED
INDEX PAGE SIZE 4096
BLOB BLOCK SIZE 512
MAX ROW BUFFER SIZE 32768
MAX INDEX BUFFER SIZE 65536
MAX BLOB BUFFER SIZE 32768
  
CREATE INDEX "A1" ON "AddressRelate" ("A1")
  
CREATE INDEX "A2" ON "AddressRelate" ("A2")
Wed, Feb 28 2007 9:22 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Dave,

<< Included below is script, unmodified after being produced by reverse
engineering on a dbisam v4 table, using edb manager. Script produces 700
error using edb manager v1. >>

EDB doesn't support scripts currently.  You have to execute each statement
separately.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image