|
|
 | | From: | Pieter van Heerden | | Subject: | spinbox and date entries | | Date: | Fri, 31 Dec 2004 03:53:39 -0500 |
|
|
 | I have recently upgraded to dbase 2.5
I have "designed" my on form controls based on the examples in the dBase Tutrial.
Linking a spinbox to a date field an error message pops up when pressing the "append" button. Error message "Data type mismatch. Expecting character" is shown.
The "edit" button functions normally.
Advise please?!
|
|
| | From: | Ken Mayer [dBVIPS] | | Subject: | Re: spinbox and date entries | | Date: | Fri, 31 Dec 2004 05:32:08 -0800 |
|
|
| Pieter van Heerden wrote:
> I have recently upgraded to dbase 2.5
>
> I have "designed" my on form controls based on the examples in the dBase Tutrial.
>
> Linking a spinbox to a date field an error message pops up when pressing the "append" button. Error message "Data type mismatch. Expecting character" is shown.
>
> The "edit" button functions normally.
>
> Advise please?!
This newsgroup is specifically for posting bug reports to the R&D team.
Suggest you use a different newsgroup, such as d.programming for this.
(And it would help to show some code ...)
Ken
--
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/
*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase
|
|
| | From: | Pieter van Heerden | | Subject: | Re: spinbox and date entries | | Date: | Mon, 03 Jan 2005 01:42:35 -0500 |
|
|
| Ken Mayer [dBVIPS] Wrote:
> Pieter van Heerden wrote:
> > I have recently upgraded to dbase 2.5
> >
> > I have "designed" my on form controls based on the examples in the dBase Tutrial.
> >
> > Linking a spinbox to a date field an error message pops up when pressing the "append" button. Error message "Data type mismatch. Expecting character" is shown.
> >
> > The "edit" button functions normally.
> >
> > Advise please?!
>
> This newsgroup is specifically for posting bug reports to the R&D team.
> Suggest you use a different newsgroup, such as d.programming for this.
>
> (And it would help to show some code ...)
>
> Ken
>
> --
> /(Opinions expressed are purely my own, not those of dataBased
> Intelligence, Inc.)/
>
> *Ken Mayer* [dBVIPS]
> /Golden Stag Productions/
> dBASE at goldenstag dot net
> http://www.goldenstag.net/GSP
> http://www.goldenstag.net/dbase
Thanks Ken
I am red-faced on this side, it seems to have been a programming problem and not a bug. So sorry.
What happend was the following:
I am upgrading an old DOS-based dBase program where date and month columns are found in a table, a month name is entered programmatically based on the month value in the date field after data entry. I wanted to be clever and wrote the month number to the month name and then have the month name linked into the field through an SQL lookup. This worked fine when I tested it in the datamodule in edit mode, but the problem reported surfaced when new data was appended. Subsequent to my message to you, I have identified the source of the problem and changed the table as follows; I removed the month column as a permanent column and added it as a calculated field, together with a beforeGetValue event. This solved my problem.
|
|
|
