In a different email someone pointed out the advantage of separating the user interface code from the data. I know what you are doing. I did that for 10 years with fox-dos and I was very happy with it. I could 'feel' the data and I liked having the control (like knowing where the record pointer is). I really did not like moving to VFP with objects, views, and all that nonsense. But I went to the meetings and forced myself to write some code and make sure I was not stuck in the past. That was about 9 years ago and I would never go back. Now I don't care about the record pointer. I don't even remember why I ever cared. I am not as far along as others on this list. I feel I am ready to begin moving to Python and PostgreSQL in the near future. I don't want to start any flaming on this list, but I think it is possible that most people on this list will be using something other than VFP ten years from now. Time passes faster the older you get. Also it gets more difficult to learn new things.
----- Original Message ----- From: "John Weller" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Thursday, March 27, 2008 10:45 AM Subject: RE: Question for you longtime FoxPro guys But that won't position the record pointer - which is what I wanted. Personally I prefer to use a SEEK instead of SET RELATION TO to position the record pointer for whatever I need. I accept your point that SQL is more general but I can't see anyone ever wanting to move code to another language, there are too many differences so it would be a re-write job anyway. John Weller 01380 723235 07976 393631 > > Others on this list are better at sql than I am. > > Select * from MyTable where cCode = MyTag > > If empty(cCode) > MESSAGEBOX('That key not found') > endif > > I don't know the field you are searching on, but that is the > idea. With a small change you could put this record into a view/file, > etc. You could copy it to a new dbf and a lot of things like that. > [excessive quoting removed by server] _______________________________________________ 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.
