SQLite COUNT()
#9

Change to:
pawn Код:
format(Query, sizeof(Query), "UPDATE HOUSES SET NAME = 'Grad', FOR_SELL = 1, SELL_PRICE = %d, RENTPRICE = 1000, HOUSE_LEVEL = %d, X = %f, Y = %f, Z = %f, VIRTUALWORLD = &d, STATUS = 0 WHERE ID = %d", sellprice, HouseLvl, X, Y, Z, ID, ID);
db_query(Database, Query);
print(Query); // DEBUG!
Also make sure the names of the fields are correct. If it's "SELLPRICE" instead of "SELL_PRICE" (en example) will fail to update.
Reply


Messages In This Thread
SQLite COUNT() - by Danijel. - 07.07.2013, 19:33
Re: SQLite COUNT() - by Jefff - 07.07.2013, 19:46
Re: SQLite COUNT() - by ReVo_ - 07.07.2013, 19:48
Re: SQLite COUNT() - by Danijel. - 07.07.2013, 20:03
Re: SQLite COUNT() - by Konstantinos - 07.07.2013, 20:10
Re: SQLite COUNT() - by Danijel. - 07.07.2013, 20:31
Re: SQLite COUNT() - by Konstantinos - 07.07.2013, 20:38
Re: SQLite COUNT() - by Danijel. - 07.07.2013, 20:53
Re: SQLite COUNT() - by Konstantinos - 07.07.2013, 20:59
Re: SQLite COUNT() - by Danijel. - 07.07.2013, 21:00

Forum Jump:


Users browsing this thread: 4 Guest(s)