Toad World® Forums

Read Only Bug

Hey Guys,

If I run this query (with the updateable button selected)

select /llnl_ins_dt,
trip_rsrv_chrg_load_inv_dt,
trip_chrg_xactn_post_dt,
trip_ticket_amt,trip_chrg_amt,
trip_ticket_no,
trip_chrg_xactn_post_dt,
trip_ticket_no_orig,
trip_ticket_no_xchg,
trip_passenger_id_no,
trip_rsrv_chrg_load_inv_dt,
trip_rsrv_chrg_load_comnt_txt
/ * from
trip_rsrv_chrg_load_day d WHERE d.trip_ticket_no_orig IS NULL AND trip_chrg_amt IS NOT null;

it won’t be writable, but if I do this:

select * from
trip_rsrv_chrg_load_day d WHERE d.trip_ticket_no_orig IS NULL AND trip_chrg_amt IS NOT null;

It is! Oops.

A very good catch, Jet. SQLNAV-1636 is created for this. We will fix it asap.

From: joethejet [mailto:bounce-joethejet@toadworld.com]

Sent: Saturday, 24 May 2014 4:53 AM

To: sqlnavbeta@toadworld.com

Subject: [SQL Navigator - Beta Discussion Forum] Read Only Bug

Read Only Bug

Thread created by joethejet

Hey Guys,

If I run this query (with the updateable button selected)

select /*llnl_ins_dt,

   trip_rsrv_chrg_load_inv_dt,

   trip_chrg_xactn_post_dt,

   trip_ticket_amt,trip_chrg_amt,

   trip_ticket_no,

   trip_chrg_xactn_post_dt,

   trip_ticket_no_orig,

   trip_ticket_no_xchg,

   trip_passenger_id_no,

   trip_rsrv_chrg_load_inv_dt,

   trip_rsrv_chrg_load_comnt_txt*/  * from

trip_rsrv_chrg_load_day d WHERE d.trip_ticket_no_orig IS NULL AND trip_chrg_amt IS NOT null;

it won’t be writable, but if I do this:

select * from

trip_rsrv_chrg_load_day d WHERE d.trip_ticket_no_orig IS NULL AND trip_chrg_amt IS NOT null;

It is! Oops.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from SQL Navigator - Beta
notifications altogether.

SQL Navigator - Beta Discussion Forum

Flag
this post as spam/abuse.

Jet, this error has been addressed in the latest beta 3662.

Hi Vincent,

Great. I will test as soon as I get an answer about the uninstaller on the other thread.

Thanks,

Jet