Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #8582 > unrolled thread

ReportPro 2.17b support

Started by"Pedro M. Espinosa" <pmespinosa@gmail.com>
First post2015-10-28 17:13 -0700
Last post2015-12-21 14:54 +0100
Articles 6 on this page of 46 — 9 participants

Back to article view | Back to comp.lang.clipper.visual-objects


Contents

  ReportPro 2.17b support "Pedro M. Espinosa" <pmespinosa@gmail.com> - 2015-10-28 17:13 -0700
    Re: ReportPro 2.17b support Franz Rachbauer <office@rachbauer.org> - 2015-10-29 07:40 +0100
      Re: ReportPro 2.17b support "Pedro M. Espinosa" <pmespinosa@gmail.com> - 2015-10-30 14:26 -0700
        Re: ReportPro 2.17b support Karl Faller <mail_withoutthat_@_drei-f_andthat_.de> - 2015-11-08 23:29 +0100
          Re: ReportPro 2.17b support "Pedro M. Espinosa" <pmespinosa@gmail.com> - 2015-11-09 16:49 -0800
        Re: ReportPro 2.17b support Franz Rachbauer <office@rachbauer.org> - 2015-11-09 07:43 +0100
        Re: ReportPro 2.17b support Robert van der Hulst <rjvanderhulst@gmail.com> - 2015-11-09 01:02 -0800
          Re: ReportPro 2.17b support "Pedro M. Espinosa" <pmespinosa@gmail.com> - 2015-11-09 16:58 -0800
    Re: ReportPro 2.17b support "Jamal Assaf" <someone@example.com> - 2015-10-29 12:44 -0400
      Re: ReportPro 2.17b support "Pedro M. Espinosa" <pmespinosa@gmail.com> - 2015-11-01 20:26 -0800
    Re: ReportPro 2.17b support "Willie Moore" <williem@wmconsulting.com> - 2015-11-10 08:30 -0600
      Re: ReportPro 2.17b support "Pedro M. Espinosa" <pmespinosa@gmail.com> - 2015-11-10 11:21 -0800
        Re: ReportPro 2.17b support Franz Rachbauer <office@rachbauer.org> - 2015-11-11 07:53 +0100
          Re: ReportPro 2.17b support "Pedro M. Espinosa" <pmespinosa@gmail.com> - 2015-11-11 08:28 -0800
          Re: ReportPro 2.17b support "Pedro M. Espinosa" <pmespinosa@gmail.com> - 2015-11-11 11:10 -0800
            Re: ReportPro 2.17b support Franz Rachbauer <office@rachbauer.org> - 2015-11-12 10:39 +0100
              Re: ReportPro 2.17b support "Pedro M. Espinosa" <pmespinosa@gmail.com> - 2015-11-12 10:41 -0800
                Re: ReportPro 2.17b support "Pedro M. Espinosa" <pmespinosa@gmail.com> - 2015-11-12 12:43 -0800
                  Re: ReportPro 2.17b support Franz Rachbauer <office@rachbauer.org> - 2015-11-13 07:04 +0100
                    Re: ReportPro 2.17b support "Pedro M. Espinosa" <pmespinosa@gmail.com> - 2015-11-13 06:21 -0800
                      Re: ReportPro 2.17b support Franz Rachbauer <office@rachbauer.org> - 2015-11-14 20:11 +0100
      Re: ReportPro 2.17b support "Pedro M. Espinosa" <pmespinosa@gmail.com> - 2015-11-18 10:14 -0800
        Re: ReportPro 2.17b support nicktekhne@googlemail.com - 2015-11-18 11:00 -0800
          Re: ReportPro 2.17b support "Pedro M. Espinosa" <pmespinosa@gmail.com> - 2015-11-18 11:35 -0800
        Re: ReportPro 2.17b support Franz Rachbauer <office@rachbauer.org> - 2015-11-19 07:07 +0100
          Re: ReportPro 2.17b support "Wolfgang Riedmann" <wriedmann@gmail.com> - 2015-11-19 07:52 +0100
        Re: ReportPro 2.17b support "Willie Moore" <williem@wmconsulting.com> - 2015-11-20 09:19 -0600
          Re: ReportPro 2.17b support Fabio Romling Rotheia <pinbitmap@gmail.com> - 2015-11-20 11:06 -0800
            Re: ReportPro 2.17b support "Willie Moore" <williem@wmconsulting.com> - 2015-11-20 14:03 -0600
              Re: ReportPro 2.17b support Fabio Romling Rotheia <pinbitmap@gmail.com> - 2015-11-22 19:05 -0800
            Re: ReportPro 2.17b support "Pedro M. Espinosa" <pmespinosa@gmail.com> - 2015-11-20 16:02 -0800
              Re: ReportPro 2.17b support Fabio Romling Rotheia <pinbitmap@gmail.com> - 2015-11-22 19:09 -0800
                Re: ReportPro 2.17b support "Pedro M. Espinosa" <pmespinosa@gmail.com> - 2015-11-27 16:03 -0800
        Re: ReportPro 2.17b support "Willie Moore" <williem@wmconsulting.com> - 2015-11-20 15:27 -0600
          Re: ReportPro 2.17b support "Pedro M. Espinosa" <pmespinosa@gmail.com> - 2015-11-20 13:38 -0800
            Re: ReportPro 2.17b support "Willie Moore" <williem@wmconsulting.com> - 2015-11-22 04:26 -0600
            Re: ReportPro 2.17b support "Willie Moore" <williem@wmconsulting.com> - 2015-11-27 13:22 -0600
              Re: ReportPro 2.17b support "Pedro M. Espinosa" <pmespinosa@gmail.com> - 2015-11-27 14:23 -0800
              Re: ReportPro 2.17b support "Pedro M. Espinosa" <pmespinosa@gmail.com> - 2015-11-27 17:42 -0800
              Re: ReportPro 2.17b support "Pedro M. Espinosa" <pmespinosa@gmail.com> - 2015-11-30 10:24 -0800
                Re: ReportPro 2.17b support "Willie Moore" <williem@wmconsulting.com> - 2015-11-30 15:41 -0600
                  Re: ReportPro 2.17b support "Pedro M. Espinosa" <pmespinosa@gmail.com> - 2015-12-01 07:53 -0800
                    Re: ReportPro 2.17b support "Willie Moore" <williem@wmconsulting.com> - 2015-12-01 14:44 -0600
    Re: ReportPro 2.17b support Franz Rachbauer <office@rachbauer.org> - 2015-12-21 07:53 +0100
      Re: ReportPro 2.17b support "Willie Moore" <williem@wmconsulting.com> - 2015-12-21 03:27 -0600
        Re: ReportPro 2.17b support Franz Rachbauer <office@rachbauer.org> - 2015-12-21 14:54 +0100

Page 3 of 3 — ← Prev page 1 2 [3]


#8761

From"Willie Moore" <williem@wmconsulting.com>
Date2015-11-30 15:41 -0600
Message-ID<n3ifr5$tqj$1@speranza.aioe.org>
In reply to#8759
Pedro,

Please take a look at the properties of your rpSQL32 Test aef. There should 
not be a reference to the rpDSN lib anymore. As to the first issue. Before 
it was not compiling the codeblock properly which is why you were getting 
the error moving to the first record after changing the picture of a field. 
The setVarInitExpression uses the same code as fieldspec to build the 
expression at runtime. SetvariableValue does not set a codeblock. Please 
send me a small example of exactly how you are calling it so I can debug. 
Below is the relevant section of the source.

Regards,
Willie
Grafx Development Team

method SetVariableValue(cName as string,xValue as usual) as logic pascal 
class rpSection

    local nEle     as dword
    local oVar     as rpVariable

    cName    :=upper(alltrim(cName))
    nEle        :=ascan(self:aVars,{|x| upper(alltrim(x:cName))==cName})

    if nEle==0
        return false
    endif

    oVar            :=self:aVars[nEle]
    oVar:uValue        :=xValue
    oVar:uSetValue     :=xValue
    oVar:cIniExp        :=""
    oVar:bIniBlk        :=nil
    return true

method SetVarInitExpression(cName as string,xExpression as usual) as logic 
pascal class rpSection

    local nEle     as dword
    local oVar     as rpVariable

    cName    :=upper(alltrim(cName))
    nEle        :=ascan(self:aVars,{|x| upper(alltrim(x:cName))==cName})

    if nEle==0
        return false
    endif

    oVar    :=self:aVars[nEle]

    if UsualType(xExpression)==STRING
        oVar:cIniExp:=xExpression
        if self:oRpReport:lConnected
            oVar:bIniBlk:=self:ExpBlk(oVar:cIniExp)
        endif

    elseif UsualType(xExpression)==CODEBLOCK
        oVar:cIniExp    :=""
        oVar:bIniBlk    :=xExpression
    endif
    return true 

[toc] | [prev] | [next] | [standalone]


#8767

From"Pedro M. Espinosa" <pmespinosa@gmail.com>
Date2015-12-01 07:53 -0800
Message-ID<0028379e-e8c3-454a-a96f-45f002d7283e@googlegroups.com>
In reply to#8761
On Monday, November 30, 2015 at 3:42:02 PM UTC-6, Willie Moore wrote:
> Pedro,
> 
> Please take a look at the properties of your rpSQL32 Test aef. There should 
> not be a reference to the rpDSN lib anymore. As to the first issue. Before 
> it was not compiling the codeblock properly which is why you were getting 
> the error moving to the first record after changing the picture of a field. 
> The setVarInitExpression uses the same code as fieldspec to build the 
> expression at runtime. SetvariableValue does not set a codeblock. Please 
> send me a small example of exactly how you are calling it so I can debug. 
> Below is the relevant section of the source.
> 
> Regards,
> Willie
> Grafx Development Team
> 
> method SetVariableValue(cName as string,xValue as usual) as logic pascal 
> class rpSection
> 
>     local nEle     as dword
>     local oVar     as rpVariable
> 
>     cName    :=upper(alltrim(cName))
>     nEle        :=ascan(self:aVars,{|x| upper(alltrim(x:cName))==cName})
> 
>     if nEle==0
>         return false
>     endif
> 
>     oVar            :=self:aVars[nEle]
>     oVar:uValue        :=xValue
>     oVar:uSetValue     :=xValue
>     oVar:cIniExp        :=""
>     oVar:bIniBlk        :=nil
>     return true
> 
> method SetVarInitExpression(cName as string,xExpression as usual) as logic 
> pascal class rpSection
> 
>     local nEle     as dword
>     local oVar     as rpVariable
> 
>     cName    :=upper(alltrim(cName))
>     nEle        :=ascan(self:aVars,{|x| upper(alltrim(x:cName))==cName})
> 
>     if nEle==0
>         return false
>     endif
> 
>     oVar    :=self:aVars[nEle]
> 
>     if UsualType(xExpression)==STRING
>         oVar:cIniExp:=xExpression
>         if self:oRpReport:lConnected
>             oVar:bIniBlk:=self:ExpBlk(oVar:cIniExp)
>         endif
> 
>     elseif UsualType(xExpression)==CODEBLOCK
>         oVar:cIniExp    :=""
>         oVar:bIniBlk    :=xExpression
>     endif
>     return true

Hi Willie:
Last night I sent you a small sample to your email, consisting of the RPT file along with the DBF's and CDX's involved and a simplified Method (PRG file) for you to see
Regards
Pedro

[toc] | [prev] | [next] | [standalone]


#8773

From"Willie Moore" <williem@wmconsulting.com>
Date2015-12-01 14:44 -0600
Message-ID<n3l0r8$lus$1@speranza.aioe.org>
In reply to#8767
Pedro,

Thank you for your sample. I am looking at it. I will try to get you a new 
build this week.

Regards,
Willie
Grafx Development Team

"Pedro M. Espinosa"  wrote in message 
news:0028379e-e8c3-454a-a96f-45f002d7283e@googlegroups.com...

On Monday, November 30, 2015 at 3:42:02 PM UTC-6, Willie Moore wrote:
> Pedro,
>
> Please take a look at the properties of your rpSQL32 Test aef. There 
> should
> not be a reference to the rpDSN lib anymore. As to the first issue. Before
> it was not compiling the codeblock properly which is why you were getting
> the error moving to the first record after changing the picture of a 
> field.
> The setVarInitExpression uses the same code as fieldspec to build the
> expression at runtime. SetvariableValue does not set a codeblock. Please
> send me a small example of exactly how you are calling it so I can debug.
> Below is the relevant section of the source.
>
> Regards,
> Willie
> Grafx Development Team
>
> method SetVariableValue(cName as string,xValue as usual) as logic pascal
> class rpSection
>
>     local nEle     as dword
>     local oVar     as rpVariable
>
>     cName    :=upper(alltrim(cName))
>     nEle        :=ascan(self:aVars,{|x| upper(alltrim(x:cName))==cName})
>
>     if nEle==0
>         return false
>     endif
>
>     oVar            :=self:aVars[nEle]
>     oVar:uValue        :=xValue
>     oVar:uSetValue     :=xValue
>     oVar:cIniExp        :=""
>     oVar:bIniBlk        :=nil
>     return true
>
> method SetVarInitExpression(cName as string,xExpression as usual) as logic
> pascal class rpSection
>
>     local nEle     as dword
>     local oVar     as rpVariable
>
>     cName    :=upper(alltrim(cName))
>     nEle        :=ascan(self:aVars,{|x| upper(alltrim(x:cName))==cName})
>
>     if nEle==0
>         return false
>     endif
>
>     oVar    :=self:aVars[nEle]
>
>     if UsualType(xExpression)==STRING
>         oVar:cIniExp:=xExpression
>         if self:oRpReport:lConnected
>             oVar:bIniBlk:=self:ExpBlk(oVar:cIniExp)
>         endif
>
>     elseif UsualType(xExpression)==CODEBLOCK
>         oVar:cIniExp    :=""
>         oVar:bIniBlk    :=xExpression
>     endif
>     return true

Hi Willie:
Last night I sent you a small sample to your email, consisting of the RPT 
file along with the DBF's and CDX's involved and a simplified Method (PRG 
file) for you to see
Regards
Pedro 

[toc] | [prev] | [next] | [standalone]


#8829

FromFranz Rachbauer <office@rachbauer.org>
Date2015-12-21 07:53 +0100
Message-ID<n587lg$75q$1@speranza.aioe.org>
In reply to#8582
Hi Willie,
if you fix some bugs in RP 2.17, I've another one in RP2SQL32 for you: 
If you have a field tinyint(x) in MySQL it's returned as valtype C 
instead of N.

Regards, Franz

[toc] | [prev] | [next] | [standalone]


#8830

From"Willie Moore" <williem@wmconsulting.com>
Date2015-12-21 03:27 -0600
Message-ID<n58gmh$p0n$1@speranza.aioe.org>
In reply to#8829
Franz,

I will need a sample report that demonstrates the issue.

Regards,
Willie
Grafx Development Team

"Franz Rachbauer"  wrote in message news:n587lg$75q$1@speranza.aioe.org... 

Hi Willie,
if you fix some bugs in RP 2.17, I've another one in RP2SQL32 for you: 
If you have a field tinyint(x) in MySQL it's returned as valtype C 
instead of N.

Regards, Franz

[toc] | [prev] | [next] | [standalone]


#8833

FromFranz Rachbauer <office@rachbauer.org>
Date2015-12-21 14:54 +0100
Message-ID<n590b9$tts$2@speranza.aioe.org>
In reply to#8830
Hi Willie,
create a table in MySQL (I used V5.6) and insert some data:

create table test_tinyint (xyz tinyint(2) default 0);
insert into test_tinyint values (0);
insert into test_tinyint values (1);

Then configure ODBC DNS named RBKASSA (I used MySQL ODBC 5.1) and run 
report downloaded from http://www.rachbauer.org/test_tinyint.zip .

I could not attach report directly because newsserver said "invalid 
content type".

Regards Franz

Am 21.12.2015 um 10:27 schrieb Willie Moore:
> Franz,
>
> I will need a sample report that demonstrates the issue.
>
> Regards,
> Willie
> Grafx Development Team
>
> "Franz Rachbauer"  wrote in message news:n587lg$75q$1@speranza.aioe.org...
> Hi Willie,
> if you fix some bugs in RP 2.17, I've another one in RP2SQL32 for you:
> If you have a field tinyint(x) in MySQL it's returned as valtype C
> instead of N.
>
> Regards, Franz

[toc] | [prev] | [standalone]


Page 3 of 3 — ← Prev page 1 2 [3]

Back to top | Article view | comp.lang.clipper.visual-objects


csiph-web