SQLite question

[d0n]

Hi, trying to move my ini stuff into SQLite and had a quick question

If i had a database name "Fruits" and it looked like this

Fruit a b c

Apple 17 23 31

Orange 13 43 21

Banana 9 12 32

is it possible to find say, the data from Apple on column b (which would be 23)

I have something like this so far, but it doesn't seem to return the correct one

_SQlite_Query (-1, "SELECT b FROM Fruit ORDER BY Fruit;", $hQuery)
_SQLite_FetchNames ($hQuery, $aNames)
_SQLite_FetchData ($hQuery, $aRow)
ConsoleWrite(@LF&$aRow[0]&@LF)

Also i am not quite sure what Order by really does? if all i want is to find a data in a cell

[leos]

If i had a database name "Fruits" and it looked like this

Fruit a b c

Apple 17 23 31

Orange 13 43 21

Banana 9 12 32

is it possible to find say, the data from Apple on column b (which would be 23)

I have something like this so far, but it doesn't seem to return the correct one

_SQlite_Query (-1, "SELECT b FROM Fruit ORDER BY Fruit;", $hQuery)

...

Also i am not quite sure what Order by really does? if all i want is to find a data in a cell

the query should be:

SELECT b FROM Fruits WHERE Fruit="Apple"

If the result is a single row then the ORDER clause has no meaning

Attention: Fruits is not the database but is the table as a database can have more than a table.

[d0n]

ah i see thanks

quick question, is SQLite faster than ini in terms of searching?

[Zedna]

quick question, is SQLite faster than ini in terms of searching?

Do the tests yourself it's easy.

SQL database is perfect for big amount of data where INI files would be bad choice.

Edited October 23, 2009 by Zedna

[Joec49]

Do the tests yourself it's easy.

SQL database is perfect for big amount of data where INI files would be bad choice.

How does one write to disk using sqlite - I tried and it did nothing....help!

[PsaltyDS]

How does one write to disk using sqlite - I tried and it did nothing....help!

Specify the file name in _SQLite_Open(). If it doesn't exist, a new DB file will be created.

Edited October 27, 2009 by PsaltyDS