If a select statement is executed against an empty sqlite database, will the result be a null or will it throw an exception?

Question

1.00/5 (1 vote)

See more:

If a select statement is executed against an empty sqlite3 database, will the result be a null or will it throw an exception?
I kind find anything in the documentation that says something explicit about this and it is very important to me.

Posted 17-Nov-14 3:22am

Gbenbam

Add a Solution

Comments

DamithSL 17-Nov-14 9:33am

why don't you try?

Maciej Los 17-Nov-14 10:48am

What you mean by 'empty database'?

Gbenbam 17-Nov-14 11:11am

sorry.I meant an empty table.

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Accepted Answer · 2014-11-17T04:51:00

Solution 1

Please, read my comment to the question.

If by saying database, you mean table, you'll get NULL. If by saying database you mean database (there is no table), you'll get an exception.

Posted 17-Nov-14 4:51am

Maciej Los

Comments

Gbenbam 17-Nov-14 11:10am

sorry i meant a table.Thanks.

Maciej Los 17-Nov-14 12:07pm

You're welcome ;)

If a select statement is executed against an empty sqlite database, will the result be a null or will it throw an exception?

1 solution

Solution 1

Add your solution here

Preview 0

If a select statement is executed against an empty sqlite database, will the result be a null or will it throw an exception?

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us