Hi friends,
While i am writing data into the table the values are not storing
in a single records, instead the values are storing in improper order.
I am adding the values to the table as,
query = "insert into ONTTable (slotId) values (?1);";
sqlite3_prepare_v2(db,query,strlen(query)+1, &stmt, NULL);
sqlite3_bind_int(stmt,1,ontTable -> slotId);
sqlite3_step(stmt,DONE);
query = "insert into ONTTable (ponChannelId) values (?);";
sqlite3_prepare_v2(db,query,strlen(query)+1, &stmt, NULL);
sqlite3_bind_int(stmt,1,ontTable -> ponChannelId);
sqlite3_step(stmt,DONE);
query = "insert into ONTTable (onuType) values (?);";
sqlite_prepare_v2(db,query,strlen(query)+1, &stmt, NULL);
sqlite3_bind_int(stmt,1,ontTable -> ontType);
sqlite3_step(stmt,DONE);
query = "insert into ONTTable (onuId) values (?);";
sqlite3_prepare_v2(db,query,strlen(query)+1, &stmt, NULL);
sqlite3_bind_int(stmt,1,ontTable -> onuId);
sqlite3_step(stmt,DONE);
query = "insert into ONTTable (adminStatus) values (?);";
sqlite3_bind_prepare_v2(db,query,strlen(query)+1, &stmt, NULL);
sqlite3_bind_int(stmt,1,ontTable -> adminStatus);
slotId ponChannelId onuType onuId
adminStatus
1
2
3
4
5
Can any one tell me how i can get all values at one record.
Regards
Bhaskar Reddy
--
View this message in context:
http://old.nabble.com/All-values-of-a-fields-are-not-stored-in-the-single-record.-tp33147362p33147362.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
