another problem -usrw_wkfl table

[peterW]

Hi again,

I got another problemwhich accualy can be trival if u more experienced than me

I got usrw_wkfl table and i want to insert my agents ip's there. Although it inserts data, but when i wantto select them it returns only 8 characters not 12. I do it as follows

insert into usrw_wkfl(usrw_key1, usrw_key2,usrw_charfld@1,usrw_charfld@2,usrw_charfld@3) values('b2b cust','00012899','127.0.0.1','192.168.1.251','192.168.1.138');

and when i wan tto return value

select usrw_charfld@1 from usrw_wkfl

it returns ips but only first 8 characters,

Is there any sql query or a method to return full ip addres not only 8 characters?

Thanx alot for any help,

Regards
Peter

 

[Kishor Chari]

all you need to do is increase the display format.
For character value PROGRESS displays 8 characters only.

 

[peterW]

Any hint how to change this display format in Progerss?

 

[Kishor Chari]

display field_name format 'x(20)'.

But you are doing select isnt it?

 

[Kishor Chari]

Yup it applies to SQL as well.

 

[peterW]

When i state this query it returns error, what i do wrong?

select usrw_charfld@1 from usrw_wkfl where display usrw_charfld@1 format 'x(20)';

 

[Kishor Chari]

Select usrw_charfld[1] format 'x(20)' from usrw_wkfl .

.i.e first element of the Array.

 

[peterW]

ty mate , again you find to be very helpfull.

Tyvm

Peter