Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help with date based index
Message
From
12/11/2001 03:39:02
 
 
To
11/11/2001 21:50:32
Mike Yearwood
Toronto, Ontario, Canada
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00580327
Message ID:
00580363
Views:
15
Okay that sort of works.

I fixed the return value and when the relational expression is correct it returns the correct data.

One problem though.

The relation gets triggered during openfiles. Nothing unusual in that I hear you say. Well that would be the case except my lovely expression

'relCurrPrice(prsched,code)'

gets replaced with

'effdate'

I have absolutely no idea why this might occur.

effdate is part of the key

'prsched+code+str({^3000/01/01)-effdate)'

but why should it be corrupting the RelationExpression????

Any ideas????

PS Can I save the current SET KEY setting. KEY() just returns the key tag
expression doesn't it?


Regards
Geoff Scott
May all your weeds be wildflowers
Previous
Reply
Map
View

Click here to load this message in the networking platform