SQLite

Scriptcase 8 Discussion
#1

Hello,

I try to test sc with SQLite database.
I created a database with database builder and put into a table named “posart” , and make the connection.
I make a new form application without any problem, I see all fields etc…
When I run to test the form app, I have this error message :

(pdo-sqlite): SELECT count(*) from posart [HR][/HR]HY000: no such table: posart

Something is missing but what ??
Can any anyone help me ?

Thanks
Nac

#2

Are there any sub queries, grouping statements or count, average, etc. in your sql statement?
ScriptCase does not fare well with these.

Also double check any special use of quotes which might create problems when the query is created by SC.

#3

Thanks Frank for answering but it’s just a select count(*) from posart !!!
There is no extra codes in form app, I just created the form without any additional codes.

It must be something else !!

#4

Hrm… but I am still wondering, how can there be a select(*) when it is a form application, or is it grid app?

You can send the SQL create statement for the table and I can try to make a form or grid application with all fields to see how it plays.

#5

It’s a form app with Multiple rows ,

it’s just a simple table with a 3 fields :

IDART int(10) autoincrement
NAMEART varchar(30)
PRICE double(15,2)
Thanks

#6

It works fine for me.
First of all, I had to change the create statement which looks more like MySQL. In SQLite the following works:

create table posart
( IDART integer primary key autoincrement
, NAMEART varchar
, PRICE double
);

I then created a forms app of editable grid view type, executed it directly and created one record.
See attachments.

sc, sqlite-test, 2016-09-26, edit-grid-view.JPG

sc, sqlite-test, 2016-09-26, table-def.JPG

#7

Thanks Frank

I will try it

#8

Table has been created. 19:40:48SQL command
CREATE TABLE “article” ( “IDART” integer NOT NULL PRIMARY KEY AUTOINCREMENT, “NAMEART” text(30) NOT NULL, “PRICE” numeric NOT NULL );

This is what I get ???

SELECT count(*) from article [HR][/HR]
HY000: no such table: article Same error !!!

#9

oooooh !!!

I delete tmp folder’s content and now it works !!!

Thanks Frank for your help
Best regards