Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 266 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
What to do by creating new tables or expanding tables?
Daniel
Member Posts: 5
I'm thinking about creating or expanding tables in navision database. For example, I'd like to add a new field 'Has animals' in the table contact or creat a new table 'animal'.
a) In which navision objects have I to implement code, so that I get the static informations in the SQL table and datas in the existing WebPortal.
b) Will it be generated automatically? Of course would be nice ;-).
c) Do I have to add code in the ASP pages?
I already have the hole system (CS 2002, SQL 2000, SP etc.) installed.
Could somebody give me some inputs or are there specific documents to get this informations?
Thanks to all for helping
Dani
a) In which navision objects have I to implement code, so that I get the static informations in the SQL table and datas in the existing WebPortal.
b) Will it be generated automatically? Of course would be nice ;-).
c) Do I have to add code in the ASP pages?
I already have the hole system (CS 2002, SQL 2000, SP etc.) installed.
Could somebody give me some inputs or are there specific documents to get this informations?
Thanks to all for helping
Dani
0
Comments
to your questions:
a) In which navision objects have I to implement code, so that I get the static informations in the SQL table and datas in the existing WebPortal.
This is done in various objects. You have to modify at least the Synch codeunit. When you want the data send back to navision than it depends on the function.
b) Will it be generated automatically? Of course would be nice .
No :-(
c) Do I have to add code in the ASP pages?
That depends on the things you want to do. But in fact yes, because if you wont need the data for displaying or calculating issues you wouldnt synch them ;-)
A good overview could be found in the training materials, but if you have to do the work for a project i would recommend to get in contact with a partner that has enough knowledge in programming portals. Because CP is not as easy as "normal" navision programming.
HTH,
IHateLinux