RTF_NOTES and SQL

[wilma]

Is it possible extract with a SQL query the field RTF_NOTES from the MPS_TASK
or MSP_ASSIGNMENTS tables?
I tried with this:

DECLARE @ptrval varbinary(16)
SELECT @ptrval = TEXTPTR(TASK_RTF_NOTES)
FROM MSP_TASKS
WHERE (TASK_HAS_NOTES = 1) AND (TASK_NAME = 'NOTA_SUL_TASK')
READTEXT MSP_TASKS.TASK_RTF_NOTES @ptrval 1 25

but it doesn't work.
Any Idea?
thanks in advance

 

[Rod Gill]

Hi,

The answer is in the projdb.htm file in one of Project's program folders