Need help for reading the value of a fieldref

katerina
Member Posts: 4
Hi. I use Navision 3.70 and I have the following problem.
fref --> fieldref
ref --> RecordRef
Here's the code of a function of a codeunit. The function's arguments as
tableno and position.
ref_mod(tableno : Integer;position : Text [250])
ref.OPEN(tableno);
ref.SETPOSITION(position);
fref := ref.FIELD(1);
message(format(fref.value));
Here's the deal: if the field is the primary key,is shows its value. If it is any other field it shows its initial value ('' for string, 0 for option etc). I can't get the real value of the specific record. :evil:
Does anyone know why this happens? How can I get the real value?
PS. Here's a usual call of ref_mod :
ref_mod(9,'Code=const(ES)');
PS2. Thanks for reading this.
fref --> fieldref
ref --> RecordRef
Here's the code of a function of a codeunit. The function's arguments as
tableno and position.
ref_mod(tableno : Integer;position : Text [250])
ref.OPEN(tableno);
ref.SETPOSITION(position);
fref := ref.FIELD(1);
message(format(fref.value));
Here's the deal: if the field is the primary key,is shows its value. If it is any other field it shows its initial value ('' for string, 0 for option etc). I can't get the real value of the specific record. :evil:
Does anyone know why this happens? How can I get the real value?
PS. Here's a usual call of ref_mod :
ref_mod(9,'Code=const(ES)');
PS2. Thanks for reading this.
0
Comments
-
Hi,
Try using ref.FIND after your ref.SETPOSITION.
According to the help SETPOSITION only sets the values of the primary key and does not actually get any info out of the DB.
Hope it worksThis isn't a signature, I type this at the bottom of every message0 -
-
Glad to hear it!!This isn't a signature, I type this at the bottom of every message0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions