Column "...." cannot be null

Forum related to MySQL

Moderators: gto, cipto_kh, EgonHugeist

Post Reply
MYSQL889
Fresh Boarder
Fresh Boarder
Posts: 16
Joined: 16.06.2008, 23:04

Column "...." cannot be null

Post by MYSQL889 »

Hello friends,

I'm working with Mysql, using Zeos 6.6.2 RC and there is a problem with the fields Not Null and value Default.

As an example, this table:

Code: Select all

Create table `Articles` (
     `Code` varchar (40),
     `` Varchar Article (60),
     `` COLOR varchar (30) NOT NULL default''
     primary key ( `` Code)
) Type = InnoDB;
If I make a direct integration with SQL code, as follows:

Code: Select all

SQL Code [-]

INSERT INTO `articles` ( `Code`
)
Value ('123 '
)
all goes well, the server is responsible automatically fill in the fields Not Nul with a vacuum'':

However, if I upgrade through a DBGrid using a TZQuery.Insert ..... TZquery.Post and is blank, for example, the color field, you get the error: Column "Color" can not be null - Do not Zeos assigns the default to the field?

Thank you,

Sebas.
User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Post by mdaems »

Can you please test with the testing branch snapshots? See http://zeosdownloads.firmos.at/downloads/snapshots . This may be related to bug #90.

Mark
Image
MYSQL889
Fresh Boarder
Fresh Boarder
Posts: 16
Joined: 16.06.2008, 23:04

Post by MYSQL889 »

Hello Mark,

I will try with the latest version of testing. Thank you for responding to mail and my support, to your work.

Sincerely,

Sebas.
mdaems wrote:Can you please test with the testing branch snapshots? See http://zeosdownloads.firmos.at/downloads/snapshots . This may be related to bug #90.

Mark
khh
Fresh Boarder
Fresh Boarder
Posts: 1
Joined: 14.10.2008, 16:26

Post by khh »

i have vers. 6.63 an the same problem.

KH
User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Post by mdaems »

khh,

This doesn't help us much. The problem above was really fixed. So you might have stumbled into something similar but different; Can you please tell us exactly what you are trying (table structures, sql, database server version, compiler version, ...) or send a sample application (including db creation script!)

Mark
Image
MYSQL889
Fresh Boarder
Fresh Boarder
Posts: 16
Joined: 16.06.2008, 23:04

Post by MYSQL889 »

Hi Khh,

I have not returned to find this problem with version 6.6.3 and Mysql.

Thanks for the support Mdaems
Sebas
Post Reply