Data Access Worldwide Forums - Open Source http://support.dataaccess.com/Forums/ The Open Source area is a discussion and up/download area to share files within the developer community. en Wed, 19 Jun 2013 18:24:37 GMT vBulletin 60 http://support.dataaccess.com/Forums/images/misc/rss.png Data Access Worldwide Forums - Open Source http://support.dataaccess.com/Forums/ <![CDATA[L&L Blank Line]]> http://support.dataaccess.com/Forums/showthread.php?50735-L-amp-L-Blank-Line&goto=newpost Sun, 09 Jun 2013 18:45:11 GMT So using L&L version 16, how does one show a blank line in a table? I've set the "Ignore blank line" property to "No", tried setting the fixed height and a few other things and no joy. The only way I've been able to do it is to put some kind of character in it which kind of goes against the blank line concept. ]]> Open Source Bob Worsley http://support.dataaccess.com/Forums/showthread.php?50735-L-amp-L-Blank-Line <![CDATA[L&L Two tables]]> http://support.dataaccess.com/Forums/showthread.php?50688-L-amp-L-Two-tables&goto=newpost Tue, 04 Jun 2013 02:42:56 GMT I tried to create a single page report that pulls data from two small 5-row tables. I therefore created a two L&L table report using the cListLabelWrapper class. The single table works as expected but when I include the second one everything gets screwy (technical term...). I found a section in the developer manual that talks about using two L&L tables in one report but I didn't understand what it was trying to say - a little cryptic. Judging from the fact that the first table pretty much works, I'd guess there's some kind of initialization or special handling necessary for the second table. Ideas on how I should do this?

Code:
        Send SQLSetConnect of hoSQL MSSQLDRV_ID TM_CONNECT
        Get SQLConnect    of hoSQL "" "" to hdbc
        If (hdbc <> 0) Begin
            Get SQLOpen of hdbc to hstmt
            If (hstmt <> 0) Begin
                Get psLocalArea to sArea
                Get sGetLoadSQL_Local iCustomerID sArea to sSQL
                Send SQLExecDirect of hstmt sSQL
   
                Repeat
                    Get SQLFetch of hstmt to iFetchResult
                    If (iFetchResult <> 0) Begin
                        Get SQLColumnValue of hstmt 1 to sArea
                        Get SQLColumnValue of hstmt 2 to sSpecial
                        Get SQLColumnValue of hstmt 3 to iCustomerID
                        Get SQLColumnValue of hstmt 4 to sTerminal
                        Get SQLColumnValue of hstmt 5 to nMinimum
                        Get SQLColumnValue of hstmt 6 to nFrom100
                        Get SQLColumnValue of hstmt 7 to nFrom1000
                        Get SQLColumnValue of hstmt 8 to nFrom2000
                        Get SQLColumnValue of hstmt 9 to nFrom3000
                        Get SQLColumnValue of hstmt 10 to nFrom5000
                        Get SQLColumnValue of hstmt 11 to nCap

                        Set psLocalArea to sArea
                        Set pnMin to nMinimum
                        Set pn100 to nFrom100
                        Set pn1000 to nFrom1000
                        Set pn2000 to nFrom2000
                        Set pn3000 to nFrom3000
                        Set pn5000 to nFrom5000
                        Set pnCap to nCap

                        Get PrintData of hoLL to iRet
                        Move 1 to iPrinted
                    End
                Until (iFetchResult = 0)
                Send SQLClose of hstmt
            End
            Send SQLDisconnect of hdbc
        End

//******************************************************************
// Second table routine
//******************************************************************
        Get LLPrintFields of hoLL to iRet

        Move 0 to iPrinted
   
        Get SQLConnect    of hoSQL "" "" to hdbc2
        If (hdbc2 <> 0) Begin
            Get SQLOpen of hdbc2 to hstmt2
            If (hstmt2 <> 0) Begin
                Get psLocalArea to sArea
                Get sGetLoadSQL_Special sArea to sSQL
                Send SQLExecDirect of hstmt2 sSQL
   
                Repeat
                    Get SQLFetch of hstmt2 to iFetchResult
                    If (iFetchResult <> 0) Begin
                        Get SQLColumnValue of hstmt2 1 to sArea
                        Get SQLColumnValue of hstmt2 2 to nDailyDay
                        Get SQLColumnValue of hstmt2 3 to nDailyEvening
                        Get SQLColumnValue of hstmt2 4 to nDailyMid
                        Get SQLColumnValue of hstmt2 5 to nSatDay
                        Get SQLColumnValue of hstmt2 6 to nSatEvening
                        Get SQLColumnValue of hstmt2 7 to nSunHol

                        Set psSpecArea    to sArea
                        Set pnSpecMFDay  to nDailyDay
                        Set pnSpecMFEve  to nDailyEvening
                        Set pnSpecMFNight to nDailyMid
                        Set pnSpecSatAM  to nSatDay
                        Set pnSpecSatPM  to nSatEvening
                        Set pnSpecSun    to nSunHol
                       
                        Get PrintData of hoLL to iRet
                       
                        Move 1 to iPrinted
                    End
                Until (iFetchResult = 0)
                Send SQLClose of hstmt2
            End
            Send SQLDisconnect of hdbc2
        End
]]> Open Source Bob Worsley http://support.dataaccess.com/Forums/showthread.php?50688-L-amp-L-Two-tables