What does DEFAULT mean in the context of a field definition?

[HarryStottle]

One of the things I liked when I started digging into Lianja was the ability to assign a default value to a field. I assumed this would mean that on adding a new record, its values would be pre-populated with default values where they existed.

As I have thousands of instances where I waste time assigning things like the current datetime and username to newly added records, I imagined I was about to streamline development by being able to have such data automatically inserted into new records without me having to code it.

Not so?

With the datetime field I added, I made the default value DATETIME(), assuming that this would call the standard VFP function of that name. That failed, so what should I have written? Or am I completely misinterpreting the Lianja notion of Default?

[davefoss]

Hi Harry,

This is working for me. If you are setting the default value in the column attributes of a form, make sure that "Inherit dictionary rules" is False. If you continue to have difficulty, please submit a ticket and attach your app and data. Thanks!

[barrymavin]

As Dave points out you can have a "Default" value in the table/column attributes or a "Default" value in the grid/column attributes.

[davefoss]

This is specifically an issue with setting the default in the table column attribute - setting it in the form/grid works fine. A ticket has been opened.