[AccessD] [EXTERNAL] Re: Option Groups in continuous forms break SQL Execute: (MULTI-ROW FETCH)?

[Ryan W]

Here is a trace of the 4 forms opened one after another:

*--BEGIN FORM 1--*

SQLExecDirect: SELECT Config, nValue FROM MSysConf

SQLExecDirect: SELECT "dbo"."tblTEST"."ID" FROM "dbo"."tblTEST"

SQLPrepare: SELECT "ID","DummyData"  FROM "dbo"."tblTEST"  WHERE "ID" = ?

SQLExecute: (GOTO BOOKMARK)

SQLPrepare: SELECT "ID","DummyData"  FROM "dbo"."tblTEST"  WHERE "ID" = ?
OR "ID" = ? OR "ID" = ? OR "ID" = ? OR "ID" = ? OR "ID" = ? OR "ID" = ? OR
"ID" = ? OR "ID" = ? OR "ID" = ?

SQLExecute: (MULTI-ROW FETCH)

SQLExecute: (MULTI-ROW FETCH)

SQLExecute: (MULTI-ROW FETCH)

SQLExecute: (MULTI-ROW FETCH)

*--END FORM 1--*

*--BEGIN FORM 2--*
SQLExecDirect: SELECT "dbo"."tblTEST"."ID" FROM "dbo"."tblTEST"

SQLPrepare: SELECT "ID","DummyData"  FROM "dbo"."tblTEST"  WHERE "ID" = ?

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)



*--END FORM 2----BEGIN FORM 3--*

SQLExecDirect: SELECT "dbo"."tblTEST"."ID" FROM "dbo"."tblTEST"

SQLPrepare: SELECT "ID","DummyData"  FROM "dbo"."tblTEST"  WHERE "ID" = ?

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)

SQLExecute: (GOTO BOOKMARK)



*--END FORM 3----BEGIN FORM 4--*

SQLExecDirect: SELECT "dbo"."tblTEST"."ID" FROM "dbo"."tblTEST"

SQLPrepare: SELECT "ID","DummyData"  FROM "dbo"."tblTEST"  WHERE "ID" = ?

SQLExecute: (GOTO BOOKMARK)

SQLPrepare: SELECT "ID","DummyData"  FROM "dbo"."tblTEST"  WHERE "ID" = ?
OR "ID" = ? OR "ID" = ? OR "ID" = ? OR "ID" = ? OR "ID" = ? OR "ID" = ? OR
"ID" = ? OR "ID" = ? OR "ID" = ?

SQLExecute: (MULTI-ROW FETCH)

SQLExecute: (MULTI-ROW FETCH)

SQLExecute: (MULTI-ROW FETCH)

SQLExecute: (MULTI-ROW FETCH)

*--END FORM 4--*