Re: How to convert this mysql syntax - Mailing list pgsql-odbc

> I thought that SQL was nomalized but when I tried this wmysql code

SQL is mostly normalized, but every database seems to bring in its own
incompatibilities.
>
> With PostGreSQL it doesn't work.

It is probably a MySQL extension.

>
>
>
>
>
> //Select database
>
>
>
> m_pDb.Execute( "USE dbBornes;" );

Try:
m_pDb.Execute( "connect dbBornes;" );

>
>
>
> // Create table
>
> csSql.Format( "CREATE TABLE %s(", m_DbTable );
>
> csSql += _T( "UserID     INTEGER    NOT NULL AUTO_INCREMENT,"    );
>
> csSql += _T( "Time       DATETIME  NOT NULL,"  );
>
> csSql += _T( "NumSerie   INTEGER    NOT NULL," );
>
> csTmp.Format( "%s VARCHAR(64),", im->first );
>
> csSql += _T( "PRIMARY KEY(UserID))" );
>
>