Hi,



This is select statement ;

Select AField from ATable where ADateField=:ADateParam and
AVCField=:AVCParam into :AResult"



I want to use it with EXECUTE STAMENT command. I does not run cause of
parameters.

I guess, parameters must be also converted to String??! I following, but it
doesn't run also!



SQLStr = 'Select AField from ATable where ADateField=' || '''
cast(:ADateParam as varchar(10)) || ''' AND AVCField = ''' || :AVCParam ||
'''';

EXCUTE STATEMENT SQLStr into :AResult;



What's the wrong?

Kadri.



[Non-text portions of this message have been removed]