FiveTech Software tech support forums

by **hag** » Sun Aug 24, 2008 5:26 pm

I have a 15 column browse and the user can move and eliminate columns . I'd like to print the oBrw with the user changes.
The oBrw:print() seems to print only what is on the screen. Is there a way to print the entire oBrw with the changes and to the last record being used?

by **Antonio Linares** » Mon Aug 25, 2008 10:40 am

Harvey,

Try with oBrw:Report()

by **hag** » Mon Aug 25, 2008 2:12 pm

Antonio:

>Try with oBrw:Report()

Get an argument error...

Error description: Error BASE/1111 Argument error: LEN
Args:
[ 1] = U

Stack Calls
===========
Called from: => LEN(0)
Called from: => TRCOLUMN:STABILIZE(0)
Called from: => (b)STABILIZE(0)
Called from: => AEVAL(0)
Called from: => TREPORT:STABILIZE(0)
Called from: => TREPORT:ACTIVATE(0)
Called from: => TXBROWSE:REPORT(0)
Called from: .\JBROWSE.PRG => TOEXITPRINT(6091)

by **James Bott** » Mon Aug 25, 2008 2:50 pm

>Called from: .\JBROWSE.PRG => TOEXITPRINT(6091)

What is on line 6091?

Regards,
James

by **hag** » Mon Aug 25, 2008 2:52 pm

James
Line 6091 == oBrw:report()

by **Antonio Linares** » Mon Aug 25, 2008 3:06 pm

Harvey,

How are you creating the browse ?

Please post here the source code for it, thanks

by **hag** » Mon Aug 25, 2008 3:19 pm

Sent oBrw creation and a typical column.

Code: Select all Expand view RUN: getcoors(ownd1:nTop,ownd1:nLeft,ownd1:nBottom,ownd1:nRight) if ownd1:nright >= 1020 //.and. ownd1:nright < 1028 if bFont[1] <= 16 oDlg:bResized := ; {|| aRect := GetWndRect(oDlg:hWnd), ; oBrw:Move( 24,4,arect[ 4 ]-arect[ 2 ] -16, ; //16 aRect[3]-aRect[1]-175,.t.); //150 // 130 ,oBtn1:move(arect[3] -aRect[1]- 89,11 ,,,.t.); //14 * ,oBtn5:move(arect[3] -aRect[1]- 89,197 ,,,.t.); //106 ,oBtn7:move(arect[3] -aRect[1]- 89,380 ,,,.t.); //16 ,oBtn2:move(arect[3] -aRect[1]- 119,481 ,,,.t.); //4002 ,oBmp1:move( "",11 ,,,.t.); //calculate ,oBmp5:move(arect[3] -aRect[1]- 149,380 ,,,.t.); // Info ,oBtn4:move( "",620 ,,,.t.); //calculate ,oCbx:move(arect[3] -aRect[1]- 89,575 ,,,.t.); //Transfer data ,oCbx1:move(arect[3] -aRect[1]- 119,575 ,,,.t.); // ,oCbx2:move(arect[3] -aRect[1]- 119,11 ,,,.t.); //15 * ,oCbx3:move(arect[3] -aRect[1]- 119,197 ,,,.t.); //14 ,oSay11:move(arect[3]-aRect[1]- 119,806 ,,,.t.); // ,oSay12:move(arect[3]-aRect[1]- 111,806 ,,,.t.); // ,oCbx4:move( "",728 ,,,.t.); //reports ,oSay13:move( "",855 ,,,.t.); // ,oSay20:move(arect[3] -aRect[1]-145,11 ,,,.t.); // 75 * //120 ,oSay21:move(arect[3] -aRect[1]-145,197 ,,,.t.); // 75 * ,oBtn3:move(arect[3] -aRect[1]-119,380 ,,,.t.)} //103 else oDlg:bResized := ; {|| aRect := GetWndRect(oDlg:hWnd), ; oBrw:Move( 24,4,arect[ 4 ]-arect[ 2 ] -16, ; //16 aRect[3]-aRect[1]-207,.t.); //150 //175 // 130 ,oBtn1:move(arect[3] -aRect[1]- 102,5 ,,,.t.); //14 * ,oBtn5:move(arect[3] -aRect[1]- 102,197 ,,,.t.); //106 ,oBtn7:move(arect[3] -aRect[1]- 102,380 ,,,.t.); //16 ,oBtn2:move(arect[3] -aRect[1]- 132,520 ,,,.t.); //4002 ,oBmp1:move( "",11 ,,,.t.); //calculate ,oBmp5:move(arect[3] -aRect[1]- 168,380 ,,,.t.); // Info ,oBtn4:move( "",575 ,,,.t.); //calculate ,oCbx:move(arect[3] -aRect[1]- 102,605 ,,,.t.); //Transfer data ,oCbx1:move(arect[3] -aRect[1]- 132,605 ,,,.t.); // ,oCbx2:move(arect[3] -aRect[1]- 132,5 ,,,.t.); //15 * ,oCbx3:move(arect[3] -aRect[1]- 132,197 ,,,.t.); //14 ,oSay11:move(arect[3]-aRect[1]- 132,806 ,,,.t.); // ,oSay12:move(arect[3]-aRect[1]- 111,806 ,,,.t.); // ,oCbx4:move( "",675 ,,,.t.); //reports ,oSay13:move( "",845 ,,,.t.); // ,oSay20:move(arect[3] -aRect[1]-168,5 ,,,.t.); // 75 * //120 ,oSay21:move(arect[3] -aRect[1]-168,197 ,,,.t.); // 75 * ,oBtn3:move(arect[3] -aRect[1]-132,380 ,,,.t.)} //103 //,oBmp5:move( "",51 ,,,.t.); //calculate endif endif if (oWnd1:nRight > 600 .AND. oWnd1:nRight < 1020) bFont := getFontInfo(hFont) if bFont[1] <= 16 ODLG:BRESIZED := ; {|| aRect := GetWndRect(oDlg:hWnd), ; oBrw:Move( 24,1,arect[ 4 ]-arect[ 2 ] - 27, ; aRect[3]-aRect[1]-150,.t.); ,oBtn1:move(arect[3] -aRect[1]- 55,5, , ,.t.); //14 ,oBtn5:move(arect[3] -aRect[1]- 55,177 ,,,.t.); //106 ,oBtn7:move(arect[3] -aRect[1]- 55,333 ,,,.t.); //16 ,oBtn2:move(arect[3] -aRect[1]- 85,433 ,,,.t.); //4002 ,oBmp1:move( "",11 ,,,.t.); //calculate ,oBmp5:move(arect[3] -aRect[1]- 119,352 ,,,.t.); // Info ,oBtn4:move( "",600 ,,,.t.); //calculate ,oCbx:move(arect[3] -aRect[1]- 55,519 ,,,.t.); //Transfer data ,oCbx1:move(arect[3] -aRect[1]- 85,519 ,,,.t.); // ,oCbx2:move(arect[3] -aRect[1]- 85,5 ,,,.t.); //15 ,oCbx3:move(arect[3] -aRect[1]- 85,177 ,,,.t.); //14 ,oSay11:move(arect[3]-aRect[1]- 85,805 ,,,.t.); // ,oSay12:move(arect[3]-aRect[1]- 52,805 ,,,.t.); // ,oCbx4:move( "",680 ,,,.t.); //reports ,oSay13:move( "",804 ,,,.t.); // ,oSay20:move(arect[3]-aRect[1]- 115,5 ,,,.t.);// 75 * ,oSay21:move(arect[3]-aRect[1]- 115,177 ,,,.t.);// 75 * ,oBtn3:move(arect[3] -aRect[1]- 85,349 ,,,.t.),oBrw:refresh()} //103 else oDlg:bResized := ; {|| aRect := GetWndRect(oDlg:hWnd), ; oBrw:Move( 24,4,arect[ 4 ]-arect[ 2 ] -16, ; //16 aRect[3]-aRect[1]-175,.t.); //150 // 130 ,oBtn1:move(arect[3] -aRect[1]- 89,5 ,,,.t.); //14 * ,oBtn5:move(arect[3] -aRect[1]- 89,197 ,,,.t.); //106 ,oBtn7:move(arect[3] -aRect[1]- 89,380 ,,,.t.); //16 ,oBtn2:move(arect[3] -aRect[1]- 119,400 ,,,.t.); //4002 ,oBmp1:move( "",11 ,,,.t.); //calculate ,oBmp5:move( "",51 ,,,.t.); //calculate ,oBtn4:move( "",575 ,,,.t.); //calculate ,oCbx:move(arect[3] -aRect[1]- 89,605 ,,,.t.); //Transfer data ,oCbx1:move(arect[3] -aRect[1]- 119,605 ,,,.t.); // ,oCbx2:move(arect[3] -aRect[1]- 119,5 ,,,.t.); //15 * ,oCbx3:move(arect[3] -aRect[1]- 119,197 ,,,.t.); //14 ,oSay11:move(arect[3]-aRect[1]- 119,806 ,,,.t.); // ,oSay12:move(arect[3]-aRect[1]- 111,806 ,,,.t.); // ,oCbx4:move( "",675 ,,,.t.); //reports ,oSay13:move( "",845 ,,,.t.); // ,oSay20:move(arect[3] -aRect[1]-145,5 ,,,.t.); // 75 * //120 ,oSay21:move(arect[3] -aRect[1]-145,197 ,,,.t.); // 75 * ,oBtn3:move(arect[3] -aRect[1]-119,380 ,,,.t.)} //103 endif endif redefine column xbrowse oBrw ID 101 of oDlg cell lines //autocols //fastedit if cFixoDbf == .f. select bal database oDbf oDbf:GoTop() #translate oDbf:bal: => oDbf: oBrw:SetoDbf(oDbf) else select gl database oDbf oDbf:GoTop() oBrw:SetoDbf(oDbf) #translate oDbf:gl: => oDbf: oBrw:nFreeze := 4 // freeze endif oBrw:nMARQueesTYLE := MARQSTYLE_HIGHLROW msize := 68 // 78 if mWhichCountry == .t. // CANADA if !EMPTY(cFrecast) ADD COLUMN TO xbrowse oBrw data {|| trans(oBrw:oDbf:gl:trend, '@Z 999.9') }; SIZE 40 COLOR CLR_BLACK, CLR_WHITE LEFT HEADER "TrendIt" ADD COLUMN TO xbrowse oBrw DATA {|| if(gl->gst == 1, "Yes", if(gl->gst == 0, " ",)) }; SIZE 25 COLOR CLR_BLACK, CLR_WHITE LEFT HEADER "GST" // blank cursor colm else ADD COLUMN TO xbrowse oBrw DATA {|| if(gl->gst == 1, "Yes", if(gl->gst == 0, " ",)) }; SIZE 25 COLOR CLR_BLACK, CLR_WHITE LEFT HEADER "GST" // blank cursor colm endif else if !EMPTY(cFrecast) ADD COLUMN TO xbrowse oBrw data {|| trans(oBrw:oDbf:gl:trend, '@Z 999.9') }; SIZE 40 COLOR CLR_BLACK, CLR_WHITE LEFT HEADER "TrendIt" else //oBrw:hBmpCursor := LoadBitmap( GetResources(), "Z_Finger" ) ADD COLUMN TO xbrowse oBrw DATA {|| if(gl->gst == 1, " ", if(gl->gst == 0, " ",)) }; SIZE 20 COLOR CLR_BLACK, CLR_WHITE LEFT HEADER " " // blank cursor colm endif endif gl->(dbGoTop()) oBrw:bLDblClick := { | nRow,nCol | if (nNewVar == 1,msginfo("Editing is not available while vewing this report."),(odlg:hide(),apicard( oBrw, nRow, nCol, odlg))),oBrw:refresh(); ,oBrw:setfocus(),odlg:show(),needCalc(oDlg),oBrw:refresh(),odlg:setfocus(),mPassMess := .t.} oBrw:bKeyChar := { | nKey,nRow,nCol | if(nKey=VK_RETURN,; (IF(nNewVar == 1,msginfo("Editing is not available while in this report."); ,(odlg:hide(),apicard( oBrw, nRow, nCol, odlg))),whatUsing(oDlg),oDlg:update(),oBrw:refresh(),oBrw:setfocus(),odlg:show(),needCalc(oDlg)),)} // 2007 oBrw:bRClicked := { | nRow,nCol | build(oBrw, nRow, nCol, odlg),oBrw:refresh(),oBrw:setfocus(),odlg:setfocus(),mPassMess := .t.} ADD COLUMN TO xBROWSE oBrw ; data {|| if(gl->title == repli('-', 30), repli(' ' , 30), ; if(gl->title == repli('=', 30), repli(' ', 30), ; eval(cBal))) }; SIZE 140 LEFT HEADER "Account (dblclick to edit)" COLOR CLR_BLACK,CLR_HGRAY ADD COLUMN to xBrowse oBrw ; DATA {|| if(gl->title == repli('-', 30), repli(' ' , 30), ; if(gl->title == repli('=', 30), repli(' ', 30), ; if(gl->account == "2053" .or. gl->account == "2514".or. gl->account == "2632", repli(' ', 30), ; if(gl->account == "2733", repli(' ', 30), ; if(gl->account == "2833" .or. gl->account == "2933", repli(' ', 30), ; if(gl->account == "2998" .or. gl->account == "3355", repli(' ', 30), ; if(gl->account == "3485" , repli(' ', 30), ; trans(eval(bty13), '999,999,999') ))))))) }; SIZE 71 RIGHT HEADER cOne COLOR CLR_BLACK,CLR_WHITE

by **James Bott** » Mon Aug 25, 2008 3:33 pm

You may need to compile a copy of TXBROWSE.PRG and link it into your app, then make it error out, so you can find the line number in Txbrowse where the error is occuring.

Regards,
James

by **James Bott** » Mon Aug 25, 2008 4:03 pm

Here is a programming tip. This code:

Code: Select all Expand view RUN: if(gl->account == "2053" .or. gl->account == "2514".or. gl->account == "2632", repli(' ', 30), ; if(gl->account == "2733", repli(' ', 30), ; if(gl->account == "2833" .or. gl->account == "2933", repli(' ', 30), ; if(gl->account == "2998" .or. gl->account == "3355", repli(' ', 30), ; if(gl->account == "3485" , repli(' ', 30), ;

Could be simplified to:

Code: Select all Expand view RUN: if( at(gl->account, "2053 2514 2632 2733 2833 2933 2998 3355 3485") > 0, space(30), ... )

Or better yet, move the account numbers to a file so they are more easily updated without recompiling. So then you have something like:

Code: Select all Expand view RUN: if( at(gl->account, cSpecialAccounts) > 0, space(30), ... )

Regards,
James

by **hag** » Tue Aug 26, 2008 3:01 am

James

Thanks for the tip. I'm a real amature at this. I have only one program i've been dealing with for the last 18 years and I know my program and but I can use all the help can get. I don't do programing. Just the one. I am a practicing CPA in LA. Developed my prgram in '89 and been improving ever since. Fivewin has been a absolute life saver. I remember you from the old Omnicrom days. Never moved from fw192 til now and its been a pleasure converting to 32bits even though I have a number of things that don't seem to work right.

The theme issue is my concern at this time. It doesn't work. I get all the nice rounded dialogs and blue color if I use "windowsXP.manefest" or not. If I use the manifest nothing happens. None of the other items on my dialogs such as coloring borders of says and gets, rounded buttons etc. Just doesn't work. Any thoughts?

by **hag** » Tue Aug 26, 2008 3:15 am

James:

>You may need to compile a copy of TXBROWSE.PRG and link it into your >app, then make it error out, so you can find the line number in >Txbrowse where the error is occuring.

line txbrowse. 4282....

Thanks for your help.

by **James Bott** » Tue Aug 26, 2008 3:56 am

Harvey,

>The theme issue is my concern at this time. It doesn't work. I get all the nice rounded dialogs and blue color if I use "windowsXP.manefest" or not. If I use the manifest nothing happens. None of the other items on my dialogs such as coloring borders of says and gets, rounded buttons etc. Just doesn't work. Any thoughts?

Try compiling fwh\samples\win32.prg with buildh.bat or buildx.bat (depending on whether you are using Harbour or xHarbour) and see if the controls are themed.

I seem to remember you are using a DLL, is that true? I always use RC files instead--these are compiled right into the EXE. Perhaps there is a problem with the theme when using a DLL. Try converting your DLL to an RC (using Workshop; File Save As) and linking it into your app (see the buildh.bat for how).

I always had trouble trying to edit 32bit DLLs with Workshop--they end up corrupted. So, it is my suggestion to use RCs instead.

>I am a practicing CPA in LA.

Is your program a cash flow analysis program or something like that? If so, I remember conversing with you many years ago.

Regards,
James

by **hag** » Tue Aug 26, 2008 4:05 am

Try that:

http://www.upyourcashflow.com

by **James Bott** » Tue Aug 26, 2008 4:10 am

Harvey,

Yes, the name of the program came to me right after I posted my last message. I think we had some discussions when you were getting ready to convert your old DOS version to Windows.

Glad to hear your program is still doing well.

Regards,
James

by **hag** » Tue Aug 26, 2008 4:22 am

Many many years ago. 1995...Thanks to fivewin.

If I compile my rc into exe. How are they called in the program.

Now is define odlg resources "Name"of etc...

since no longer using the dll what do I do?

Compiled win32 and has the theme.

FiveTech Software tech support forums

Using oBrw:print() only prints whats on screen

Using oBrw:print() only prints whats on screen

Who is online