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


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

Report Pro and Advantage FTS Index tag

Started byD.J.W. van Kooten <public@ic2remove.this.com>
First post2013-03-21 15:28 +0100
Last post2013-03-22 20:06 +0100
Articles 4 — 3 participants

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


Contents

  Report Pro and Advantage FTS Index tag D.J.W. van Kooten <public@ic2remove.this.com> - 2013-03-21 15:28 +0100
    Re: Report Pro and Advantage FTS Index tag "Jamal" <jamal@examples.net> - 2013-03-21 17:48 -0400
    Re: Report Pro and Advantage FTS Index tag Karl Wochele <kw@e©os-system.de> - 2013-03-22 11:22 +0100
      Re: Report Pro and Advantage FTS Index tag D.J.W. van Kooten <public@ic2remove.this.com> - 2013-03-22 20:06 +0100

#4940 — Report Pro and Advantage FTS Index tag

FromD.J.W. van Kooten <public@ic2remove.this.com>
Date2013-03-21 15:28 +0100
SubjectReport Pro and Advantage FTS Index tag
Message-ID<216mk8hulo4ubp7s5m8ibm32ba125p3527@4ax.com>
I have 1 database with an ADS FTS (Full Text Search) index tag. I can
interchange the use of ADS and DBFCDX without problems.

When I open a Report Pro report using this table/index tag I get the
message "Can not open file..." (and then this CDX).

Nevertheless the report opens and even the index seems to be used
correctly (obviously the FTS index tag is not used in the report).

Is there any way I can avoid that error message?

Dick

[toc] | [next] | [standalone]


#4945

From"Jamal" <jamal@examples.net>
Date2013-03-21 17:48 -0400
Message-ID<kifv76$rhs$1@speranza.aioe.org>
In reply to#4940
Dick,

You may be familiar with rpwin.ini option, but here we go :)

If the index tag contains a user defined function, ReportPro will not link 
it since it does not about it and thus the message.

I think the solution is to create a user defined VO DLL according to RP 
Developer docs, and include a reference to FTS function with the same exact 
name as used in your index tag (must use clipper calling convention!).
If you cannot use the same function name, create a wrapper function which 
you need to use in index tag and the RP DLL.

Then include the reference to the DLL in the rpwin.ini file.

[FunctionLibs]
LIB1=path to your DLL

When RP starts, it loads that DLL, and report should be fine - hopefully!

The above applies to RP 3.x . Same ma work for RP 2.x.

HTH,
Jamal


"D.J.W. van Kooten"  wrote in message 
news:216mk8hulo4ubp7s5m8ibm32ba125p3527@4ax.com...

I have 1 database with an ADS FTS (Full Text Search) index tag. I can
interchange the use of ADS and DBFCDX without problems.

When I open a Report Pro report using this table/index tag I get the
message "Can not open file..." (and then this CDX).

Nevertheless the report opens and even the index seems to be used
correctly (obviously the FTS index tag is not used in the report).

Is there any way I can avoid that error message?

Dick 

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


#4949

FromKarl Wochele <kw@e©os-system.de>
Date2013-03-22 11:22 +0100
Message-ID<ar2pnuFlh8hU1@mid.individual.net>
In reply to#4940
Hello Dick,

I can't help you with your problem, but I can assure you that an 
FTS-Index should not be the cause. We have several tables with up to 15 
normal index-tags and up to 5 FTS-index-tags in one CDX. Never had any 
problems with these index-files in any report...

Perhaps the FTS-index is the only or first tag in the cdx-file ?
Or you have an invalid index-expression (invalid for ADS) in another 
tag. Sometimes "normal" index-expressions for us can't be used in ADS.

You should of course not use the FTS-index as the controlling order of 
the report. This can't work. FTS-indexes usually only speed up 
filter-expressions.

HTH
Karl

Am 21.03.2013 15:28, schrieb D.J.W. van Kooten:
> I have 1 database with an ADS FTS (Full Text Search) index tag. I can
> interchange the use of ADS and DBFCDX without problems.
>
> When I open a Report Pro report using this table/index tag I get the
> message "Can not open file..." (and then this CDX).
>
> Nevertheless the report opens and even the index seems to be used
> correctly (obviously the FTS index tag is not used in the report).
>
> Is there any way I can avoid that error message?
>
> Dick
>

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


#4951

FromD.J.W. van Kooten <public@ic2remove.this.com>
Date2013-03-22 20:06 +0100
Message-ID<0mapk859j276uhi9iohsorvlf419hffb1j@4ax.com>
In reply to#4949
On Fri, 22 Mar 2013 11:22:54 +0100, Karl Wochele <kw@e©os-system.de>
wrote:

Hello Karl, Jamal,

>I can't help you with your problem, but I can assure you that an 
>FTS-Index should not be the cause. We have several tables with up to 15 
>normal index-tags and up to 5 FTS-index-tags in one CDX. Never had any 
>problems with these index-files in any report...


Ok, good to know. ADS support wrote:

"And, the FTS index issue (problem 5):  It is true that non-Advantage
applications do not recognize FTS indexes.  This is expected behavior.
If they want to use 3rd party tools to open a table that has an FTS
index, the customer needs to put the FTS index into a separate index
file that will not be opened by the 3rd party software. "

So that's the 5th reply from them I got which is useless.....

About Jamals (and also ADS' suggestion): I would go into that
direction if this error message bothers dozens of clients daily. But I
think the report isn't used that widely. If it bothers anyone, I will,
with your reply in mind, first see if what happens if I start from
scratch with this index tag (not being the leading tag indeed).

Thanks!

Dick

[toc] | [prev] | [standalone]


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


csiph-web