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


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

bArrayServer Seek() Problem

Started byPaulo Oliveira <paulofvoliveira@gmail.com>
First post2017-06-12 14:14 -0700
Last post2017-06-14 15:39 +0200
Articles 6 — 4 participants

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


Contents

  bArrayServer Seek() Problem Paulo Oliveira <paulofvoliveira@gmail.com> - 2017-06-12 14:14 -0700
    Re: bArrayServer Seek() Problem "Jamal" <noooospam@example.com> - 2017-06-12 23:51 -0400
      Re: bArrayServer Seek() Problem Martin <Martin@spam.spam> - 2017-06-13 09:55 +0100
    Re: bArrayServer Seek() Problem Gerhard Bunzel <g.bunzel@domonet.de> - 2017-06-13 14:31 +0200
    Re: bArrayServer Seek() Problem Paulo Oliveira <paulofvoliveira@gmail.com> - 2017-06-14 02:33 -0700
      Re: bArrayServer Seek() Problem Gerhard Bunzel <g.bunzel@domonet.de> - 2017-06-14 15:39 +0200

#10671 — bArrayServer Seek() Problem

FromPaulo Oliveira <paulofvoliveira@gmail.com>
Date2017-06-12 14:14 -0700
SubjectbArrayServer Seek() Problem
Message-ID<873365fb-38bd-42c2-b39d-cd0559b76001@googlegroups.com>
Hi all,

I have a Order in a bArrayServer like this:
SELF:obdbEstruturaFinal:CreateOrder("server:CMARCA+server:PRODUTO+Str(server:SANOCALC,4,0)+Str(server:INRCALC,6,0)")

And this don't work:

cChaveOri:=CMARCA+PRODUTO+Str(SANOCALC,4,0)+Str(INRCALC,6,0)

SELF:obdbEstruturaFinal:Seek(cChaveOri)
			cChave:=SELF:obdbEstruturaFinal:CMARCA+SELF:obdbEstruturaFinal:PRODUTO+Str(SELF:obdbEstruturaFinal:SANOCALC,4,0)+Str(SELF:obdbEstruturaFinal:INRCALC,6,0)
			
DO WHILE cChave==cChaveOri
 SELF:obdbEstruturaFinal:FIELDPUT(#DDTPROD,dData)
		  SELF:obdbEstruturaFinal:FIELDPUT(#SEMANA,ClipWeekNumber(dData))			
				SELF:obdbEstruturaFinal:Skip()				
				cChave:=SELF:obdbEstruturaFinal:CMARCA+SELF:obdbEstruturaFinal:PRODUTO+Str(SELF:obdbEstruturaFinal:SANOCALC,4,0)+Str(SELF:obdbEstruturaFinal:INRCALC,6,0)								
ENDDO

What is Wrong? The seek in bArrayServer is not equal of the seek in bdbserver?

TIA
Paulo Oliveira

[toc] | [next] | [standalone]


#10672

From"Jamal" <noooospam@example.com>
Date2017-06-12 23:51 -0400
Message-ID<ohnnfh$n92$1@news.albasani.net>
In reply to#10671
Paul,

Classic response that every classic VO developer should be doing:

Check the success of CreateOrder.
Make the values you are searching for are correct.
Where is your SetOrder() ?
In the Seek() set the lSoftSeek (2nd parameter)  to FALSE.

Jamal

"Paulo Oliveira"  wrote in message 
news:873365fb-38bd-42c2-b39d-cd0559b76001@googlegroups.com...

Hi all,

I have a Order in a bArrayServer like this:
SELF:obdbEstruturaFinal:CreateOrder("server:CMARCA+server:PRODUTO+Str(server:SANOCALC,4,0)+Str(server:INRCALC,6,0)")

And this don't work:

cChaveOri:=CMARCA+PRODUTO+Str(SANOCALC,4,0)+Str(INRCALC,6,0)

SELF:obdbEstruturaFinal:Seek(cChaveOri)
cChave:=SELF:obdbEstruturaFinal:CMARCA+SELF:obdbEstruturaFinal:PRODUTO+Str(SELF:obdbEstruturaFinal:SANOCALC,4,0)+Str(SELF:obdbEstruturaFinal:INRCALC,6,0)

DO WHILE cChave==cChaveOri
SELF:obdbEstruturaFinal:FIELDPUT(#DDTPROD,dData)
  SELF:obdbEstruturaFinal:FIELDPUT(#SEMANA,ClipWeekNumber(dData))
SELF:obdbEstruturaFinal:Skip()
cChave:=SELF:obdbEstruturaFinal:CMARCA+SELF:obdbEstruturaFinal:PRODUTO+Str(SELF:obdbEstruturaFinal:SANOCALC,4,0)+Str(SELF:obdbEstruturaFinal:INRCALC,6,0)
ENDDO

What is Wrong? The seek in bArrayServer is not equal of the seek in 
bdbserver?

TIA
Paulo Oliveira 

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


#10675

FromMartin <Martin@spam.spam>
Date2017-06-13 09:55 +0100
Message-ID<oho93v$6tf$1@dont-email.me>
In reply to#10672
And also is the notificiation disabled?

On 13/06/2017 04:51, Jamal wrote:
> Paul,
>
> Classic response that every classic VO developer should be doing:
>
> Check the success of CreateOrder.
> Make the values you are searching for are correct.
> Where is your SetOrder() ?
> In the Seek() set the lSoftSeek (2nd parameter)  to FALSE.
>
> Jamal
>
> "Paulo Oliveira"  wrote in message
> news:873365fb-38bd-42c2-b39d-cd0559b76001@googlegroups.com...
>
> Hi all,
>
> I have a Order in a bArrayServer like this:
> SELF:obdbEstruturaFinal:CreateOrder("server:CMARCA+server:PRODUTO+Str(server:SANOCALC,4,0)+Str(server:INRCALC,6,0)")
>
>
> And this don't work:
>
> cChaveOri:=CMARCA+PRODUTO+Str(SANOCALC,4,0)+Str(INRCALC,6,0)
>
> SELF:obdbEstruturaFinal:Seek(cChaveOri)
> cChave:=SELF:obdbEstruturaFinal:CMARCA+SELF:obdbEstruturaFinal:PRODUTO+Str(SELF:obdbEstruturaFinal:SANOCALC,4,0)+Str(SELF:obdbEstruturaFinal:INRCALC,6,0)
>
>
> DO WHILE cChave==cChaveOri
> SELF:obdbEstruturaFinal:FIELDPUT(#DDTPROD,dData)
>  SELF:obdbEstruturaFinal:FIELDPUT(#SEMANA,ClipWeekNumber(dData))
> SELF:obdbEstruturaFinal:Skip()
> cChave:=SELF:obdbEstruturaFinal:CMARCA+SELF:obdbEstruturaFinal:PRODUTO+Str(SELF:obdbEstruturaFinal:SANOCALC,4,0)+Str(SELF:obdbEstruturaFinal:INRCALC,6,0)
>
> ENDDO
>
> What is Wrong? The seek in bArrayServer is not equal of the seek in
> bdbserver?
>
> TIA
> Paulo Oliveira

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


#10676

FromGerhard Bunzel <g.bunzel@domonet.de>
Date2017-06-13 14:31 +0200
Message-ID<oholum$qfu$1@news-1.m-online.net>
In reply to#10671
Paolo,

your bArrayServer:CreateOrder(...) does ONLY create the order.
To work with that index you have to select your working index with 
bArrayServer:SetOrder(1)

HTH

Gerhard Bunzel


Am 12.06.2017 um 23:14 schrieb Paulo Oliveira:
> Hi all,
> 
> I have a Order in a bArrayServer like this:
> SELF:obdbEstruturaFinal:CreateOrder("server:CMARCA+server:PRODUTO+Str(server:SANOCALC,4,0)+Str(server:INRCALC,6,0)")
> 
> And this don't work:
> 
> cChaveOri:=CMARCA+PRODUTO+Str(SANOCALC,4,0)+Str(INRCALC,6,0)
> 
> SELF:obdbEstruturaFinal:Seek(cChaveOri)
> 			cChave:=SELF:obdbEstruturaFinal:CMARCA+SELF:obdbEstruturaFinal:PRODUTO+Str(SELF:obdbEstruturaFinal:SANOCALC,4,0)+Str(SELF:obdbEstruturaFinal:INRCALC,6,0)
> 			
> DO WHILE cChave==cChaveOri
>   SELF:obdbEstruturaFinal:FIELDPUT(#DDTPROD,dData)
> 		  SELF:obdbEstruturaFinal:FIELDPUT(#SEMANA,ClipWeekNumber(dData))			
> 				SELF:obdbEstruturaFinal:Skip()				
> 				cChave:=SELF:obdbEstruturaFinal:CMARCA+SELF:obdbEstruturaFinal:PRODUTO+Str(SELF:obdbEstruturaFinal:SANOCALC,4,0)+Str(SELF:obdbEstruturaFinal:INRCALC,6,0)								
> ENDDO
> 
> What is Wrong? The seek in bArrayServer is not equal of the seek in bdbserver?
> 
> TIA
> Paulo Oliveira
> 

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


#10678

FromPaulo Oliveira <paulofvoliveira@gmail.com>
Date2017-06-14 02:33 -0700
Message-ID<39a9f5a7-0b8b-45f0-b02d-be9fdb25062f@googlegroups.com>
In reply to#10671
Thanks all,

before:
SELF:obdbEstruturaFinal:SuspendNotification()
SELF:obdbEstruturaFinal:SetOrder(1)

Now:
SELF:obdbEstruturaFinal:SetOrder(1)
SELF:obdbEstruturaFinal:SuspendNotification()

Sometimes i'm even blind. Now its work.

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


#10679

FromGerhard Bunzel <g.bunzel@domonet.de>
Date2017-06-14 15:39 +0200
Message-ID<ohreab$l0l$1@news-1.m-online.net>
In reply to#10678
Paulo,

switching these lines does not change any funktion.
SuspendNotification() is only to not notify the clients about changes. 
That has nothing do do with setting a new order.
Had a look at the bArrayServer sources - this could not have been the 
problem.

Best regards

Gerhard Bunzel


Am 14.06.2017 um 11:33 schrieb Paulo Oliveira:
> Thanks all,
> 
> before:
> SELF:obdbEstruturaFinal:SuspendNotification()
> SELF:obdbEstruturaFinal:SetOrder(1)
> 
> Now:
> SELF:obdbEstruturaFinal:SetOrder(1)
> SELF:obdbEstruturaFinal:SuspendNotification()
> 
> Sometimes i'm even blind. Now its work.
> 

[toc] | [prev] | [standalone]


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


csiph-web