Who's On?

	Membership:
	Latest: Zac Shields
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5210

	People Online:
	Visitors: 488
	Members: 0
	Total: 488

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1372
Roger French	1315
mark.cook	1244

Get Field Value Desciptions via Fetch

4 Replies

0 Subscribed to this topic

17 Subscribed to this forum

Sort:

Author

Messages

Woozy

Veteran Member

Posts: 709

11/25/2013 4:18 PM

I have a table that includes a "status" field that has a value list with translations defined in dbdef (i.e 0=Entered, 1=Submitted, etc). If I do a fetch against that table, are the field translations returned as well as the field value?

For example, if my table is ZZTEST with prefix ZZZ, I can do an 840-FIND-ZZZSET1. Once I do this, I will be able to do a "MOVE ZZZ-STATUS TO whatever". Is there a way for me to move the translation value as well?

I know I can do this on a screen using key numbers, but I want to be able to push the status into another field. Any thoughts on how I can do this without re-defining the translations in my code?

Thanks!

Kelly

jaherb

Veteran Member

Posts: 164

11/25/2013 9:01 PM

I don't think you can get to that info directly, Kelly... If you paint a new report that has translation values you can paint the translations into the report by simply repainting the field again. However all this will do is provide a translation field such as you see with your on-line forms. What this does is supply the db translation values in your .rpt. You could then grab the translation value from your report and move it elsewhere. This would not be a "dynamic" approach in the case if you added new translations, however.

Woozy

Veteran Member

Posts: 709

11/25/2013 10:14 PM

Drat! Thanks Jim. I figured that was the case, but I though maybe there was a trick I didn't know about. I can manually add them to the code, but I was being lazy. It seemed reasonable that if they were defined in DBDEF, then a fetch should be able to return them as well. Oh well!

Thanks for the reply!

Kelly

jaherb

Veteran Member

Posts: 164

11/26/2013 6:00 PM

Have a great Thanksgiving Holiday, Kelly

Woozy

Veteran Member

Posts: 709

11/26/2013 6:08 PM

Thanks Jim - You too!