>From a cursor, I want to add some specific fields. I am presently using this approach:
>
>
>CREATE CURSOR TempNotes (Notes M)
>APPEND BLANK
>SELECT Temp.*,TempNotes.Notes AS Url,SPACE(20) AS Image FROM Temp,TempNotes;
> INTO CURSOR Temp2 READWRITE
>
>
>I was wondering if there would be a way to do that without redoing a SQL from the main cursor into another cursor. Basically, I would like to simply add the additional fields in the Temp cursor without having to select all in Temp2.
You can send the result back into Temp: change the above to:
... into cursor Temp ReadWrite
Hilmar.
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)