How to create a table with a macro?

[Krankenstein]

I can't figure out how to create a new table using a StarBasic macro. The following code worked for sending a SELECT query to the dbase, but it won't let me send a CREATE TABLE query.

[dfrench]

what you can do will be dependent on the capabilities of the connection (odbc, jdbc etc) and database type. what are you using? can you do the sql create table from the data source interface of OOo client?

[Krankenstein]

If I create a SQL query manually, it doesn't work either. It says "No data can be loaded" "No Select statement". It's the standard database type (dBase). I can try changing that. But what would otherwise be the procedure for creating a table? I can't find it in the basic macro programming guide. What other sources can I use?

edit: Using other databases has no effect. Exactly the same error

edit2: the error message I mentioned is what I get when I try to execute a query manually. If I do it with my macro it keeps saying:

[Krankenstein]

Now it won't even execute an INSERT query. The query is roughtly as follows (using other values):

INSERT INTO table1 (col1, col2, col3, col4, col5, col6) VALUES ("Something", "", "123456", "Somename", "Some short scentence.", "")

The error:

Type: com.sun.star.sdbc.SQLException
Message: Function sequence error.

Never mind used " instead of '. Now it works (well the INSERT query that is, the other one still won't do anything

edit: I tried different query syntaxes, and I get different error messages:

CREATE TABLE Table1 (row1 VARCHAR, row2 VARCHAR)

gives me the message: syntax error, unexpected NAME

and this: CREATE TABLE 'whatever' (row1 VARCHAR, row2 VARCHAR)

gives me the message: syntax error, unexpected STRING, expecting NAME

I don't get it why is it torturing me?
_________________
For I Am Evil

[Noelson]

Hi,

This code works for me. More info in Dev Guide section 12.4.3.

[Krankenstein]

Thanks it works .
_________________
For I Am Evil