Re: FoxproDOS - No APP after BUILD APP
On Tue, Apr 7, 2015 at 2:05 PM, Rick Schummer wrote: > > The author was much smarter about FoxPro for DOS 21 years ago. Thanks for the > fond memories. > Enjoyed them myself. Many, "oh yeah, I used to know that" moments. > Hopefully my mistake rushing to get to a vacation was not too much of a > problem for Mr. Cully. No mistake there at all. Sounds like priorities in the right place. Enjoyed the pix on Twitter. ___ Post Messages to: ProFox@leafe.com 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/CACW6n4sjcpgC=bv_gb9dbjf+l_it7g2wsgn_437zwj-lrn3...@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.
Re: FoxproDOS - No APP after BUILD APP
Not a problem at all. I've built then an extended stand-alone EXE for them to clean up their database. I'm working on finishing a VFP upgrade. The original programmer used a lot of wizards to upsize it to VFP7. I'm trying to work with what he's done and to get it up to VFP9 in the process. As a side note, what is this 'vacation' thing you're talking about. I've heard of the word but I don't recall it's implementation. :P I still owe everyone a benchmark of using FoxproDos in DOSBox! I haven't forgotten. CULLY Technologies, LLC http://cullytechnologies.com http://cully.biz On 04/07/2015 02:05 PM, Rick Schummer wrote: Hi Ted, There's also a great article on it here: http://rickschummer.com/articles/projfile.htm<< The author was much smarter about FoxPro for DOS 21 years ago. Thanks for the fond memories. Hopefully my mistake rushing to get to a vacation was not too much of a problem for Mr. Cully. Rick White Light Computing, Inc. www.whitelightcomputing.com www.swfox.net www.rickschummer.com [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com 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/55241e19@cullytechnologies.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.
RE: FoxproDOS - No APP after BUILD APP
Hi Ted, >> There's also a great article on it here: http://rickschummer.com/articles/projfile.htm<< The author was much smarter about FoxPro for DOS 21 years ago. Thanks for the fond memories. Hopefully my mistake rushing to get to a vacation was not too much of a problem for Mr. Cully. Rick White Light Computing, Inc. www.whitelightcomputing.com www.swfox.net www.rickschummer.com ___ Post Messages to: ProFox@leafe.com 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/005001d0715d$5d9d1fe0$18d75fa0$@whitelightcomputing.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.
RE: [NF] Stephen Russell
Dang, ain't heard that one in about 30 years. Forgot all about it -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ted Roche Sent: Tuesday, April 07, 2015 12:33 PM To: profox@leafe.com Subject: Re: [NF] Stephen Russell Or, Bravo, Zulu, Stephen! (http://en.wikipedia.org/wiki/Bravo_Zulu) On Tue, Apr 7, 2015 at 9:59 AM, Virgil Bierschwale wrote: > Attaboy as we used to say in the Navy > > > -Original Message- > From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Jeff > Johnson > Sent: Tuesday, April 07, 2015 8:52 AM > To: profox@leafe.com > Subject: [NF] Stephen Russell > > I want to publicly thank Stephen for helping me off line find the > correct connection string to a SQL Server 2014 database. > > Thank you Stephen! > > -- > Jeff > > Jeff Johnson > j...@san-dc.com > SanDC, Inc. > (623) 582-0323 > SMS (602) 717-5476 > Fax 623-869-0675 > > www.san-dc.com > www.cremationtracker.com > www.agentrelationshipmanager.com > > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com 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/143f01d0715a$c91f6e60$5b5e4b20$@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.
Re: [NF] Stephen Russell
Or, Bravo, Zulu, Stephen! (http://en.wikipedia.org/wiki/Bravo_Zulu) On Tue, Apr 7, 2015 at 9:59 AM, Virgil Bierschwale wrote: > Attaboy as we used to say in the Navy > > > -Original Message- > From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Jeff Johnson > Sent: Tuesday, April 07, 2015 8:52 AM > To: profox@leafe.com > Subject: [NF] Stephen Russell > > I want to publicly thank Stephen for helping me off line find the correct > connection string to a SQL Server 2014 database. > > Thank you Stephen! > > -- > Jeff > > Jeff Johnson > j...@san-dc.com > SanDC, Inc. > (623) 582-0323 > SMS (602) 717-5476 > Fax 623-869-0675 > > www.san-dc.com > www.cremationtracker.com > www.agentrelationshipmanager.com > > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com 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/cacw6n4tyycedbx5riswzyayskezzt1iqnco15jh7lj4a3ye...@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.
Re: [NF] SQL Server Question
On 07/04/2015 19:57, Stephen Russell wrote: On Tue, Apr 7, 2015 at 8:50 AM, Jeff Johnson wrote: Man-wai, actually I am going to use VFP to scan the tables and see which ones of them have data in them. Out of 1025 tables, very few are used. This is the most bizarre database structure I have ever seen. Nothing is stored in the primary table except foreign keys to tables. There is a name table, eye color table, hair color table, etc. It was developed by a non-programmer and they kept working on it until they sold it as a commercial application. It is very expensive also. - You have a normalized system I guess. Welcome to the world of intense data instead of simplistic Master with one or two child tables. +1 ___ Post Messages to: ProFox@leafe.com 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/552409f7.8000...@hawthorncottage.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.
Re: [NF] SQL Server Question
See if the column names of all tables could be used to link them up into a entity-relationship diagram... If not, you would have to read the source codes to find out. You might also try creating new records in each part of the systems using special descriptions, then find them in the tables. On Tue, Apr 7, 2015 at 9:50 PM, Jeff Johnson wrote: > This is the most bizarre database structure I have ever seen. Nothing is > stored in the primary table except foreign keys to tables. There is a name > table, eye color table, hair color table, etc. -- .~. Might, Courage, Vision. SINCERITY! / v \ 64-bit Ubuntu 9.10 (Linux kernel 2.6.39.3) /( _ )\ http://sites.google.com/site/changmw ^ ^ May the Force and farces be with you! ___ Post Messages to: ProFox@leafe.com 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/CAGv=MJCMLxgkjZNe03LLZa-m_kHHqcN5GU_CVDiGR0wp_q=k...@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.
Re: [NF] Stephen Russell
Here is the silver bullet:
lcurl = 'Driver={ODBC Driver 11 for SQL
Server};Server=MySQLServer;Database=MyDatabase;UID=MyUserID;PWD=MyPassword'
On 4/7/2015 6:52 AM, Jeff Johnson wrote:
I want to publicly thank Stephen for helping me off line find the
correct connection string to a SQL Server 2014 database.
Thank you Stephen!
--
Jeff
Jeff Johnson
j...@san-dc.com
SanDC, Inc.
(623) 582-0323
SMS (602) 717-5476
Fax 623-869-0675
www.san-dc.com
www.cremationtracker.com
www.agentrelationshipmanager.com
___
Post Messages to: ProFox@leafe.com
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/5523f04d.2050...@san-dc.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.
Re: [NF] Stephen Russell
+1 :-) -K- Sent from my iPhone > On Apr 7, 2015, at 10:22 AM, Jean Laeremans > wrote: > > Give the man a beer ! >> On 7 Apr 2015 15:59, "Virgil Bierschwale" wrote: >> >> Attaboy as we used to say in the Navy >> >> >> -Original Message- >> From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Jeff Johnson >> Sent: Tuesday, April 07, 2015 8:52 AM >> To: profox@leafe.com >> Subject: [NF] Stephen Russell >> >> I want to publicly thank Stephen for helping me off line find the correct >> connection string to a SQL Server 2014 database. >> >> Thank you Stephen! >> >> -- >> Jeff >> >> Jeff Johnson >> j...@san-dc.com >> SanDC, Inc. >> (623) 582-0323 >> SMS (602) 717-5476 >> Fax 623-869-0675 >> >> www.san-dc.com >> www.cremationtracker.com >> www.agentrelationshipmanager.com [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com 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/e2c9baa4-2583-496e-80c6-3910c2b27...@optonline.net ** 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.
Re: [NF] SQL Server Question
On Tue, Apr 7, 2015 at 8:50 AM, Jeff Johnson wrote: > Man-wai, actually I am going to use VFP to scan the tables and see which > ones of them have data in them. Out of 1025 tables, very few are used. > > This is the most bizarre database structure I have ever seen. Nothing is > stored in the primary table except foreign keys to tables. There is a name > table, eye color table, hair color table, etc. > > It was developed by a non-programmer and they kept working on it until > they sold it as a commercial application. It is very expensive also. > > - > You have a normalized system I guess. Welcome to the world of intense data instead of simplistic Master with one or two child tables. I have worked with a name table before because it greatly reduces index stress in inserting and when you are searching for last name "Williams" across 4 million rows it is much faster. The text search to find 1 row out of 4000 is instantaneous, and taking it's key value to the other table it increases your search speed by a factor of 12 I found when I put this into SQL Server 2005 system. We had 4-6 million customers as I remember. Customer support was real happy because they could find someone's record without have to wait a while with them on the phone bitching about a charge. -- 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 --- ___ Post Messages to: ProFox@leafe.com 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/cajidmyjj8d1s3gdwzgh8hdqfg4needwxb4xsf0pevetrkk3...@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.
RE: [NF] Stephen Russell
Give the man a beer ! On 7 Apr 2015 15:59, "Virgil Bierschwale" wrote: > Attaboy as we used to say in the Navy > > > -Original Message- > From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Jeff Johnson > Sent: Tuesday, April 07, 2015 8:52 AM > To: profox@leafe.com > Subject: [NF] Stephen Russell > > I want to publicly thank Stephen for helping me off line find the correct > connection string to a SQL Server 2014 database. > > Thank you Stephen! > > -- > Jeff > > Jeff Johnson > j...@san-dc.com > SanDC, Inc. > (623) 582-0323 > SMS (602) 717-5476 > Fax 623-869-0675 > > www.san-dc.com > www.cremationtracker.com > www.agentrelationshipmanager.com > > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com 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/CAPqLOBzO9=kvrnf_kzfz24mdpgnw0d7zmnkmkzyeg--p962...@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.
RE: [NF] Stephen Russell
Attaboy as we used to say in the Navy -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Jeff Johnson Sent: Tuesday, April 07, 2015 8:52 AM To: profox@leafe.com Subject: [NF] Stephen Russell I want to publicly thank Stephen for helping me off line find the correct connection string to a SQL Server 2014 database. Thank you Stephen! -- Jeff Jeff Johnson j...@san-dc.com SanDC, Inc. (623) 582-0323 SMS (602) 717-5476 Fax 623-869-0675 www.san-dc.com www.cremationtracker.com www.agentrelationshipmanager.com [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com 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/130201d0713b$1a5a7790$4f0f66b0$@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.
[NF] Stephen Russell
I want to publicly thank Stephen for helping me off line find the correct connection string to a SQL Server 2014 database. Thank you Stephen! -- Jeff Jeff Johnson j...@san-dc.com SanDC, Inc. (623) 582-0323 SMS (602) 717-5476 Fax 623-869-0675 www.san-dc.com www.cremationtracker.com www.agentrelationshipmanager.com ___ Post Messages to: ProFox@leafe.com 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/5523e10d.5040...@san-dc.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.
Re: [NF] SQL Server Question
Man-wai, actually I am going to use VFP to scan the tables and see which ones of them have data in them. Out of 1025 tables, very few are used. This is the most bizarre database structure I have ever seen. Nothing is stored in the primary table except foreign keys to tables. There is a name table, eye color table, hair color table, etc. It was developed by a non-programmer and they kept working on it until they sold it as a commercial application. It is very expensive also. On 4/7/2015 4:08 AM, Man-wai Chang wrote: You talking about Information Schema? https://msdn.microsoft.com/en-us/library/ms186778.aspx On Mon, Apr 6, 2015 at 2:37 AM, Jeff Johnson wrote: Gang, this SQL Server I was talking about the last few days appears to have 1025 tables! My question, is there a way to query the database to see how many records a table has? -- Jeff Jeff Johnson j...@san-dc.com SanDC, Inc. (623) 582-0323 SMS (602) 717-5476 Fax 623-869-0675 www.san-dc.com www.cremationtracker.com www.agentrelationshipmanager.com ___ Post Messages to: ProFox@leafe.com 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/5523e091.8080...@san-dc.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.
Re: [NF] SQL Server Question
You talking about Information Schema? https://msdn.microsoft.com/en-us/library/ms186778.aspx On Mon, Apr 6, 2015 at 2:37 AM, Jeff Johnson wrote: > Gang, this SQL Server I was talking about the last few days appears to have > 1025 tables! My question, is there a way to query the database to see how > many records a table has? -- .~. Might, Courage, Vision. SINCERITY! / v \ 64-bit Ubuntu 9.10 (Linux kernel 2.6.39.3) /( _ )\ http://sites.google.com/site/changmw ^ ^ May the Force and farces be with you! ___ Post Messages to: ProFox@leafe.com 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/CAGv=MJA+7-e3QxzmiMF9rNJQLbe+qt0=eYLLKNuT=Jfks=3...@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.
