How can i compile the table through coding in navision 2013 r2
You have to run finsql.exe with some parameters to do that:
In previous versions this can be done using SHELL command, but this command is obsolete in RTC client... you can create a DotNet variable (runonclient=true), System.Diagnostics.Process, this DotNet can run a command line. In Saurav Blog, you have an example on how to use it:
You don't have to change anything there, you only have to change your values in the following vars: FinSQLPath := '"C:\Program Files (x86)\Microsoft Dynamics NAV\110\RoleTailored Client\finsql.exe"'; ServerName := '"my_sql_server_name"'; DatabaseName := '"my_sql_database_name"'; Filter := '"Type=Table;ID=50500"';
I only had a problem compiling table the first time. I had to compile table manually, but after that, the table was compiled correctly.
Not working...My navision get closed and i have to compile tthe table from development by pressing F11
Can you execute the command directly in windows command prompt (CMD), and observe if some error is displayed?
In Command prompt How ??
Please, remove the first double quote, the one previous finsql.exe, and run command again.
No Error is showing.
Maybe you should lean a little basic command prompt syntax before starting this! That you strings and "" are important and used wrongly.
ok. Thank You