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.
UniLoader issue with UNIQUEIDENTIFIER column
-
AndreyZ
Re: UniLoader issue with UNIQUEIDENTIFIER column
Thank you for the information. We have reproduced the problem and fixed it. This fix will be included in the next UniDAC version.
Re: UniLoader issue with UNIQUEIDENTIFIER column
If I have a non-source license for Unidac, and a source license for SDAC, would I be able to make the fix myself, while waiting for the official release that includes the fix?
-
AndreyZ
Re: UniLoader issue with UNIQUEIDENTIFIER column
As you have only SDAC source code, you can make a fix only for SDAC. Please send your license number to andreyz*devart*com , and I will send you the fix.