Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #4940 > unrolled thread
| Started by | D.J.W. van Kooten <public@ic2remove.this.com> |
|---|---|
| First post | 2013-03-21 15:28 +0100 |
| Last post | 2013-03-22 20:06 +0100 |
| Articles | 4 — 3 participants |
Back to article view | Back to comp.lang.clipper.visual-objects
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
| From | D.J.W. van Kooten <public@ic2remove.this.com> |
|---|---|
| Date | 2013-03-21 15:28 +0100 |
| Subject | Report 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]
| From | "Jamal" <jamal@examples.net> |
|---|---|
| Date | 2013-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]
| From | Karl Wochele <kw@e©os-system.de> |
|---|---|
| Date | 2013-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]
| From | D.J.W. van Kooten <public@ic2remove.this.com> |
|---|---|
| Date | 2013-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