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:
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
*
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