data insertion in table

mdsr
Member Posts: 163
Hello experts,
I have scenario like i have custom page on page i have action on click of that action data from page is store in table .for that i have created table QC test Result.
In action added code
thanks in advance
I have scenario like i have custom page on page i have action on click of that action data from page is store in table .for that i have created table QC test Result.
In action added code
QCTestResult1.INIT; QCTestResult1."Test Certificate No":="Test Certificate No"; QCTestResult1."GRN No.":="GRN No."; QCTestResult1."Line No.":="Line No."; QCTestResult1."Item No.":="Item No."; QCTestResult1."Parameter Code":="Parameter Code"; QCTestResult1."Test Method Code":="Test Method Code"; QCTestResult1."Parameter Name":="Parameter Name"; QCTestResult1."Test Method Name":="Test Method Name"; QCTestResult1.Specification:=Specification; QCTestResult1.Result:=Result; QCTestResult1.Approved:=Approved; QCTestResult1.Rejected:=Rejected; QCTestResult1.INSERT(TRUE);[code]where QCTestResult is record variable of that table in which data want to store of page.problem is that one one line data pull not multiple line of page how we can get all lines from page into table.
thanks in advance
0
Answers
-
Still the question is not clear but what i understood is you want to insert the entire records of the page into some custom table, that's something you want??
Where is Repeat Until then?
All table columns are same?Thanks
Blog - rockwithnav.wordpress.com/
Twitter - https://twitter.com/RockwithNav
Facebook - https://facebook.com/rockwithnav/0 -
@RockWithNAV I have added repeat ..until bu still it not gives me all records of line
IF PurchaseQCTestResult.FindFirst THEN BEGIN REPEAT QCTestResult1.INIT; QCTestResult1."Test Certificate No":="Test Certificate No"; QCTestResult1."GRN No.":="GRN No."; QCTestResult1."Line No.":="Line No."; QCTestResult1."Item No.":="Item No."; QCTestResult1."Parameter Code":="Parameter Code"; QCTestResult1."Test Method Code":="Test Method Code"; QCTestResult1."Parameter Name":="Parameter Name"; QCTestResult1."Test Method Name":="Test Method Name"; QCTestResult1.Specification:=Specification; QCTestResult1.Result:=Result; QCTestResult1.Approved:=Approved; QCTestResult1.Rejected:=Rejected; QCTestResult1.INSERT(TRUE); UNTIL PurchaseQCTestResult.NEXT=0; END;
table have same column as pages0 -
You repeatedly add the same record into the table (or maybe no record at all, if PurchaseQCTestResult has no records at all. I would suggest to use the debugger, or add a message in your loop to check if the code is excuted at all.IF User.Loves('Edo') THEN ok() ELSE currReport.genSkip;0
-
Your question is entirely unclear.
What type of page do you have?
Do you have a repeater on that page, or how else is the data on your page relevant to more than one record to be modified?
Does your page have SourceTableTemporary=Yes?
Maybe tell us more about your use case and how you intended to go about it.0 -
Hi vaprog,let me explain:
i have created one table (QC Test Result) in which i have to store data came from page.i have added same field in table.
i have created custom page .page having action (approved)on click of action data from page shown have to transfer to table.
if i used code without repeater it will send data but only single line from page.
if i used repeat..untill then it not sending data at all.
now i want send all lines from page to table.
0
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