Browse by Tags

SQL script

Hi there! I am trying to build a reporting Excel spreadsheet using VB and SQL. While trying to query info from a table using SQL script, I can see some field names such as GL Posting Code. Normally such fields are created using the underscore like GL_Posting_Code. In Navision the fields do not have the...

Posted to NAV / Navision - Developers Forum (Forum) by benjos on 11-13-2008
Inserting Views

Will the DB performance be affected by inserted views? And how about data-manipulation? Will the MS SQL Server (2005) automatically adjust/update the VSIFTs if I insert data manually through a sql-queries? Somebody told me to use the C/ODBC-driver instead but if I got it right it's just for the native...

Posted to NAV / Navision - Microsoft SQL Server (Forum) by TUNIX on 10-30-2008
Error - Cannot create more than one clustered index on table

This post describes one scenario in which this error occurs. There may be others. In the late 4.0 versions of the NAV executables, all tables in NAV had a clustered index created on SQL for the primary key (Index 0). However, the table objects in 4.0 versions did not have the Clustered property set on...

Posted to NAV Developers Blog (Weblog) by Anonymous on 10-17-2008
The NAV/SQL Performance Field Guide - 3rd Edition

While struggling with NAV/SQL performance issues for many years I scribbled down countless pages about various issues, learned by own experience or from colleagues, taken from numerous knowledgebase articles, whitepapers, etc. or heard in several webcasts. In 2006 I started to put all this into a structured...

Posted to Dynamics NAV Performance on SQL - My Two Cents (Weblog) by Jörg A. Stryk on 10-04-2008
List of released updates for SQL Server 2005 SP2

The link below lists build numbers, KB numbers and links to cumulative updates updates 1 to 9 for SQL Server 2005: List of build numbers and cumulative updates 1-9 for SQL Server 2005 Also see this post for relevance of SQL Updates to Microsoft Dynamics NAV: Overview of updates for SQL Server 2005 SP2...

Posted to NAV Developers Blog (Weblog) by Anonymous on 09-23-2008
Query HAVING clausule in AX

Hi, How can I add HAVING clausule to query in AX? I build query by QueryBuildDataSource by adding additional suming and grouping steatments but I need to filter resoult by checking value of sum. I make CustTransSplit table that splits custTrans record by goup of iitems, I want too check if values are...

Posted to AX / Axapta - Developer Forum (Forum) by rudiwu on 09-12-2008
Navision on SQL - What doors does this open?

OK, over the last couple of weeks I have been asked, more than once, 'so if I go to SQL, what can I do, that I can't do on Native'? I started to ponder on this, did a bunch of searching, but couldn't find a definitive list. I thought I would get your thoughts on this and put my two cents...

Posted to NAV / Navision - Microsoft SQL Server (Forum) by dbezzant on 07-31-2008
Having a problem with ODBC

Has anybody seen anything like this... Message: ERROR [42000] [Simba][SimbaEngine ODBC Driver]SELECT * FROM << ??? >>[G_L Account] ERROR [42000] [Simba][SimbaEngine ODBC Driver]Syntax Error.]]> It looks like the [dbo] context is missing. We have upgraded to the latest SP's for Nav...

Posted to NAV / Navision - Beginners Forum (Forum) by BobbyBoy on 07-11-2008
Sr. Dynamics GP Position - up to $105k in Los Angeles, CA USA

Excellent opportunity to lead the support of Financial systems within a well-known global entertainment company in the San Fernando Valley, California, USA. Systems include: Dynamics GP 9 FRx Hyperion Excellent compensation (up to $105k) and benefits package for the right candidate, depending on experience...

Posted to Jobs Offered (Forum) by pvit1 on 06-12-2008
Table filter best practice?

Hello, I was taught that when filtering a table (for instance 39 - "Purchase Line"), one should follow a certain sequence. Imagine that you need to filter 39 "Purchase Line" by fields "Document Type" and "Document No." to get to the range of lines of an invoice...

Posted to NAV / Navision - Developers Forum (Forum) by Pedro Pelicano on 05-26-2008

Page 1 of 8 (74 items) 1 2 3 4 5 Next > ... Last »