some questions on sql

cirollo · Jan 8, 2012

Posted a new discussion, today the search function seems not working :-(

by the way, just some questions:

1) which is the correct syntax for creating a table with a two column index?
looked at some examples but I don't know how to made it.
I'm using:

DBUtils.CreateTable(SQL1, "Listini", m, "Seriale")

to create the table

2) how can I define numeric columns in the db (I need float, not integer because there are decimals!)?
I'm using:

m.Put("ImpUni", DBUtils.DB_TEXT)

this should be a numeric value

3) how can I get the numeric value from a string, also with decimal places?

thanks!
cirollo

Erel · Jan 8, 2012

1) See SQLite CREATE INDEX documentation: SQLite Query Language: CREATE INDEX
After creating the table you should use:

B4X:

SQL1.ExecNonQuery("CREATE INDEX index1 ON table1 (col1, col2)")

2) Use DBUtils.DB_REAL
3)

B4X:

Dim s As String
s = "3.4"
Dim d As Double
d = s 'strings are parsed automatically

cirollo · Jan 8, 2012

thank you Erel!

just another question

if i set the column real type, do I have to specify how many decimals are present?

sorry, I come from Sql where I put myfield N(10,2) for a numeric field with 2 decimals....

thanks!!!

:icon_clap:

Erel · Jan 9, 2012

if i set the column real type, do I have to specify how many decimals are present?

No.

You can see more information about the supported data types here: Datatypes In SQLite Version 3

some questions on sql

cirollo

Active Member

Erel

B4X founder

cirollo

Active Member

Erel

B4X founder

some questions on sql

cirollo

Active Member

Erel

B4X founder

cirollo

Active Member

Erel

B4X founder

Privacy & Transparency

Privacy & Transparency