>>Michelle,
>>
>>I just checked it from my command line and it's okay.
>>
>>I called x = getid(), and got the error about the missing prg. Then did SET DATABASE TO mydatabase and did x=getid() again and it was fine. So it should work for you.
>
>I may have missed it in the thread earlier, but you can set the default value of your view's primary key to be the same SP call as your table's primary key.

I think I missed the post you're replying to, so I'll reply to both of you.

While I'm developing, it's easier to have a second program, because I'll never remember to do SET DATABASE TO. Once it's actually in an application, I can just stick that in the init code and it'll work.

Someone said that about view primary keys. It seems to be working now, but that's a good thing to know in the future.

I discovered a trick by accident. You can do an INSERT INTO *without* getting the key value first. Just list the fields you're inserting into, and *don't* list the key field. It puts it in for you.

Thanks,

-Michelle