lcSQL=[SELECT * FROM CUSTSTATUS] CREATE SQL VIEW V_test AS ; &?lcSQLgives me a
SQL SELECT statement is invalidin VFP7. VFP8 give a different error.
CREATE SQL VIEW V_test AS ; SELECT * FROM CUSTSTATUSworks fine. Didn't get as far as a remote view.
>MyCommand = "Create sql view..."
>&MyCommand
>>>CREATE SQL VIEW V_STATUSMON AS ; >>SELECT Invcont.*, ; >> FROM wots!invcont ; >> WHERE &?lcWhere ; >> ORDER BY lastaction, Custstreet, Custflatnum, our_ref >>>>This enables me to search on any combination of fields I choose, which is really neat and I can do the same thing with the order if I choose.