some questions abaut stored procedures in sqlpp

Tomasz Dreßler <[email protected]> Sat, 24 Jul 2004 15:12:22 +0200
Newsgroups gmane.comp.lib.sql.sqlpp
Message-ID <[email protected]>
Hi.
I have some questions about sqlpp.

I use only type="INT" for numeric fields.
When I use type="SMALLINT" in my sema.xml I get the error error CS0029 
implizit convert from type 'int' to 'short' not possible
during compilation. Only integer is supported in generated classes?

Sqlpp support this syntax for stores procedures: (found in sqlpp 2.12)
<field table="O" ref="orderid" alias="OrderID" /> ?

Or only this syntax
<column alias="OrderID">
                    <link tableref="O" fieldref="orderid" />
 </column> ?

Can I implement select "*" from table where [..] as store procedure?


How can I include a fixed value in my SP?

[...]
</left>
                        <right>
                            <equal>
                                <left>
                                    <link tableref="T" 
fieldref="IsCostumer"/>
                                </left>
                                <right>
                                    <???  value="True" /> ????
                                    <!-- <local name="isCostumer" 
type="BIT"  /> -->
                                </right>
                            </equal>
                        </right>
                    </and>       
                </where>

I hope you find some time to answer.

Greetings
Tomasz Dreßler



-------------------------------------------------------
This SF.Net email is sponsored by BEA Weblogic Workshop
FREE Java Enterprise J2EE developer tools!
Get your free copy of BEA WebLogic Workshop 8.1 today.
http://ads.osdn.com/?ad_id=4721&alloc_id=10040&op=click