Hi,

I want to use a function call in an Oracle insert statement. INSERT INTO TAG_BEROEP (DT_WIJZ) VALUES (GetDate())

I've coded the following line but nothing happens clientEntity.Fields[TagBeroepFields.DtWijz.FieldIndex].ExpressionToApply = QueryHelper.GetDate();

    public static IExpression GetDate()
    {
        return new DbFunctionCall("GetDate", null);
    }

Should this also work for updates ?

Thanks in advance

It's not supported for inserts. It's on our todo list, but we don't have a final date when / if it will be available. It's not scheduled for addition in v2.6

Actually, we migrated from version 2.0 to 2.5 and those problems occured after migration. Are there no other ways to add an expression in an insert statement ?

Thanks in advance

This is not supported yet. You can workaround this by adding GetDate() as a default to the database field.