12.02.2013, 08:08
You don't see the problem in your query output?
Missing a comma there between obj2r and obj559x.
You could vastly reduce the amount of columns in your table by putting all data from a single object into a column. So that a single column holds the objects - "objectid x, y, z, rx. ry. rz" and anything else you might need. Then split the data when you retrieve it. This also makes your code much more manageable.
This way you can have many many more objects per house without having to do HUGE queries.
SQLite can handle a lot of columns per table, but it's not good practice to do so.
pawn Код:
`Obj2Rx`,`Obj2R`Obj599X`,
You could vastly reduce the amount of columns in your table by putting all data from a single object into a column. So that a single column holds the objects - "objectid x, y, z, rx. ry. rz" and anything else you might need. Then split the data when you retrieve it. This also makes your code much more manageable.
This way you can have many many more objects per house without having to do HUGE queries.
SQLite can handle a lot of columns per table, but it's not good practice to do so.