Hello all,



I'm having trouble getting SQL7 sproc to return a text data type from a

stored procedure.



I have no problems when using integers, smallints, varchars etc. just text



The error message is seen when I try to save the sproc:-

Microsoft SQL-DMO (ODBC SQL State: 22018)

Error 409: The assignment operator operation cannot take a text data type as

an argument.



Any ideas?



-Alec Moss

Senior Analyst Programmer

Foundation Software Solutions Limited

e:alec.moss@f...

w:http://www.foundationsystems.co.uk

t:01603 224920

f:01603 224921

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

- - - - - - - - - - - - - 

Confidentiality and Disclaimer



This e-mail and any attachment(s) may contain confidential information, it

is intended solely for the stated addressee and may be legally privileged.

Any such information must not be copied or conveyed to any third party

without the express permission of the sender. Access to and use of its

contents by anyone other than the addressee(s) may be unlawful. If you have

received this message in error or for reasons beyond the original intention

of the communication, you may not disclose, copy, circulate or in any other

way use or rely on the information contained in this message. Please advise

us of any error by return e-mail to the above address (your details may be

recorded for communications purposes). 



Any opinions expressed in this email are those of the author and may not

necessarily reflect opinion or policy of Foundation Software Solutions Ltd.

Foundation cannot be responsible for any inaccuracy or incompleteness

resulting from errors or interference in the transmission  and receipt of

this message.



Although we have taken steps to ensure this e-mail and attachments are virus

free, we advise that in keeping with good computing practice the recipient

should ensure they are virus free.

Post your code.



regards

David Cameron

nOw.b2b

dcameron@i...



-----Original Message-----

From: Alec Moss [mailto:alec.moss@f...]

Sent: Wednesday, 26 September 2001 12:03 AM

To: ASP Databases

Subject: [asp_databases] Getting a text data type returned from sproc





Hello all,



I'm having trouble getting SQL7 sproc to return a text data type from a

stored procedure.



I have no problems when using integers, smallints, varchars etc. just text



The error message is seen when I try to save the sproc:-

Microsoft SQL-DMO (ODBC SQL State: 22018)

Error 409: The assignment operator operation cannot take a text data type as

an argument.



Any ideas?



-Alec Moss

Senior Analyst Programmer

Foundation Software Solutions Limited

e:alec.moss@f...

w:http://www.foundationsystems.co.uk

t:01603 224920

f:01603 224921

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -