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