------ =_NextPart_000_01BA95A1.21920180
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<<<<<<<
We are trying to get a Sybase stored procedure to return .T. or .F. to =
our app. It appears that the only way we can do this is by having Sybase =
return the logical value in a field of a single-record view.
Does anybody else know of a better way?
>>>>>>>>>>
Hi Mario,
One way is to have a output parameter in your stored procedure and =
return appropriate value through this output variable, which your =
application can use for further processing/checking. This method also =
depends on how your app is communicating to Sybase server.
The other way is to return integer values from stored procedures =
and check for those values in your app. This approach is more useful =
because the system generates it's own error numbers when an error occurs =
while executing the stored procedure. This will allow your application =
to differentiate between the system generated error messages and the =
value returned by the stored procedure.
Hope this helps,
Sanath Kumar R.
------ =_NextPart_000_01BA95A1.21920180
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64
eJ8+IicLAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEEkAYAOAEAAAEAAAAMAAAAAwAAMAIAAAAL
AA8OAAAAAAIB/w8BAAAAUQAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAAAAGZveHByb0B0cmFuc2Zv
cm1hdGlvbi5jb20AU01UUABmb3hwcm9AdHJhbnNmb3JtYXRpb24uY29tAAAAAB4AAjABAAAABQAA
AFNNVFAAAAAAHgADMAEAAAAaAAAAZm94cHJvQHRyYW5zZm9ybWF0aW9uLmNvbQAAAAMAFQwBAAAA
AwD+DwYAAAAeAAEwAQAAABwAAAAnZm94cHJvQHRyYW5zZm9ybWF0aW9uLmNvbScAAgELMAEAAAAf
AAAAU01UUDpGT1hQUk9AVFJBTlNGT1JNQVRJT04uQ09NAAADAAA5AAAAAAsAQDoBAAAAAgH2DwEA
AAAEAAAAAAAAAmpAAQSAAQA0AAAAUkU6IFZpc3VhbCBGb3hQcm8gLSBTeWJhc2UgU3RvcmVkIFBy
b2NlZHVyZXMgWzk1ODFdADMRAQWAAwAOAAAAywcKAAgAEQALACQAAAAkAQEggAMADgAAAMsHCgAI
ABEAAAAOAAAAAwEBCYABACEAAAA5QTYyNTczRkFDMDBDRjExQUUyNzAwQTAyNDAzMkQ1QgAMBwED
kAYAJAUAABQAAAALACMAAAAAAAMAJgAAAAAACwApAAEAAAADAC4AAAAAAAMANgAAAAAAQAA5AOBy
ggZzlboBHgBwAAEAAAA0AAAAUkU6IFZpc3VhbCBGb3hQcm8gLSBTeWJhc2UgU3RvcmVkIFByb2Nl
ZHVyZXMgWzk1ODFdAAIBcQABAAAAFgAAAAG6lXMGcT9XYpsArBHPricAoCQDLVsAAB4AHgwBAAAA
AwAAAE1TAAAeAB8MAQAAABwAAABORVRRVUVTVElOL05RVUVTVEJMUi9zYW5hdGgAAwAGEHICh2MD
AAcQEwMAAB4ACBABAAAAZQAAADw8PDw8PDxGUk9NOk1BUklPREVNRUxMT1dFQVJFVFJZSU5HVE9H
RVRBU1lCQVNFU1RPUkVEUFJPQ0VEVVJFVE9SRVRVUk5UT1JGVE9PVVJBUFBJVEFQUEVBUlNUSEFU
VEhFT04AAAAAAgEJEAEAAAB5AwAAdQMAANwFAABMWkZ1TJjJm/8ACgEPAhUCpAPkBesCgwBQEwNU
AgBjaArAc2V0bjIGAAbDAoMyA8UCAHDccnESIAcTAoMzEwwGsNBzdGVtAoM0A8YT5f59CoAIzwnZ
AoAKgQ2xC2DgbmcxMDMUgAsDDNB4MTQ0DfALVRLyAdAghjwbxAqLbGkzNhrHVxYiDAETkG8VoGMF
QFsaRgNhOgXQCsBpbyCgRGVNZWwXkF0KhTEKhVdlIArAIQB0ctp5C4BnIVAfcGcSACEQ6RIxYmER
8CAVkAWwCYD6IB5BYwmACHAhQR9wGACGdAhwA6AuVC4gBbE8LkYkoCHRCGEhEHBw7SSgSSIhJbBl
EdEhUBHADwVAJqAhAAIgbHkgd9ZhJ2EhAGMDkWQfcCagtQQAICiBYidgEcB2IZLPImUkFSbyF5Bn
aSfwAyC+dgdAClAooAOgIkBmCJBybCMgb2YiMQCQGbBsfGUtGAAFoSMgKTAH0C75IBxEbweRAHAi
cARwJ2BjH8AioWtubwfgLDNinxIAFaAFwCeAGt15PwqFfj4yZwqHGvoeNzMPG3NIemkfJCwgHAr7
G1U440/+biEAJ4IogSHRKREhASVR3HRwOqAjMArAYQeAMIL9K4F5JWIi3wBwIyAkFSWhfwNgE5AH
MBWgKxUmoANgdXxnaChUOpUrIAchAmBl+iw44HcocBGwO8QloR0A3SfwdB9gA6An8nUioQIQ/QXA
ZghwJvEFwCNDBBAhkVYvEbAFkGshkS4MgiD2VChyO0FoBHAhEC9wH3D/DbAmQD1AP7EDoEWwB+BB
VuMoogWgbW11AwBB8iGk9yJmBJA6QHItrTjjRTAnEf9DUzmIJBULgBWgIgAFwCsj/wQgA1I8Hy7C
IyBEU0LTRaH/IqFNRTumJaNFJD3jANA/YP9FUiLxQpJDIAMgMFAn8EKi/SbycxWDIfE5UDsgFaAo
kfR0Jz+xdwOgBJADYAXA/G51BtAEkAQgQPAJ8C7Re1XVI2BjCHBWogMQIQBl/ngFkDqgIZNUEiLt
UYYD8L8f0EXhF5BHGEHXIdFkBpD+ZgSQCfBCED5iMFEnwFbhn1QPFaAjIFXkB4FzYSIA/08EJvIr
JCQUIxEo4VkfWiI9IBxIPiA+4iiBJwBscN5zNs0GESbAP2BLVlAKwb5SLa0crzPfN0UXIQBqsAAA
AAMAEBAAAAAAAwAREAEAAABAAAcwIH2Kb3GVugFAAAgwIH2Kb3GVugEeAD0AAQAAAAUAAABSRTog
AAAAAAMADTT9NwAAvXs=
------ =_NextPart_000_01BA95A1.21920180--