>Hello again, Happy Fox'ers
>
>Massive amounts of data, held in a Master file and Sub-Master files, tied by a MasterID. Sub-Master structure is MasterID, Memo where the memo field can be up to 247 lines, each line being the equivalent of a data field.
>
>I want Lines NN and NN + 1 of this memo field to be pulled into an SQL:
>
>Select a.fld1, a.fld2, mline(b.MstrMemo, NN) as fld3, ;
> mline(b.MstrMemo, NN+1) as fld4 ;
>from myfile1 a, mysubfile b ;
>where b.MasterID = a.MasterID
>into cursor myCursor
>
>Timings on this are not bad for small myCursor, but get REAL bad for larger return files (400K records in 960 seconds). Is there a faster way to do this?
>
>Thanks
If you need to fetch consecutive lines from a memo, check the variable _mline - but this would be difficult to combine into a SQL-only approach.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)