Toad World® Forums

Can't edit dates when not using mm/dd/yyyy date format for display


#1

Hello Toad Team;

Using 10.1, I get a Toad exception (i.e. not an oracle error but the ‘Error occurred’ popup with the call stack) if I try to update a date in an editable data grid when I don’t have mm/dd/yyyy specified as my date format in the data grid options. I didn’t test all the formats, but I normally use yyyy/mm/dd as my date format and that generates the error, and so does dd/mm/yyyy so I’m guessing the data grid is not taking into account the display format in use when updating. Let me know if this can’t be reproduced or if it could somehow be due to a config problem.

Happy Monday,
Troy

EurekaLog 6.0.20

Application:


#2

Hi all,
I’m using Toad for Oracle Xpert ver.9.7.2.5 with db admin module.
Problem is that ;when I connect as SYS with sysdba priviliges, but not able to see the icon images Lock/Expire on the left of every USER(s) in the schema browser. I checked/unchecked browser style option “Show LHS Item Images” very many times but makes no change except “Img” column’s appearing & disappearing. When I click on “Img” column , the label “Img” disappears and instead down/up arrow leaves back.
I’ve searched Quest’s Knowledge base and tried all recommended issues and no improvement at all !!.
Before 9.7 , Toad can do this and it’s was a great feature actually.
Will you kindly help me with my problem, otherwise it’s really a bargain to find out which user is locked/expired.

Regards,
Tülin Riva

Hello Toad Team;

Using 10.1, I get a Toad exception (i.e. not an oracle error but the ‘Error occurred’ popup with the call stack) if I try to update a date in an editable data grid when I don’t have mm/dd/yyyy specified as my date format in the data grid options. I didn’t test all the formats, but I normally use yyyy/mm/dd as my date format and that generates the error, and so does dd/mm/yyyy so I’m guessing the data grid is not taking into account the display format in use when updating. Let me know if this can’t be reproduced or if it could somehow be due to a config problem.

Happy Monday,
Troy

EurekaLog 6.0.20

Application:

Hi all,

I’m using Toad for Oracle Xpert ver.9.7.2.5 with db admin module.

Problem is that ;when I connect as SYS with sysdba priviliges, but not able to
see the icon images Lock/Expire on the left of every USER(s) in the schema
browser. I checked/unchecked browser style option “Show LHS Item Images” very
many times but makes no change except “Img” column’s appearing & disappearing.
When I click on “Img” column , the label “Img” disappears and instead down/up
arrow leaves back.

I’ve searched Quest’s Knowledge base and tried all recommended issues and no
improvement at all !!.

Before 9.7 , Toad can do this and it’s was a great feature actually.

Will you kindly help me with my problem, otherwise it’s really a bargain to find
out which user is locked/expired.

Regards,

Tülin Riva

Hello Toad Team;

Using 10.1, I get a Toad exception (i.e. not an oracle error but the ‘Error
occurred’ popup with the call stack) if I try to update a date in an editable
data grid when I don’t have mm/dd/yyyy specified as my date format in the data
grid options. I didn’t test all the formats, but I normally use yyyy/mm/dd as my
date format and that generates the error, and so does dd/mm/yyyy so I’m guessing
the data grid is not taking into account the display format in use when
updating. Let me know if this can’t be reproduced or if it could somehow be due
to a config problem.

Happy Monday,
Troy

EurekaLog 6.0.20

Application:


1.1 Start Date : Thu, 5 Nov 2009 15:18:16 -0600
1.2 Name/Description: Toad.exe - (Toad for Oracle)
1.3 Version Number : 10.1.0.7
1.4 Parameters :
1.5 Compilation Date: Fri, 23 Oct 2009 12:57:05 -0600
1.6 Up Time : 4 days, 2 hours, 42 minutes, 44 seconds

Exception:


2.1 Date : Mon, 9 Nov 2009 18:01:00 -0600
2.2 Address : 006E8B21
2.3 Module Name : Toad.exe - (Toad for Oracle)
2.4 Module Version: 10.1.0.7
2.5 Type : EcxEditValidationEr ror
2.6 Message : Invalid Date.
2.7 ID : 5DEE
2.8 Count : 1
2.9 Status : New
2.10 Note :
image004.gif


#3

Hi all,
I’m using Toad for Oracle Xpert ver.9.7.2.5 with db admin module.
Problem is that ;when I connect as SYS with sysdba priviliges, but not able to see the icon images Lock/Expire on the left of every USER(s) in the schema browser. I checked/unchecked browser style option “Show LHS Item Images” very many times but makes no change except “Img” column’s appearing & disappearing. When I click on “Img” column , the label “Img” disappears and instead down/up arrow leaves back.
I’ve searched Quest’s Knowledge base and tried all recommended issues and no improvement at all !!.
Before 9.7 , Toad can do this and it’s was a great feature actually.
Will you kindly help me with my problem, otherwise it’s really a bargain to find out which user is locked/expired.

Regards,
Tülin Riva

Hello Toad Team;

Using 10.1, I get a Toad exception (i.e. not an oracle error but the ‘Error occurred’ popup with the call stack) if I try to update a date in an editable data grid when I don’t have mm/dd/yyyy specified as my date format in the data grid options. I didn’t test all the formats, but I normally use yyyy/mm/dd as my date format and that generates the error, and so does dd/mm/yyyy so I’m guessing the data grid is not taking into account the display format in use when updating. Let me know if this can’t be reproduced or if it could somehow be due to a config problem.

Happy Monday,
Troy

EurekaLog 6.0.20

Application:

Hi all,

I’m using Toad for Oracle Xpert ver.9.7.2.5 with db admin module.

Problem is that ;when I connect as SYS with sysdba priviliges, but not able to
see the icon images Lock/Expire on the left of every USER(s) in the schema
browser. I checked/unchecked browser style option “Show LHS Item Images” very
many times but makes no change except “Img” column’s appearing & disappearing.
When I click on “Img” column , the label “Img” disappears and instead down/up
arrow leaves back.

I’ve searched Quest’s Knowledge base and tried all recommended issues and no
improvement at all !!.

Before 9.7 , Toad can do this and it’s was a great feature actually.

Will you kindly help me with my problem, otherwise it’s really a bargain to find
out which user is locked/expired.

Regards,

Tülin Riva

Hello Toad Team;

Using 10.1, I get a Toad exception (i.e. not an oracle error but the ‘Error
occurred’ popup with the call stack) if I try to update a date in an editable
data grid when I don’t have mm/dd/yyyy specified as my date format in the data
grid options. I didn’t test all the formats, but I normally use yyyy/mm/dd as my
date format and that generates the error, and so does dd/mm/yyyy so I’m guessing
the data grid is not taking into account the display format in use when
updating. Let me know if this can’t be reproduced or if it could somehow be due
to a config problem.

Happy Monday,
Troy

EurekaLog 6.0.20

Application:


1.1 Start Date : Thu, 5 Nov 2009 15:18:16 -0600
1.2 Name/Description: Toad.exe - (Toad for Oracle)
1.3 Version Number : 10.1.0.7
1.4 Parameters :
1.5 Compilation Date: Fri, 23 Oct 2009 12:57:05 -0600
1.6 Up Time : 4 days, 2 hours, 42 minutes, 44 seconds

Exception:


2.1 Date : Mon, 9 Nov 2009 18:01:00 -0600
2.2 Address : 006E8B21
2.3 Module Name : Toad.exe - (Toad for Oracle)
2.4 Module Version: 10.1.0.7
2.5 Type : EcxEditValidationEr ror
2.6 Message : Invalid Date.
2.7 ID : 5DEE
2.8 Count : 1
2.9 Status : New
2.10 Note :
att1.dat (43 Bytes)


#4

Hello Tulin,

The information for the image column comes from the “ACCOUNT_STATUS” column
of dba_users. The first thing I would suggest is look at the filter icon (the
one that looks like a funnel). If it is red, then click it and clear the
filter.

Another idea is try this query logged in as SYS and another user. Does the
value in the account_status column change?

select username , account_status

from dba_Users

order by 1


#5

Hi John,
I’ve cleared the filter icon and closed the SB and opened again. No images.
Unchecked and checked browser style option . No images.
As for the query it’s successful, fetched the records with account status whatever they are.
Could the images files missing somewhere or the image type problem ?
below the screenshot of SB.

On 11 November 2009 Wednesday at 15:53, in message , John Dorlon wrote:

Hello Tulin,
The information for the image column comes from the “ACCOUNT_STATUS” column of dba_users. The first thing I would suggest is look at the filter icon (the one that looks like a funnel). If it is red, then click it and clear the filter.
Another idea is try this query logged in as SYS and another user. Does the value in the account_status column change?
select username, account_status
from dba_Users
order by 1

Hi John,

I’ve cleared the filter icon and closed the SB and opened again. No images.

Unchecked and checked browser style option . No images.

As for the query it’s successful, fetched the records with account status
whatever they are.

Could the images files missing somewhere or the image type problem ?

below the screenshot of SB.

On 11 November 2009 Wednesday at 15:53, in message
, John
Dorlon wrote:

Hello Tulin,

The information for the image column comes from the “ACCOUNT_STATUS” column
of dba_users. The first thing I would suggest is look at the filter icon (the
one that looks like a funnel). If it is red, then click it and clear the filter.

Another idea is try this query logged in as SYS and another user. Does the value
in the account_status column change?

select username , account_status

from dba_Users

order by 1
att1.dat (3.91 MB)


#6

Hi John,
I’ve cleared the filter icon and closed the SB and opened again. No images.
Unchecked and checked browser style option . No images.
As for the query it’s successful, fetched the records with account status whatever they are.
Could the images files missing somewhere or the image type problem ?
below the screenshot of SB.

On 11 November 2009 Wednesday at 15:53, in message , John Dorlon wrote:

Hello Tulin,
The information for the image column comes from the “ACCOUNT_STATUS” column of dba_users. The first thing I would suggest is look at the filter icon (the one that looks like a funnel). If it is red, then click it and clear the filter.
Another idea is try this query logged in as SYS and another user. Does the value in the account_status column change?
select username, account_status
from dba_Users
order by 1

Hi John,

I’ve cleared the filter icon and closed the SB and opened again. No images.

Unchecked and checked browser style option . No images.

As for the query it’s successful, fetched the records with account status
whatever they are.

Could the images files missing somewhere or the image type problem ?

below the screenshot of SB.

On 11 November 2009 Wednesday at 15:53, in message
, John
Dorlon wrote:

Hello Tulin,

The information for the image column comes from the “ACCOUNT_STATUS” column
of dba_users. The first thing I would suggest is look at the filter icon (the
one that looks like a funnel). If it is red, then click it and clear the filter.

Another idea is try this query logged in as SYS and another user. Does the value
in the account_status column change?

select username , account_status

from dba_Users

order by 1
att1.dat (43 Bytes)


#7

Hi John,
I’ve cleared the filter icon and closed the SB and opened again. No images.
Unchecked and checked browser style option . No images.
As for the query it’s successful, fetched the records with account status whatever they are.
Could the images files missing somewhere or the image type problem ?
below the screenshot of SB.

On 11 November 2009 Wednesday at 15:53, in message , John Dorlon wrote:

Hello Tulin,
The information for the image column comes from the “ACCOUNT_STATUS” column of dba_users. The first thing I would suggest is look at the filter icon (the one that looks like a funnel). If it is red, then click it and clear the filter.
Another idea is try this query logged in as SYS and another user. Does the value in the account_status column change?
select username, account_status
from dba_Users
order by 1

Hi John,

I’ve cleared the filter icon and closed the SB and opened again. No images.

Unchecked and checked browser style option . No images.

As for the query it’s successful, fetched the records with account status
whatever they are.

Could the images files missing somewhere or the image type problem ?

below the screenshot of SB.

On 11 November 2009 Wednesday at 15:53, in message
, John
Dorlon wrote:

Hello Tulin,

The information for the image column comes from the “ACCOUNT_STATUS” column
of dba_users. The first thing I would suggest is look at the filter icon (the
one that looks like a funnel). If it is red, then click it and clear the filter.

Another idea is try this query logged in as SYS and another user. Does the value
in the account_status column change?

select username , account_status

from dba_Users

order by 1
image004.gif


#8

Fixed for December patch.


#9

Merry Christ - err - Happy Holidays! We’ve fixed over 26 bugs for this patch and about 33 for the last patch. Who said we don’t do maintenance releases? :slight_smile:


#10

Do you have the option under Startup - “Check for DBA views” checked? Looks like
the query that is populating the SB is using all_users instead of dba_users.

Ed

[TeamT]
ATT00232.jpg


#11

It does look that, Ed. I’ve been emailing Tulin offline. I have his
Toad.ini and he has that option checked. I just asked for a spool sql.


#12

Thanks Ed and John,

    In Toad Options, I've checked "Check for access to DBA views" (it was unchecked) then Icon images came back for USERS tab.

Again thanx for your kind help,

Regards,

On 12 November 2009 Thursday at 16:36, in message , John Dorlon wrote:

It does look that, Ed. I’ve been emailing Tulin offline. I have his Toad.ini and he has that option checked. I just asked for a spool sql.

Thanks Ed and John,

In Toad Options, I’ve checked “Check for access to DBA views” (it was unchecked)
then Icon images came back for USERS tab.

Again thanx for your kind help,

Regards,

On 12 November 2009 Thursday at 16:36, in message
, John
Dorlon wrote:

It does look that, Ed. I’ve been emailing Tulin offline. I have his Toad.ini
and he has that option checked. I just asked for a spool sql.
att1.dat (43 Bytes)