Expression Problem

[BRIAN GRAY]

Hello everyone,

I'm trying to put a child filter on a set in the set editor.
The logical expression I was wanting to use gives me a dialog box stating the expression is invalid. The filter Builder does not give the options i have tried to use (which I should take as a hint that it will not work)so I checked it in the expression builder. It came back as logical and correct.

Client Information Parent Table
Customer Suggest table Child table

Heres the expression:

Customer_Suggest_Table->Next_Cleaning_ToStart_Time+Client_Information->Job_time+Customer_Suggest_Table->Drive_Time

I'm sure it has to do with the use of multiple tables
Should a lookup function be used?

Thanks Again for all the Help

Brian

[Tom Cone Jr]

RE: Expression Problem

Brian,

Looks like you're trying to add times. Cannot tell whether you want to wind up with the time displayed on the clock at a given point, or whether you're trying to calc the elapsed time (duration). In either case I think you have to convert things to lowest common denominator (seconds) to do the math, and then reconvert back to clock time if desired.

More information about the purpose of the function, and the details on each field used in the expression will help.

-- tom

[BRIAN GRAY]

RE: Expression Problem

Hi Tom

Well I originally was just making sure I could use parts of both tables to make the filter and was going to add the rest later. I went ahead and added the rest still with no success. I know the expression is valid atleast if I use it on the form for the set but I cannont get it valid in the set editor. Is there something I am missing???? Or is it just not possible for some reason????

The updated expression Is as follows:

Customer_Suggest_Table->Start_Time_To>=totime(toseconds(Client_Information->Start_Time)+toseconds(Client_Information->Job_Time)+toseconds(Customer_Suggest_Table->Drive_Time),11,0

Again any help is appreciated

Thanks Brian

[Tom Cone Jr]

RE: Expression Problem

It is odd that you are working in the 'set editor'. I interpret this to mean that you are working with the design of the set itself. i.e. edit the set. If so, stop. If not, you'll have to describe what you're doing more completely.

A MUCH better choice for you would be to build a simple model of the necessary tables (using dummy data) and post it here with a text file explaining what you want to do, and where you're stuck. Details, details, details. Cannot ever have too many when trying to debug someone else's app.

-- tom

[BRIAN GRAY]

RE: Expression Problem

Hey Tom

Thanks for replying so quickly. I do not have much time right now unfortuneltly so I will give a quick explanation.

The purpose is to help us schedule one job with another.

I want it to suggest in a browse for the child table what job is compatable to the job suggested in the parent.

A couple of things come into play

Due Month

Start time of first job + How long the job takes + Jobtime to the next job

now any jobs whos start time is after this equation is an acceptable 2nd job.

"Customer" parent table

"Customer Job Suggest" child table

this table holds fields and records such as

CustomerFrom Customer to Drive time
A B 00:15
A C 00:10
A D 00:20
A E 00:40

there is also of course start times ,job times,Due monthe etc.

The link between the tables is

Customer+Due month to Customerfrom+ due month

i put the due month in there to make only the jobs with the correct due months appear in the browse. This all works correctly so far

now we need to place a filter using the above explanation.

well I need to go to work so see if you can make any sense of this and I will get back with you tomorrow. Thanks again for the help
Brian