>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.
>
>We discussed the approach of adding a memo field recently by using that approach. I am wondering if we could benefit of a modify structure approach within the cursor itself.
Michel,
Assuming you created the 'temp' cursor with 'readwrite' :
ALTER TABLE 'temp' ADD COLUMN url m
ALTER TABLE 'temp' ADD COLUMN cImage c(20)
Cetin