OpenBase support requires that the OpenBase client libraries be installed. They are available free of charge from the OpenBase website.
The OpenBase Framework for Mac OS X has a known problem when creating tables. When you use MacSQL's table tool to create a new table in your OpenBase database, OpenBase automatically creates a _rowid column which it uses as its default primary key for a table. The problem is that it does not automatically make the _rowid a primary key for the table. This issue causes problems later on, since MacSQL will only edit a table that has a valid primary key.
This issue can be resolved by manually setting _rowid as the primary key on a table you created
using the MacSQL table tool. Simply go to the Query Maker tab in MacSQL after using the Create Table Tool to create your table.
In the text box, enter the following query, replacing tableName with the name
of the table you just created:
CREATE PRIMARY KEY tableName (_rowid)
Press the Make Query button to execute the command. It should respond with the following:
CREATE PRIMARY KEY tableName (_rowid)
1 row touched.
This will set _rowid as the primary key, allowing MacSQL to make the table editable in the spreadsheet view.