SQL RESULT SET FOR LONG FIELDS

[mnolting]

If you perform a query on a MS Access table where a field is 255 in size, the resulting view will create a memo field for the field in the query. EG
Table name "LOGDATA"
Fields "Start","Stop","Notes"
=SQLEXEC(1,"SELECT * FROM LOGDATA","MYVIEW&quot
BROW
You will see 3 fields in the table view with the fields named the same as the Access table , Except for the "Notes" field which will be named "EXPR1000". That field will be a Memo field.
OK, the solution is to use MID(Field,start,end)
=SQLEXEC(1,"SELECT START,STOP,MID(NOTES,1,15) FROM LOGDATA","MYVIEW&quot
Even though you will get only the first 15 characters, you still get a 255 character memo field.
WHY?

 

[raskew]

It sounds as though you're attempting to manipulate Access tables with xBase (FoxPro, maybe) commands. A little more info would be helpful.