>>From any place of your app when you need in new key value, you just issue:
>>nNewkeyvalue=getnewid("mytable")
>>and evaluate return value.
>
>Ed,
>I am running Active Server Pages with VB Script
>and the VFP trigger does NOT execute when inserting
>records. Wahhhhhh. It's just like any true backend
>server, you have got to have the server running
>to add records that understands the language. Since
>VFP isn't a server, it can't be done.
>
>Also, in web development, calling a table to
>look up keys is very time consuming to the end-user.
>Web developement reminds me of the programming
>15 years ago. It's ancient and slow.
>
>The only way to have an increment key using
>VFP free table on the web is to use an
>Apllication Variable that does the increment.
>
>I wish I could use VFP for the development
>but Microsoft forces us to us VB. I guess
>VFP is going by the wayside and one way
>or another, MS will force us to change to VB
>or another vendor's language. I've begun
>to study up on Fortran.
>
>Thanks for the reply.

However, Gene, you can use the getnewid FUNCTION (placed in stored proceedures so as to be available even with browsing outside of an app) and put it in a table's default value box (table designer) . Use the replace command, not the insert cmd.
BTW, I dropped WIN95 and MS OS's and Installed LINUX from RedHat, version 5.0.
There site is www.redhat.com. The complete OS and axuillary software is available for around $50. Most of that cost is the book. LINUX, and the apps on the CD are under a GNU license and are free. A 486Mz 16MB server machine running LINUX and SAMBA will run rings around an NT server setting on a 200MHz dual pentium pro with 64MB RAM.