Liveware Publishing Support Forum

Dear Friends:____ Enviro: RRW Version 9.0 and Clipper/Comix Databases____ I^m converting a bunch of old working reports from RR V6.0a to RRW Version 9.0. So far the conversion effort is going nicely.____ However, this morning during my conversion efforts (on a Purchase Order (PO) form), I hit the following error message which baffles me:____ "Cannot use Index or Tag on NULLable Key: Temp2.cdx"____ The index expression which created this temp2.cdx file was:____ "index on ponum TAG PONUM TO temp2.cdx for ponum == cPonum while ponum == cPonum"____ I^ve used this expression successfully for years and it hasn^t been changed.____ Any hints please ??____-Mel Smith__

This message indicates that a field used in an index key has a nullable property set within its table definition.__Even though your index has not changed, has there been a change to the underlying data structure?____Kathleen__R&R Support

Kathleen,____ Since I^m indexing only on a 5-character Purchase Order Number (PONUM) (using only digits), and since this structure hasn^t changed for years, I^m baffled by the error (since R&R 6.0a has never had a problem with it).____ I^ll puzzle some more on the problem before changing the way I create this relation (I^m using this index into a massive PO detail file to relate the master P.O. to it). ____ Instead of this relation, I may simply copy the portion of the detail file to a temporary file for the duration of the report.____ The word ^nullable^ still puzzles me though____Thanks for your response.____-Mel Smith