@Martin How Do I specify the Schema in MSSQL
if the current user does NOT have a default Schema set up, then creating a table creates the table in that users own schema.
How do I force Dataflex to create a table in the [dbo] schema?
Code:
Structure_Start hFile "MSSQLDRV"
Set_Attribute DF_FILE_PHYSICAL_NAME of hFile to (fullFilename(Self, sIntFile))
Set_Attribute DF_FILE_RECNUM_TABLE of hFile to False
Set_Attribute DF_FILE_LOGIN of hFile to "DFCONNID=DBE_Etherial"
Set_Attribute DF_FILE_TABLE_NAME of hFile to (psFilename(Self))
Set_Attribute DF_FILE_USE_DUMMY_ZERO_DATE of hFile to True
Set_Attribute DF_FILE_IS_SYSTEM_FILE of hFile to False
Michael Mullan.
Danes Bridge Enterprises.
++++++++++++++++++++++++++++
There is just today. Tomorrow is a concept
that is mostly theoretical. -- GM Wylie
++++++++++++++++++++++++++++