Cannot Open SomeIndex.CDX when starting ReportPro 2.17

[lumberjack]

Hi Jeff,

it now says it can't find Client.CDX or Details.cdx, though BOTH are in the same folder as the report. Any ideas please?

I have never used ReportPro in "designer" mode, only for hardnoded reports. I see your .RPT contains "C:CAVO28Bin<filename>.DBF / .CDX
Are you sure that is where the .DBF/CDX files are located?

[BiggyRat]

Yes Johan, absolutely positive...

[BiggyRat]

Here is my index re-indexing code. Is there anything in here that's wrong perhaps? I've left all my previous attempts visible to show my working out...

METHOD OptionsReindex CLASS MainMenu

LOCAL oServer as DBServer

RddSetDefault("DBFCDX")
self:Pointer := Pointer{ POINTERHOURGLASS }

SetExclusive( true )

oServer := DbServer{"Client"}
oServer:PACK()
oServer:GoTop()
/* oServer:CreateOrder("CLCode", "Client","CLCode",,.T.)
oServer:CreateOrder("CLName", "Client", "ClName")
oServer:CreateOrder("ClState", "Client", "ClState")
oServer:CreateOrder("CLCodeName", "Client", "AllTrim(CLIENT->ClCode) + Space(1) + Alltrim(CLIENT->ClName)" )
oServer:CreateOrder("CLPcode", "Client", "ClPCode") */
oServer:Reindex()

DbSetIndex("client")
?? DbReindex() <====== returns true


oServer:CLOSE()

oServer := DbServer{"Details"}
oServer:PACK()
oServer:GoTop()
/* oServer:CreateOrder("CLCode", "Details", "CLCode")
oServer:CreateOrder("CLCodeName", "Details", "AllTrim(DETAILS->CLCODE) + Space(1) + AllTrim(DETAILS->CLNAME)" )
oServer:CreateOrder("JobDate", "Details", "JobDate")
oServer:CreateOrder("JobFin", "Details", "JobFin")
oServer:CreateOrder("JobNumber", "Details", "JobNumber")
oServer:CreateOrder("PONumber", "Details", "PONumber",, .T.)
oServer:CreateOrder("Subby", "Details", "Subby",, .T.)
oServer:CreateOrder("Rego", "Details", "Rego")
oServer:CreateOrder("Invoiced", "Details", "Invoiced")
oServer:CreateOrder("InvFile", "Details", "InvFile") */
oServer:Reindex()
DbSetIndex("Details")
?? DbReindex() <======= returns true
oServer:CLOSE()

SetExclusive(FALSE)
self:Pointer := Pointer{ POINTERARROW }
self:Show()

return self

[BiggyRat]

OK I worked it out. These two lines are causing it, but WHY?

oServer:CreateOrder("CLCodeName", "Client", "AllTrim(CLIENT->ClCode) + Space(1) + Alltrim(CLIENT->ClName)" )

AND

oServer:CreateOrder("CLCodeName", "Details", "AllTrim(DETAILS->CLCODE) + Space(1) + AllTrim(DETAILS->CLNAME)" )


As expressions they test OK, QQout say they create ok, yet it is these two lines (one in each index of course) stopping the report from opening. What have I done wrong please?

[lumberjack]

Hi Jeff,

OK I worked it out. These two lines are causing it, but WHY?
oServer:CreateOrder("CLCodeName", "Client", "AllTrim(CLIENT->ClCode) + Space(1) + Alltrim(CLIENT->ClName)" )
AND
oServer:CreateOrder("CLCodeName", "Details", "AllTrim(DETAILS->CLCODE) + Space(1) + AllTrim(DETAILS->CLNAME)" )
As expressions they test OK, QQout say they create ok, yet it is these two lines (one in each index of course) stopping the report from opening. What have I done wrong please?

Think you just need to drop the "CLIENT->" and "DETAILS->" from your expressions. Rather use "FIELD->" or "_FIELD->", sorry have not done DBF in ages so you need to check those two out.

[BiggyRat]

Hmmm OK, thank you very much Johan.

[lumberjack]

Hmmm OK, thank you very much Johan.

Hi Jeff,
Further to my previous response, remember you cannot guarantee that your DBF will always be referenced/aliased as "Client", your index expressions are hard-coded to a specific alias. Let us know if that solves the issue.

[robert]

Johan,
You are right.
ReportPro opens the workareas with aliases that look like _RP1, _RP2 etc.

Robert

[BiggyRat]

OK, thank you Robert and Johan,that was something I wasn't aware of with the Aliases in ReportPro. I will certainly keep that in mind. In the meantime, yes, your solution Johan seems to have done the trick. The report now opens every time without error. Thanks again.

[wriedmann]

Hi Jeff,

AFAIK CDX indices cannot have variable length expressions. If you are using AllTrim(), you need to pad them to a fixed lenght.

Wolfgang