Progress "extend fields" via JDBC

[andrew_simi]

I can't get into extend field from DbVisualiser. I use JDBC driver.

Field PUB."adres" in Progress is an array composed with 4 field in character types. In procedure editor I get o this field like below:

find first customer where adres[1] = "....".

or

disp adres.

(which gives me 4 fields together)

SQL Commander stops when I execute query:

select "nr-cust","adres" from PUB."customer";

I dont know how can I get to this field. Please help.

 

[tamhas]

It's been a while, but check the SQL reference ... I think it is called PRO-ELEMENT, i.e., PRO-ELEMENT(fieldname, 1) or something like that to get the first element in the extent.

 

[andrew_simi]

PRO_ELEMENT("adres",1,1)

- it's working. Great thanks.

by the way

select adres from customer;

works as well, but before I had exception :

 [DataDirect][OpenEdge JDBC Driver]Transliteration failed, reason: invalid UTF8 data

- something wrong whith text coding.

 

[DevTeam]

PRO_ELEMENT("adres",1,1)

- it's working. Great thanks.

by the way

select adres from customer;

works as well, but before I had exception :

 [DataDirect][OpenEdge JDBC Driver]Transliteration failed, reason: invalid UTF8 data

- something wrong whith text coding.

Yes, we get the UTF8 error too, I think that's when the array-field value contains accented character

 

[Casper]

works as well, but before I had exception :

[DataDirect][OpenEdge JDBC Driver]Transliteration failed, reason: invalid UTF8 data
- something wrong whith text coding.

fixed in 10.1B01:
http://progress.atgnow.com/esprogress/Group.jsp?bgroup=progress&id=P120274

Casper.

 

[andrew_simi]

ok, fine - issue is solved. Thanks.

I found that character "Ś" (one of the field value) was making this problem in my situation. After change to "S" both selects are working.