Total mess after alt-block delete and beautify

[Gustavo]

1. Open a SQL Window and enter the following code:

Insert Into mtl_item_categories_interface
  (vr_cat.organization_code,
   vr_cat.item_number,
   vr_cat.category_set_name,
   vr_cat.category_name,
   vr_cat.process_flag,
   vr_cat.transaction_type,
   vr_cat.set_process_id)
Values
  (vr_cat.organization_code,
   vr_cat.item_number,
   vr_cat.category_set_name,
   vr_cat.category_name,
   vr_cat.process_flag,
   vr_cat.transaction_type,
   vr_cat.set_process_id);

2. Select all and ident
3. In the columns list, alt-select all "vr_cat." entries
4. Delete
5. Beautify

The bigger the text, the bigger the mess.

Workaround: after step 4, copy another non-rectangular content to the clipboard and then beautify.

Regards,
Gustavo

 

[Gustavo]

BTW, this is what I get after beautify:

Insert Into mtl_item_categories_interface
    (Insert Into mtl_item_categories_interface
  (organization_code,
   item_number,
   category_set_name,
   category_name,
   process_flag,
   transaction_type,
   set_process_id)
Values
  (vr_cat.organization_code,
   vr_cat.item_number,
   vr_cat.category_set_name,
   vr_cat.category_name,
   vr_cat.process_flag,
   vr_cat.transaction_type,
   vr_cat.set_process_id);
organization_code,
     item_number,
     category_set_name,
     category_name,
     process_flag,
     transaction_type,
     set_process_id)
  Values
    (vr_cat.organization_code,
     vr_cat.item_number,
     vr_cat.category_set_name,
     vr_cat.category_name,
     vr_cat.process_flag,
     vr_cat.transaction_type,
     vr_cat.set_process_id);

 

[Marco Kalter]

That is indeed not correct. Apparently this issue is related by the selection information. If I do a Select-All between step 4 and 5, it works okay.

We'll fix it.

 

[Gustavo]

Thx. Though the sample case above is a very simple one, it actually happenned in the program window, and more than 400 lines were affected. I had to split the window and make a line-to-line comparison. It took me about one hour to recover the code.

Regards,
Gustavo

 

[Marco Kalter]

Sorry about that. Note that if you notice this on time, you can undo the beautify operation.

 

[Gustavo]

Yeah, I know. Unfortunately I had already entered a lot of code after that, and I only realized the problem when I tried to recompile.

Do you intend to publish a new 7.1 release before 8 comes out? Not that I do this every time, but the idea of going through that again can't be described as pleasant.

Regards,
Gustavo

 

[Gustavo]

Marco,

This issue is still exactly the same, even in v9b1. Quite dangerous, don't you think?

Regards,
Gustavo

 

[Gustavo]

Marco,

This one has not yet been addressed in v9b2.

Regards,
Gustavo

 

[Gustavo]

Hi,

Still the same in v9b7.

Regards,
Gustavo

 

[William Robertson]

Also the "Insert", "Into" and "Values" keywords seem to have retained their presumably accidental initial caps after beautifying

 

[Gustavo]

Actualy, I have set InitCaps for keywords in Beautifier.

 

[Gustavo]

Hi, Marco,

Still not fixed in v9b8.

Regards,
Gustavo

 

[Gustavo]

Hi, Marco,

This is still not fixed in v9rc1. Please note that this has been reported almost 3 years ago, during v8 beta tests.

Regards,
Gustavo

 

[Gustavo]

Hi,

Still not ok in v9rc2.

Regards,
Gustavo

 

[Gustavo]

Hi,

Still not fixed in v9 final (1601). Will we ever be able to safely use this feature (alt-select)?

Regards,
Gustavo

 

[Gustavo]

bump!

 

[Marco Kalter]

This will be fixed in a future patch release.

 

[Gustavo]

Still not ok in 9.0.2.1621.