English 中文(简体)
我如何从.NET的U2工具包获取多价数据?
原标题:How do I access MultiValue data from U2 Toolkit for .NET?

尝试从 U2 数据文件中选择 * 时, 我收到以下消息 。

[U2][UCINET][UNIDATA]:Multi-value or multi-subvalue are not supported in this version "

如果我只选择一个字段,我得不到错误,是否有一个版本无法获取此错误 。

最佳回答

您需要在 U2ConnectryStringBilder 类中设置属性“ 第一游牧形式=false ” 。 例如 :

            U2ConnectionStringBuilder conn_str = new U2ConnectionStringBuilder();
            conn_str.UserID = "user";
            conn_str.Password = "pass";
            conn_str.Server = "localhost";
            conn_str.Database = "XDEMO";
            conn_str.ServerType = "UNIVERSE";
            conn_str.FirstNormalForm = false;

            U2Connection con = new U2Connection();
            con.ConnectionString = conn_str.ToString();
            con.Open();
            .......

For UniVerse Database: SQL Statement : SELECT FNAME,PRICE,BUY_DATE FROM UNNEST CUSTOMER ON ORDERS (PRICE and BUY_DATE are multi-valued attributes)

For UniData Database: SQL Statement : SELECT * FROM STUDENT UNNEST NL_ALL CGA (FNAME,...,SEMESTER are multi-valued attributes)

问题回答

暂无回答




相关问题
Manually implementing high performance algorithms in .NET

As a learning experience I recently tried implementing Quicksort with 3 way partitioning in C#. Apart from needing to add an extra range check on the left/right variables before the recursive call, ...

Anyone feel like passing it forward?

I m the only developer in my company, and am getting along well as an autodidact, but I know I m missing out on the education one gets from working with and having code reviewed by more senior devs. ...

How do I compare two decimals to 10 decimal places?

I m using decimal type (.net), and I want to see if two numbers are equal. But I only want to be accurate to 10 decimal places. For example take these three numbers. I want them all to be equal. 0....

Exception practices when creating a SynchronizationContext?

I m creating an STA version of the SynchronizationContext for use in Windows Workflow 4.0. I m wondering what to do about exceptions when Post-ing callbacks. The SynchronizationContext can be used ...

Show running instance in single instance application

I am building an application with C#. I managed to turn this into a single instance application by checking if the same process is already running. Process[] pname = Process.GetProcessesByName("...

How to combine DataTrigger and EventTrigger?

NOTE I have asked the related question (with an accepted answer): How to combine DataTrigger and Trigger? I think I need to combine an EventTrigger and a DataTrigger to achieve what I m after: when ...

热门标签