At 2007-05-17 22:45, you wrote: > > nitwit had a relation set to recno() > >Uh, what could possibly be wrong with that? It worked, did it not <g>...
It works, by design, quoting the helpfile: The child table must be indexed unless the relational expression is numeric. Visual FoxPro displays an error message if you issue SET RELATION with a non-numeric relational expression and the child table isn't ordered with an index. If eExpression1 is numeric, it is evaluated when the record pointer in the parent table is moved. The record pointer in the child table is then moved to record number eExpression1. Can as an example be used to split a table that reaches the 2GB-limit into 2 tables coupled together... ****************************** * Dan Olsson * <mailto:[EMAIL PROTECTED]> * <http://www.dolittle.se> _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
