c++/api marco problem bei query.update()

[Joerg Geistmann]

hello!

if i use the update funktion like:

// stock macro
sql_create_5(	stock, 1, 5,
			string, item,
			int, num,
			double, weight,
			double, price,
			string, sdate)

// create an empty stock object
stock row;
...

query << "select * from stock where item = 'Pommes'";

Result res = query.store();

row = res[0];

stock row2 = row;

// now change num
row.num  = 999;

query.update(row2, row);

cout << "Query : " << query.preview() << endl;

query.execute();

i get this:

Query : UPDATE stock SET item = Pommes,num = 999,weight = 0.5,price =
1.99,sdate = 2001-11-11 WHERE item = Pommes
Error: Unknown column 'Pommes' in 'where clause'

the "'" are missing?!
in this case i donīt want to set all fields ;-)
where is the problem?
what can i do?

thanks a lot!

joerg


---
Infos zur Mailingliste, zur Teilnahme und zum An- und Abmelden unter
-->>  http://www.4t2.com/mysql