How to set data type when creates sql table?

[belotrei]

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.

 

[JJM]

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

 

[belotrei]

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]

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.

 

[belotrei]

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