Programming Temporary Tables Problem: Fill data into table

AliBomber
Member Posts: 13
Hi,
I tried to create a temporary table, by using records, like recommended in the developers guide. No I have the following problem:
evertime I try to insert some date into a table, e.g. automatic by function, only the last value filled in is visible. Looks like the other values haven't been inserted. Has anyone an example, how to solve my problem or can help me ??
Thank You...
I tried to create a temporary table, by using records, like recommended in the developers guide. No I have the following problem:
evertime I try to insert some date into a table, e.g. automatic by function, only the last value filled in is visible. Looks like the other values haven't been inserted. Has anyone an example, how to solve my problem or can help me ??
Thank You...
0
Comments
-
You will have to supply some of your code, if you expect to get any help.
Possible causes:
- Didn't fill the primary key fields.
- Set a filter.
- ...
but I'm just guessing...0 -
Even though you can create a record type variable and set it to temporary, you still have to treat it in code as if it were a regular table, so you must do INSERT and MODIFY and everything else. The variable and its values will only be destroyed as soon as the codeunit/form/etc. is closed. If you want to copy records from your temp table into your database, you must have another record type variable and copy the records from your temp one into the regular one.
HTH0
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