Dataport for Record Link table

paddypower

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

kriki

[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.

paddypower

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

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.

marialorena

Hi,

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

Thanks,

Morilen

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

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 );