Error message "Cannot use or tag on Nullable key"

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

Error message "Cannot use or tag on Nullable key"

Post by PK » Tue Oct 02, 2001 2:45 pm

I have never come across this error message in earlier versions of R&R.__This error message pops up when I try to establish a one to one relation between the 2 dbf tables using cdx index file selecting a tag.__Any comments?

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

=> RE: Error message "Cannot use or tag on Nullable key"

Post by kfleming » Wed Oct 03, 2001 10:41 am

This is a real restriction. You probably have not used any indexes with nullable keys in earlier versions which is why you have not seen it until now.____Kathleen__R&R Support

PK
Posts: 9
Joined: Tue Oct 10, 2017 12:44 pm

==> RE: Error message "Cannot use or tag on Nullable key"

Post by PK » Wed Oct 17, 2001 2:26 pm

Thanks.__I am not even sure what this nullable key is.__Now how do I avoid this from happening.__The structure of the files remain same. __Except that the files I was using earlier were foxpro files with cdx index files and now these files have somewhat similar structure but in visual foxpro with cdx index files.__The tags are also the same. __Is there anyhting I am missing?__Pls help!!!!

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

===> RE: Error message "Cannot use or tag on Nullable key"

Post by kfleming » Thu Oct 18, 2001 7:24 am

If you open the table in the Foxpro table designer and look at the structure, you will see a column called Null. If there is a checkmark in that column for any field that is used in your index, then you will see the error.____If you remove the check and restructure the file, the error will no longer appear.______Kathleen__R&R Support

PK
Posts: 9
Joined: Tue Oct 10, 2017 12:44 pm

====> RE: Error message "Cannot use or tag on Nullable key"

Post by PK » Thu Oct 18, 2001 10:56 am

Thanks. But will it affect the application. The application is accounting package called "SBT Pro Series" from AccPac. I am not sure if you r familiar with this package. __Lastly what is the significance of thie field?__Thanks again.__

Post Reply