Christopher,

Have you looked at using an Async connection to SQL server. This eliminates the 'locked' look of VFP. You can also display a progress bar or do other stuff while the query/sp is running on the server.

BOb


>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?