You are not logged in.
- Topics: Active | Unanswered
Pages: 1
#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
Pages: 1