UniLoader issue with UNIQUEIDENTIFIER column
Posted: Fri 15 Mar 2013 01:26
I have the following table definition:
CREATE TABLE unidactest (
[Identifier] [uniqueidentifier] NOT NULL DEFAULT NEWID(),
[Vendor_Name] [varchar](500) NULL
)
I an using a TUniLoader to load values into the above table. On the OnPutData event, I run the following:
loaderMain.PutColumnData(1, 1, 'Vendor A');
The application will not upload the value, but instead raises the following EOLEDB error: Unspecified error.
If I change the definition of the Identifier column to
[Identifier] [uniqueidentifier] NULL DEFAULT NEWID()
or
[Identifier] [integer] NOT NULL DEFAULT 999
everything works. So it looks like a problem when the column does not accept null values and is a uniqueidentifier column.
Is there some setting I am missing?
Thanks in advance.
CREATE TABLE unidactest (
[Identifier] [uniqueidentifier] NOT NULL DEFAULT NEWID(),
[Vendor_Name] [varchar](500) NULL
)
I an using a TUniLoader to load values into the above table. On the OnPutData event, I run the following:
loaderMain.PutColumnData(1, 1, 'Vendor A');
The application will not upload the value, but instead raises the following EOLEDB error: Unspecified error.
If I change the definition of the Identifier column to
[Identifier] [uniqueidentifier] NULL DEFAULT NEWID()
or
[Identifier] [integer] NOT NULL DEFAULT 999
everything works. So it looks like a problem when the column does not accept null values and is a uniqueidentifier column.
Is there some setting I am missing?
Thanks in advance.