How to set data type when creates sql table?

Discussion in 'Questions (Windows Mobile)' started by belotrei, Jun 5, 2007.

  1. belotrei

    belotrei Member

    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.

  2. JJM

    JJM Active Member Licensed User

  3. belotrei

    belotrei Member

    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..
  4. Erel

    Erel Administrator Staff Member Licensed User

    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.
  5. belotrei

    belotrei Member

    Thanks Erel. Its solved now... :sign0060:
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice