Posted by John Aspinall-5 on Oct 07, 2004; 7:07am
URL: https://forum.world.st/reStore-and-fireBird-tp3371731p3371735.html

Pablo,

> When i am trying to sinchronize tables fireBird send me and error when
> trying to create NEXT_ID table.
> It saids that the primary key ID_  has to be created not NULL . By default
> reStore trying to create it without not Null sentence.
> I am trying to customize reStoreDialect but i am not succesfully. Someone
> can help me with this problem?.

Try the patch below; it's a little bit of a hack but I think it should solve
this issue for you.

Best regards,

John Aspinall
Solutions Software


!SSWDBStaticField methodsFor!

writeSQLDefinitionOn: aStream

 super writeSQLDefinitionOn: aStream.
 aStream space.
 self targetClass writeSQLTypeOn: aStream using: self sqlDialect.

 self accessor class = SSWDBIDAccessor ifTrue:
  [aStream nextPutAll: ' NOT NULL']! !
!SSWDBStaticField categoriesFor: #writeSQLDefinitionOn:!output!public! !