|
1.16. A CREATE TABLE command will convert FoxPro types
definition into MS SQL types.
Insert a ~ character before each type definition and use the E_SQL_Create_Stru_Convert function like this:
= SQLExec(connection, ;
[Create Table #temp (] + E_SQL_Create_Stru_Convert( [IDENT ~C(10),CODE ~C(10),NAME ~C(100)] ) + [)] )
which will return this:
IDENT CHAR(10) DEFAULT '' NOT NULL,CODE CHAR(10) DEFAULT '' NOT NULL,NAME CHAR(10) DEFAULT NULL
back
to features list
|
