I defined a view programmatically and I cannot figure out how I can create a default value to my primary key. The problem is that I call a procedure in the dbc called NewId("MyView"). The procedure in the dbc locate the parameter and return the next sequential surrogate key.

When using the view designer, everithing is perfect. But when I use the syntax
:= DBSETPROP("MyView.PrimaryKey", "Field", "DefaultValue", "NewId("MyView")")
VFP tells me that I make a syntax error. I Figured that the problem was the quotes so I tried :
= DBSETPROP("yView.PrimaryKey", "Field", "DefaultValue", NewId("MyView")).
Then the procedure execute but still nothing assigned at the default value of my field.

Does sombody has an idea ?
Thank You,
Christian Coté