Hi All,
I am trying to insert the note data by code, as I know that this should go into Record Link table. But I don't know how to get the data for Record ID colum.
Any suggestion for this?
Thank you,
Ko
*This post is locked for comments
Hi All,
I am trying to insert the note data by code, as I know that this should go into Record Link table. But I don't know how to get the data for Record ID colum.
Any suggestion for this?
Thank you,
Ko
*This post is locked for comments
Lets say you want to add recordLink for Customer 10000
Then
Cust.GET('10000');
RecRef.GETTABLE(Cust);
RecordLink.INIT;
RecordLink."Record ID" := RecRef.RECORDID;
.....
RecordLink.INSERT;
Where Cust is record type variable Customer
RecRef is RecordRef
RecordLink is record type variable Record Link
Thank you so much for the answer Jens.
But I think I don't get what you mean, I am very new to coding with Navision. The thing I need to do is, I am writing the application that can insert the Note data directly to NAV database. So, Im need to know how Record ID colum link to the each customer in Customer table and how to convert the Customer ID into Record ID.
Best Regards,
Ko
Hi Ko,
you can AFAIK only get a RecordID from a RecordRef. So, the way would be to set a RecordRef to the record that you have with GETTABLE, and then get the RecordID from the RecordRef. I would recommend to use the RecordRef as a local variable.
with best regards
Jens
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,280 Super User 2024 Season 2
Martin Dráb 230,214 Most Valuable Professional
nmaenpaa 101,156