Building a SQL in a BizObjForm give a lot of errors. I don't know why but remove the SQL and the errors go away. My previous post on a Free Table BO was based on the same problem.
<i><font color="#663300">Don't build your SQL in the BO, build it in the Form's Init process or a custom setform process so it exists before the BO instantiates.
Try moving your code to the form's init and see if that makes it work.
Lynette
<i><font color="#663300">Hi All
I have complicated SQL Statements generating a data set into a cursor. Essentially this cursor calculates the current balances of all the accounts for a given date. Then going further (I have a dream) will generate a tree structure type of record sets using the iID and iParentID of the accounts and print the trial balance.
I doubt that the view designer will be able to manage this.
So I created a BO bo_lkTrialBalance. In the Init of the BO I put in a SQL Statement (very simple right now for trial purpose) named the cursor lv_LKTrialBalance and did not forget to DODEFAULT(). Fired the builder for this BO and set up the DE using the regular conventions.
When I run the form containing this BO I get the error:
Error instantiating cursor object. Cannot find
lv_LKTrialBalance in
c:vso3projectsc00datavso2views.dbc
Locate, Ignore, Cancel
Locate is useless as this is code based
Ignore won't really igore except for iFreeTableCursor
Cancel is the only way out.
I have tried the DE options iDynamicViewCursor, iCursor, iFreeTableCursor as lv_lktrialbalance, v_lktrialbalance. None worked for me.
What have I done wrong?
Is a BO possible with a code based View?
Is it possible to create a code based view?
All the help and knowledge insights I can get will be appreciated.
</font></i>
</font></i>
Regards
Bhavbhuti
©2002 Bhavbhuti Nathwani |
