|
Hi
Naresh,
( for
the list : Naresh experienced some errors while generating result sets in SQL
Studio,
for example (but not restricted to that case) when he dragged a table symbol
from the
catalog view onto a QueryByExample dialog :
Module : SQL Studio Database
result
Function getformatedNumber error No: 13 error: Type Mismatch Module : SQL Studio
Database result
Function getformatedNumber error No: 13 error: Type Mismatch Module
:QBEObject
Function:Getcolumn Error No:13 Error: Type Mismatch these
errors were hard to generate on any other computer )
i
could reproduce your problems now : they occur when i deleted the following
registry entry :
'HKEY_CURRENT_USER'->'Control
Panel'->'International'->'iLzero'
(the
data of this entry is either '0' or '1' it determines whether there is a
leading zero at the left
of the decimal sign if the absolute value of the number is smaller
than 1.0).
Such a
deletion is _not_ reflected in the 'regional options' dialog of
w2k.
(and can not be repaired by a setting in this
dialog)
SQLStudio tries to prepare for such missing entries by using default
values, unfortunately
the
default for 'iLzero' was set to "" (the empty string) which lead to type
mismatch errors.
So
have a look in the registry of your system and correct the missing
entry.
thanks
for the bug report, the defaults for such missing registry entries will
be
set to
more reasonable defaults in one of the next releases.
>one
more thing ...what is the syntex for getting out parameter from procedure
through sql studio.
>i
checked in refference manual :sap db but doesnt seem
working
>can
you plz tell me where can i get documantation for procedures with
examples.
the syntax you use
seems to be correct ...
When you call a
stored procedure from SQLStudio it fakes and displays a result set
with
columns that
correspond to the output parameters in the procedure.
I remember there
have been some references to examples in the mailing list
search
regards,
Markus Stausberg |
- Sql Studio ---Query By Example Problem Naresh Chandak
- Stausberg, Markus
