Tracy, Your pointing out the VFP9 System capacities helped. I split the program created by GenDBCX into smaller bits and I got the results I required.
Thanks very much. Kelvin On 18/06/2013, Kelvin Matola <[email protected]> wrote: > Hi Tracy, > > Thanks very much for your quick response. I am using VFP9 SP2 and > Visual Promatrix Entreprise Framework 9.0 and 9.12a. I have converted > my old app to VPME9.12a and one of the things I need to do is change > Criteria on Joins and Filters in my views from = to Like. With a large > app, this takes anything from a day to a day and half. > > GenDBCX creates a prg with view creation code in it. I globally > change = to like in the prg. Run the prg and the result is a views dbc > with correct criteria. Problem is the prg created by GenDBCX comes > with the error "Program too large" because, I think, of the way it is > structured. > > I was hopping that others, who might have experienced this problem, > would have a workaround. Will look at the System capabilities and see > how I can restructure the prg. > > Most grateful for your contact. > > Kelvin > > On 18/06/2013, Tracy Pearson <[email protected]> wrote: >> Kelvin Matola wrote on 2013-06-18: >>> I am trying to recreate a views dbc and came across the above on >>> http://www.leafe.com/dls/vfp. >>> >>> Using the program still comes with the error "Program too large". I do >>> have many views of course. Is there a version of gendbc that doesnt >>> have this error? Or has somebody have a workaround? >>> >>> Kelvin K Matola >>> >> >> Kelvin, >> >> What version of VFP are you using? >> VFP 9's help file topic "Visual FoxPro System Capacities" shows: >> Maximum # of characters per command line. = 8,192 >> Maximum # of characters per macro substituted line. = 8,192 >> >> You would need to have a fairly complex view to exceed that character >> count. >> >> Tracy Pearson >> PowerChurch Software >> >> [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAERO=2l_ymlyynx_j8ufvfhwtnfaxmesu9irwzp-ctnlzie...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
