Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: myearwood
- Order by date
-
How to check for an array's existance.
In my Foxpro Advisor article (subscription required): http://my.advisor.com/doc/17117 I argued that this line of code: IF TYPE("ALEN(m.SomeVariable") is not as readable, maintainable or extendable as: IF X2IsArray(@m.SomeVariable) Remember, copying code is not code reuse! ;) The...- myearwood
- Forum: Microsoft: FoxPro
-
How to merge new table into existing table
Over the years, I've seen people ask how to merge a new table into an existing table. This can be for purposes of a data conversion or a business process to synchronize two systems. This usually involves a long process to scan the new table, seek in the existing table and either add or...- myearwood
- Forum: Microsoft: FoxPro
-
OOP way to get a SQL progress bar.
You've probably seen code to SET TALK ON before running your query to show the SQL thermometer/progress bar. First off, all such techniques require you to write several statements before and after the SQL. In a procedural approach you'd have to either build a single routine where you pass in the...- myearwood
- Forum: Microsoft: FoxPro
-
Correct usage of BETWEEN
The BETWEEN function should be used in all non SQL situations in VFP. In all SQL avoid the use of the BETWEEN() function as it will make it harder for you to do straight SQL outside of VFP. While this is possible SELECT * FROM TABLE WHERE BETWEEN(DATEFIELD,ONEDATE,ANOTHERDATE) this is...- myearwood
- Forum: Microsoft: FoxPro
