Column "...." cannot be null

[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.

[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

[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.

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]

i have vers. 6.63 an the same problem.

KH

[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

[MYSQL889]

Hi Khh,

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

Thanks for the support Mdaems
Sebas