how to edit through navision a file created in sql server ?

mistral

hi all ...

how can i edit through navisio 3.7 a file created in sql server ???

HalMdy

Sorry but ...

What do you mean by "file created in SQL server" ?

Waldo

and with "Edit through Navision..." ?

mistral

I have create a file manually in sql server.
I want to have access and to see and edit data via a form in navision

jm1

mistral wrote:

I have create a file manually in sql server.
I want to have access and to see and edit data via a form in navision

Just for curiousity, how did you create the file manually in sql server?

Luc_VanDyck

I guess you created a table in a SQL database without using the finsql.exe client. You can use this table in Navision, if you create a view to this table ... but don't ask me how. :roll:

Waldo

Well, It's pretty easy:

1) In SQL Server Enterprise Manager: Create you view and name it like a navision table is named: e.g. Companyname$Tablename
2) In Navision:
a. Create a table with the same fields as the view ...
b. Set the property "LinkedObject" to "Yes"

Done!

fb

Read all about it here:

Section 7.4 - "Linked Objects" in the Application Designers Guide (w1w1adg.pdf on the Product CD).

davmac1

I have done this with Views to get around Navision's sorting problem (can only sort on fields actually in Navision table).
It works well and the performance is excellent.

mistral

thanks all , it works ...

Shenpen

But you have to buy those table is licence?

I think the whole point of using SQL is to save on licence, no? I mean tables are EXPENSIVE.

IMHO

Shenpen

Actually to save on licence, I would use Access and link SQL tables into it. Acces provides a very Navision-like, and even web-enable UI very easily.