Anyone knows how to use SQL object?

[Locaz00]

i can basicaly use it, the only thing i can't do is create a column inside a table... y can create a table but empty.. anyone knows how? (srry about my english).. tnx so much ^^

[byo]

Normally you'd create a table like this:

CREATE TABLE tablename( Code int, Description varchar(256))

[byo]

Suppose that you wish to add a field later, you'd do like this:

ALTER TABLE tablename ADD newfieldname varchar(256)

Hope that helps.

[Corentin]

If you are using SQLite, Alter table doesn't work. But most SQL queries work like in any other db, i don't see any problem for filling your tables.

[byo]

ALTER TABLE does work in SQLite. There is a minor difference or two but it does work.

More here.

[Locaz00]

Nope, it's not working... SQLite for MMF2 doesn't support ALTER and i don't know how to create a column inside a table.. can't understand the parameters right. Can anyone please make an example that helps me understand this thing? Tnx a lot guys!! ^^

[DanielRehn]

I'm no expert when it comes to SQLite but this might be of help!
http://www.sqlite.org/lang_altertable.html

[Locaz00]

Thank you Daniel, but the MMF version for SQLite doesn't support the ALTER command.. tnx anyway ^^

[DanielRehn]

If the extension is based on SQLite, it should!
I don't think SQLite supports any other method to add columns to a table...

[Locaz00]

Hi again, ok.. if you can create a colum into a tab, please make an example and i'll apreciate it a lot ^^ ... ( again.. srry about my english.. >_< )