Problems copying one record to another table

jCarter
Member Posts: 3
greetings and thanks for looking....
what i am trying to do is populate a new table(newTable) based upon a filter put on another table(masterTable)...heres my code
masterTable.setRange(parentFlag, true);
IF masterTable.FIND('-') THEN
REPEAT
newTable.COPY(masterTable);
UNTIL masterTable.NEXT = 0;
when i run this i get the following error:
"Copying all filters at once can only be done between records belonging to the same table."
"Table: newTable<--masterTable"
"Copy the necessary filters one at a time"
i have tried to use COPYFILTER and COPYFILTERS to get rid of this error but to this time have had no luck...can anyone help me with what could possibly be going on...i am clueless since the help file on COPY states the following:
COPY: Use this function to copy a record from a C/SIDE table. All filters, marks, and keys are included in the copy.
SYNTAX: Record.COPY(FromRecord)
Record Data type: record
The record where the copy should be placed.
FromRecord Data type: record
The record you want to make a copy of.
what i am trying to do is populate a new table(newTable) based upon a filter put on another table(masterTable)...heres my code
masterTable.setRange(parentFlag, true);
IF masterTable.FIND('-') THEN
REPEAT
newTable.COPY(masterTable);
UNTIL masterTable.NEXT = 0;
when i run this i get the following error:
"Copying all filters at once can only be done between records belonging to the same table."
"Table: newTable<--masterTable"
"Copy the necessary filters one at a time"
i have tried to use COPYFILTER and COPYFILTERS to get rid of this error but to this time have had no luck...can anyone help me with what could possibly be going on...i am clueless since the help file on COPY states the following:
COPY: Use this function to copy a record from a C/SIDE table. All filters, marks, and keys are included in the copy.
SYNTAX: Record.COPY(FromRecord)
Record Data type: record
The record where the copy should be placed.
FromRecord Data type: record
The record you want to make a copy of.
0
Comments
-
Take a look at the TRANSFERFIELDS command, it will do the trick for you. Remember to INSERT.
/Soren0
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