Barbara,
I modified the gendbc program to fix the file too large problem. What I did was to make it create an individual record for each view. I also put a hook into it that let me recreate any number of selected dbc objects view or the entire database. If you would like, I'll email it to you.

>Gary,
>Use GenDBC to get the setup code for your views and check the DBSetProp lines. I found that I needed to have
>
>Fetchsize = -1
>FetchAsNeeded = .F.
>ShareConnection = .T.
>
>Setting Fetchsize to -1 and FetchAsNeeded to .F. said "Stop handling any more commands until I've brought back all the data" which reduced my BusyConnection problems to a very low number.
>
>When I'm writing code with a lot of complex views I do a basic set of views, run GenDBC and put the view code into a PRG which is then updated and used to re-generate the views whenever I need to. If GenDBC has problems due to the size/number of views, check for the line that compiles the result PRG. Comment it out and you should have no problems.
>
>HTH
>Barbara
>
>
>
>>Hi all,
>>I'm converting a VFP app for a client to run against a SQL Server back end instead of VFP. (They have enough sense to keep the VFP front end!) I've made remote views in a DBC that work fine, but I've started having problems with the connection or something. I have some SQLExec's and they are getting the error "Invalid call issued while executing a sqlmoreresults sequence". I'm not attempting and asynch data returns, at least intentionally. If I pause the debugger and run a sqlmoreresults() I get a 2 and I can continue. Also, after the form loads, when a method calls for a ReQuery() of a view, I get a "Connection MyConnection Is Busy". The connection is set up as shared. I've tried about every setting I can think of, although perhaps not the proper combonation. Has anyone run into this before and more importantly, fixed it? Thanks for any consideration.