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


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

ReportPro 3 problem

Started by"Jack Konings" <Gordon_remove_this_.Freeman@Live_dot.nl>
First post2014-03-27 21:48 +0100
Last post2014-03-29 13:15 -0400
Articles 5 — 2 participants

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


Contents

  ReportPro 3 problem "Jack Konings" <Gordon_remove_this_.Freeman@Live_dot.nl> - 2014-03-27 21:48 +0100
    Re: ReportPro 3 problem "Jamal" <someone@example.com> - 2014-03-27 18:56 -0400
      Re: ReportPro 3 problem "Jack Konings" <Gordon_remove_this_.Freeman@Live_dot.nl> - 2014-03-28 20:21 +0100
      Re: ReportPro 3 problem "Jack Konings" <Gordon_remove_this_.Freeman@Live_dot.nl> - 2014-03-28 20:32 +0100
        Re: ReportPro 3 problem "Jamal" <someone@example.com> - 2014-03-29 13:15 -0400

#6715 — ReportPro 3 problem

From"Jack Konings" <Gordon_remove_this_.Freeman@Live_dot.nl>
Date2014-03-27 21:48 +0100
SubjectReportPro 3 problem
Message-ID<b1de6$53348eb7$541cf385$31712@cache1.tilbu1.nb.home.nl>
Hi All,

I'm having some trouble with RP3.
I defined the variable 
N_vrij:=365.25*Brn1.Brn_Hlf*log(10000*Brn_Eig.A1waarde/Brn1.Brn_Ref)/-log(2). 
With this variable I calculate the days until a certain event will occur. 
Typical values are around 10.000 days.
I checked these values and RP3 displays them correctly. So these value seem 
to be valid and usable for RP3.

In order to get the correct date of the event I defined the variable 
D_vrij:=ctod(Brn1.Ref_Dat)+N_vrij.

Unfortunately RP doesn't like this expression and gives an expression error.
If the variable is defined as D_vrij:=ctod(Brn1.Ref_Dat)+10000, it works 
(but the calculated date is obviously not exact).
If the variable is defined as D_vrij:=ctod(Brn1.Ref_Dat)+val(str(N_vrij)), 
RP crashes (sometimes direct or after a few attempts).

Some advice on how to solve this is appreciated.
For what it's worth, I'm working on VO28SP4b, RP3.9, WIN8.1.

TIA,

Jack 

[toc] | [next] | [standalone]


#6717

From"Jamal" <someone@example.com>
Date2014-03-27 18:56 -0400
Message-ID<lh2aa7$ta9$1@speranza.aioe.org>
In reply to#6715
Jack,

For testing purposes, does setting N_vrij := 10000 work with no errors? If 
it does, then something wrong with expression.

Does this return an integer or a float value? 
N_vrij:=365.25*Brn1.Brn_Hlf*log(10000*Brn_Eig.A1waarde/Brn1.Brn_Ref)/-log(2).
If it return a float, this could be a problem!

What happens if you convert return value? For example:

N_vrij:= 
INTEGER(365.25*Brn1.Brn_Hlf*log(10000*Brn_Eig.A1waarde/Brn1.Brn_Ref)/-log(2)))

HTH,
Jamal

"Jack Konings"  wrote in message 
news:b1de6$53348eb7$541cf385$31712@cache1.tilbu1.nb.home.nl...

Hi All,

I'm having some trouble with RP3.
I defined the variable
N_vrij:=365.25*Brn1.Brn_Hlf*log(10000*Brn_Eig.A1waarde/Brn1.Brn_Ref)/-log(2).
With this variable I calculate the days until a certain event will occur.
Typical values are around 10.000 days.
I checked these values and RP3 displays them correctly. So these value seem
to be valid and usable for RP3.

In order to get the correct date of the event I defined the variable
D_vrij:=ctod(Brn1.Ref_Dat)+N_vrij.

Unfortunately RP doesn't like this expression and gives an expression error.
If the variable is defined as D_vrij:=ctod(Brn1.Ref_Dat)+10000, it works
(but the calculated date is obviously not exact).
If the variable is defined as D_vrij:=ctod(Brn1.Ref_Dat)+val(str(N_vrij)),
RP crashes (sometimes direct or after a few attempts).

Some advice on how to solve this is appreciated.
For what it's worth, I'm working on VO28SP4b, RP3.9, WIN8.1.

TIA,

Jack 

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


#6720

From"Jack Konings" <Gordon_remove_this_.Freeman@Live_dot.nl>
Date2014-03-28 20:21 +0100
Message-ID<a17d7$5336956e$541cf385$23343@cache60.multikabel.net>
In reply to#6717
Hi Jamal,

Thanks for your reply.

The return value is a float.
I did the Integer conversion:
N_vrij:=integer(365.25*Brn1.Brn_Hlf*log(10000*Brn_Eig.A1waarde/Brn1.Brn_Ref)/-log(2))
as initialisation and update expression

Now RP3 gives a report error:
The following error was encountered while fetching the next logical record
Description: Data type error
Argument: 9

followed by a crash:
Error code 50 (access violation)
......
error subcode 5333

For some reason N_vrij returns someting RP3 can't handle.


Greetings,

Jack




"Jamal"  wrote in message news:lh2aa7$ta9$1@speranza.aioe.org...

Jack,

For testing purposes, does setting N_vrij := 10000 work with no errors? If
it does, then something wrong with expression.

Does this return an integer or a float value?
N_vrij:=365.25*Brn1.Brn_Hlf*log(10000*Brn_Eig.A1waarde/Brn1.Brn_Ref)/-log(2).
If it return a float, this could be a problem!

What happens if you convert return value? For example:

N_vrij:=
INTEGER(365.25*Brn1.Brn_Hlf*log(10000*Brn_Eig.A1waarde/Brn1.Brn_Ref)/-log(2)))

HTH,
Jamal

"Jack Konings"  wrote in message
news:b1de6$53348eb7$541cf385$31712@cache1.tilbu1.nb.home.nl...

Hi All,

I'm having some trouble with RP3.
I defined the variable
N_vrij:=365.25*Brn1.Brn_Hlf*log(10000*Brn_Eig.A1waarde/Brn1.Brn_Ref)/-log(2).
With this variable I calculate the days until a certain event will occur.
Typical values are around 10.000 days.
I checked these values and RP3 displays them correctly. So these value seem
to be valid and usable for RP3.

In order to get the correct date of the event I defined the variable
D_vrij:=ctod(Brn1.Ref_Dat)+N_vrij.

Unfortunately RP doesn't like this expression and gives an expression error.
If the variable is defined as D_vrij:=ctod(Brn1.Ref_Dat)+10000, it works
(but the calculated date is obviously not exact).
If the variable is defined as D_vrij:=ctod(Brn1.Ref_Dat)+val(str(N_vrij)),
RP crashes (sometimes direct or after a few attempts).

Some advice on how to solve this is appreciated.
For what it's worth, I'm working on VO28SP4b, RP3.9, WIN8.1.

TIA,

Jack 

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


#6721

From"Jack Konings" <Gordon_remove_this_.Freeman@Live_dot.nl>
Date2014-03-28 20:32 +0100
Message-ID<ade83$5336956e$541cf385$23343@cache60.multikabel.net>
In reply to#6717
Hi Jamal,

I think i solved it.
Due to the values of Brn1.Brn_Hlf some very big numbers can occur in N_vrij
I solved it by creating an intermediate variable and only return N_vrij when 
it has a plausible value
N_vrij:=iif( IsHASS, integer(N_vrij), 0)
Then i calculate D_vrij:=ctod(Brn1.Ref_Dat)+N_vrijx
That did the trick.

Again thanks for your input,

Jack




"Jamal"  wrote in message news:lh2aa7$ta9$1@speranza.aioe.org...

Jack,

For testing purposes, does setting N_vrij := 10000 work with no errors? If
it does, then something wrong with expression.

Does this return an integer or a float value?
N_vrij:=365.25*Brn1.Brn_Hlf*log(10000*Brn_Eig.A1waarde/Brn1.Brn_Ref)/-log(2).
If it return a float, this could be a problem!

What happens if you convert return value? For example:

N_vrij:=
INTEGER(365.25*Brn1.Brn_Hlf*log(10000*Brn_Eig.A1waarde/Brn1.Brn_Ref)/-log(2)))

HTH,
Jamal

"Jack Konings"  wrote in message
news:b1de6$53348eb7$541cf385$31712@cache1.tilbu1.nb.home.nl...

Hi All,

I'm having some trouble with RP3.
I defined the variable
N_vrij:=365.25*Brn1.Brn_Hlf*log(10000*Brn_Eig.A1waarde/Brn1.Brn_Ref)/-log(2).
With this variable I calculate the days until a certain event will occur.
Typical values are around 10.000 days.
I checked these values and RP3 displays them correctly. So these value seem
to be valid and usable for RP3.

In order to get the correct date of the event I defined the variable
D_vrij:=ctod(Brn1.Ref_Dat)+N_vrij.

Unfortunately RP doesn't like this expression and gives an expression error.
If the variable is defined as D_vrij:=ctod(Brn1.Ref_Dat)+10000, it works
(but the calculated date is obviously not exact).
If the variable is defined as D_vrij:=ctod(Brn1.Ref_Dat)+val(str(N_vrij)),
RP crashes (sometimes direct or after a few attempts).

Some advice on how to solve this is appreciated.
For what it's worth, I'm working on VO28SP4b, RP3.9, WIN8.1.

TIA,

Jack 

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


#6722

From"Jamal" <someone@example.com>
Date2014-03-29 13:15 -0400
Message-ID<lh6v37$o0e$1@speranza.aioe.org>
In reply to#6721
Hi Jack,

For the future, whenever you have such issues, try the code outside 
ReportPro such as in a VO terminal app, and test the code where you will get 
"better" error messages.
ReportPro error messages are ambiguous and not really helpful!

Jamal

"Jack Konings"  wrote in message 
news:ade83$5336956e$541cf385$23343@cache60.multikabel.net...

Hi Jamal,

I think i solved it.
Due to the values of Brn1.Brn_Hlf some very big numbers can occur in N_vrij
I solved it by creating an intermediate variable and only return N_vrij when
it has a plausible value
N_vrij:=iif( IsHASS, integer(N_vrij), 0)
Then i calculate D_vrij:=ctod(Brn1.Ref_Dat)+N_vrijx
That did the trick.

Again thanks for your input,

Jack




"Jamal"  wrote in message news:lh2aa7$ta9$1@speranza.aioe.org...

Jack,

For testing purposes, does setting N_vrij := 10000 work with no errors? If
it does, then something wrong with expression.

Does this return an integer or a float value?
N_vrij:=365.25*Brn1.Brn_Hlf*log(10000*Brn_Eig.A1waarde/Brn1.Brn_Ref)/-log(2).
If it return a float, this could be a problem!

What happens if you convert return value? For example:

N_vrij:=
INTEGER(365.25*Brn1.Brn_Hlf*log(10000*Brn_Eig.A1waarde/Brn1.Brn_Ref)/-log(2)))

HTH,
Jamal

"Jack Konings"  wrote in message
news:b1de6$53348eb7$541cf385$31712@cache1.tilbu1.nb.home.nl...

Hi All,

I'm having some trouble with RP3.
I defined the variable
N_vrij:=365.25*Brn1.Brn_Hlf*log(10000*Brn_Eig.A1waarde/Brn1.Brn_Ref)/-log(2).
With this variable I calculate the days until a certain event will occur.
Typical values are around 10.000 days.
I checked these values and RP3 displays them correctly. So these value seem
to be valid and usable for RP3.

In order to get the correct date of the event I defined the variable
D_vrij:=ctod(Brn1.Ref_Dat)+N_vrij.

Unfortunately RP doesn't like this expression and gives an expression error.
If the variable is defined as D_vrij:=ctod(Brn1.Ref_Dat)+10000, it works
(but the calculated date is obviously not exact).
If the variable is defined as D_vrij:=ctod(Brn1.Ref_Dat)+val(str(N_vrij)),
RP crashes (sometimes direct or after a few attempts).

Some advice on how to solve this is appreciated.
For what it's worth, I'm working on VO28SP4b, RP3.9, WIN8.1.

TIA,

Jack 

[toc] | [prev] | [standalone]


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


csiph-web