Toad World® Forums

Error

While writing a script to create a new table, every time I go to a new line and
type a comma to start putting the next field like in this screen capture:

The Toad Insight list of suggestions appears, and behind it, I get this error
message:

image007.png

I’m still getting this error on a regular basis.

I’ve got a “new table” code snippet with this definition:

–Region CREATE TableName

IF EXISTS ( SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE Table_Name =
TableName’ )

DROP TABLE [TableName]

IF NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE Table_Name =
TableName’ )

CREATE TABLE [TableName]

(

–Region Column Definitions

$TableName$ID int identity CONSTRAINT PK_TableName PRIMARY KEY

, FirstColumnName nvarchar( 30 ) NOT NULL

, CreatedDate datetime NOT NULL CONSTRAINT DF_TableName_CreatedDate DEFAULT (
GetDate ())

, CreatedBy nvarchar( 50 ) NULL

, LastModifiedTimestamp RowVersion

–End Region

–Region Add Foreign Keys here:

–, CONSTRAINT FK_TableName_FirstForeignKeyFieldName FOREIGN KEY (
FirstForeignKeyFieldName ) REFERENCES dbo.ForeignTableName (
ForeignColumnName ) ON UPDATE CASCADE ON DELETE NO ACTION

–End Region

)

–Region TableName Descriptions:

–Describe the Table:

–EXEC sys.sp_addextendedproperty @value=N’Custom Table’,
@level1name=N’TableName’, @name=N’MS_Description’,
@level0type=N’SCHEMA’,@level0name=N’dbo’, @level1type=N’TABLE’

–Describe Column(s):

–EXEC sys.sp_addextendedproperty @value=N’Custom Field’,
@level1name=N’TableName’, @level2name=N’FirstColumnName’,
@name=N’MS_Description’, @level0type=N’SCHEMA’,@level0name=N’dbo’,
@level1type=N’TABLE’, @level2type=N’COLUMN’

–End Region

–End Region

To repro, start by creating a new snippet. Copy and paste in the definition
above call the snippet “NewTable”

Now in a new query editor, type newtable and press CTRL+Space to expand the
snippet

Start filling in the blanks. If you want to use exactly the same settings as me,
see below.

When you get to the field list, Before the “CreatedDate” field
that’s already there hit Enter

Start a new line with , SomeFieldName somedatatype NOT NULL

Hit enter

Start a new line with ,

Pause for a second, after typing the comma a list of system variables appears
(those starting with @@CONNECTIONS etc), then a fraction of a second later, I
get this API Guard (QP5 … error message:

–Region CREATE RedCagePickupHistory

IF EXISTS ( SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE Table_Name =
‘RedCagePickupHistory’ )

DROP TABLE [RedCagePickupHistory]

IF NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE Table_Name =
‘RedCagePickupHistory’ )

CREATE TABLE [RedCagePickupHistory]

(

–Region Column Definitions

RedCagePickupHistoryID int identity CONSTRAINT PK_RedCagePickupHistory PRIMARY
KEY

, VendorID nvarchar( 10 ) NOT NULL

, PickupDate datetime NOT NULL

, --<<<<<*
, CreatedDate datetime NOT NULL CONSTRAINT DF_RedCagePickupHistory_CreatedDate
DEFAULT ( GetDate ())

, CreatedBy nvarchar( 50 ) NULL

, LastModifiedTimestamp RowVersion

–End Region

–Region Add Foreign Keys here:

–, CONSTRAINT FK_RedCagePickupHistory_FirstForeignKeyFieldName FOREIGN KEY (
FirstForeignKeyFieldName ) REFERENCES dbo.ForeignTableName ( ForeignColumnName )
ON UPDATE CASCADE ON DELETE NO ACTION

–End Region

)

–Region RedCagePickupHistory Descriptions:

–Describe the Table:

–EXEC sys.sp_addextendedproperty @value=N’Custom Table’,
@level1name=N’RedCagePickupHistory’, @name=N’MS_Description’,
@level0type=N’SCHEMA’,@level0name=N’dbo’, @level1type=N’TABLE’

–Describe Column(s):

–EXEC sys.sp_addextendedproperty @value=N’Custom Field’,
@level1name=N’RedCagePickupHistory’, @level2name=N’VendorID’,
@name=N’MS_Description’, @level0type=N’SCHEMA’,@level0name=N’dbo’,
@level1type=N’TABLE’, @level2type=N’COLUMN’

–End Region

–End Region

Darren
*
image004.gif

I’m still getting this error on a regular basis.

I’ve got a “new table” code snippet with this definition:

–Region CREATE TableName

IF EXISTS ( SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE Table_Name =
TableName’ )

DROP TABLE [TableName]

IF NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE Table_Name =
TableName’ )

CREATE TABLE [TableName]

(

–Region Column Definitions

$TableName$ID int identity CONSTRAINT PK_TableName PRIMARY KEY

, FirstColumnName nvarchar( 30 ) NOT NULL

, CreatedDate datetime NOT NULL CONSTRAINT DF_TableName_CreatedDate DEFAULT (
GetDate ())

, CreatedBy nvarchar( 50 ) NULL

, LastModifiedTimestamp RowVersion

–End Region

–Region Add Foreign Keys here:

–, CONSTRAINT FK_TableName_FirstForeignKeyFieldName FOREIGN KEY (
FirstForeignKeyFieldName ) REFERENCES dbo.ForeignTableName (
ForeignColumnName ) ON UPDATE CASCADE ON DELETE NO ACTION

–End Region

)

–Region TableName Descriptions:

–Describe the Table:

–EXEC sys.sp_addextendedproperty @value=N’Custom Table’,
@level1name=N’TableName’, @name=N’MS_Description’,
@level0type=N’SCHEMA’,@level0name=N’dbo’, @level1type=N’TABLE’

–Describe Column(s):

–EXEC sys.sp_addextendedproperty @value=N’Custom Field’,
@level1name=N’TableName’, @level2name=N’FirstColumnName’,
@name=N’MS_Description’, @level0type=N’SCHEMA’,@level0name=N’dbo’,
@level1type=N’TABLE’, @level2type=N’COLUMN’

–End Region

–End Region

To repro, start by creating a new snippet. Copy and paste in the definition
above call the snippet “NewTable”

Now in a new query editor, type newtable and press CTRL+Space to expand the
snippet

Start filling in the blanks. If you want to use exactly the same settings as me,
see below.

When you get to the field list, Before the “CreatedDate” field
that’s already there hit Enter

Start a new line with , SomeFieldName somedatatype NOT NULL

Hit enter

Start a new line with ,

Pause for a second, after typing the comma a list of system variables appears
(those starting with @@CONNECTIONS etc), then a fraction of a second later, I
get this API Guard (QP5 … error message:

–Region CREATE RedCagePickupHistory

IF EXISTS ( SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE Table_Name =
‘RedCagePickupHistory’ )

DROP TABLE [RedCagePickupHistory]

IF NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE Table_Name =
‘RedCagePickupHistory’ )

CREATE TABLE [RedCagePickupHistory]

(

–Region Column Definitions

RedCagePickupHistoryID int identity CONSTRAINT PK_RedCagePickupHistory PRIMARY
KEY

, VendorID nvarchar( 10 ) NOT NULL

, PickupDate datetime NOT NULL

, --<<<<<*
, CreatedDate datetime NOT NULL CONSTRAINT DF_RedCagePickupHistory_CreatedDate
DEFAULT ( GetDate ())

, CreatedBy nvarchar( 50 ) NULL

, LastModifiedTimestamp RowVersion

–End Region

–Region Add Foreign Keys here:

–, CONSTRAINT FK_RedCagePickupHistory_FirstForeignKeyFieldName FOREIGN KEY (
FirstForeignKeyFieldName ) REFERENCES dbo.ForeignTableName ( ForeignColumnName )
ON UPDATE CASCADE ON DELETE NO ACTION

–End Region

)

–Region RedCagePickupHistory Descriptions:

–Describe the Table:

–EXEC sys.sp_addextendedproperty @value=N’Custom Table’,
@level1name=N’RedCagePickupHistory’, @name=N’MS_Description’,
@level0type=N’SCHEMA’,@level0name=N’dbo’, @level1type=N’TABLE’

–Describe Column(s):

–EXEC sys.sp_addextendedproperty @value=N’Custom Field’,
@level1name=N’RedCagePickupHistory’, @level2name=N’VendorID’,
@name=N’MS_Description’, @level0type=N’SCHEMA’,@level0name=N’dbo’,
@level1type=N’TABLE’, @level2type=N’COLUMN’

–End Region

–End Region

Darren
*
image002.gif (43 Bytes)

I’m still getting this error on a regular basis.

I’ve got a “new table” code snippet with this definition:

--Region CREATE TableName

IF EXISTS ( SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE Table_Name =
'TableName' )

DROP TABLE [TableName]

IF NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE Table_Name =
'TableName' )

CREATE TABLE [TableName]

(

--Region Column Definitions

$TableName$ID int identity CONSTRAINT PK_TableName PRIMARY KEY

, FirstColumnName nvarchar( 30 ) NOT NULL

, CreatedDate datetime NOT NULL CONSTRAINT DF_TableName_CreatedDate DEFAULT (
GetDate ())

, CreatedBy nvarchar( 50 ) NULL

, LastModifiedTimestamp RowVersion

--End Region

--Region Add Foreign Keys here:

--, CONSTRAINT FK_TableName_FirstForeignKeyFieldName FOREIGN KEY (
FirstForeignKeyFieldName ) REFERENCES dbo.ForeignTableName (
ForeignColumnName ) ON UPDATE CASCADE ON DELETE NO ACTION

--End Region

)

--Region TableName Descriptions:

--Describe the Table:

--EXEC sys.sp_addextendedproperty @value=N'Custom Table',
@level1name=N'TableName', @name=N'MS_Description',
@level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE'

--Describe Column(s):

--EXEC sys.sp_addextendedproperty @value=N'Custom Field',
@level1name=N'TableName', @level2name=N'FirstColumnName',
@name=N'MS_Description', @level0type=N'SCHEMA',@level0name=N'dbo',
@level1type=N'TABLE', @level2type=N'COLUMN'

--End Region

--End Region

To repro, start by creating a new snippet. Copy and paste in the definition
above call the snippet “NewTable”

Now in a new query editor, type newtable and press CTRL+Space to expand the
snippet

Start filling in the blanks. If you want to use exactly the same settings as me,
see below.

When you get to the field list, Before the “CreatedDate” field
that’s already there hit Enter

Start a new line with , SomeFieldName somedatatype NOT NULL

Hit enter

Start a new line with ,

Pause for a second, after typing the comma a list of system variables appears
(those starting with @@CONNECTIONS etc), then a fraction of a second later, I
get this API Guard (QP5 … error message:

--Region CREATE RedCagePickupHistory

IF EXISTS ( SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE Table_Name =
'RedCagePickupHistory' )

DROP TABLE [RedCagePickupHistory]

IF NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE Table_Name =
'RedCagePickupHistory' )

CREATE TABLE [RedCagePickupHistory]

(

--Region Column Definitions

RedCagePickupHistoryID int identity CONSTRAINT PK_RedCagePickupHistory PRIMARY
KEY

, VendorID nvarchar( 10 ) NOT NULL

, PickupDate datetime NOT NULL

, --<<<<<*
, CreatedDate datetime NOT NULL CONSTRAINT DF_RedCagePickupHistory_CreatedDate
DEFAULT ( GetDate ())

, CreatedBy nvarchar( 50 ) NULL

, LastModifiedTimestamp RowVersion

--End Region

--Region Add Foreign Keys here:

--, CONSTRAINT FK_RedCagePickupHistory_FirstForeignKeyFieldName FOREIGN KEY (
FirstForeignKeyFieldName ) REFERENCES dbo.ForeignTableName ( ForeignColumnName )
ON UPDATE CASCADE ON DELETE NO ACTION

--End Region

)

--Region RedCagePickupHistory Descriptions:

--Describe the Table:

--EXEC sys.sp_addextendedproperty @value=N'Custom Table',
@level1name=N'RedCagePickupHistory', @name=N'MS_Description',
@level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE'

--Describe Column(s):

--EXEC sys.sp_addextendedproperty @value=N'Custom Field',
@level1name=N'RedCagePickupHistory', @level2name=N'VendorID',
@name=N'MS_Description', @level0type=N'SCHEMA',@level0name=N'dbo',
@level1type=N'TABLE', @level2type=N'COLUMN'

--End Region

--End Region

Darren
*

I’m still getting this error on a regular basis.

I’ve got a “new table” code snippet with this definition:

--Region CREATE TableName

IF EXISTS ( SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE Table_Name =
'TableName' )

DROP TABLE [TableName]

IF NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE Table_Name =
'TableName' )

CREATE TABLE [TableName]

(

--Region Column Definitions

$TableName$ID int identity CONSTRAINT PK_TableName PRIMARY KEY

, FirstColumnName nvarchar( 30 ) NOT NULL

, CreatedDate datetime NOT NULL CONSTRAINT DF_TableName_CreatedDate DEFAULT (
GetDate ())

, CreatedBy nvarchar( 50 ) NULL

, LastModifiedTimestamp RowVersion

--End Region

--Region Add Foreign Keys here:

--, CONSTRAINT FK_TableName_FirstForeignKeyFieldName FOREIGN KEY (
FirstForeignKeyFieldName ) REFERENCES dbo.ForeignTableName (
ForeignColumnName ) ON UPDATE CASCADE ON DELETE NO ACTION

--End Region

)

--Region TableName Descriptions:

--Describe the Table:

--EXEC sys.sp_addextendedproperty @value=N'Custom Table',
@level1name=N'TableName', @name=N'MS_Description',
@level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE'

--Describe Column(s):

--EXEC sys.sp_addextendedproperty @value=N'Custom Field',
@level1name=N'TableName', @level2name=N'FirstColumnName',
@name=N'MS_Description', @level0type=N'SCHEMA',@level0name=N'dbo',
@level1type=N'TABLE', @level2type=N'COLUMN'

--End Region

--End Region

To repro, start by creating a new snippet. Copy and paste in the definition
above call the snippet “NewTable”

Now in a new query editor, type newtable and press CTRL+Space to expand the
snippet

Start filling in the blanks. If you want to use exactly the same settings as me,
see below.

When you get to the field list, Before the “CreatedDate” field
that’s already there hit Enter

Start a new line with , SomeFieldName somedatatype NOT NULL

Hit enter

Start a new line with ,

Pause for a second, after typing the comma a list of system variables appears
(those starting with @@CONNECTIONS etc), then a fraction of a second later, I
get this API Guard (QP5 … error message:

--Region CREATE RedCagePickupHistory

IF EXISTS ( SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE Table_Name =
'RedCagePickupHistory' )

DROP TABLE [RedCagePickupHistory]

IF NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE Table_Name =
'RedCagePickupHistory' )

CREATE TABLE [RedCagePickupHistory]

(

--Region Column Definitions

RedCagePickupHistoryID int identity CONSTRAINT PK_RedCagePickupHistory PRIMARY
KEY

, VendorID nvarchar( 10 ) NOT NULL

, PickupDate datetime NOT NULL

, --<<<<<*
, CreatedDate datetime NOT NULL CONSTRAINT DF_RedCagePickupHistory_CreatedDate
DEFAULT ( GetDate ())

, CreatedBy nvarchar( 50 ) NULL

, LastModifiedTimestamp RowVersion

--End Region

--Region Add Foreign Keys here:

--, CONSTRAINT FK_RedCagePickupHistory_FirstForeignKeyFieldName FOREIGN KEY (
FirstForeignKeyFieldName ) REFERENCES dbo.ForeignTableName ( ForeignColumnName )
ON UPDATE CASCADE ON DELETE NO ACTION

--End Region

)

--Region RedCagePickupHistory Descriptions:

--Describe the Table:

--EXEC sys.sp_addextendedproperty @value=N'Custom Table',
@level1name=N'RedCagePickupHistory', @name=N'MS_Description',
@level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE'

--Describe Column(s):

--EXEC sys.sp_addextendedproperty @value=N'Custom Field',
@level1name=N'RedCagePickupHistory', @level2name=N'VendorID',
@name=N'MS_Description', @level0type=N'SCHEMA',@level0name=N'dbo',
@level1type=N'TABLE', @level2type=N'COLUMN'

--End Region

--End Region

Darren
*

Hi Darren,

Sorry for the inconvenience. I 95% sure this problem is already fixed. Will be
available in first Beta build we expect to post next week.

regards,

Alexander Maximov

Hi Darren,

Sorry for the inconvenience. I 95% sure this problem is already fixed. Will be
available in first Beta build we expect to post next week.

regards,

Alexander Maximov