Liveware Publishing Support Forum

Im using v12.5.001 to access foxpro tables in MOM v7.____When I select a Master Index Tag field of type datetime, the Data Type restricts to type Character.____I would like to use this index to specify a starting and ending scope. If the index data type is character, what would be valid for scope values?____I have tried scope values such as:__03/17/2011 12:00:00 AM__03/17/2011 12:00:00__03/17/2011____The scope values were being truncated and I found that the width of all datetime fields in the tables is 8, so I tried:__03172011__20110317____When I specify scope values, I do not get any records returned. I only get results if scope is set to Beginning of Table and End of Table.____Any advice?____Thank you.

This is a bug within R&R. The only workaround is to use a query rather than scope. If your records are being added in date sequence, you could remove the master index and then scope based on record number so that you do not need to see older information.____Regards,__Kathleen__R&R Support

Have there been any updates that would fix this bug?