#1 Re: Source Code repository » Cannot create AuthUser record » 2020-10-05 10:24:26

Hi Arnold

I forgot to mention that I manually changed the definition to NOT NULL and a problem occurred further into the execution that seemed to imply mORMOT could not handle a NUL value for the field Data.

Regards
Graeme

#2 Re: Source Code repository » Cannot create AuthUser record » 2020-10-05 10:21:35

Hi Arnold

Thanks for the quick reply.

The tables (ECAuthGroups and ECAuthUsers) were created by mORMot code.

The SQL to create the table looks like

CREATE TABLE [dbo].[ECSQLAuthUsers](
    [ID] [bigint] NOT NULL,
    [LogonName] [nvarchar](20) NOT NULL,
    [DisplayName] [nvarchar](50) NOT NULL,
    [PasswordHashHexa] [nvarchar](64) NOT NULL,
    [GroupRights] [bigint] NOT NULL,
    [Data] [varbinary](max) NOT NULL,
    [Initials] [nvarchar](10) NOT NULL,
PRIMARY KEY CLUSTERED
(
    [ID] ASC ...........

The tables ere create during the call to CreateMissingTables and I also found the the tables would be created on the first call to CreateAndFillPrepare if the
CreateMissingTables method was not called.

Regards
Graeme

#3 Source Code repository » Cannot create AuthUser record » 2020-10-05 07:30:00

Graeme
Replies: 4

Hi

I have my own TSQLAuthUser record called TECSQLAuthUser) and when I attempt to create such a record to my database I get the following error:
   Cannot insert the value NULL into column 'Data', table ECSSQLAuthUsers; column not allow null, INSERT fails

This is a reasonable sql error as mORMot has created the table with the column Data declared as NOT NULL'

My database is an MSSQL database and I am using the ZEOS components/classes.

In my code I do not assign a value to my TECSQLAuthUser Data field but I still get the error when I do assign a value.

Would you please assist with my problem.

Regards
Graeme

Board footer

Powered by FluxBB