-
Hi, Do anybody have an idea about retrieving value of an option field while accessing Navision Database using N/ODBC. When we query NAV database via ODBC connection, the option field returns integer values (its true that option field stores integer value in the database). If there is any method to get...
-
I am using JetReports to generate most of my reports. For some of them, I am also using VBA and ADO to get the result directly from SQL Server 2005 database and import it into Excel . The problem I have been having with the latter is that if I need to get the value of a field that has DateFormula (1W...
-
Use CAST and CONVERT to format the datatime field for Navision EXAMPLE: CAST(''1754-01-01 ''+CONVERT(CHAR(8), [StartTime], 108) AS DATETIME) Where StartTime is the SQL datetime field. This will set the date to 01/01/1754 and display time as hh:mm:ss
-
Imcurrently working on a project to integrate a mobile solution to Navision. We have decided on a stagin table route directly into the underlying SQL database. I an currently having an issue with the Nav Time field, which is seen as datetime on the sql server table. This issue i have is using sql insert...
-
I am working in 3.70B SQL 2000, with no support contract, so no option of moving to 4.00 executables They client has asked for advise on the best way to both export and import XML files. I would like opinions about what people felt most comfortable with: Batch routine that uses code to create the XML...
-
Hi! Well, there are basically two options I ould like to propose for your purposes: 1) Linked Object To have a real "lookup" - means opening a form which is displaying a list records - on an external table, you could create a View within the NAV database, querying the required data from the...
-
Hi, Sorry took so long to get back to you went on a last minute trip. RecordsAffected := 0; // Command Option Values: // adCmdFile : 256 = Evaluate as a previously persisted file // adCmdStoredProc : 4 = Evaluate as a stored procedure // adCmdTable : 2 = Have the provider generate a SQL query and return...
-
Hi, I have a set of Navision Objects that query the SQL system to get the DBCC Showcontig details into a newly created "Table" in sql server. So the code creates a table in SQL, populates it with the DBCC Showcontig details, uses that to do a DBCC Reindex etc.. then deletes it. If that sounds...
-
I am writing from Navision to a SQL Database using ADO 2.8. I can do this using ADOConnection.Execute but would like to do this using ADOCommand.Execute. Does anyone know how to instantiate the command object? By the way ADOCommand.ActiveConnection := ADOConn.State; does not work. Also what is the fastest...
-
Chaps, Ive found it. After trying ADO.COMMAND, ADO.PARAMETER etc I still had the same results. So this led me to thinking "it's the stored procedures at fault".... SET NOCOUNT ON must be called at the beginning of the procedure and SET NOCOUNT OFF at the end of the procedure. This has an...