>>>lcFolder = "H:\TEMP\sdffiles" >>>lcSdfFile = "tempsdf.txt" >>>lcSchemaFile = "schema.ini" >>> >>>* Create test SDF file >>>TEXT TO lcStr NOSHOW >>>AAAAA00005555BBBBBB >>>CCCCC00003556CCCCCC >>>QREWW00432445GFDGDF >>>ENDTEXT >>>STRTOFILE(lcStr, lcFolder + "\" + lcSdfFile) >>> >>>* Create Column definition for the ODBC driver >>>TEXT TO lcStr TEXTMERGE NOSHOW >>>[<<lcSdfFile>>] >>>ColNameHeader = False >>>Format = FixedLength >>>MaxScanRows=0 >>>CharacterSet=OEM >>>Col1 = FLD01 char width 5 >>>Col2 = FLD02 char width 8 >>>Col3 = FLD03 char width 6 >>>ENDTEXT >>> >>>STRTOFILE(lcStr, lcFolder + "\" + lcSchemaFile) >>> >>>lcConnStr = "DRIVER={Microsoft Text Driver (*.txt; *.csv)};DBQ=" + lcFolder + ";" >>>lnConn = SQLSTRINGCONNECT(lcConnStr) >>>IF lnConn < 0 >>> * Error >>> =AERROR(laError) >>> ? ALLTRIM( laError[1,2] ) >>> RETURN >>>ENDIF >>> >>>oCA = CREATEOBJECT("CursorAdapter") >>>oCA.DataSourceType = "ODBC" >>>oCA.DataSource = lnConn >>>oCA.SelectCmd = "SELECT * FROM " + lcSdfFile >>>oCA.Alias = "crsSdfText" >>>oCA.CursorFill() >>>BROWSE >>>>>>