dDateTextBox runtime problem

[Mike Mabey]

Hi all,

I've got some dDateTime widgets in an app, and they won't retain any value
when the app is running.  I've checked and made sure that they are enabled
and not read only.  When I inserted them into my app I was using the Class
Designer and simply added controls from the data environment, and then
changed the field type to "Date Textbox".  Then I made sure to import
datetime.

At runtime, I can enter any text in the field and the shortcut keys don't
work.  Then when that field looses focus, the default value of <None>
replaces whatever was typed in before.  In the database the field can be
NULL, but I don't think this would affect the way the program runs.

Does anyone know why this is happening and how to fix it?

Thanks,
Mike M.


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

_______________________________________________
Post Messages to: Dabo-users@...
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/89fe67110807161150q1281aa27nea8a10ad428cd737@...

[Ed Leafe]

On Jul 16, 2008, at 1:50 PM, Mike Mabey wrote:

> I've got some dDateTime widgets in an app, and they won't retain any  
> value
> when the app is running.  I've checked and made sure that they are  
> enabled
> and not read only.  When I inserted them into my app I was using the  
> Class
> Designer and simply added controls from the data environment, and then
> changed the field type to "Date Textbox".  Then I made sure to import
> datetime.

        Are they listed as dDateTime entities in the .cdxml file that was  
created?

> At runtime, I can enter any text in the field and the shortcut keys  
> don't
> work.  Then when that field looses focus, the default value of <None>
> replaces whatever was typed in before.  In the database the field  
> can be
> NULL, but I don't think this would affect the way the program runs.
>
> Does anyone know why this is happening and how to fix it?


        Sounds mostly like the control is not the correct type. Can you post  
the lines from the cdxml file that define these controls? (Or the  
whole cdxml, if it isn't too big).

-- Ed Leafe





_______________________________________________
Post Messages to: Dabo-users@...
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/2B501AEA-3481-4823-9767-F634A51D9B68@...

[Mike Mabey]

On Thu, Jul 17, 2008 at 8:43 AM, Ed Leafe <ed@...> wrote:
>
>
>         Are they listed as dDateTime entities in the .cdxml file that was
> created?
>

They are listed as dDateTextBox objects.


>        Sounds mostly like the control is not the correct type. Can you post
> the lines from the cdxml file that define these controls? (Or the
> whole cdxml, if it isn't too big).
>

I don't know if the server will let me, but I'm going to try to attach the
file to this email message.  In this cdxml file these objects are on the
following lines:

67
81
110
124
138
152
166
180
194

Thanks,
Mike M.


--- StripMime Report -- processed MIME parts ---
multipart/mixed
  multipart/alternative
    text/plain (text body -- kept)
    text/html
  application/octet-stream
---

_______________________________________________
Post Messages to: Dabo-users@...
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/89fe67110807171127h5f48aeccx364591b307f58c4f@...

[Ed Leafe]

On Jul 17, 2008, at 1:27 PM, Mike Mabey wrote:

> I don't know if the server will let me, but I'm going to try to  
> attach the
> file to this email message.  In this cdxml file these objects are on  
> the
> following lines:


        No attachments are allowed. That's why I asked you to post just the  
lines for those objects. Copy them and paste them into your reply.

-- Ed Leafe





_______________________________________________
Post Messages to: Dabo-users@...
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/8DE4684A-550B-42F6-82D8-495D1BF3A51B@...

[Mike Mabey]

Sorry, thought it was worth a try.  As far as I can see the others have
similar properties to this one.

<dDateTextBox sizerInfo="{'Proportion': 0, 'ColExpand': True, 'VAlign':
'Middle', 'Expand': True, 'RowExpand': False}" DataField="completion_date"
Name="dDateTextBox8" rowColPos="(6, 1)" designerClass="controlMix"
DataSource="grad_students" ToolTipText="Available Keys:
=============
T : Today
+ : Up One Day
- : Down One Day
[ : Up One Month
] : Down One Month
M : First Day of Month
H : Last Day of montH
Y : First Day of Year
R : Last Day of yeaR
C: Popup Calendar to Select
"></dDateTextBox>

Mike M.

On Thu, Jul 17, 2008 at 12:32 PM, Ed Leafe <ed@...> wrote:

> On Jul 17, 2008, at 1:27 PM, Mike Mabey wrote:
>
> > I don't know if the server will let me, but I'm going to try to
> > attach the
> > file to this email message.  In this cdxml file these objects are on
> > the
> > following lines:
>
>
>         No attachments are allowed. That's why I asked you to post just the
> lines for those objects. Copy them and paste them into your reply.
>
> -- Ed Leafe
>
>
>
>
>

[excessive quoting removed by server]

_______________________________________________
Post Messages to: Dabo-users@...
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/89fe67110807171141va45771amc20bd068e76ecd39@...

[Mike Mabey]

Ed,

Was this section of code informative or should I post more of my cdxml file?

Thanks,
Mike M.

On Thu, Jul 17, 2008 at 12:41 PM, Mike Mabey <mike611@...> wrote:

> Sorry, thought it was worth a try.  As far as I can see the others have
> similar properties to this one.
>
> <dDateTextBox sizerInfo="{'Proportion': 0, 'ColExpand': True, 'VAlign':
> 'Middle', 'Expand': True, 'RowExpand': False}" DataField="completion_date"
> Name="dDateTextBox8" rowColPos="(6, 1)" designerClass="controlMix"
> DataSource="grad_students" ToolTipText="Available Keys:
> =============
> T : Today
> + : Up One Day
> - : Down One Day
> [ : Up One Month
> ] : Down One Month
> M : First Day of Month
> H : Last Day of montH
> Y : First Day of Year
> R : Last Day of yeaR
> C: Popup Calendar to Select
> "></dDateTextBox>
>
> Mike M.
>

--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

_______________________________________________
Post Messages to: Dabo-users@...
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/89fe67110807181121t43a47e5eu22488d2982d62e94@...

[Ed Leafe]

On Jul 18, 2008, at 1:21 PM, Mike Mabey wrote:

> Was this section of code informative or should I post more of my  
> cdxml file?


        No, that confirmed that it wasn't anything wrong with the class  
definition.

        Do you have any code that acts on these controls? I'm just ruling out  
something else interfering with the expected behavior.

-- Ed Leafe





_______________________________________________
Post Messages to: Dabo-users@...
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/49E95EF7-EAA5-4A60-A25E-CD376C3CBE63@...

[Mike Mabey]

On Fri, Jul 18, 2008 at 12:30 PM, Ed Leafe <ed@...> wrote:
>
>
>        Do you have any code that acts on these controls?


Nothing that acts on them directly other than requery.  My code is really
pretty simple.  I've posted it to www.ece.usu.edu/files/myApp-code.py so you
can check it out.

Mike M.


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

_______________________________________________
Post Messages to: Dabo-users@...
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/89fe67110807181153i498cf5d6me868669bd8c419dc@...

[Mike Mabey]

I'm starting to think that I either suck at providing sufficient information
about my problems, or I just have weird problems that no one knows how to
fix.  Has no one had problems with the dDateTextBox object retaining entered
data?  Can anyone duplicate this problem?  Or should I just find a
workaround that doesn't use the date widget?

Mike M.


On Fri, Jul 18, 2008 at 12:53 PM, Mike Mabey <mike611@...> wrote:

> On Fri, Jul 18, 2008 at 12:30 PM, Ed Leafe <ed@...> wrote:
>
>>
>>        Do you have any code that acts on these controls?
>
>
> Nothing that acts on them directly other than requery.  My code is really
> pretty simple.  I've posted it to www.ece.usu.edu/files/myApp-code.py so
> you can check it out.
>
> Mike M.
>

--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

_______________________________________________
Post Messages to: Dabo-users@...
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/89fe67110807211002w25b20493r2b623b701edd88ba@...

[Uwe Grauer-5]

Mike Mabey wrote:
> I'm starting to think that I either suck at providing sufficient information
> about my problems, or I just have weird problems that no one knows how to
> fix.  Has no one had problems with the dDateTextBox object retaining entered
> data?  Can anyone duplicate this problem?  Or should I just find a
> workaround that doesn't use the date widget?
>
> Mike M.

Start with reporting which versions you are using, as this is the most
important info.
You can get the version info from any dabo app using the menu Help/About.

Uwe



_______________________________________________
Post Messages to: Dabo-users@...
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/4884C4BD.2080701@...

[Paul McNett]

Mike Mabey wrote:
> I'm starting to think that I either suck at providing sufficient information
> about my problems, or I just have weird problems that no one knows how to
> fix.  Has no one had problems with the dDateTextBox object retaining entered
> data?  Can anyone duplicate this problem?  Or should I just find a
> workaround that doesn't use the date widget?

It wouldn't hurt to try a raw dTextBox. If that still doesn't work
right, then it is likely something on your end. If it does work, then
there's something wrong with dDateTextBox.

I use dTextBox for my dates and datetimes, because dTextBox works for my
needs.

Paul


_______________________________________________
Post Messages to: Dabo-users@...
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/4884CB75.1070907@...

[Mike Mabey]

Hi Paul,

On Mon, Jul 21, 2008 at 11:46 AM, Paul McNett <p@...> wrote:
>
>
> It wouldn't hurt to try a raw dTextBox. If that still doesn't work
> right, then it is likely something on your end. If it does work, then
> there's something wrong with dDateTextBox.
>

That was actually the workaround I had in mind since all the other Text
Boxes in the app work just fine.  One thing I think might be causing a
problem with Dabo is that several of the DATE type fields in the db table
can be NULL.  My indication that this is a problem is that when the field
was *not* previously NULL, I can enter data just fine, but when the field
*is* NULL, it acts quirky and sometimes will let me type in the field,
sometime it won't, but is always replaces what was typed with <None>, which
is what was displayed initially.

Also, the last time that I ran my compiled app, I got the following error:

Traceback (most recent call last):
  File "dabo\ui\uiwx\dPemMixin.pyo", line 520, in __onWxKeyChar
  File "dabo\ui\uiwx\dPemMixin.pyo", line 915, in raiseEvent
  File "dabo\lib\eventMixin.pyo", line 93, in raiseEvent
  File "dabo\ui\uiwx\dDateTextBox.pyo", line 189, in __onChar
  File "dabo\ui\uiwx\dDateTextBox.pyo", line 217, in adjustDate
AttributeError: 'unicode' object has no attribute 'toordinal'

Does this shed any light on the situation?

I use dTextBox for my dates and datetimes, because dTextBox works for my
> needs.
>

When you do this, how do you check that the format of the date is SQL
compatible?  I guess this could be done with a regular expression, but those
are more messy in Python than I wish they were.

Thanks for your help,
Mike M.


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

_______________________________________________
Post Messages to: Dabo-users@...
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/89fe67110807211142qeba9431nf863e90414a5160d@...

[Paul McNett]

Mike Mabey wrote:
> I use dTextBox for my dates and datetimes, because dTextBox works for my
>> needs.
>>
>
> When you do this, how do you check that the format of the date is SQL
> compatible?  I guess this could be done with a regular expression, but those
> are more messy in Python than I wish they were.

You don't need to deal with that. Dabo does it for you.

Paul


_______________________________________________
Post Messages to: Dabo-users@...
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/4884DA6D.8060702@...

[Mike Mabey]

Just so you know, I wasn't able to get the dTextBox to insert a date into
the database.  I ended up changing the data type in the database to be a
varchar.  This isn't what I had in mind, but it's not completely imperative
that those fields be of type DATE.

Thanks for trying to help me anyway.

Mike M.

On Mon, Jul 21, 2008 at 12:50 PM, Paul McNett <p@...> wrote:

> Mike Mabey wrote:
> > I use dTextBox for my dates and datetimes, because dTextBox works for my
> >> needs.
> >>
> >
> > When you do this, how do you check that the format of the date is SQL
> > compatible?  I guess this could be done with a regular expression, but
> those
> > are more messy in Python than I wish they were.
>
> You don't need to deal with that. Dabo does it for you.
>
> Paul
>
>

[excessive quoting removed by server]

_______________________________________________
Post Messages to: Dabo-users@...
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/89fe67110807221408p1dcc7c77tc650e79f8647a329@...

[Ed Leafe]

On Jul 22, 2008, at 4:08 PM, Mike Mabey wrote:

> Just so you know, I wasn't able to get the dTextBox to insert a date  
> into
> the database.  I ended up changing the data type in the database to  
> be a
> varchar.  This isn't what I had in mind, but it's not completely  
> imperative
> that those fields be of type DATE.

        What database? It might be an implementation detail in the DB layer.

-- Ed Leafe





_______________________________________________
Post Messages to: Dabo-users@...
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/55A307CF-AF46-4BB2-8464-9AE9F6ADA183@...

[Mike Mabey]

On Tue, Jul 22, 2008 at 3:11 PM, Ed Leafe <ed@...> wrote:
>
>
>         What database? It might be an implementation detail in the DB
> layer.
>
> -- Ed Leafe


Ed,

Sorry for the delayed response.  Looks like the web server is running MySQL
3.23.58.  It surprises me that it has such an old version running on it, but
that's not something I have control over.

Mike M.


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

_______________________________________________
Post Messages to: Dabo-users@...
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/89fe67110807281406q1296699j78006109881e180e@...