CLOSE DATABASES all CLEAR SET MULTILOCKS ON CREATE CURSOR foo (f1 I) INSERT INTO foo VALUES (1) INSERT INTO foo VALUES (2) LOCAL oCA as CursorAdapter oCA = CREATEOBJECT("CursorAdapter") oCA.DataSourceType="NATIVE" ? "try with macro" lcSQLWhere = "f1 = 1" oCA.SelectCmd="SELECT * FROM foo WHERE &?lcSQLWhere" ?[oCA.SelectCmd],oCA.SelectCmd ?[oCA.CursorFill()],oCA.CursorFill() SELECT (oCA.Alias) LIST lcSQLWhere = "f1 = 2" ?[REQUERY()],REQUERY() LIST ? "try with parameter with '?'" nF1=1 oCA.SelectCmd="SELECT * FROM foo WHERE f1=?nF1" && will prompt for parameter if it can not be found ?[oCA.SelectCmd],oCA.SelectCmd ?[oCA.CursorFill()],oCA.CursorFill() SELECT (oCA.Alias) LIST nF1=2 ?[REQUERY()],REQUERY() LIST ? "try with parameter without '?'" nF1=1 oCA.SelectCmd="SELECT * FROM foo WHERE f1=nF1" && will not prompt for parameter if it can not be found ?[oCA.SelectCmd],oCA.SelectCmd ?[oCA.CursorFill()],oCA.CursorFill() SELECT (oCA.Alias) LIST nF1=2 ?[REQUERY()],REQUERY() LISTThanks,