RetroBBS - comp.lang.xharbour - Function OrdConSet ?

Function OrdConSet ?

<740ea86e-cd1e-43c9-807b-dc1289fb9dbdn@googlegroups.com>

https://www.rocksolidbbs.com/devel/article-flat.php?id=17263&group=comp.lang.xharbour#17263

copy link Newsgroups: comp.lang.xharbour

X-Received: by 2002:ad4:55e9:0:b0:56e:9f09:ee58 with SMTP id bu9-20020ad455e9000000b0056e9f09ee58mr2689339qvb.8.1677771559559;
Thu, 02 Mar 2023 07:39:19 -0800 (PST)
X-Received: by 2002:a05:6902:4b:b0:a02:a3a6:7a67 with SMTP id
m11-20020a056902004b00b00a02a3a67a67mr5692207ybh.11.1677771559176; Thu, 02
Mar 2023 07:39:19 -0800 (PST)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!feed1.usenet.blueworldhosting.com!peer01.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.lang.xharbour
Date: Thu, 2 Mar 2023 07:39:18 -0800 (PST)
Injection-Info: google-groups.googlegroups.com; posting-host=62.2.210.254; posting-account=JUJWmgoAAAC6zTWwzAl5l2TCnYthlL4o
NNTP-Posting-Host: 62.2.210.254
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <740ea86e-cd1e-43c9-807b-dc1289fb9dbdn@googlegroups.com>
Subject: Function OrdConSet ?
From: otto.haldi.1955@gmail.com (Otto Haldi)
Injection-Date: Thu, 02 Mar 2023 15:39:19 +0000
Content-Type: text/plain; charset="UTF-8"
X-Received-Bytes: 1800

by: Otto Haldi - Thu, 2 Mar 2023 15:39 UTC

Hello
I have a problem using the OrdConSet() function.
In fact, in my "do while" loop "endo", I check if all the following conditions are respected. Here is my filter:
if LIEFD->ADR_NR == vAdrNr .and. Year(LIEFD->FAK_DATUM) == vJahr .and. Month(LIEFD->FAK_DATUM) == vMonat .and. LIEFD->MENGE>=10 .and. !Empty(LIEFD->FAK_DATUM)
.....
etc
Question: is it possible to do this with the OrdConSet() function?
I have already tried this with the following filter (same address number and same year):
OrdCondSet( "LIEFD->ADR_NR == vAdrNr .and. Year(LIEFD->FAK_DATUM) == vJahr" )
OrdCreate( "TMP_LIEF", , "Str(_FIELD->LS_NR,6)")
LIEFD->(DbGoTop())

However when I execute my loop there is no record!
I wanted to test this way of working to see if it would make my report run faster.
Thanks in advance for your help.
Otto

Re: Function OrdConSet ?

<ttqi3i$b1gi$1@dont-email.me>

copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=17264&group=comp.lang.xharbour#17264

copy link Newsgroups: comp.lang.xharbour

Path: i2pn2.org!i2pn.org!eternal-september.org!reader01.eternal-september.org!.POSTED!not-for-mail
From: e.m.giordano@emagsoftware.it (Enrico Maria Giordano)
Newsgroups: comp.lang.xharbour
Subject: Re: Function OrdConSet ?
Date: Thu, 2 Mar 2023 17:15:47 +0100
Organization: A noiseless patient Spider
Lines: 28
Message-ID: <ttqi3i$b1gi$1@dont-email.me>
References: <740ea86e-cd1e-43c9-807b-dc1289fb9dbdn@googlegroups.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Injection-Date: Thu, 2 Mar 2023 16:15:46 -0000 (UTC)
Injection-Info: reader01.eternal-september.org; posting-host="9837f3635cc1c3a253ab9b9da6066c29";
logging-data="362002"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+XC0wSnTpRJofCsbKT3NtC"
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:102.0) Gecko/20100101
Thunderbird/102.8.0
Cancel-Lock: sha1:tdUF7Uhvebwizgkb4UFIhbHfdqw=
In-Reply-To: <740ea86e-cd1e-43c9-807b-dc1289fb9dbdn@googlegroups.com>

by: Enrico Maria Giordan - Thu, 2 Mar 2023 16:15 UTC

Il 02/03/2023 16:39, Otto Haldi ha scritto:

> Hello
> I have a problem using the OrdConSet() function.
> In fact, in my "do while" loop "endo", I check if all the following conditions are respected. Here is my filter:
> if LIEFD->ADR_NR == vAdrNr .and. Year(LIEFD->FAK_DATUM) == vJahr .and. Month(LIEFD->FAK_DATUM) == vMonat .and. LIEFD->MENGE>=10 .and. !Empty(LIEFD->FAK_DATUM)
> ....
> etc
> Question: is it possible to do this with the OrdConSet() function?
> I have already tried this with the following filter (same address number and same year):
> OrdCondSet( "LIEFD->ADR_NR == vAdrNr .and. Year(LIEFD->FAK_DATUM) == vJahr" )

Try this:

OrdCondSet( "LIEFD->ADR_NR == vAdrNr .and. Year(LIEFD->FAK_DATUM) ==
vJahr", { || LIEFD->ADR_NR == vAdrNr .and. Year(LIEFD->FAK_DATUM) ==
vJahr } )

--
Enrico Maria Giordano

http://www.emagsoftware.it
http://www.emagsoftware.it/emgmusic
http://www.emagsoftware.it/spectrum
http://www.emagsoftware.it/tbosg

Re: Function OrdConSet ?

<931e855c-16da-4ef0-9283-2b1f6200ca07n@googlegroups.com>

copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=17265&group=comp.lang.xharbour#17265

copy link Newsgroups: comp.lang.xharbour

X-Received: by 2002:a05:620a:b88:b0:71f:b8f8:f3e1 with SMTP id k8-20020a05620a0b8800b0071fb8f8f3e1mr661913qkh.7.1677774989478;
Thu, 02 Mar 2023 08:36:29 -0800 (PST)
X-Received: by 2002:a5b:a10:0:b0:87a:957b:fd67 with SMTP id
k16-20020a5b0a10000000b0087a957bfd67mr5898721ybq.10.1677774989066; Thu, 02
Mar 2023 08:36:29 -0800 (PST)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!feed1.usenet.blueworldhosting.com!peer01.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.lang.xharbour
Date: Thu, 2 Mar 2023 08:36:28 -0800 (PST)
In-Reply-To: <ttqi3i$b1gi$1@dont-email.me>
Injection-Info: google-groups.googlegroups.com; posting-host=62.2.210.254; posting-account=JUJWmgoAAAC6zTWwzAl5l2TCnYthlL4o
NNTP-Posting-Host: 62.2.210.254
References: <740ea86e-cd1e-43c9-807b-dc1289fb9dbdn@googlegroups.com> <ttqi3i$b1gi$1@dont-email.me>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <931e855c-16da-4ef0-9283-2b1f6200ca07n@googlegroups.com>
Subject: Re: Function OrdConSet ?
From: otto.haldi.1955@gmail.com (Otto Haldi)
Injection-Date: Thu, 02 Mar 2023 16:36:29 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
X-Received-Bytes: 2651

by: Otto Haldi - Thu, 2 Mar 2023 16:36 UTC

Thank you, work well and it's very fast!
Can you help me for the complete Filter:
LIEFD->ADR_NR == vAdrNr .and. Year(LIEFD->FAK_DATUM) == vJahr .and. Month(LIEFD->FAK_DATUM) == vMonat .and. LIEFD->MENGE>=10 .and. !Empty(LIEFD->FAK_DATUM)

Le jeudi 2 mars 2023 à 17:15:48 UTC+1, Enrico Maria Giordano a écrit :
> Il 02/03/2023 16:39, Otto Haldi ha scritto:
>
> > Hello
> > I have a problem using the OrdConSet() function.
> > In fact, in my "do while" loop "endo", I check if all the following conditions are respected. Here is my filter:
> > if LIEFD->ADR_NR == vAdrNr .and. Year(LIEFD->FAK_DATUM) == vJahr .and. Month(LIEFD->FAK_DATUM) == vMonat .and. LIEFD->MENGE>=10 .and.. !Empty(LIEFD->FAK_DATUM)
> > ....
> > etc
> > Question: is it possible to do this with the OrdConSet() function?
> > I have already tried this with the following filter (same address number and same year):
> > OrdCondSet( "LIEFD->ADR_NR == vAdrNr .and. Year(LIEFD->FAK_DATUM) == vJahr" )
> Try this:
> OrdCondSet( "LIEFD->ADR_NR == vAdrNr .and. Year(LIEFD->FAK_DATUM) => vJahr", { || LIEFD->ADR_NR == vAdrNr .and. Year(LIEFD->FAK_DATUM) ==
> vJahr } )
>
> --
> Enrico Maria Giordano
>
> http://www.emagsoftware.it
> http://www.emagsoftware.it/emgmusic
> http://www.emagsoftware.it/spectrum
> http://www.emagsoftware.it/tbosg

Re: Function OrdConSet ?

<ttr101$cpnf$1@dont-email.me>

copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=17266&group=comp.lang.xharbour#17266

copy link Newsgroups: comp.lang.xharbour

Path: i2pn2.org!i2pn.org!eternal-september.org!reader01.eternal-september.org!.POSTED!not-for-mail
From: e.m.giordano@emagsoftware.it (Enrico Maria Giordano)
Newsgroups: comp.lang.xharbour
Subject: Re: Function OrdConSet ?
Date: Thu, 2 Mar 2023 21:29:53 +0100
Organization: A noiseless patient Spider
Lines: 22
Message-ID: <ttr101$cpnf$1@dont-email.me>
References: <740ea86e-cd1e-43c9-807b-dc1289fb9dbdn@googlegroups.com>
<ttqi3i$b1gi$1@dont-email.me>
<931e855c-16da-4ef0-9283-2b1f6200ca07n@googlegroups.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Injection-Date: Thu, 2 Mar 2023 20:29:53 -0000 (UTC)
Injection-Info: reader01.eternal-september.org; posting-host="9837f3635cc1c3a253ab9b9da6066c29";
logging-data="419567"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+SUHu9Yq9mta58pyvWnLRp"
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:102.0) Gecko/20100101
Thunderbird/102.8.0
Cancel-Lock: sha1:ZUVIzu0OD5S43HbJqdpNgbI73CA=
In-Reply-To: <931e855c-16da-4ef0-9283-2b1f6200ca07n@googlegroups.com>

by: Enrico Maria Giordan - Thu, 2 Mar 2023 20:29 UTC

Il 02/03/2023 17:36, Otto Haldi ha scritto:

> Thank you, work well and it's very fast!
> Can you help me for the complete Filter:
> LIEFD->ADR_NR == vAdrNr .and. Year(LIEFD->FAK_DATUM) == vJahr .and. Month(LIEFD->FAK_DATUM) == vMonat .and. LIEFD->MENGE>=10 .and. !Empty(LIEFD->FAK_DATUM)

OrdCondSet( "LIEFD->ADR_NR == vAdrNr .and. Year(LIEFD->FAK_DATUM) ==
vJahr .and. Month(LIEFD->FAK_DATUM) == vMonat .and. LIEFD->MENGE>=10
..and. !Empty(LIEFD->FAK_DATUM)", { || LIEFD->ADR_NR == vAdrNr .and.
Year(LIEFD->FAK_DATUM) == vJahr .and. Month(LIEFD->FAK_DATUM) == vMonat
..and. LIEFD->MENGE>=10 .and. !Empty(LIEFD->FAK_DATUM) } )

--
Enrico Maria Giordano

http://www.emagsoftware.it
http://www.emagsoftware.it/emgmusic
http://www.emagsoftware.it/spectrum
http://www.emagsoftware.it/tbosg

Re: Function OrdConSet ?

<f6563473-fa4e-43a4-9727-f281cb7bcc82n@googlegroups.com>

copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=17267&group=comp.lang.xharbour#17267

copy link Newsgroups: comp.lang.xharbour

X-Received: by 2002:a05:6214:b82:b0:571:e9d3:24a9 with SMTP id fe2-20020a0562140b8200b00571e9d324a9mr2859224qvb.10.1677796494281;
Thu, 02 Mar 2023 14:34:54 -0800 (PST)
X-Received: by 2002:a81:ad20:0:b0:526:859e:8b16 with SMTP id
l32-20020a81ad20000000b00526859e8b16mr7178678ywh.8.1677796493930; Thu, 02 Mar
2023 14:34:53 -0800 (PST)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!feed1.usenet.blueworldhosting.com!peer01.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.lang.xharbour
Date: Thu, 2 Mar 2023 14:34:53 -0800 (PST)
In-Reply-To: <ttr101$cpnf$1@dont-email.me>
Injection-Info: google-groups.googlegroups.com; posting-host=62.2.210.254; posting-account=JUJWmgoAAAC6zTWwzAl5l2TCnYthlL4o
NNTP-Posting-Host: 62.2.210.254
References: <740ea86e-cd1e-43c9-807b-dc1289fb9dbdn@googlegroups.com>
<ttqi3i$b1gi$1@dont-email.me> <931e855c-16da-4ef0-9283-2b1f6200ca07n@googlegroups.com>
<ttr101$cpnf$1@dont-email.me>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <f6563473-fa4e-43a4-9727-f281cb7bcc82n@googlegroups.com>
Subject: Re: Function OrdConSet ?
From: otto.haldi.1955@gmail.com (Otto Haldi)
Injection-Date: Thu, 02 Mar 2023 22:34:54 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
X-Received-Bytes: 2495

by: Otto Haldi - Thu, 2 Mar 2023 22:34 UTC

It's fantastical. It's really fast
The command line is really complex. I don't understand why you have to write the selection twice? once between the quotation marks and once between the {}
Once again a big thank you.

Le jeudi 2 mars 2023 à 21:29:55 UTC+1, Enrico Maria Giordano a écrit :
> Il 02/03/2023 17:36, Otto Haldi ha scritto:
>
> > Thank you, work well and it's very fast!
> > Can you help me for the complete Filter:
> > LIEFD->ADR_NR == vAdrNr .and. Year(LIEFD->FAK_DATUM) == vJahr .and. Month(LIEFD->FAK_DATUM) == vMonat .and. LIEFD->MENGE>=10 .and. !Empty(LIEFD->FAK_DATUM)
> OrdCondSet( "LIEFD->ADR_NR == vAdrNr .and. Year(LIEFD->FAK_DATUM) => vJahr .and. Month(LIEFD->FAK_DATUM) == vMonat .and. LIEFD->MENGE>=10
> .and. !Empty(LIEFD->FAK_DATUM)", { || LIEFD->ADR_NR == vAdrNr .and.
> Year(LIEFD->FAK_DATUM) == vJahr .and. Month(LIEFD->FAK_DATUM) == vMonat
> .and. LIEFD->MENGE>=10 .and. !Empty(LIEFD->FAK_DATUM) } )
> --
> Enrico Maria Giordano
>
> http://www.emagsoftware.it
> http://www.emagsoftware.it/emgmusic
> http://www.emagsoftware.it/spectrum
> http://www.emagsoftware.it/tbosg

Re: Function OrdConSet ?

<ttscli$jgp5$1@dont-email.me>

copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=17268&group=comp.lang.xharbour#17268

copy link Newsgroups: comp.lang.xharbour

Path: i2pn2.org!i2pn.org!eternal-september.org!reader01.eternal-september.org!.POSTED!not-for-mail
From: e.m.giordano@emagsoftware.it (Enrico Maria Giordano)
Newsgroups: comp.lang.xharbour
Subject: Re: Function OrdConSet ?
Date: Fri, 3 Mar 2023 09:55:16 +0100
Organization: A noiseless patient Spider
Lines: 19
Message-ID: <ttscli$jgp5$1@dont-email.me>
References: <740ea86e-cd1e-43c9-807b-dc1289fb9dbdn@googlegroups.com>
<ttqi3i$b1gi$1@dont-email.me>
<931e855c-16da-4ef0-9283-2b1f6200ca07n@googlegroups.com>
<ttr101$cpnf$1@dont-email.me>
<f6563473-fa4e-43a4-9727-f281cb7bcc82n@googlegroups.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Injection-Date: Fri, 3 Mar 2023 08:55:14 -0000 (UTC)
Injection-Info: reader01.eternal-september.org; posting-host="e05f059bbbbe6d9dbbb17789ec07a51b";
logging-data="639781"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+mz1miqrOOVY1v9C/c/rQM"
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:102.0) Gecko/20100101
Thunderbird/102.8.0
Cancel-Lock: sha1:CyOhLfgm6P3XpKIOfDyxUV1PLKc=
In-Reply-To: <f6563473-fa4e-43a4-9727-f281cb7bcc82n@googlegroups.com>

by: Enrico Maria Giordan - Fri, 3 Mar 2023 08:55 UTC

Il 02/03/2023 23:34, Otto Haldi ha scritto:

> It's fantastical. It's really fast
> The command line is really complex. I don't understand why you have to write the selection twice? once between the quotation marks and once between the {}

You can use the command the is simpler:

INDEX ON <key> TO <file> FOR <condition>

--
Enrico Maria Giordano

http://www.emagsoftware.it
http://www.emagsoftware.it/emgmusic
http://www.emagsoftware.it/spectrum
http://www.emagsoftware.it/tbosg

The documentation is in Japanese. Good luck. -- Rich $alz

devel / comp.lang.xharbour / Function OrdConSet ?

Subject	Author
Function OrdConSet ?	Otto Haldi
Re: Function OrdConSet ?	Enrico Maria Giordano
Re: Function OrdConSet ?	Otto Haldi
Re: Function OrdConSet ?	Enrico Maria Giordano
Re: Function OrdConSet ?	Otto Haldi
Re: Function OrdConSet ?	Enrico Maria Giordano