kfutter Posted November 2, 2006 Posted November 2, 2006 We are currently converting a large number of databases from v6 to v8, and I've come across my first real problem so far. A calendar db we have has some scripted buttons that show records for the current date + up to one month ahead. I noticed that converting to v8 updated the syntax of the scripts to be v8 compliant, but they no longer work. I didn't write the original scripts, but have managed to get only the one that selects the current date to work. Anything that appends a set range to the current date just pops up a dialogue box complaining about invalid find criteria. The important lines of the converted script are like so: Enter Find Mode [] Insert Calculated Result [select; calendar::date; "//..."&GetAsText(Get(CurrentDate)+6)] Insert Calculated Result [select; calendar::Level; "1"] Perform Find [] I've tried a few variations on this theme, but no go. Anyone know how to achieve this in FM 8? Cheers, Kevin
Ender Posted November 2, 2006 Posted November 2, 2006 I'd try it this way: Enter Find Mode [] Set Field [ calendar::date; get(currentdate) & "..." & Get(CurrentDate)+6] Set Field [ calendar::Level; 1] Perform Find []
kfutter Posted November 2, 2006 Author Posted November 2, 2006 Thanks. I actually tried something similar to that, but still using a calculated result. Needless to say, it didn't work, but I'll give your variation a go and report back. Cheers, Kevin
kfutter Posted November 2, 2006 Author Posted November 2, 2006 Just a quick report back - works like a charm! Must remember from now on: Set Field, Set Field, Set Field ... Cheers and thanks, Kevin
Recommended Posts
This topic is 6598 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now