UniLoader issue with UNIQUEIDENTIFIER column

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
yeohray
Posts: 56
Joined: Mon 26 Mar 2007 01:25

UniLoader issue with UNIQUEIDENTIFIER column

Post by yeohray » 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.

AndreyZ

Re: UniLoader issue with UNIQUEIDENTIFIER column

Post by AndreyZ » Fri 15 Mar 2013 13:06

Thank you for the information. We have reproduced the problem and fixed it. This fix will be included in the next UniDAC version.

yeohray
Posts: 56
Joined: Mon 26 Mar 2007 01:25

Re: UniLoader issue with UNIQUEIDENTIFIER column

Post by yeohray » Fri 15 Mar 2013 14:37

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

Post by AndreyZ » Mon 18 Mar 2013 08:35

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.

Post Reply