Qpro 9 database function returns gibberish

[Gbark]

I'm using a simple database function to return a label from a small (60x5)database. The function will work if I use a column offset which points to a value but not if it points to a label.

I'm sure the function's syntax is correct and it works properly when read into Qpro 8! Here's the function:

@DGET(Frames,2,$Backframes:$G$9..$K$10)

Frames is the 60 row x 5 col database; the $Backfr... is the 2 row criterion table with col headings copied from the database to insure accuracy. (Again, it works in Qpro 8!)

I have Qpro 9.0.0.738 version (WP9 service pack 3) and am wondering if this is possibly a bug fixed in sp4 (which I don't have.)

TIA for any help/workarounds. It frustrating when something this simple grinds me to a halt.

Gbark

 

[Gbark]

Well, as it turns out, this really is a bug in Qpro 9 that wasn't fixed until version 10.

Mark Strzyzewski (C_Tech Volunteer) over at the Corel forums was kind enough to confirm the bug and suggested using the @Xindex function as a workaround.

Hope this info helps someone else.

Gbark