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);
}

Thanks in advance

Better to have it as a default value in the database, so you don't need to set it when Inserting a new row.

Walaa wrote:

Better to have it as a default value in the database, so you don't need to set it when Inserting a new row.

Do you consider to add this functionality in the near future ?

yep, tho it's not certain it will make the cut for 3.5.