#1 Re: mORMot 1 » TDate Problem » 2012-06-25 20:16:57

Do you mean TDate is fractionless?But Tdate fields have fraction in db (float type) .How  we can query for example if that field hold date value( no hour no minute no second) without rounding?Can you give some examples?

#2 mORMot 1 » TDate Problem » 2012-06-25 16:10:11

dieforwhat
Replies: 3

Hi everyone.I've problem with TDate field.Is there any example about using Tdate but not TdateTime  and is it possible to save Tdate like  sqlite julianday ?As I know Tdate is saved like single precision floating number and not matching either sqlite datetime nor date function.

#3 Re: mORMot 1 » ID Field Auto-increment » 2012-06-18 08:26:41

smile. I've downloaded  sqlspy and see that you're absolutely right.( not about sqliteadministrator since it shows if ID filed autoincremented fieldcontrains column show that info).I've end up with that this is a bug in sqliteadministrator not mORMot and record saving error is about my coding (in fact mistyping).Thanks for your help and kindly replies and sorry about wasting your time.

#4 Re: mORMot 1 » ID Field Auto-increment » 2012-06-18 07:09:34

Thanks for immidate answers.I'm neither using low level sql apis nor creating tables my self.I've just create a descendant of tsqlrecord and add it to my model.Table is automatically created but id field is not autoincremented.This is the image from sqliteadministrator.2d2ei3q.jpgThis is strange as I've 2 more tables but neither of them have this issue.With looking this picture, should we expect ID fileds have NOT NULL AUTOINCREMENTED ...constraints?By the way I've catch this by when I try to add new record to that table it is not working,new record never get added and maybe expecting some ID value given by me.(I know making id field autoinc is more easy than writing this post but I want it from framework since database file will be created in customer pc.Even I tried to make it myself but then I have the error 'SQL Error: no such collation sequence: SYSTEMNOCASE'.As far as I know  this is becasue  sqliteadminstrator (from sqliteadmin.orbmu2k.de) is not aware of framework created collation sequence and all my queries from sqliteadminstrator end up with this error but this is another issue anyway.)

#5 mORMot 1 » ID Field Auto-increment » 2012-06-17 22:08:00

dieforwhat
Replies: 6

Hi everyone.I've newly downloaded and begun to use the framework.My problem is when a table is auto created ,sometimes ID field is autoincremented and sometimes not(but always PK).I can't find any difference between my tables.They are just regular tables with different fields and no  property as  tsqlrecordmany(just string and integer fields).Is this a bug or am I missing a critical point.(I've also searched the forum but not encountered with this topic.)Any help will be appreciated.

Board footer

Powered by FluxBB