Thank you Andy and Alan for your continued feedback. Stephen - I do understand what you are saying. But, here's a little additional info.
Yesterday I asked a question to the manager of the dept. that uses this system. Besides the Grid for editing of Data - there is a button to edit a single record - and it pops-up another form. My associate here - she suggested I ask the manager if the use of that button - and the single record edit screen was needed. The manager said no - and, also confirmed that when they need to edit this data on the Grid on the main screen - its coordinated so only one person does ALL the updates all at once. So - I'm going to discuss this with my associate and see what she says about our original discussion to just pull all the data down - allow editing - then push it all back up again. Of course, I could program it so it only pushes back up what data fields were specifically modified. I know - this Brute force method may not be the best solution. But, we are only putting a "patch" on this system - until the new system is ready. Plus, I need to do things quickly - since they have a TON Of projects for me to do - and I can't spend a lot of time on this one piece for this Country Rules update... -K- -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Stephen Russell Sent: Tuesday, June 23, 2015 9:22 AM To: [email protected] Subject: Re: VFP Migration to MS SQL & a Difficult Screen... On Tue, Jun 23, 2015 at 7:39 AM, AndyHC <[email protected]> wrote: > Unfortunately the change from local .dbf files to a client-server > system using a remote rdb *is* a fairly steep learning curve, but it > probably isn't worth the effort for a stub-end system with no onward > development. > You could try this (which omits the intermediate options and their > useful learning opportunities): > VFP Data Explorer is *excellent* at finding SQL Server db's on the > same network - use it to find one (or a couple of related) files that > have already been 'converted'; drop it on a cursor adapter and have a > play (VFP Help! is your friend). Have a play, then see if you can get > it to work with the data environment of a copy of your form with the grid. > >> --------------------- Or byte the bullet and start to do client server processing. :) Comprehending what data you have on hand and allowing you to only insert, update, and or delete what is necessary is good programming. Just pushing a big ass dataset back is lazy and may wipe out another's edits done while your user was doing theirs. -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [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/80838f1ca795b14ea1af48659f35166f1c2...@drexch02.corp.globetax.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.
