Thanks Naomi.
>>Hi
>>
>>I am getting an '"cursor" must be created with SELECT ... INTO TABLE (Error 1815)' when attempting to do the following
>>
SELECT t_key, wo_id ;
>> FROM invcont WHERE wo_id = 345245 ;
>> INTO CURSOR tContInvs
>>
>>SELECT tContInvs.*, invcont ;
>> FROM tContInvs ;
>> LEFT JOIN invcont ON tContInvs.wo_id = invcont.wo_id ;
>> INTO CURSOR t1
>>
>>I realise the code is a bit non-sensical but it illustrates my problem. Can someone explain to me why I am getting the problem (i.e. cant use the created cursor)
>>
>>regards
>>Geoff Scott
>
>Are you selecting all fields from InvCont in your first select? If yes, when you have fallen into the well-known trap, when VFP doesn't create a file on the disk, but filters the original table. You should add NOFILTER clause to your first select statement. In fact, you can always use either NOFILTER or READWRITE depending on your scenario.
May all your weeds be wildflowers