Hi -
No idea if I should be concerned about this, but here goes anyway. SQL Express 2008, VDF 15.1 running on Win 7 Ultimate.
I've converted a System File to SQL Express. As with all converted, I did not convert Recnums.
SQL Exp. shows no Recnum field, Table Explorer & DBBuilder don't either. However, even after making a change to the table, the FD file still shows a Recnum field. On top of that, the INT file starts with field #8, instead of #1 like all the others.
I can save fields in the table & everything seems OK, but this doesn't seem right.
Table Explorer:
FD:
Code:
#REPLACE FILE1 SysFile
#REPLACE SysFile.Recnum |FN1,0
#REPLACE SysFile.CompanyName |FS1,1
#REPLACE SysFile.Address |FS1,2
etc.
Int:
Code:
DRIVER_NAME MSSQLDRV
SERVER_NAME SERVER=GARRET-PC\SQLEXPRESS;Trusted_Connection=yes;DATABASE=Yankee
DATABASE_NAME SYSFILE
SCHEMA_NAME dbo
SYSTEM_FILE YES
TABLE_CHARACTER_FORMAT ANSI
USE_DUMMY_ZERO_DATE YES
FIELD_NUMBER 8
FIELD_LENGTH 6
FIELD_NUMBER 9
FIELD_LENGTH 6
etc.
Any input appreciated -