> Benoît Minisini ha scritto:
> > Query to Benoit ... is there a way to define 'NOT NULL' entry via
> > gambas code ?
>
> You have to define the default value. What's the point of having a
> mandatory field (NOT NULL) without a default value?
> >>>
> >>> just say i want somet
Benoît Minisini ha scritto:
>>
>
> Query to Benoit ... is there a way to define 'NOT NULL' entry via
> gambas code ?
>
You have to define the default value. What's the point of having a
mandatory field (NOT NULL) without a default value?
>>> just s
2010/2/11 Vassilis K :
> I 'll use the Gambas Mysql commands to make a table ! it works !
> The reason that I asked you is that the code for creating a Mysql table
> in Gambas is less accurate than the code of python.
no at same...
but the gambas code way allow you to change the database server
wit
> Fabien Bodard ha scritto:
> > Le 11 février 2010 15:23, Benoît Minisini
> >
> > a écrit :
> >>> sql = "CREATE TABLE Aplianikis ("
> >>> "aa BIGINT(20) NOT NULL auto_increment,"
> >>> "Eponimia VARCHAR(40) NOT NULL,"
> >>> "AFM VARCHAR(18) NOT NULL,"
> >>> "Hmerom
I 'll use the Gambas Mysql commands to make a table ! it works !
The reason that I asked you is that the code for creating a Mysql table
in Gambas is less accurate than the code of python.
--
SOLARIS 10 is the OS for Data
Fabien Bodard ha scritto:
> Le 11 février 2010 15:23, Benoît Minisini
> a écrit :
>
>>> sql = "CREATE TABLE Aplianikis ("
>>> "aa BIGINT(20) NOT NULL auto_increment,"
>>> "Eponimia VARCHAR(40) NOT NULL,"
>>> "AFM VARCHAR(18) NOT NULL,"
>>> "Hmerominia DATE NOT N
Le 11 février 2010 15:23, Benoît Minisini
a écrit :
>> sql = "CREATE TABLE Aplianikis ("
>> "aa BIGINT(20) NOT NULL auto_increment,"
>> "Eponimia VARCHAR(40) NOT NULL,"
>> "AFM VARCHAR(18) NOT NULL,"
>> "Hmerominia DATE NOT NULL,"
>> "Checkbox TINYINT(1) NO
> sql = "CREATE TABLE Aplianikis ("
> "aa BIGINT(20) NOT NULL auto_increment,"
> "Eponimia VARCHAR(40) NOT NULL,"
> "AFM VARCHAR(18) NOT NULL,"
> "Hmerominia DATE NOT NULL,"
> "Checkbox TINYINT(1) NOT NULL,"
> "primary key(aa)"
> ")"
>
sql = "CREATE TABLE Aplianikis ("
"aa BIGINT(20) NOT NULL auto_increment,"
"Eponimia VARCHAR(40) NOT NULL,"
"AFM VARCHAR(18) NOT NULL,"
"Hmerominia DATE NOT NULL,"
"Checkbox TINYINT(1) NOT NULL,"
"primary key(aa)"
")"
"DEFAULT CHARSET
I am using python because it executes the table creation commands with
the same type like in terminal mode. For example in python we write:
sql = """CREATE TABLE Aplianikis (
aa BIGINT(20) NOT NULL auto_increment,
Eponimia VARCHAR(40) NOT NULL,
AFM VARCHAR(18) NOT NULL,
Fabien Bodard ha scritto:
>
>>>
>>> I am using the following code for the creation of a table in a Mysql DB:
>>>
>>>
>>> SHELL"python
>>> /home/delphi/Documents/Apodeixi/dimiourgiaTableMYSQLmePython1.py" IF ERROR
>>> THEN
>>> Message.Error(DConv(Error.Text))
>>> ENDIF
>>>
>>> The co
and why are you using python to create your table ???
Le 11 février 2010 12:35, Benoît Minisini
a écrit :
>> Hello again,
>>
>> I am using the following code for the creation of a table in a Mysql DB:
>>
>>
>> SHELL"python
>> /home/delphi/Documents/Apodeixi/dimiourgiaTableMYSQLmePython1.py" IF E
> Hello again,
>
> I am using the following code for the creation of a table in a Mysql DB:
>
>
> SHELL"python
> /home/delphi/Documents/Apodeixi/dimiourgiaTableMYSQLmePython1.py" IF ERROR
> THEN
> Message.Error(DConv(Error.Text))
> ENDIF
>
> The command works perfectly and it cr
Hello again,
I am using the following code for the creation of a table in a Mysql DB:
SHELL"python /home/delphi/Documents/Apodeixi/dimiourgiaTableMYSQLmePython1.py"
IF ERROR THEN
Message.Error(DConv(Error.Text))
ENDIF
The command works perfectly and it creates the table.
14 matches
Mail list logo
