Welcome! Log In Create A New Profile

Advanced

Create new MySql database from WinDev

Posted by SUN 
Forum List Message List New Topic
SUN
Create new MySql database from WinDev
June 15, 2009 11:35AM
Is it possible to create a new mysql database from Windev (native access),with
HF H Commands or SQL .
I tried to insert a new record in information_schema database i table who holsd
information about databases,but the database says that i do not have sufficient
rigths to do that.


Reply Quote
issah
Re: Create new MySql database from WinDev
June 15, 2009 12:11PM
HexecuteSQLQuery(viewname, myconnection, hquerydefault+hquerywithoutcorrection, 'create database newdb')

Cant vouch for the spelling and exact syntax but this should do it once you are connected to the database. You should of course have the necessary rights.

Regards

issah
Reply Quote
SUN
Re: Create new MySql database from WinDev
June 16, 2009 01:14AM
Thanks, the problem was in the option hquerywithoutcorrection,i have omitted this
option. Now it works.
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: