|
kibln8 Beginner
Joined: 05 Sep 2005 Posts: 11
|
Posted: Fri Oct 05, 2007 7:11 pm
query question |
how do you get the value from a specific record.. I have the record id number but I need to access a specific value within that record to check if it has a value or not.
Thanks in advance! :) |
|
|
|
Vijilante SubAdmin
Joined: 18 Nov 2001 Posts: 5182
|
Posted: Fri Oct 05, 2007 7:31 pm |
If you use #DBGET it will put the information into the predefined variable %rec. You can then examine all the values with %rec.field or %db(%rec,field). Also if your record number is from a %query or %find meaning it has a value of (2 letter DB ID and number) pe123 then you can use that directly in the %db function.
|
|
_________________ The only good questions are the ones we have never answered before.
Search the Forums |
|
|
|
|
|