Welcome! Log In Create A New Profile

Advanced

WD21 MSSQL Native Access

Posted by Nick 
Forum List Message List New Topic
Nick
WD21 MSSQL Native Access
October 02, 2020 04:35PM
Hi,

I want to use MSSQL as database for a new project.
I have a connection with the database and I created a table in the Windev 21 Data Model editor.

How can i create the table in the MSSQL database.
I asume that I can not use HcreationIfNotFound(Table_name)

So my questionL How to create the table in the MSSQL database ?
Reply Quote
Nick
Re: WD21 MSSQL Native Access
October 02, 2020 04:42PM
Solved.
i can use Hcreationifnotfounf.
I had to synchronise the analyse with the project...
Reply Quote
pao
Re: WD21 MSSQL Native Access
October 02, 2020 05:46PM
In this case the only thing you don't have is the automatic data modification and the constraints.
If you change the definition of the table in the analisys you have to change the definition manually in the MSSQL or make some programming to do that.
If you want the constraints created in the MSSQL you must create them mannully or by programming.

Just the first tip, try to use queries as much as you can instead of HREAD *. You can use the HREAD* functions but the performance isn't the same.

Regards

Paulo Oliveira



Edited 1 time(s). Last edit at 10/06/2020 10:52AM by pao.
Reply Quote
Newer Topic Older Topic
Author:

Your Email:


Subject:
Spam prevention:
Please, enter the code that you see below in the input field. This is for blocking bots that try to post this form automatically. If the code is hard to read, then just try to guess it right. If you enter the wrong code, a new image is created and you get another chance to enter it right.
Message: