On 12/5/2013 4:31 PM, Hayden Livingston wrote:
--> End Goal:
A SQL Table:
FooId,SomeStringValue,SomeIntValue,SomeOtherColumn,WhateverColumnNameItNeedsTo,
You do not want a table with an open-ended set of columns - SQL doesn't
work that way. You want a fixed schema; let the number of rows be
open-ended. Something like this:
ComponentId, OperationId, ColumnName, Value
See also
http://en.wikipedia.org/wiki/Entity%E2%80%93attribute%E2%80%93value_model
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users