WD21 MSSQL Native Access Using ModFic

hi,

I have a MSSQL database in a testproject.
I can describe the MSSQL tables in my analyse.
With HCreationIfNotFound i can create the tables in my MSSQL database.

Now I want to change the name of a field.
Can I use a Windev Tool for this ?
Something like ModFic ?

Yes with sql statements....

No... the automatic modification of DB based on the analysis works ONLY for HFSQL...

You will have to code yourself some alter table sql statement...

Or, as some developers have done, code once and for all a tool using in input the sql CREATE table statements that the analysis CAN generate, compare their content to the previous version, and generate automatically the alter table...

Of course, the easiest solution is to use HFSQL :-)

Hi,

Thanks for the reply's.
I will use MSSQL Management Studio for changes.....