*-- for example to build a SQL SELECT command dynamically in VFP, we need something like this: MyField = "Id" MyTable = "FoxUser" MyWhere = " WHERE Id LIKE 'WIND%'" SELECT &MyField FROM (MyTable) &MyWhere *-- however, when we use SPT, we can build the SQL command and pass the *-- string to SQLEXEC(): *-- build the SQL command lcSqlCommand = "SELECT " + MyField + " FROM " + MyTable + " " + MyWhere SQLEXEC(lnSQL, lcSqlCommand) *-- same approach with ADO: ioRecordSet.Open(lcSqlCommand, This.ioConnection, adOpenDynamic, adLockOptimistic)It would be nice if we could use SQLEXEC() against local data.
>local lcSql > >lcSql = "SELECT * FROM Claim " ; > + "WHERE Claim_Status = 'PAID' " > >if !empty(ThisForm.txtProviderNumber.Value) > lcSql = lcSql + "AND Provider_Number = " ; > + ltrim(str(ThisForm.txtProviderNumber.Value)) >endif > >&lcSql INTO CURSOR csrClaimData>