How to set data type when creates sql table?

B

belotrei

Member

• Jun 5, 2007

• #1

Code:
Con.CreateSQLTable ("Table1","mastertablename")

What is the syntax that needed to be added to the code above if i want to set the data type of certain column when making sql table?
Ex: i want to set "number" column to numeric.

So i don't have to reedit the data type of column anymore with third-party application.

Thanks.

 

J

JJM

Active Member

Licensed User

Longtime User

• Jun 5, 2007

• #2

Hi,

http://www.w3schools.com/sql/sql_intro.asp this link is very usefull to understand how to use of SQL library.

Best regards

JJ M

 

B

belotrei

Member

• Jun 5, 2007

• #3

Thanks JJM, i've already know this site.. and see the sqlcreate syntax.

but dont know how to put the syntax to the b4ppc syntax..

 

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Jun 5, 2007

• #4

CreateSQLTable will convert all cString columns to TEXT columns and all cNumber columns to REAL columns.
You should create the right types when you create the table.
If you are loading CSV files then you can first create the columns (with their types) and then load the data.

 

B

belotrei

Member

• Jun 5, 2007

• #5

Thanks Erel. Its solved now... :sign0060: