开发者

Update Array field in progress DB using ODBC

开发者 https://www.devze.com 2022-12-12 11:44 出处:网络
I access the progress DB using ODBC in my C# program, and I need to update some fields,which are array data type.

I access the progress DB using ODBC in my C# program, and I need to update some fields,which are array data type. so how can I write my sql statement to do such thing开发者_开发问答s?

I read some progress documentations,in which some methods were mentioned as bellow: update pub.sometable set arrayfield='X;X;X;X;X;X' where condition.... but it only works on the unsubscripted array.well,another problem,what's the difference between unsubscripted arrays and subscripted ones?

Any ideas?


I believe that you need to write the table & field name like so

   "table"."field"[1]
0

精彩评论

暂无评论...
验证码 换一张
取 消