Hi Razzak,
On my first issue, I will forget about implementing the DROPCOLUMNS or the
DROPROWS properties since my customer is using Window 7 Professional and it
is a window OS issue.
On my second issue, I did not explained myself properly. Here I will try
again:
1. Create a blank form.
2. Set the variable datatype and NULL. "SET VAR v1 DATE=NULL"
3. SET your computer's system date back to maybe "1/15/2011" or
anything else you wish.
3. Create the "Date/Time Picker" object on the form.
(Here is order to be able to duplicate the problem we set the
computer's date back just before you create the object on the form. This
simulate what happened to me when I created the object on the form one year
ago.)
4. Set your computer date back to normal "today's date".
4. When you open the form "EDIT USING TestForm" the date picker field
object show null but the initial calendar that pops open is for the month
January of the year 2011 corresponding to the object's creation date when
the form was designed.
I can always pre-set the variable to today's date to work-around this issue
but I really wanted to know if I am doing something wrong.
Thank you Razzak for your time,
Manuel
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak
Memon
Sent: Tuesday, March 20, 2012 6:43 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Variable Date/Time Picker questions
At 12:02 AM 3/20/2012, Manuel de Aguiar wrote:
>Hello Everyone,
>I am back from the dying and in need of a little help. Two issues when
>using the form's variable date/time picker object in R:BASE eXtreme 9.1
>(32), U.S. Version, Build: 9.1.5.20317.
>FIRST ISSUE: I cannot get the DROPCOLUMNS or the DROPROWS properties
>to work. I tried it in the form designer under properties and I tried
>it programmatically using the PROPERTY COMMANDS
> PROPERTY vdpvBegDate DROPCOLUMNS '3'
> PROPERTY vdpvBegDate DROPROWS '2'
>No luck, I always get a single calendar to display when I click on the
>object.
>
>SECOND ISSUE: If the variable used to collect the date range are set
>to NULL then the default date that appears on the forms is the date I
>created the date/time picker on the form. In my case 1/15/2011. The
>calendar opens in January 2011 when the user clicks on the object.This
>is a bit annoying to some customers. The "SHOWTODAY" property displays
>today's date at the bottom of the calendar that helps the user get to a
>more current year.Another workaround I tried is to set the variables to
>#DATE.
>What am I doing wrong?
>Really appreciate any help I can get.
Manuel,
The first issue has to do with the Operating System. Variable Date/Time
Picker Columns and Rows are only supported in XP. If you wish, you may
contact Microsoft for further details and ask them to provide the same
functionality in Windows 7.
In reference to the second issue, when the underlying variable associated
with the Variable Date/Time Picker is set to NULL, it should be NULL.
However, using the drop-down, Today's Date should be highlighted and not
01/15/2011.
If defined correctly, it should be NULL. To test, place a new Variable
Date/Time Picker and associate that with another variable, such as "v1"
and make sure to set the variable v1 as DATE as On Before Start EEP, such
as:
SET VAR v1 DATE = NULL
RETURN
Now run the form and see what you get.
That simple exercise should provide you with some blue's clues!
Good Luck and Very Best R:egards,
Razzak.
