SQLite problem
#4

it wont give an error if sql syntax is wrong,

post what you changed,

heres how i insert!

pawn Код:
//first i build my values to insert
format
    (
        Query_Values,
        sizeof(Query_Values),
        "'%i','%f','%f','%f','%f','%f','%f'",
        gDBObjs[objectid][E_DB_OBJ_MODEL],
        gDBObjs[objectid][E_DB_OBJ_X],
        gDBObjs[objectid][E_DB_OBJ_Y],
        gDBObjs[objectid][E_DB_OBJ_Z],
        gDBObjs[objectid][E_DB_OBJ_RX],
        gDBObjs[objectid][E_DB_OBJ_RY],
        gDBObjs[objectid][E_DB_OBJ_RZ]
    );
//then i build a query and  append my Values from above to it
    format(Query, sizeof(Query), "INSERT INTO OBJS (`MODEL`,`X`, `Y`, `Z`, `RX`, `RY`, `RZ`) VALUES(%s)", Query_Values);
Reply


Messages In This Thread
SQLite problem - by Danijel. - 24.06.2012, 14:22
Re: SQLite problem - by Jonny5 - 24.06.2012, 15:09
Re: SQLite problem - by Danijel. - 24.06.2012, 15:16
Re: SQLite problem - by Jonny5 - 24.06.2012, 15:19

Forum Jump:


Users browsing this thread: 1 Guest(s)