>>>Hi to all,
>>>
>>>I've to put some line of code in a memo field a execute this code in my form's method.
>>>I've tried with macro substitution but if I've two or more lines of code I've a "Syntax error". Why ?
>>>
>>>I can't read line by line the memo because I can have a IF ELSE ENDIF statement, someone say me to copy this memo in a TEMP.PRG and DO TEMP.PRG but this is slow and my form have to do this operation several time in Init() or on a event.
>>>
>>>How can I execute my code in the memo ?
>>>
>>>Thanks in advance for any suggestion
>>
>>is there more than one line of code in the memo or is it a long sql statement? we use memo fields to hold sql statements and found that semi-colons at the end of lines and carraige returns at the end of the statement will both give you syntax errors.
>
>
>There is more than one line of code in the memo...
Using macro substitution from a memo field is like working from the command box: one line at a time.
Try using IIF()
Matt McDonnell
...building a better mousetrap with moldy cheese...