From: <to...@te...> - 2004-07-24 13:12:38
|
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 |