Samuel cartaxo's List: Morfik

• Hi Jacob ,
  
     I made a simple example App to demostrate this usage you need
  
  I hope its helpfull ,
  Pascal
• No worries please :)) . I was just trying to clarify the async nature of the framework. In this forum there is no such thing as hate or aggressiveness, we are all seekers of knowledge . You are correct when you said that i did nothing to enshure that changes was posted back. I'm send a fixed Project.

• <div style="border: medium none; line-height: 0px; overflow: hidden; cursor: default; position: absolute; left: -1px; top: -1px; right: -2px; bottom: -2px;" id="frmResponse_cntIndentBackground_2"><div style="left: 0px; bottom: 0px; background-color: transparent; background-image: url(&quot;/ProjectTheme/ImageBundle_frmResponse_norepeat_1.png?cls=res&amp;xid={5701417A-D505-4AE4-A818-6ECA99E5A8D4}&quot;); background-repeat: no-repeat; background-position: -10px 0px; position: absolute; overflow: hidden; height: 9px; width: 10px;" id="D2"></div><div style="right: 0px; bottom: 0px; background-color: transparent; background-image: url(&quot;/ProjectTheme/ImageBundle_frmResponse_norepeat_1.png?cls=res&amp;xid={5701417A-D505-4AE4-A818-6ECA99E5A8D4}&quot;); background-repeat: no-repeat; background-position: 0px 0px; position: absolute; overflow: hidden; height: 9px; width: 9px;" id="D4"></div><div style="position: absolute; overflow: hidden; height: 2px; background-color: transparent; background-image: url(&quot;/ProjectTheme/ImageBundle_frmResponse_repeatX2.png?cls=res&amp;xid={5701417A-D505-4AE4-A818-6ECA99E5A8D4}&quot;); background-repeat: repeat-x; background-position: 0px 0px; left: 10px; bottom: 0px; right: 9px;" id="E3"></div><div style="position: absolute; overflow: hidden; height: 7px; background-color: rgb(255, 255, 255); background-image: url(&quot;/ProjectTheme/frmResponse_cntIndent_D3.png?cls=res&amp;xid={5701417A-D505-4AE4-A818-6ECA99E5A8D4}&quot;); background-repeat: repeat; left: 10px; bottom: 2px; right: 9px;" id="D3"></div></div><br/><div style="border: medium none; position: absolute; overflow: hidden; cursor: default; left: 0px; top: 0px; width: 726px; height: 81px; z-index: 0;" id="frmResponse_Container2_2"><br/><div style="border: medium none; line-height: 0px; overflow: hidden; cursor: default; position: absolute; left: 0px; top: 0px; right: 0px; bottom: 0px; background-image: url(&quot;/ProjectTheme/frmResponse_Container2.png?cls=res&amp;xid={5701417A-D505-4AE4-A818-6ECA99E5A8D4}&quot;); background-repeat: repeat-x;" id="frmResponse_Container2Background_2"><br/></div><br/><a rel="nofollow" href="/user/2705" class="HijaxLink"><br/><div style="font-family: Arial; font-size: 16pt; color: rgb(24, 24, 23); position: absolute; overflow: hidden; cursor: pointer; left: 83px; top: 6px; width: 492px; height: 24px; z-index: 6; white-space: nowrap; background-color: transparent; font-style: normal; font-weight: normal;" id="frmResponse_lblUser_2">Utku Karatas <img style="position: relative; top: 4px; margin-top: -4px; border: medium none;" title="Turkey" src="http://forum.morfik.com/Flags/24/flag_turkey.png?cls=res&amp;t=%7BD82F5E79-C875-4C14-9742-C2EF740C88BF%7D"></div><br/></a><br/><div style="border: medium none; position: absolute; cursor: default; left: 175px; top: 6px; width: 546px; height: 26px; z-index: 1;" id="frmResponse_cntrActions_2"><br/><div style="border: medium none; font-family: Arial; font-size: 9pt; color: rgb(60, 60, 57); text-decoration: underline; position: relative; float: right; margin-left: 8px; margin-right: 8px; overflow: hidden; cursor: pointer; text-align: center; z-index: 0; white-space: nowrap; display: none;" id="frmResponse_lblEdit_2">Edit</div><br/><div style="border: medium none; font-family: Arial; font-size: 9pt; color: rgb(60, 60, 57); position: relative; float: right; overflow: hidden; cursor: default; z-index: 1; white-space: nowrap; display: none;" id="frmResponse_sepEdit_2">|</div><br/><div style="border: medium none; font-family: Arial; font-size: 9pt; color: rgb(60, 60, 57); text-decoration: underline; position: relative; float: right; margin-left: 8px; margin-right: 8px; overflow: hidden; cursor: pointer; text-align: center; z-index: 2; white-space: nowrap;" id="frmResponse_lblReply_2">Reply</div><br/><div style="border: medium none; font-family: Arial; font-size: 9pt; color: rgb(60, 60, 57); position: relative; float: right; overflow: hidden; cursor: default; z-index: 3; white-space: nowrap;" id="frmResponse_sepReply_2">|</div><br/><div style="border: medium none; font-family: Arial; font-size: 9pt; color: rgb(60, 60, 57); text-decoration: underline; position: relative; float: right; margin-left: 8px; margin-right: 8px; overflow: hidden; cursor: pointer; text-align: center; z-index: 4; white-space: nowrap;" id="frmResponse_lblQuote_2">Quote</div><br/><div style="border: medium none; font-family: Arial; font-size: 9pt; color: rgb(60, 60, 57); position: relative; float: right; overflow: hidden; cursor: default; z-index: 5; white-space: nowrap;" id="frmResponse_sepQuote_2">|</div><br/><div style="border: medium none; font-family: Arial; font-size: 9pt; color: rgb(60, 60, 57); text-decoration: underline; position: relative; float: right; margin-left: 8px; margin-right: 8px; overflow: hidden; cursor: pointer; text-align: center; z-index: 6; white-space: nowrap; display: none;" id="frmResponse_lblDelete_2">Delete</div><br/><div style="border: medium none; font-family: Arial; font-size: 9pt; color: rgb(60, 60, 57); position: relative; float: right; overflow: hidden; cursor: default; z-index: 7; white-space: nowrap; display: none;" id="frmResponse_sepDelete_2">|</div><br/><div style="border: medium none; font-family: Arial; font-size: 9pt; color: rgb(60, 60, 57); text-decoration: underline; position: relative; float: right; margin-left: 8px; margin-right: 8px; overflow: hidden; cursor: pointer; text-align: center; z-index: 8; white-space: nowrap; display: none;" id="frmResponse_lblPublish_2">Publish</div><br/><div style="border: medium none; font-family: Arial; font-size: 9pt; color: rgb(60, 60, 57); position: relative; float: right; overflow: hidden; cursor: default; z-index: 9; white-space: nowrap; display: none;" id="frmResponse_sepPublish_2">|</div><br/><div style="border: medium none; font-family: Arial; font-size: 9pt; color: rgb(60, 60, 57); text-decoration: underline; position: relative; float: right; margin-left: 8px; margin-right: 8px; overflow: hidden; cursor: pointer; text-align: center; z-index: 10; white-space: nowrap; display: none;" id="frmResponse_lblAcceptAnswer_2">Accept Answer</div><br/><div style="border: medium none; font-family: Arial; font-size: 9pt; color: rgb(60, 60, 57); position: relative; float: right; overflow: hidden; cursor: default; z-index: 11; white-space: nowrap; display: none;" id="frmResponse_sepAcceptAnswer_2">|</div><br/><a rel="nofollow" href="/user/2705" class="HijaxLink"><br/><div style="border: medium none; font-family: Arial; font-size: 9pt; color: rgb(60, 60, 57); text-decoration: underline; position: relative; float: right; margin-left: 8px; margin-right: 8px; overflow: hidden; cursor: pointer; text-align: center; z-index: 12; white-space: nowrap;" id="frmResponse_lblViewProfile_2">View Profile</div><br/></a><br/><div style="border-right: 1px solid rgb(255, 255, 255); position: relative; float: right; overflow: visible; cursor: default; width: 62px; height: 15px; z-index: 13; display: none;" id="frmResponse_ddAdmin_2"><br/><div style="position: absolute; width: 100%; height: 100%; border: medium none; line-height: 0px; overflow: hidden; cursor: default;" id="frmResponse_ddAdminBackground_2"><br/></div><br/><div style="border: medium none; font-family: Arial; font-size: 9pt; color: rgb(60, 60, 57); text-decoration: underline; position: absolute; cursor: default; text-align: right; left: 0px; top: 0px; width: 46px; height: 15px; z-index: 0;" id="frmResponse_DropButton2_2"><br/><input value="Admin" tabindex="-1" style="position: absolute; border: medium none; background: none repeat scroll 0% 0% transparent; outline: medium none; left: 0px; top: 0px; width: 46px; height: 15px; padding: 0px; font-family: Arial; font-size: 9pt; color: rgb(60, 60, 57); text-decoration: underline; cursor: default; text-align: right;" type="button" id="frmResponse_DropButton2Button_2"><br/></div><br/><div style="border: medium none; font-family: Arial; font-size: 10pt; color: rgb(0, 0, 0); position: absolute; cursor: default; left: 46px; top: 0px; width: 16px; height: 15px; z-index: 2;" id="frmResponse_SplitButton2_2"><br/><div style="border: medium none; line-height: 0px; overflow: hidden; cursor: default; position: absolute; left: 0px; top: 0px; height: 15px; width: 16px; background-image: url(&quot;/ProjectTheme/ImageBundle_frmResponse_norepeat_1.png?cls=res&amp;xid={5701417A-D505-4AE4-A818-6ECA99E5A8D4}&quot;); background-repeat: no-repeat; background-position: -210px 0px;" id="frmResponse_SplitButton2Background_2"><br/></div><br/><input value="" tabindex="-1" style="position: absolute; border: medium none; background: none repeat scroll 0% 0% transparent; outline: medium none; left: 0px; top: 0px; width: 16px; height: 15px; padding: 0px; font-family: Arial; font-size: 10pt; color: rgb(0, 0, 0); cursor: default;" type="button" id="frmResponse_SplitButton2Button_2"><br/></div><br/><div style="border: medium none; position: absolute; overflow: visible; cursor: default; left: 0px; top: 15px; width: 140px; height: 120px; z-index: 1; display: none;" id="frmResponse_DropContainer2_2"><br/><div style="border: medium none; line-height: 0px; overflow: hidden; cursor: default; position: absolute; left: -1px; top: -1px; right: -3px; bottom: -3px;" id="frmResponse_DropContainer2DropBackground_2"><br/><div style="left: 0px; top: 0px; background-color: transparent; background-image: url(&quot;/ProjectTheme/ImageBundle_frmResponse_norepeat_1.png?cls=res&amp;xid={5701417A-D505-4AE4-A818-6ECA99E5A8D4}&quot;); background-repeat: no-repeat; background-position: -177px 0px; position: absolute; overflow: hidden; height: 10px; width: 10px;" id="B2"></div><div style="right: 0px; top: 0px; background-color: transparent; background-image: url(&quot;/ProjectTheme/ImageBundle_frmResponse_norepeat_1.png?cls=res&amp;xid={5701417A-D505-4AE4-A818-6ECA99E5A8D4}&quot;); background-repeat: no-repeat; background-position: -166px 0px; position: absolute; overflow: hidden; height: 10px; width: 10px;" id="B4"></div><div style="position: absolute; overflow: hidden; height: 1px; background-color: transparent; background-image: url(&quot;/ProjectTheme/ImageBundle_frmResponse_norepeat_1.png?cls=res&amp;xid={5701417A-D505-4AE4-A818-6ECA99E5A8D4}&quot;); background-repeat: no-repeat; background-position: -109px 0px; left: 10px; top: 0px; width: 56px;" id="A3"></div><div style="position: absolute; overflow: hidden; height: 1px; background-color: transparent; background-image: url(&quot;/ProjectTheme/frmResponse_ddAdmin__Drop_A4.png?cls=res&amp;xid={5701417A-D505-4AE4-A818-6ECA99E5A8D4}&quot;); background-repeat: repeat-x; left: 66px; top: 0px; right: 10px;" id="A4"></div><div style="position: absolute; overflow: hidden; height: 9px; background-color: rgb(242, 242, 242); background-image: url(&quot;/ProjectTheme/frmResponse_ddAdmin__Drop_B3.png?cls=res&amp;xid={5701417A-D505-4AE4-A818-6ECA99E5A8D4}&quot;); background-repeat: repeat; left: 10px; top: 1px; right: 10px;" id="B3"></div><div style="position: absolute; overflow: hidden; width: 1px; background-color: transparent; background-image: url(&quot;/ProjectTheme/ImageBundle_frmResponse_repeatY_3.png?cls=res&amp;xid={5701417A-D505-4AE4-A818-6ECA99E5A8D4}&quot;); background-repeat: repeat-y; background-position: -5px 0px; left: 0px; top: 10px; bottom: 10px;" id="C1"></div><div style="position: absolute; overflow: hidden; width: 9px; background-color: rgb(242, 242, 242); background-image: url(&quot;/ProjectTheme/frmResponse_ddAdmin__Drop_C2.png?cls=res&amp;xid={5701417A-D505-4AE4-A818-6ECA99E5A8D4}&quot;); background-repeat: repeat; left: 1px; top: 10px; bottom: 10px;" id="C2"></div><div style="position: absolute; overflow: hidden; width: 3px; background-color: transparent; background-image: url(&quot;/ProjectTheme/ImageBundle_frmResponse_repeatY_3.png?cls=res&amp;xid={5701417A-D505-4AE4-A818-6ECA99E5A8D4}&quot;); background-repeat: repeat-y; background-position: -7px 0px; right: 0px; top: 10px; bottom: 10px;" id="C5"></div><div style="position: absolute; overflow: hidden; width: 7px; background-color: rgb(242, 242, 242); background-image: url(&quot;/ProjectTheme/frmResponse_ddAdmin__Drop_C4.png?cls=res&amp;xid={5701417A-D505-4AE4-A818-6ECA99E5A8D4}&quot;); background-repeat: repeat; right: 3px; top: 10px; bottom: 10px;" id="C4"></div><div style="position: absolute; overflow: hidden; left: 10px; top: 10px; background-color: rgb(242, 242, 242); background-image: url(&quot;/ProjectTheme/frmResponse_ddAdmin__Drop_C3.png?cls=res&amp;xid={5701417A-D505-4AE4-A818-6ECA99E5A8D4}&quot;); background-repeat: repeat; right: 10px; bottom: 10px;" id="C3"></div><div style="left: 0px; bottom: 0px; background-color: transparent; background-image: url(&quot;/ProjectTheme/ImageBundle_frmResponse_norepeat_1.png?cls=res&amp;xid={5701417A-D505-4AE4-A818-6ECA99E5A8D4}&quot;); background-repeat: no-repeat; background-position: -199px 0px; position: absolute; overflow: hidden; height: 10px; width: 10px;" id="D2"></div><div style="right: 0px; bottom: 0px; background-color: transparent; background-image: url(&quot;/ProjectTheme/ImageBundle_frmResponse_norepeat_1.png?cls=res&amp;xid={5701417A-D505-4AE4-A818-6ECA99E5A8D4}&quot;); background-repeat: no-repeat; background-position: -188px 0px; position: absolute; overflow: hidden; height: 10px; width: 10px;" id="D4"></div><div style="position: absolute; overflow: hidden; height: 3px; background-color: transparent; background-image: url(&quot;/ProjectTheme/ImageBundle_frmResponse_repeatX2.png?cls=res&amp;xid={5701417A-D505-4AE4-A818-6ECA99E5A8D4}&quot;); background-repeat: repeat-x; background-position: 0px -5px; left: 10px; bottom: 0px; right: 10px;" id="E3"></div><div style="position: absolute; overflow: hidden; height: 7px; background-color: rgb(242, 242, 242); background-image: url(&quot;/ProjectTheme/frmResponse_ddAdmin__Drop_D3.png?cls=res&amp;xid={5701417A-D505-4AE4-A818-6ECA99E5A8D4}&quot;); background-repeat: repeat; left: 10px; bottom: 3px; right: 10px;" id="D3"></div></div><br/><div style="border: medium none; font-family: Arial; font-size: 9pt; color: rgb(60, 60, 57); text-decoration: underline; position: relative; margin-left: 10px; margin-top: 10px; margin-bottom: 5px; overflow: hidden; cursor: pointer; z-index: 0; white-space: nowrap;" id="frmResponse_lblAdminEdit_2">Edit Post</div><br/><div style="border: medium none; font-family: Arial; font-size: 9pt; color: rgb(60, 60, 57); text-decoration: underline; position: relative; margin-left: 10px; margin-bottom: 5px; overflow: hidden; cursor: pointer; z-index: 1; white-space: nowrap;" id="frmResponse_lblRemovePost_2">Remove Post</div><br/><div style="border: medium none; font-family: Arial; font-size: 9pt; color: rgb(60, 60, 57); text-decoration: underline; position: relative; margin-left: 10px; margin-bottom: 5px; overflow: hidden; cursor: pointer; z-index: 2; white-space: nowrap;" id="frmResponse_lblLockThread_2">Lock Thread</div><br/><div style="border: medium none; font-family: Arial; font-size: 9pt; color: rgb(60, 60, 57); text-decoration: underline; position: relative; margin-left: 10px; margin-bottom: 5px; overflow: hidden; cursor: pointer; z-index: 3; white-space: nowrap;" id="frmResponse_lblMarkAsHelpful_2">Mark as Helpful</div><br/><div style="border: medium none; font-family: Arial; font-size: 9pt; color: rgb(60, 60, 57); text-decoration: underline; position: relative; margin-left: 10px; margin-bottom: 5px; overflow: hidden; cursor: pointer; z-index: 4; white-space: nowrap;" id="frmResponse_lblRequestAResponse_2">Request a Response</div><br/></div><br/></div><br/><div style="position: absolute; text-align: left; left: 0px; top: 26px; font-family: MS Sans Serif; font-size: 8pt; font-style: normal; font-weight: normal; text-decoration: none; cursor: default; z-index: 6000449; visibility: visible; height: 0px; width: 0px; float: right;" id="xfrmResponse_cntrActionsmfk_int_2"></div></div><br/><a rel="nofollow" href="/user/2705" class="HijaxLink"><br/><div style="position: absolute; overflow: hidden; cursor: pointer; left: 12px; top: 9px; width: 62px; height: 62px; z-index: 3; background-color: transparent; font-family: Arial; font-size: 10pt; font-style: normal; font-weight: normal; color: rgb(0, 0, 0);" id="frmResponse_Container3_2"><br/><img style="border: medium none; position: absolute; overflow: hidden; cursor: pointer; left: 1px; top: 1px; width: 60px; height: 60px; z-index: 0; visibility: inherit;" alt="" src="http://bkey-users-pub-root.s3.amazonaws.com/avatars/medium/Skin3.png" id="frmResponse_imgProfilePic_2"><br/><div style="position: absolute; text-align: left; left: 0px; top: 62px; font-family: MS Sans Serif; font-size: 8pt; font-style: normal; font-weight: normal; text-decoration: none; cursor: default; z-index: 6000448; visibility: visible; height: 0px; width: 0px;" id="xfrmResponse_Container3mfk_int_2"></div></div><br/></a><br/><img style="border: medium none; position: absolute; overflow: hidden; cursor: default; left: 313px; top: 17px; z-index: 0; visibility: hidden;" alt="" src="/Draft2.png?cls=res&amp;xid=%7B5701417A-D505-4AE4-A818-6ECA99E5A8D4%7D" id="frmResponse_imgDraft_2"><br/><div style="border: medium none; font-family: Arial; font-size: 10pt; color: rgb(24, 24, 23); position: absolute; overflow: hidden; cursor: default; left: 83px; top: 33px; width: 488px; height: 22px; z-index: 4; white-space: nowrap;" id="frmResponse_lblBadges_2"><img title="Interested in Morfik" src="/Badges/20/member.png?cls=res"> <span style="position: relative; top: -5px;">275 points</span></div><br/><div style="border: medium none; position: absolute; overflow: hidden; cursor: default; left: 612px; top: 33px; width: 110px; height: 43px; visibility: hidden; z-index: 5;" id="frmResponse_cntrBounty_2"><br/><div style="border: medium none; font-family: Arial; font-size: 9pt; color: rgb(60, 60, 57); position: absolute; overflow: hidden; cursor: default; left: 44px; top: 6px; width: 61px; height: 18px; z-index: 1; white-space: nowrap;" id="frmResponse_lblBountyPoints_2"></div><br/><img style="border: medium none; position: absolute; overflow: hidden; cursor: default; left: 9px; top: 7px; visibility: hidden; z-index: 0;" alt="" src="" id="frmResponse_imgBounty_2"><br/><div style="border: medium none; font-family: Arial; font-size: 8pt; color: rgb(60, 60, 57); position: absolute; overflow: hidden; cursor: default; left: 44px; top: 26px; width: 61px; height: 17px; z-index: 2; white-space: nowrap;" id="frmResponse_lblBountyMode_2"></div><br/><div style="position: absolute; text-align: left; left: 0px; top: 43px; font-family: MS Sans Serif; font-size: 8pt; font-style: normal; font-weight: normal; text-decoration: none; cursor: default; z-index: 6000447; visibility: visible; height: 0px; width: 0px;" id="xfrmResponse_cntrBountymfk_int_2"></div></div><br/><div style="border: medium none; font-family: Arial; font-size: 9pt; color: rgb(40, 38, 34); position: absolute; overflow: hidden; cursor: default; left: 83px; top: 56px; width: 488px; height: 17px; z-index: 2; white-space: nowrap;" id="frmResponse_lblDetails_2">3 years ago, Post ID: <b>6415 </b> </div><br/><div style="position: absolute; text-align: left; left: 0px; top: 81px; font-family: MS Sans Serif; font-size: 8pt; font-style: normal; font-weight: normal; text-decoration: none; cursor: default; z-index: 6000446; visibility: visible; height: 0px; width: 0px;" id="xfrmResponse_Container2mfk_int_2"></div></div><br/><div style="border-top: 2px solid rgb(216, 216, 205); font-family: Arial; font-size: 8pt; color: rgb(0, 0, 0); position: absolute; overflow: hidden; cursor: default; left: 1px; top: 80px; width: 725px; height: 0px; z-index: 2; line-height: 0px;" id="frmResponse_Rectangle2_2"><br/></div><br/><div style="border: medium none; position: absolute; overflow: hidden; cursor: default; left: 29px; top: 80px; width: 20px; height: 23px; z-index: 5;" id="frmResponse_Image1_2"><br/><img style="position: absolute; border: medium none; background: none repeat scroll 0% 0% transparent; left: 0px; top: 0px; margin-left: 0px; margin-top: 0px;" alt="" src="/ProjectTheme/ImageBundle_frmResponse_norepeat_4.png?cls=res&amp;xid=%7B5701417A-D505-4AE4-A818-6ECA99E5A8D4%7D" id="frmResponse_Image1img_2"><br/></div><br/><div style="border: medium none; font-family: Arial; font-size: 8pt; color: rgb(0, 0, 0); position: absolute; overflow: hidden; cursor: default; background-color: rgb(255, 0, 0); left: 578px; top: 91px; width: 15px; height: 15px; visibility: hidden; z-index: 8; white-space: nowrap;" id="frmResponse_lblBounty_2">0</div><br/><div style="border: medium none; font-family: Arial; font-size: 8pt; color: rgb(0, 0, 0); position: absolute; overflow: hidden; cursor: default; background-color: rgb(255, 0, 0); left: 697px; top: 91px; width: 15px; height: 15px; visibility: hidden; z-index: 7; white-space: nowrap;" id="frmResponse_lblIsDraft_2">0</div><br/><div style="font-family: Arial; font-size: 10pt; color: rgb(24, 24, 23); position: absolute; overflow: hidden; cursor: default; left: 27px; top: 111px; width: 680px; height: 346px; z-index: 1; white-space: normal; background-color: transparent; font-style: normal; font-weight: normal;" id="frmResponse_lblContent_2">Hi Ivailo,<br><br>Quoting from a previous post by Mauricio,<br><br>"<br>Master/detail forms in Morfik are generally implemented in the following way:<br><br>- Create a query for the detail form with a parameter which is the master field<br>- Assign this query as the data source for the detail form<br>- In the master form in the events OnReady and OnAfterDBNavigate add a command such as this:<br>OpenForm('DetailFormName', 'MasterFormName:SubFormName', '"QueryParameterName=' +MasterIdLabel.Caption+'"');<br><br>This will allow you to create the Master/Detail behavior and will allow you make this work, wherever the parameter value comes from, table, query, WebMethod return value, another database, etc.<br>"<br>In addition to this, I suggest taking a look at the booktrader example (specifically the forms "Browse_by_genre", "Genre_catalog"). <br><br>ps. It would help if you tell us where you stuck on inserting records?</div>

• query syntax
• query syntax
• Hi Ricardo,
  If you prefer query approach instead stored procedures case clause can be in help. For example:
  ..................
  WHERE
  ORDERS_TABLE.ORDER_DATE >=
  case
  when CAST(:DateFromParam as VarChar(64)) != ''  then CAST(:DateFromParam as VarChar(64))
  else
  ORDERS_TABLE.ORDER_DATE
  end
• WHERE
  ORDERS_TABLE.ORDER_DATE >=
  case
  when CAST(:DateFromParam as VarChar(64)) != ''  then CAST(:DateFromParam as VarChar(64))
  else
  ORDERS_TABLE.ORDER_DATE
  end

2 more annotations...