Dataport for Record Link table

paddypower
paddypower Member Posts: 98
edited 2010-08-19 in NAV/Navision Classic Client
Hi Everyone.

V: NAV 2009
DB: SQL

I am trying to import in to the Record Link table (20000000068) using a dataport. But I am getting an error with the Record ID field.

"The datatype RecordID is not valid for the SourceExpr"

I have some coding knowledge but this is a pain. Also I could not find any other answers to this.


Cheers

PADDYPOWER :D

Comments

  • kriki
    kriki Member, Moderator Posts: 9,132
    [Topic moved from 'NAV 2009' forum to 'NAV/Navision' forum]

    I would start trying to do a format and write that in the file and when importing, doing an EVALUATE. I didn't try it out though.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • paddypower
    paddypower Member Posts: 98
    Hi Everyone,

    I am still stuck on this issue of creating a dataport to the Record LinkID.

    Can anyone help, just as a note I am a consultant not a developer.


    Your help is greatly appreciated.

    CHEERS

    PP
  • klavin
    klavin Member Posts: 117
    I am trying to import in to the Record Link table (20000000068) using a dataport. But I am getting an error with the Record ID field.

    "The datatype RecordID is not valid for the SourceExpr"

    Is RecordID the name of your variable? This is a reserved term... try:

    vRecordID or something else.

    The field in the table is "Record ID" with a space. Without it, referencing RECORDID. 
    RECORDID
This data type contains the table number and the primary key of a table. You can store a RecordID in the database but you cannot set filters on a RecordID.
    -Lavin
    "Profanity is the one language all programmers know best."
  • marialorena
    marialorena Member Posts: 62
    Hi,

    What is the use of the Record Link table. Where is the entry point for this?

    Thanks,
  • Morilen
    Morilen Member Posts: 30
    As with the original poster I cannot add the field "Record ID" to my dataport. I am getting the same error when I try to save and compile. It says, "The Data Type RecordID is not valid for the SourceExpr." Referring to the type of data being a RecordID. Is there some kind of work around for this or can you simply not data port directly into the "Record Link" table?
  • kapamarou
    kapamarou Member Posts: 1,152
    kriki wrote:
    I would start trying to do a format and write that in the file and when importing, doing an EVALUATE. I didn't try it out though.

    Did you try this?

    Declare a variable of type TEXT.

    Instead of using RecordID use your variable as a source expression.

    Then: 
    Record Link - OnBeforeExportRecord()
MyTextVariable := FORMAT("Record Link"."Record ID");

    and 
    Record Link - OnAfterImportRecord()
EVALUATE("Record Link"."Record ID",MyTextVariable );

Categories