-
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...
-
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...
-
use variant data type variable to cast type: var_variant := adoConnection; cmd.ActiveConnection := var_variant; cmd.CommandText := 'Select * ....'; cmd.Execute();
-
What method are you using to get the records back into SQL? ADORecordSet.Addnew, Innsert Into or something else?