On Thu, Jan 20, 2011 at 8:19 AM, Lou Syracuse <[email protected]> wrote: > Unfortunately I don't know what this value will be in the UI. The value is > dynamic; it is calculated based on other values inside the equivalent of 3 > vfp scan loops, and could change for each record that is processed. It's a > complex calculation as you can tell by it being 3-deep in scan loops, right > now the SP is over 200 lines and I still have more to convert. ---------------------
So it takes 3 loops to identify what the column is as well as the value you need to write to the data. SO WHAT! Sometimes we justify our salary on doing the hard stuff. :) Now that you have those TWO items the dealing with any data are easy. Right? > Looks like I may just have to bite the bullet and go with the case > statements in this instance. I can't just get the data from SQL and change > the VFP program to handle it as we are migrating all of our code out of VFP > and rewriting this process in .NET would be just as challenging (if not > more so) and this is a major report used throughout the organization that > has to be dead-on accurate every time. ------------------ Look to separate the message of "Save this data for me" from the operation of the form. I am going nTier here but it needs to be seen for what it is. Your GUI takes the raw info from the user and passes it's contents in a message to a second tier to actually do something. In the second tier you loop de loop till you get the true nature of the request for this tough situation. Once this prg has the true syntax for the back end it passes that back for execution. I had a hard time going back and forth with VFP and other languages because VFP let you cross the boundary so easily. I am only asking you to break apart the process into the tasks that need to be accomplished. -- Stephen Russell Sr. Production Systems Programmer CIMSgts 901.246-0159 cell _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** 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.
