Hi Ricardo,

I stumbled across your thread on tight SQL Server integration. I have only been using VFP for a little over a year but I do have a few thoughts on the subject.

The main feature I would love to see and I haven’t seen mentioned is the ability to spawn threads. More specifically the ability to create cursors on it’s own worker thread. That way returning a large result set would not 'lock' foxpro up. Perhaps something like this…

SET THREADING ON
X = SQLEXEC(gnConnection, "SELECT * FROM someTable", "curTemp")

*-- Have RecCount return the number of records it currently has, but
*-- as a negative value to indicate that it is still fetching.
DO WHILE RECCOUNT("curTemp") < 0
? "Currently have " + ALLTRIM(STR(ABS(RECCOUNT("curTemp")))) + " available."
ENDDO

Well you get the general idea. :)

Also I would love the ability to count the number of references an object has on it. A major problem in VFP is dangling references, get enough dangling references and the memory available to fox gets eaten away…
i.e.

x = CREATEOBJECT(“custom”)
y[1] = x

Then a command like ReferenceCount("x") would return 2. This would be a huge benefit to framework developers like myself.

I see that Microsoft will be bundling MSDE with the product. Great!!! This is an excellent idea and will help facilitate SQL Server development.

Well that is all that I can think off for now. I hope if nothing else you find my suggestions interesting. :)

Best Regards,


Christopher Erker

PS: Is there going to be any more work done with the FLL extention library.. more object functionality perhaps?