Re: [NF] What would you miss from VFP, when migrating

On Thu, 27 Jun 2019, at 9:10 PM, Paul H. Tarver wrote:

I use TEXT/ENDTEXT to create dynamic SQL Queries by merging static text and dynamic variables, then pass the resulting string to SQLEXECUTE. Very convenient when creating large query strings.

var table = "mytable"; var myfield = "field1"; var myvalue=100; var cmd = $"select {myfield} from {mytable} where value={myvalue}";

Of course when you do this properly using SQL parameters then it will look different :)