>>>
>>>LPARAMETERS lcToMatch, lcChoice1, lcChoice2, lcChoice3, lcAnswer1, lcAnswer2, lcAnswer3
>>>
>>>DO CASE
>>> CASE lcToMatch = lcChoice1
>>> RETURN lcAnswer1
>>> CASE lcToMatch = lcChoice2
>>> RETURN lcAnswer2
>>> CASE lcToMatch = lcChoice3
>>> RETURN lcAnswer3
>>
>> Otherwise
>> Return space(10)
>>
>>>ENDCASE
>>>
>>>
>>>Right now the table is small, but it has the potential to have thousands of records. Do you know a better way of replacing the abbreviations with the full words?
>>
>>Here's a quick'n'dirty. Haven't actually checked, but I remember having done things like this already, and they worked. It's essential that the spaces in "CXLNR NS " stay as they are, so the AT() returns 1,4 or 7.
>>
>>
>>dime aStatTxt[3]
>>aStatTxt[1]="Canceled"
>>aStatTxt[2]="Not Ready"
>>aStatTxt[3]="No Show"
>>
>>SELECT cname, tdatetime, ;
>> IIF(EMPTY(cPickup), cPaddr, cPickup) AS cPickup, ;
>> IIF(EMPTY(cDropoff), cDaddr, cDropoff) AS cDropoff, ;
>> int(at(cStatus, "CXLNR NS ")+2)/3) AS nstatus ;
>> space(12) as cStatusText ;
>> FROM Trip_History ;
>> INTO CURSOR ro_trips ;
>> WHERE (INLIST(cStatus, "CXL", "NR", "NS")) AND BETWEEN(TTOD(tdatetime), pdBegin, pdEnd) ;
>> ORDER BY nStatus, tdatetime
>> use (dbf()) alias vTrips in 0 again
>> sele vTrips
>> repl all cStatusText with aStatTxt[nStatus] for betw(nstatus,1,3)
>>
>
>With that use again trick, do you have to use "(dbf())"? I tried "USE oldtable ALIAS newtable IN 0 AGAIN" and it didn't work.
>
>Thanks,
>
>-Michelle

You have to use DBF() function to use real DBF name of the cursor.