I have an easy question but I can't solve the problem.
I added a new filed in a table (using viSQL for Xojo, Valentina 6.6.9)
ALTER TABLE EventName ADD EventArt VarChar(504)
UPDATE EventName set EventArt ='Maze‘
works also fine.
then I tried to change it to INDEXED and NOT NULL.
ALTER TABLE EventName MODIFY EventArt NOT NULL INDEXED
but this doesn’t work. What can I do that it works?