>>I've discussed this problem with my manager and we decided, that the Data Entry file (for Transaction & Credit information) doesn't need to have memo field, while LOG file will have memo field. We don't process ItemDesc field the same way, we used to process it in the past.
>>
>>So, once again: good catch and many thanks to you.
>
>I've been bitten with this one before. While using extensions ending with x does create memos ending with t (create form frm.tcx will create memo file frm.tct), create table blah.lgx didn't produce blah.lgt, but blah.fpt. Thus, you can't have two dbfs with the same name if both should have memos and/or indexes.
>
>Enjoy the long file names - simply extend the stem of the first one with _log or .log: Create Table "blah.log.dbf" creates "blah.log.fpt" as well; juststem("blah.log.dbf") still returns the regular "blah.log" so that would make no confusion.

I suggested this idea as alternative, but my manager just told me, that the main file would not have memo field. Well, hopefully it's an end of story.

BTW, I got another problem (alredy solved), which I spent ~ 30 minutes.
The long select statement gave me an error Invalid argument...
I correctly suspected this line:

ctot(dtoc(SALEDATE)+SALETIME) as SaleDateTm

The file didn't contain records.

I changed it to:
iif(empty(SALEDATE),ctot(''),ctot(dtoc(SALEDATE)+SALETIME)) as SALEDATETM

to solve this problem...