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

From vincent.richomme@ratp.fr
Subject How to convert this mysql syntax
Date
Msg-id E23B4EE4F2A6F44B8660AA8723D0B82B012E18BC@nyplme19.neuilly.ratp
Whole thread Raw
Responses Re: How to convert this mysql syntax  (markw@mohawksoft.com)
List pgsql-odbc

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

With PostGreSQL it doesn’t work.

 

 

//Select database

 

m_pDb.Execute( "USE 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))" );

pgsql-odbc by date:

Previous
From: Christof Glaser
Date:
Subject: Re: not possible to create a database
Next
From: "Gastón Gordillo"
Date:
Subject: ODBC DLL register