launch preview does not work

[oumouna]

Hello,
I have a dropdown list that I load from a field in a database, but when I do a launch preview of my screen datas don't appear.

[Scott Klement]

does it work when you display the screen from an RPG program?

[oumouna]

I have not yet written the RPG program, I want to draw my screens first. But it also happened to me with other programs. It works with the RPG program but not with the launch preview. Is it not possible to view the data without writing code?...

[Scott Klement]

The problem is that database-driven tools will attempt to synchronize themselves with the RPG program that's displaying the screen. This is done in order to:

• Make sure the SQL statement runs under the same authority (userid/password) as the RPG program that's running it.
• Make sure the SQL statement runs with the same library list as the RPG program that's running it.

When you simply do a "Preview" from the designer, it can't synchronze with the RPG program, because there's no RPG program running, no userid/password, no library list, etc.

But, you can still get a good idea of what your screens will look like in the preview mode without filling in data from the database. It's actually quite similar to the fact that the non-database driven fields won't be filled in with data in preview mode (unless you type some data.)

[oumouna]

Ok I see, thank you Scott!