vStudio entering default values

[Ruslan Zasukhin]

On 7/3/08 7:26 PM, "william humphrey" <shoreagent at gmail.com> wrote:

> 1. Default system date is not "CURDAT". What do I put in the field in vStudio
> for it to default the date?

Better use Trigger for this I think.

> 2. Auto increment is what happens if you set a fld to ObjPtr? Or is it done
> somehow with something written in the default or is auto-increment not used
> because of other ways to index?

When you use RecID and ObjectPtr you do not need any auto-increments
    because RecID itself provide unique value.

Please read WIKI on details


> 3. Some databases require that you enter '' as the default when it is NOT NULL
> so that the field will have a string value when empty by default -- not
> necessary with vStudio?

You can define DEFAULT value in the CREATE TABLE actually.
    then db engine will take care on INSERT never mind from which client
    you touch db.

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]