AnsweredAssumed Answered

Re-2: vrf ADO Date BUG

Question asked by g.nied on Mar 31, 2005
Latest reply on Mar 31, 2005 by g.nied

Like • Show 0 Likes0
Comment • 8

> So is it ADO or is it VEE?

I'm pretty sure its VEE.
ADO like VB and .Net uses the OLE Automation Date Format (OADate).
>From MDSN-Website:
"An OLE Automation date is implemented as a floating-point number whose value is the number of days from midnight, 30 December 1899."

If you use ADO in VB and read out the date field with
R=Recordset("DateField")
and R being defined as a real value you can see that R is of the OADate format.
But doing the same in VEE gives us a real value that is in VEE Date Format ( number of seconds since 00:00 hours 1 January 0001 AD)
So there must be a conversion from OADate to VEEDate somewhere. And there is the bug! And this is VEE!
Interestingly if you do the following (senseless) operation inside VEE:
Recordset("DateField")=Recordset("DateField")
to read out the field value and write it back, no error occurs. Using a variable to store the readout sucks:
X=Recordset("DateField")
Recordset("DateField")=X
Here we add the current timezone offset when in daylight saving time (not 'time saving' as I wrote in my first mail )
Obviously the date conversion does not take place in the first instruction

> Or is it an April Fools joke? So Georg is replying to Georg as Andrew? And
> he's saying something about the file system when we're talking about a
> DbDateTime field in a database? I think we done been spoofered!
> -SHAWN-

Hehe, that confuses you? So you betray yourself being a Bot, huh?

No, as Andrew wrote, he had observed a different daylight saving time related effect regarding the file system. But that has nothing to do with this VEE bug.

Georg

Georg Nied Software-Development Hansestr. 7 51149 Cologne Germany
Tel: +49 (2203) 9770915 Fax: +49 (2203) 9770924 E-Mail: info@gn-software.de

---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".

No one else has this question

Outcomes

8 Replies

g.nied Mar 30, 2005 7:49 PM
Mark Correct
Correct Answer
hi,

i've got a problem with an usb-to-serial converter and vee (hp vee 5.01).
it always works correct, but when i'm using the converter in vee (as a
simple serial port), after some hours windows reports an access violation.

this error only accours when i'm really reading data (using a "direct i/o"
object).

anybody heard about that problem? - thanks for your answers!

bye,
philip

---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".
Like • Show 0 Likes0
Actions
g.nied Mar 30, 2005 7:49 PM
Mark Correct
Correct Answer
hi,

i've got a problem with an usb-to-serial converter and vee (hp vee 5.01).
it always works correct, but when i'm using the converter in vee (as a
simple serial port), after some hours windows reports an access violation.

this error only accours when i'm really reading data (using a "direct i/o"
object).

anybody heard about that problem? - thanks for your answers!

bye,
philip

---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".
Like • Show 0 Likes0
Actions
g.nied Mar 30, 2005 7:49 PM
Mark Correct
Correct Answer
hi,

i've got a problem with an usb-to-serial converter and vee (hp vee 5.01).
it always works correct, but when i'm using the converter in vee (as a
simple serial port), after some hours windows reports an access violation.

this error only accours when i'm really reading data (using a "direct i/o"
object).

anybody heard about that problem? - thanks for your answers!

bye,
philip

---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".
Like • Show 0 Likes0
Actions
VRFuser Mar 31, 2005 3:51 AM
Mark Correct
Correct Answer
If you are on VEE Pro 7.0, you can use the .NET method
System.Int16.Parse(Text value). It generates a VEE error if the text
contains any non-numeric characters. In the future (.NET 2.0), MS plans
to add TryParse methods that return a bool on failure instead of
throwing an error.

--
Keith

> -----Original Message-----
> From: jfreriks@optusnet.com.au [mailto:jfreriks@optusnet.com.au]
> Sent: Thursday, March 31, 2005 6:28 PM
> To: VRF
> Subject: [vrf] isNumeric function
>
>
> Hi,
>
> Just wondering if someone has implemented the equivalent of an
isNumeric()
> function
> that checks a string to see if it contains a valid number, i.e it
should
> return
> false if it contains non-numeric characters such as letters, etc.
>
> I know you can execute a loop and check each character individually,
but I
> was
> looking for a slightly neater way.
>
> The 'From String" function does not return any errors if part of the
> string is
> non-numeric, and the asInt16() function only returns an error if the
> first
> character is non-numeric.
>
> Thanks
> John
>
> ---
> You are currently subscribed to vrf as: keith_hill@agilent.com
> To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
> To unsubscribe send a blank email to
"leave-vrf@it.lists.it.agilent.com".
> To send messages to this mailing list, email "vrf@agilent.com".
> If you need help with the mailing list send a message to "owner-
> vrf@it.lists.it.agilent.com".

---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".
Like • Show 0 Likes0
Actions
VRFuser Mar 31, 2005 3:51 AM
Mark Correct
Correct Answer
If you are on VEE Pro 7.0, you can use the .NET method
System.Int16.Parse(Text value). It generates a VEE error if the text
contains any non-numeric characters. In the future (.NET 2.0), MS plans
to add TryParse methods that return a bool on failure instead of
throwing an error.

--
Keith

> -----Original Message-----
> From: jfreriks@optusnet.com.au [mailto:jfreriks@optusnet.com.au]
> Sent: Thursday, March 31, 2005 6:28 PM
> To: VRF
> Subject: [vrf] isNumeric function
>
>
> Hi,
>
> Just wondering if someone has implemented the equivalent of an
isNumeric()
> function
> that checks a string to see if it contains a valid number, i.e it
should
> return
> false if it contains non-numeric characters such as letters, etc.
>
> I know you can execute a loop and check each character individually,
but I
> was
> looking for a slightly neater way.
>
> The 'From String" function does not return any errors if part of the
> string is
> non-numeric, and the asInt16() function only returns an error if the
> first
> character is non-numeric.
>
> Thanks
> John
>
> ---
> You are currently subscribed to vrf as: keith_hill@agilent.com
> To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
> To unsubscribe send a blank email to
"leave-vrf@it.lists.it.agilent.com".
> To send messages to this mailing list, email "vrf@agilent.com".
> If you need help with the mailing list send a message to "owner-
> vrf@it.lists.it.agilent.com".

---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".
Like • Show 0 Likes0
Actions
VRFuser Mar 31, 2005 3:51 AM
Mark Correct
Correct Answer
If you are on VEE Pro 7.0, you can use the .NET method
System.Int16.Parse(Text value). It generates a VEE error if the text
contains any non-numeric characters. In the future (.NET 2.0), MS plans
to add TryParse methods that return a bool on failure instead of
throwing an error.

--
Keith

> -----Original Message-----
> From: jfreriks@optusnet.com.au [mailto:jfreriks@optusnet.com.au]
> Sent: Thursday, March 31, 2005 6:28 PM
> To: VRF
> Subject: [vrf] isNumeric function
>
>
> Hi,
>
> Just wondering if someone has implemented the equivalent of an
isNumeric()
> function
> that checks a string to see if it contains a valid number, i.e it
should
> return
> false if it contains non-numeric characters such as letters, etc.
>
> I know you can execute a loop and check each character individually,
but I
> was
> looking for a slightly neater way.
>
> The 'From String" function does not return any errors if part of the
> string is
> non-numeric, and the asInt16() function only returns an error if the
> first
> character is non-numeric.
>
> Thanks
> John
>
> ---
> You are currently subscribed to vrf as: keith_hill@agilent.com
> To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
> To unsubscribe send a blank email to
"leave-vrf@it.lists.it.agilent.com".
> To send messages to this mailing list, email "vrf@agilent.com".
> If you need help with the mailing list send a message to "owner-
> vrf@it.lists.it.agilent.com".

---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".
Like • Show 0 Likes0
Actions
g.nied Mar 31, 2005 4:14 AM
Mark Correct
Correct Answer

> So is it ADO or is it VEE?

I'm pretty sure its VEE.
ADO like VB and .Net uses the OLE Automation Date Format (OADate).
>From MDSN-Website:
"An OLE Automation date is implemented as a floating-point number whose value is the number of days from midnight, 30 December 1899."

If you use ADO in VB and read out the date field with
R=Recordset("DateField")
and R being defined as a real value you can see that R is of the OADate format.
But doing the same in VEE gives us a real value that is in VEE Date Format ( number of seconds since 00:00 hours 1 January 0001 AD)
So there must be a conversion from OADate to VEEDate somewhere. And there is the bug! And this is VEE!
Interestingly if you do the following (senseless) operation inside VEE:
Recordset("DateField")=Recordset("DateField")
to read out the field value and write it back, no error occurs. Using a variable to store the readout sucks:
X=Recordset("DateField")
Recordset("DateField")=X
Here we add the current timezone offset when in daylight saving time (not 'time saving' as I wrote in my first mail )
Obviously the date conversion does not take place in the first instruction

> Or is it an April Fools joke? So Georg is replying to Georg as Andrew? And
> he's saying something about the file system when we're talking about a
> DbDateTime field in a database? I think we done been spoofered!
> -SHAWN-

Hehe, that confuses you? So you betray yourself being a Bot, huh?

No, as Andrew wrote, he had observed a different daylight saving time related effect regarding the file system. But that has nothing to do with this VEE bug.

Georg

Georg Nied Software-Development Hansestr. 7 51149 Cologne Germany
Tel: +49 (2203) 9770915 Fax: +49 (2203) 9770924 E-Mail: info@gn-software.de

---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".
Like • Show 0 Likes0
Actions
g.nied Mar 31, 2005 4:14 AM
Mark Correct
Correct Answer

> So is it ADO or is it VEE?

I'm pretty sure its VEE.
ADO like VB and .Net uses the OLE Automation Date Format (OADate).
>From MDSN-Website:
"An OLE Automation date is implemented as a floating-point number whose value is the number of days from midnight, 30 December 1899."

If you use ADO in VB and read out the date field with
R=Recordset("DateField")
and R being defined as a real value you can see that R is of the OADate format.
But doing the same in VEE gives us a real value that is in VEE Date Format ( number of seconds since 00:00 hours 1 January 0001 AD)
So there must be a conversion from OADate to VEEDate somewhere. And there is the bug! And this is VEE!
Interestingly if you do the following (senseless) operation inside VEE:
Recordset("DateField")=Recordset("DateField")
to read out the field value and write it back, no error occurs. Using a variable to store the readout sucks:
X=Recordset("DateField")
Recordset("DateField")=X
Here we add the current timezone offset when in daylight saving time (not 'time saving' as I wrote in my first mail )
Obviously the date conversion does not take place in the first instruction

> Or is it an April Fools joke? So Georg is replying to Georg as Andrew? And
> he's saying something about the file system when we're talking about a
> DbDateTime field in a database? I think we done been spoofered!
> -SHAWN-

Hehe, that confuses you? So you betray yourself being a Bot, huh?

No, as Andrew wrote, he had observed a different daylight saving time related effect regarding the file system. But that has nothing to do with this VEE bug.

Georg

Georg Nied Software-Development Hansestr. 7 51149 Cologne Germany
Tel: +49 (2203) 9770915 Fax: +49 (2203) 9770924 E-Mail: info@gn-software.de

---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".
Like • Show 0 Likes0
Actions

Re-2: vrf ADO Date BUG

Outcomes

Related Content

Recommended Content