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=2keo4yd5wq+pi_qn78ersdpwj84rdwsfxvfxnhvwrs...@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.
