sqlpp-devel

[<to...@te...>]

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