Where are the errors , I can't find them, anyone can help me?

[Miguel_Silva]

I can’t find the erros on Query, anyone can help me?
This is my Query:

CREATE TABLE IF NOT EXISTS products ( id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, gr INTEGER DEFAULT 1, store TEXT, barcode TEXT, product TEXT, price TEXT, reg_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP );

Errors:

here image of blocks

[Deepanshu_Arya]

in your “Select” procedure which column you want to select? you are passing create empty list in column and i think which is not acceptable, there must be list of column names which you want to query upon or if you need to select all than use “*”
Can you live test your project using companion and while live testing right click on “Select” procedure and click on “Do it”

[Miguel_Silva]

Hi, this blocks is based on an .aia project that I took from here, and works well on other situation, I see I can’t create table.
this is my .ais where presents errors

SQLite_Pechi_addStories.ais (508 Bytes)

[Miguel_Silva]

Now It’s Working, the problem was I changed the table. and forgot DROP to CREATE again with changes.
I din’t know when I am using Compaing tables remain.