George,

More of the mysteries of VFP!

To me, the originator has a very good question, and I have not been successful at finding any kind of answer in the docs (so what's new?).

It also led me to ask what about "upsizing"?? - *IF* I choose to use validation and triggers, etc. for my database/views and then upsize, where do the validation/trigger routines go?. . . and do I have to put them there or do they go automatically?. . . and if they go automatically, how does the other service know how to "translate" the VFP commands?

It also led me to wondering about OLE to things like EXCEL or even ACCESS - same questions about validation/triggers/stored procedures.

Frankly, I'd bet on getting big negative surprises in this area, which would be even more reason to aviod using what should be a useful and powerful feature!

Just my 2¢ worth
Jim N

>>Jerry;
>>
>>Have you actually gotten Visual Basic to add a new record to a table that has fired the stored procedure? I agree with you that without VFP running, a VFP stored procedure should not fire.
>>
>>Bob
>
>I'm not so sure I agree. Using ODBC and with the appropriate DLL (VFPODBC.DLL, I think), I don't see any
>reason why it wouldn't. Also why provide access to the DBC via a driver and not allow triggers, stored
>procedures, etc. to behave as they should?
>
>I haven't tried this yet, but I will and if this does work, I'll post it.
>
>George