Discussions
Activity
Best Of...
Sign In
·
Register
Home
›
Navision Financials
Howdy, Stranger!
It looks like you're new here. Sign in or register to get started.
Sign In
Register
Quick Links
Categories
Recent Discussions
Activity
Best Of...
Unanswered
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
115
Navision DOS
854
Navision e-Commerce
1K
NAV Tips & Tricks
772
NAV Dutch speaking only
615
NAV Courses, Exams & Certification
2K
Microsoft Dynamics-Other
1.5K
Dynamics AX
305
Dynamics CRM
109
Dynamics GP
10
Dynamics SL
1.5K
Other
993
SQL General
384
SQL Performance
34
SQL Tips & Tricks
34
Design Patterns (General & Best Practices)
Architectural Patterns
10
Design Patterns
5
Implementation Patterns
53
3rd Party Products, Services & Events
1.7K
General
1.1K
General Chat
1.6K
Website
79
Testing
1.2K
Download section
23
How Tos section
260
Feedback
12
NAV TechDays 2013 Sessions
13
NAV TechDays 2012 Sessions
Object export
SimonW
Member
Posts:
77
2000-02-11
edited 2000-02-17
in
Navision Financials
Does anyone know of any other way of accessing the object export dialog other than by having the Object Designer loaded?
0
Comments
db
Member
Posts:
82
2000-02-11
If you need accsses fdb objects, there are simple rec with BLOB's, feel free work with them.
If you need to export/import them, not using standart dialogs, create own format of export file.
0
SimonW
Member
Posts:
77
2000-02-16
I don't seem to be able to create a dataport with 'blob' field types in it.
Would I need to use a C/Front or ODBC connect to extract this data?
0
ohlfsen
Member
Posts:
5
2000-02-17
This codeunit (in exported text-format) exports form 21 and imports it back again as form 80003.
Don't know is this is a recommendable way to go about things, but it seems to work.
OBJECT Codeunit 81000 im/export objekt
{
OBJECT-PROPERTIES
{
Date=16-02-00;
Time=19:22:43;
Modified=Yes;
Version List=;
}
PROPERTIES
{
OnRun=BEGIN
WITH BlobRec DO BEGIN
GET(BlobRec.Type::Form,'',21);
CALCFIELDS("BLOB Reference");
"BLOB Reference".EXPORT('c:\form21.bin');
INIT;
ID:=80003;
Type:=BlobRec.Type::Form;
Name:='TestForm';
"BLOB Reference".IMPORT('c:\form21.bin');
Date:=TODAY;
END;
BlobRec.Time:=TIME;
BlobRec.INSERT;
END;
}
CODE
{
VAR
BlobRec : Record 2000000001;
ok : Boolean;
BEGIN
END.
}
}
Best regards
Allan Ohlfsen [/i}
Best regards
Allan Ohlfsen
0
Sign In
or
Register
to comment.
Comments
If you need to export/import them, not using standart dialogs, create own format of export file.
Would I need to use a C/Front or ODBC connect to extract this data?
Don't know is this is a recommendable way to go about things, but it seems to work.
OBJECT Codeunit 81000 im/export objekt
{
OBJECT-PROPERTIES
{
Date=16-02-00;
Time=19:22:43;
Modified=Yes;
Version List=;
}
PROPERTIES
{
OnRun=BEGIN
WITH BlobRec DO BEGIN
GET(BlobRec.Type::Form,'',21);
CALCFIELDS("BLOB Reference");
"BLOB Reference".EXPORT('c:\form21.bin');
INIT;
ID:=80003;
Type:=BlobRec.Type::Form;
Name:='TestForm';
"BLOB Reference".IMPORT('c:\form21.bin');
Date:=TODAY;
END;
BlobRec.Time:=TIME;
BlobRec.INSERT;
END;
}
CODE
{
VAR
BlobRec : Record 2000000001;
ok : Boolean;
BEGIN
END.
}
}
Best regards
Allan Ohlfsen [/i}
Allan Ohlfsen