void Test::remove_person(void)
{
    StringBuffer sql;
    Sql stmt(db_session);

    sql << "DELETE FROM person ";
    sql << "WHERE id = ?";

    try
    {
        stmt.SetStatement(sql);
        stmt.SetParam(0, sql_person(0));

	stmt.ExecuteX();
    }
    catch (const SqlExc& e)
    {
        sql_person.CancelRemove();
        Exclamation("[* " + DeQtfLf(e) + "]");
    }
}

#if 1
	sql.SetParam(0, cat.GetKey());
	sql.Execute("select ID, TEXT from ITEM_TYPE where ITEM_CATEGORY_ID = ? order by TEXT");
#else
	SqlBool wh;
	if(!IsNull(cat.GetKey()))
		wh = ITEM_CATEGORY_ID == cat.GetKey();
	sql * Select(ID, TEXT).From(ITEM_TYPE).Where(wh).OrderBy(TEXT);
#endif

void Test::remove_person(void)
{
    try
    {
        SQL.SetParam(0, sql_person(0));
	SQL.ExecuteX("DELETE FROM person WHERE id = ?");
    }
    catch (const SqlExc& e)
    {
        sql_person.CancelRemove();
        Exclamation("[* " + DeQtfLf(e) + "]");
    }
}

void Test::remove_person(void)
{
    static Sql stmt("DELETE FROM person WHERE id = ?");

Sql sql1, sql2;
sql1 * Select(ID).From(DATA).Where(mycondition);
while(sql1.Fetch())
   sql2 * Update(DATA)(FIELD, value).Where(ID == sql1[ID]);

void Benchmark()
{
	Sql sql;
	sql * Select(ID).From(SUBJECT);
	Vector<int> id;
	while(sql.Fetch())
		id.Add(sql[0]);
	for(int i = 0; i < id.GetCount(); i++) {
		RTIMING("Unprepared");
		sql % Select(TEXT).From(SUBJECT_ATTR).Where(ATTR == "NAME" && SUBJECT_ID == id[i]);
	}
	sql.SetStatement("select TEXT from SUBJECT_ATTR where ATTR = ? and SUBJECT_ID = ?");
	for(int i = 0; i < id.GetCount(); i++) {
		RTIMING("Prepared");
		sql.Run("NAME", id[i]);
		sql.Fetch();
	}
}



TIMING Prepared       : 79.99 ms - 273.94 us (80.00 ms / 292 ), min:  0.00 ns, max:  1.00 ms, nesting: 1 - 292
TIMING Unprepared     : 483.99 ms -  1.66 ms (484.00 ms / 292 ), min:  0.00 ns, max: 15.00 ms, nesting: 1 - 292

void Test()
{
	Sql sql;
	sql * Select(ID).From(SUBJECT);
	Vector<int> id;
	while(sql.Fetch())
		id.Add(sql[0]);
	sql.SetStatement("select TEXT from SUBJECT_ATTR where ATTR = ? and SUBJECT_ID = ?");
	for(int i = 0; i < id.GetCount(); i++) {
		sql.Run("NAME", id[i]);
		if(sql.Fetch()) {
			DDUMP(sql[0]);
			SQL * Update(SUBJECT_ATTR)(ORG_ID, -1).Where(ID == id[i]);
		}
	}
}