>But if I do lnKey = getkey('locations'), I get "getkey.prg" doesn't exist. How do you tell it you want to use a stored procedure?
>
Michelle, you can specify a default value for a view field just like in a table field. If you maintain you views through the view designer, click on the properties button, and you will get a dialog similar to that of the table designer, where you can set all the field properties for views. If you maintain your views in code, just issue:
DBSetProp('myview.keyfield', 'Field', 'DefaultValue', "getid()")
Erik Moore
Clientelligence