Hi Beth,

It's very hard to look at these selects as they're written now. Can you post them using ; for better readability?

>Hi All,
>
> I have this working in one application, but it will error out with invalid operation for Memo. The select statement that works could look like this:
>
>
>SELECT DISTINCT SUP_ACT.ACTION_ID, SUPPRBM.PROBLEM_ID, SUP_ACT.ACT_NOTES, SUP_ACT.NXTACT_NOT, SUPPRBM.PRBLM_DESC, SUPPRBM.CLIENT_ID FROM SUP_ACT, SUPPRBM, CONTACT, WORECS WHERE .F. UNION ALL SELECT DISTINCT SUP_ACT.ACTION_ID, SUPPRBM.PROBLEM_ID, SUP_ACT.ACT_NOTES, SUP_ACT.NXTACT_NOT, SUPPRBM.PRBLM_DESC, SUPPRBM.CLIENT_ID FROM SUP_ACT, SUPPRBM, CONTACT, WORECS WHERE "A" $ UPPER(SUP_ACT.ACT_NOTES) .AND. SUPPRBM.CLIENT_ID = SUP_ACT.CLIENT_ID .AND. SUPPRBM.PROBLEM_ID = SUP_ACT.PROBLEM_ID .AND. SUPPRBM.USER_ID = CONTACT.CONTACT_ID .AND. SUP_ACT.USER_ID = CONTACT.CONTACT_ID .AND. SUPPRBM.CLIENT_ID = WORECS.CLIENT_ID .AND. SUPPRBM.PROBLEM_ID = WORECS.PROBLEM_ID INTO CURSOR QMF_TEMP
>
>
>While the one that does not, underlying code is basicly the same for both, looks like this:
>
>
>SELECT DISTINCT FIELDTRIPINFORMATION.FIELDTRIPID, DRIVERINFORMATION.DRIVERLASTNAME, DRIVERINFORMATION.DRIVERFIRSTNAME, VEHICLEINFORMATION.VEHICLEMAKE, VEHICLEINFORMATION.VEHICLEMODE, VEHICLEINFORMATION.DISTVEHICLEID, FIELDTRIPINFORMATION.APPROVEBY, FIELDTRIPINFORMATION.CLIENTNAME, CLIENTINFORMATION.CLIENTID, FIELDTRIPINFORMATION.CONTACTNAME, CLIENTINFORMATION.ADDRESS1, CLIENTINFORMATION.CLIENTCITY, CLIENTINFORMATION.CLIENTSTATE, CLIENTINFORMATION.CLIENTZIP, CLIENTINFORMATION.CLIENTPHONE, FIELDTRIPINFORMATION.DESTINATIONNAME, CLIENTINFORMATION.DISTCLIENTID, FIELDTRIPINFORMATION.REQUESTPURPOSE, FIELDTRIPINFORMATION.NUMBERSTUDENT, FIELDTRIPINFORMATION.ENDTIME1, FIELDTRIPINFORMATION.ENDDATE, FIELDTRIPINFORMATION.STARTDATE, FIELDTRIPINFORMATION.DEPARTTIME1, FIELDTRIPINFORMATION.ARRIVETIME1, FIELDTRIPINFORMATION.SPECIALNEEDS, FIELDTRIPINFORMATION.NUMBERADULT, FIELDTRIPINFORMATION.ELEMENTARY, DESTINATION.ADDRESS, DESTINATION.CITY, DESTINATION.STATE, DESTINATION.COMMENT,
>VEHICLEINFORMATION.VEHICLETYPE, FIELDTRIPINFORMATION.CONTACTPHONE, FIELDTRIPINFORMATION.INSTRUCTION, FIELDTRIPDRIVER.INSTRUCTION, TFIELDTRIPCLIENTACCOUNT.ACCOUNTNO FROM FIELDTRIPINFORMATION, DRIVERINFORMATION, VEHICLEINFORMATION, CLIENTINFORMATION, DESTINATION, FIELDTRIPDRIVER, TFIELDTRIPCLIENTACCOUNT, FIELDDVTRIPLINK, C:\data\10.1elt\exe\report\printtables\tmptables\FT000001703, C:\data\10.1elt\exe\report\printtables\tmptables\FT000001704, C:\data\10.1elt\exe\report\printtables\tmptables\FT000001705 WHERE .F. UNION ALL SELECT DISTINCT FIELDTRIPINFORMATION.FIELDTRIPID, DRIVERINFORMATION.DRIVERLASTNAME, DRIVERINFORMATION.DRIVERFIRSTNAME, VEHICLEINFORMATION.VEHICLEMAKE, VEHICLEINFORMATION.VEHICLEMODE, VEHICLEINFORMATION.DISTVEHICLEID, FIELDTRIPINFORMATION.APPROVEBY, FIELDTRIPINFORMATION.CLIENTNAME, CLIENTINFORMATION.CLIENTID, FIELDTRIPINFORMATION.CONTACTNAME, CLIENTINFORMATION.ADDRESS1, CLIENTINFORMATION.CLIENTCITY, CLIENTINFORMATION.CLIENTSTATE, CLIENTINFORMATION.CLIENTZIP,
>CLIENTINFORMATION.CLIENTPHONE, FIELDTRIPINFORMATION.DESTINATIONNAME, CLIENTINFORMATION.DISTCLIENTID, FIELDTRIPINFORMATION.REQUESTPURPOSE, FIELDTRIPINFORMATION.NUMBERSTUDENT, FIELDTRIPINFORMATION.ENDTIME1, FIELDTRIPINFORMATION.ENDDATE, FIELDTRIPINFORMATION.STARTDATE, FIELDTRIPINFORMATION.DEPARTTIME1, FIELDTRIPINFORMATION.ARRIVETIME1, FIELDTRIPINFORMATION.SPECIALNEEDS, FIELDTRIPINFORMATION.NUMBERADULT, FIELDTRIPINFORMATION.ELEMENTARY, DESTINATION.ADDRESS, DESTINATION.CITY, DESTINATION.STATE, DESTINATION.COMMENT, VEHICLEINFORMATION.VEHICLETYPE, FIELDTRIPINFORMATION.CONTACTPHONE, FIELDTRIPINFORMATION.INSTRUCTION, FIELDTRIPDRIVER.INSTRUCTION, TFIELDTRIPCLIENTACCOUNT.ACCOUNTNO FROM FIELDTRIPINFORMATION, DRIVERINFORMATION, VEHICLEINFORMATION, CLIENTINFORMATION, DESTINATION, FIELDTRIPDRIVER, TFIELDTRIPCLIENTACCOUNT, FIELDDVTRIPLINK, C:\data\10.1elt\exe\report\printtables\tmptables\FT000001703, C:\data\10.1elt\exe\report\printtables\tmptables\FT000001704,
>C:\data\10.1elt\exe\report\printtables\tmptables\FT000001705 WHERE FIELDTRIPINFORMATION.FIELDTRIPID > 0.00 .AND. UPPER(FIELDTRIPINFORMATION.FIELDTRIPSTATUS) = "SCHEDULED" .AND. FIELDTRIPINFORMATION.FIELDTRIPID =FT000001703.FIELDTRIPI .AND. DRIVERINFORMATION.DRIVERLASTNAME =FT000001704.DRIVERLAST .AND. VEHICLEINFORMATION.DISTVEHICLEID =FT000001705.DISTVEHICL .AND. FIELDTRIPINFORMATION.MAINCLIENTID = CLIENTINFORMATION.CLIENTID .AND. FIELDTRIPINFORMATION.MAINCLIENTID = TFIELDTRIPCLIENTACCOUNT.CLIENTID .AND. FIELDTRIPINFORMATION.FIELDTRIPID = TFIELDTRIPCLIENTACCOUNT.FIELDTRIPID .AND. FIELDTRIPINFORMATION.DESTINATIONID = DESTINATION.DESTINATIONID .AND. FIELDTRIPINFORMATION.FIELDTRIPID = FIELDDVTRIPLINK.FIELDTRPID .AND. FIELDDVTRIPLINK.DRIVERID = DRIVERINFORMATION.DRIVERID .AND. FIELDDVTRIPLINK.DRIVERID = FIELDTRIPDRIVER.DRIVERID .AND. FIELDDVTRIPLINK.FIELDTRPID = FIELDTRIPDRIVER.FIELDTRIPID .AND. FIELDDVTRIPLINK.VEHICLEID = VEHICLEINFORMATION.VEHICLEID INTO CURSOR QMF_TEMP
>
>other then the three tables with full data paths, I can not see any difference. I don't see how the full data paths would cause this problem also. I had the select working in the Field application first, then I copied the code over to the sup_act application and had problems there. So, I worked some more with you people and finally got it to work. Then I copied it back to the Field application and it is not working again.
>
>Please Help.
>Thanks.