Data Type for a datetime index tag

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
kraigyb
Posts: 3
Joined: Tue Oct 10, 2017 12:44 pm

Data Type for a datetime index tag

Post by kraigyb » Thu Mar 17, 2011 5:11 pm

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.

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> Data Type for a datetime index tag

Post by kfleming » Tue Mar 22, 2011 7:42 am

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

kraigyb
Posts: 3
Joined: Tue Oct 10, 2017 12:44 pm

==> RE: Data Type for a datetime index tag

Post by kraigyb » Fri Apr 27, 2012 9:54 am

Have there been any updates that would fix this bug?

Post Reply