If I add a SQL statement to a pre-load command or a post-load command in 12.2 and there isn’t a blank line below it (not in my SQL statement but as if I were going to add a second SQL to the pre-load/post-load), the SQL statement is erased as soon as I change the view on my screen.
Does anyone know if this is resolved in 12.2 SP1?
strategis (BOB member since 2009-12-03)
I have now encountered the problem myself with DS 12.2.0 … is this fixed in the most recent Fix Pack?
ErikR 
(BOB member since 2007-01-10)
not fixed in the latest release as well.
vikasonbob (BOB member since 2010-03-30)
Latest release being 12.2 SP2?
ErikR (BOB member since 2007-01-10)
… and still not fixed in 12.2.3.1. 
dnewton 
(BOB member since 2004-01-30)
This issue is already fixed in 12.2.3.0, so should be there in 12.2.3.1, are you still seeing this problem ?
following is from the 12.2.3.0 release notes
ADAPT01484667
SQL commands entered in the pre-load and post-load command editor were deleted on closing the editor or after clicking any where else on the window. This issue has been resolved
manoj_d (BOB member since 2009-01-02)
Sorry, I’m on 12.2.3.0 designer, not 12.2.3.1. Yes, the problem is still there.
If you paste in an entry into the post-load and hit enter, no little asterisk appears for the next new entry. If you close out that window and then come back, sometimes it’s gone.
If you make a point of adding an extra blank link after your first one, it seems to save it properly.
dnewton 
(BOB member since 2004-01-30)
let me check this again, the asterisk shows up for the first time, if you select that asterisk in list box on the top, and enter a text in the edit box at the bottom, the asterisk will be replaced with the text you have entered once you click elsewhere in that windows or in the list box on the top itself
to add more commands, right click on the list box on the top and select insert. not sure if asterisk should be displayed all the time (I didn’t see this in earlier release)
other thing is, once you have entered the text on the edit box in the bottom, make sure you see the text listed in the above list box. If its listed in the above list box and its still disappearing when you open this windows again, then this could be a bug, give me the extact steps
the commit of the text entered in the edit box is dependent on the losing focus event of the edit box, I think an Apply button on the side would be a better option than rely on events and expecting the user to click else where or on the list box
hitting enter will add a new line to the command text it will not add the command to the list of pre-load or post-load command
manoj_d (BOB member since 2009-01-02)
Here’s how I can reproduce it:
How to get around it:
Before step #6 above, either:
Doing either one of those seems to make your entry “take”. But if you just create entries and then close the window immediately, the changes are not saved.
dnewton (BOB member since 2004-01-30)
Hi, I am experiencing this bug also, but the workaround suggested by dnewton above does not work for me. Regardless of what I do after step 5 (hit save, hit a different tab, hit the back button, close the window…) all text disappears from the upper box, and the only way to get the asterisk back is to close the target table editor window.
I’m on 12.2.3.0
TomA2011 
(BOB member since 2011-02-07)
Ah, ok, I missed a bit further back in the thread. I can get the workaround to work if I insert these steps between #5 and #6:
a) Right-click on the newly inserted line in the upper box;
b) Select insert after
c) - as noted by dnewton - hit another tab or the save button
The blank line inserted after is deleted, but the one containing my command remains.
TomA2011 (BOB member since 2011-02-07)
Thank you very much Tom, this works also in 12.2.2.1 excellent
Christian
CKone 
(BOB member since 2008-01-30)
Is this now fixed in 12.2.3.2?
ErikR (BOB member since 2007-01-10)
No, still using the workaround also in this version
Christian
CKone (BOB member since 2008-01-30)