This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hi, how can I pass nullable parameters to stored procedure? Is it the only way to write nullable mark manually to parameters generated by LightSpeed? It'd mean I mustn't to regenerate the model.
Thanks, Pooik |
|
|
At the moment, you'd need to write the procedure calls explicitly, using ProcedureQuery and ProcedureParameter objects. However, I've now committed designer support for nullable parameters. So beginning with the 2 June nightly build (available from about 1500 GMT) you'll be able to select a procedure parameter in the designer and set its Is Nullable property to true. This will result in the method argument in the generated code being made nullable, e.g. int? maxId instead of int maxId. Note that we do not detect or infer parameter nullability. It will be up to you to mark parameters as nullable once you have created the procedure object in the LightSpeed model. |
|