Hi Cetin,

This is really a good cheat. The good news though is that it works. From my testing on Codebook's NewId function to get new id's from VFP StoredProcedure. What I found that #DEFINES don't work, though functions like LOCK, UNLOCK, SEEK, EVAL work perfectly. The length of the name of the function, the position i.e. 1st one, 2nd one etc also does not matter.

What is required is an table with an single record on which the select can be issued to return just one row.

I tested this on local machine (NT workstation) and a remote one too (NT Server) and the results have been positive. Though the one on the server was a little slower... obviously... but this time it was slower than running a query but the results returned were right.

This was also tested on VFP 5 (Build 415) and VFP6 and worked at both the places.

>Only a cheat (select storedproc(parm) as result ...) but that also succeeds if "storedproc is the first proc in stored procs.