hi, all friends, how can i run sql script to get the table's data or update data to sql database

Business Central/NAV Developers Forum
1

hi, i am useing nav2009, if i can run sql script to get the table’s data , or update data to database.

waiting for you sugesst.

Regards!

2

Yes, you can get the data or update the data using sql scripts…

google sql commands like SELECT and UPDATE…

you will get the information…

All the Best…

3

Hi,

I strongly recommend that you do not update any information if Nav from SQL as it does use the Nav validation and you may put you data out of sync.

4

thanks for all the suggest,

but i’m meaning to use the sql script in navision codeunit.

are you sure it is possible that execute the sql script in navision codeunit for get or update table’s data, how?

5

Hi,

basically you could accomplish that with using MS ADO. Check this one out:
http://dynamicsuser.net/blogs/waldo/archive/2008/01/06/using-stored-procedures-in-c-side.aspx

According to that I reccommend to follow this thread, too: http://www.mibuso.com/forum/viewtopic.php?f=23&t=45994