bheyde
11/3/2014 - 8:16 PM

Sample Create Table

Sample Create Table

<MvQUERY NAME	= "Merchant"
		QUERY	= "{ 'CREATE TABLE ' $  g.Store_Table_Prefix $ 'CFM_CatFields
						  (
							id			' $ [ g.Module_Library_Native_DBAPI ].DB_Type_NUMBER( 0, 0 ) 	$ ',
							group_id	' $ [ g.Module_Library_Native_DBAPI ].DB_Type_NUMBER( 0, 0 )	$ ',
							code		' $ [ g.Module_Library_Native_DBAPI ].DB_Type_CHAR( 50 ) 		$ ',
							name		' $ [ g.Module_Library_Native_DBAPI ].DB_Type_CHAR( 100 ) 		$ ',
							fieldtype 	' $ [ g.Module_Library_Native_DBAPI ].DB_Type_CHAR( 20 ) 		$ ',
							info		' $ [ g.Module_Library_Native_DBAPI ].DB_Type_MEMO()			$ '
						  ) ' }">
						  
<MvIF EXPR = "{ g.MvQUERY_Error }">
	<MvFUNCTIONRETURN VALUE = "{ [ g.Module_Library_Utilities ].Error( 'MER-UTL-CST-00043', g.MvQUERY_Error ) }">
</MvIF>