Hello Louis,

Well one problem that I see is that you have an element named Date. Date is a reserved keyword and is going to cause problems.

One other thing that may be causing a trip-up is that retrieve spec programming uses field names instead of the element names that regular programming uses.

Other than that you will also need to put an AND statement in your retrieve so that it only gets the records for this month in this year. Something like

{@Year(Date_Entered) = @Year(@Date) AND @Month(Date_Entered) = @Month(@Date)} 

The above code works in the sample customers file if you have records that have a Date_Entered value in this month and in this year.

-Ray

Ray:

My element was actually called CHQ DATE and not DATE.  I wasn't thinking about that statement properly.

Thanks again for your expertise.

Louis

Quote:


I can only find a couple sentences in the manuals about Table View, so of course I have questions. 

1) Can number values be displayed in their formatted state, or are they always shown with the 6 trailing decimal places?

2) Can the order (left-to-right sequence) of coumns be re-arranged and made to stay that way?  Q&A allowed for the numbering of fields which determined the sequence of columns in Table View.  Is there something similar in Sesame?

3) Is there a way to make invisible LE's visible when in Table View?

4) When I perform a search and then switch to Table View of the result set, I can sort them by clicking the boxes at the top of the columns.  This doesn't seem to affect the sort of the result set, though, does it?  The sort has to be done before the Table View, is that right?

I realize that most of the above can be accomnplished by crafting a Report, but to tell the truth Sesame's reports multiply on my hard drive like NoSeeEm Bugs in Florida during the rainy season. 

Quote:


Version 2s Table View shows formatted values.

Quote:


Version 2. Noticing a trend here?

Quote:


Not without getting pretty tricky. Table View respects the visibility and read-only settings of the form Elements.

Quote:


Sorting Table View has no affect on the sort order of the form in version 1. In version 2, both respect the Sort Spec.

The next Inside Sesame (coming out in a few days) includes a Version 2 Sneak Peek that shows the new Table View features, for those of you who did not make it to the Conference in Vegas.

Quote:


You can write a batch file that clears them out if you don't want them. Personally, I've found it very useful to be able to go back and get a previously run report, so I don't clear mine very often. I have my SESAME_REPORT_PATH variable set, so they all go to the same place.