The next NAV

ta5

I know I know, NAV 2009 has just been released, but we hear quite a lot of questions about the future developments.
Last but not least customers try to figure out whether they should upgrade now or better should skip one version, actually the same as in the situation of migrating to vista or not.

So the question:
Is there already the next NAV on the road map? If yes, whats the schedule and is there already any detail available?
Basically I know the rumours and the ideas what the next NAV could be, but I'm looking for a "official" statement.

Cheers
Thomas

ara3n

you won't find the official statement here on mibuso. Just rumors.
As far should they upgrade now or later. Every business needs to make a decision if the cost is worth the ROI.

garak

For me i wish a C/AL function to say the SQL Server: Hy doesn't use "select * from " use select MyNeededField from.

like

MyTable.setfilter(MyField,'%1|%2',FilterCriteria1,FilterCriteria2);
//The NEW C/AL FUNCTION
MyTable.RetriveTheseFields(MyField);//one ore more fields
if MyTable.findset(false,false) then begin
  repeat
    //here we do something
  until next = 0;
end;

This should execute a sql query like this:

select "MyField" from MyTable
  where MyField = 'FilterCriteria1' or 'FilterCriteria2'
    order by SetCurrentKeyField

So the sql server doesn't must retrieve the whole rec (*)
Some other functions like this are also welcome ....

ara3n

I would like to use linq like functionality in NAV.

query  := from Customer, "Sales Header" 
           join "Sales Header" on Customer."No." = "Sales Header"."sell-to Customer No." and 
                    "Sales Header"."Document type" = "Sales Header"."Document type"::Order
            select (Customer.Name, "Sales Header"."No.");

It should be read only.

garak

oh yes the join ... ah ... i miss it .....

David_Singleton

garak wrote:

For me i wish a C/AL function to say the SQL Server: Hy doesn't use "select * from " use select MyNeededField from.

...

So the sql server doesn't must retrieve the whole rec (*)
Some other functions like this are also welcome ....

You mean something like this:

Select * FROM and how to do it better in NAV

garak

David Singleton wrote:

garak wrote:

For me i wish a C/AL function to say the SQL Server: Hy doesn't use "select * from " use select MyNeededField from.

...

So the sql server doesn't must retrieve the whole rec (*)
Some other functions like this are also welcome ....

You mean something like this:

Select * FROM and how to do it better in NAV

Yes. It's absolutly the same what i mean ......
Did you got some feedback from a MS developer in DK for this issue?

http://dynamicsuser.net/blogs/singleton ... ltant.aspx

The Homer ..... i like this guy ...

Regards

ta5

Anyway, isn't it strange to have no official roadmap for NAV? :shock:

ara3n

The roadmap is pretty clear. Moving from 2 tier to 3 tier. Moving from classic client to RT client.
Also there is a roadmap documents in partnersource.

https://mbs.microsoft.com/partnersource ... page=false

https://mbs.microsoft.com/partnersource ... page=false

ta5

Thanks Rashed, thats ok for me. I thought there would be newer documents but in this case I'll use the ones you gave me the link to.
Regards
Thomas

David_Singleton

garak wrote:

Did you got some feedback from a MS developer in DK for this issue?

Yes.

generic

David Singleton wrote:

garak wrote:

Did you got some feedback from a MS developer in DK for this issue?

Yes.

My guess the response was. "Thanks, but NO thanks."

I wouldn't introduce any C/AL functionality, since it has to be translated into C#. That adds so much more complexity. I don't think anything new will be introduces until classic client is discontinued.

davmac1

I would like to see adoption of vardecimal. Maybe they could cut a deal with the SQL Server group to make it available in Standard runtime

DenSter

davmac1 wrote:

I would like to see adoption of vardecimal. Maybe they could cut a deal with the SQL Server group to make it available in Standard runtime

Synchronize data types with the DBMS... now there's a novel idea :-k

David_Singleton

generic wrote:

David Singleton wrote:

garak wrote:

Did you got some feedback from a MS developer in DK for this issue?

Yes.

My guess the response was. "Thanks, but NO thanks."

No the response was very positive. I can't say much more due to NDA restrictions.

I was quite surprised to see just how much notice MS people take of Blogs.

garak

David Singleton wrote:

No the response was very positive. I can't say much more due to NDA restrictions.

I was quite surprised to see just how much notice MS people take of Blogs.

good to know ;-)