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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.