EasySQL4Fox - helps tie FoxPro and SQL Server together

   Full manual

FoxPro + SQL Server. EasySQL4Fox functions

Update Visual FoxPro syntax to SQL Server syntax

 

EasySQL4Fox features - 1.18

 

1.18. Default values of fields and NOT NULL directives will be defined in CREATE statements. The only requirement is that you insert a tilde ("~") before each type definition and use the E_SQL_Create_Stru_Convert function.

For example: 

str = [CREATE TABLE #TEMP (] ;
+ E_SQL_Create_Stru_Convert( [IDENT ~C(10), CODE ~C(10), NAME ~C(100)]) + [)] )
will be converted to this: 
str = [CREATE TABLE #TEMP (] ;
+ [IDENT CHAR(10) DEFAULT '' NOT NULL,CODE CHAR(10) DEFAULT '' NOT NULL,NAME CHAR(10) DEFAULT NULL] )

 

back to features list

 

 HotLog

Download EasySQL4Fox for your consideration or order a copy of EasySQL4Fox.