>On a network app I use an SQL statement to populate a cursor which then displays results in a grid. The data includes people's date of birth which I need to display as an age - but I understand I cannot maniplulate cursor contents (i.e by using the date of birth to calculate the age). Is there any way round this, i.e. allowing me to modify the results of the query once in the cursor? I am using a cursor as the output from the query because it is a network app and cannot export the result to a table in case more than 1 user tries to use the facility at the same time.
Bob,
You need to USE the cursor again to make it Read Write
SELECT ..... INTO CURSOR Temp
USE DBF( 'Temp') ALIAS
AGAIN
USE IN Temp
is now a read write cursor.
Beware though of Filtered queries where the DBF('Temp') will equal the source file. To ensure this doesn't happen on fully optimised single table queries add the NOFILTER command to the SQL Statement.
HTH
regards
Ian