Q:
1. Created the app and named it, selected the data source (southwind)
2. I’ve added a form section and dropped the Customer Record into it, this was fine.
3. I added a grid section and tried to drop the Order Record into it but I’m unable to do this. Also tried with other records but same thing, they wont drop into the grid section.
A:
One thing to check – if you have the App Inspector open, make sure you have the Pages Files tab selected, not the Data tab.
an alternative is to press the shift key and drag orders directly on to the Page (without adding the Grid section first).
Q:
tried to add a table as a grid section. From what I remember in previous versions, you could drag the table onto the page from the data section and it would do so automatically. That does not appear to work in v3.0. If I add a grid section from the menu below the database and table section are greyed out in the attributes.
A:
With the App Inspector open, make sure you have the ‘Pages Files’ tab selected – this is the ‘Pages’ workspace tab and allows you to drag the table names onto a Page. A normal drag will create a Form Section and drag while pressing the Ctrl or Shift key will create a Grid Section.
Q:
If the page header is set to Visible = .F., is it possible to close the app and return to the app builder designer?
A:
If you have a menu or a button, you can use
to return to the Home workspace / App Center / Home page app.
Q2:
Is it possible to return directly to the Pages workspace?
A2:
You need Lianja.SelectWorkspace() method with an argument ‘Pages’:
Code:
Lianja.SelectWorkspace('Pages')
Every workspace can be selected/open. So, the equivalent of Lianja.home() is:
Code:
Lianja.SelectWorkspace('Home')
Be aware that the argument is case sensitive.
Q:
The database I create does not appear in the list.
What I am doing is :
In the Data workspace under Database Names, right click and click on New.
When asked for database name, I enter a name.
Table workspace appears. When I go back to the Database workspace the newly created database is not there. I even tried by adding a table and closing/reopening Lianja. Still the database is not there. However the database folder with all files is present under c:\lianja\data
A:
If you happened to have created a Project, and that Project is selected, the database has to be added to the Project in order to be visible.
So, you can try this: go to the Projects tab, select the (default) project, and then click the Data tab, and see if your database is visible.
A2:
I closed the default project and the database now appears in the list.
Q:
is possible to disable the refresh of Advanced editor panel?
In my case, I’ve a lot of procedure and this spend a lot of time..
A:
In Lianja 3.1 this now defaults to closed on first load.
The state of the advanced panel is now remembered between sessions.
You can search globally across all files from inside the script editor “Find All”…
With a Project open, the Home, Apps, Data and Library workspace explorers show just the files included in your Project, giving you a clear view of your current development. The “(default)” Project shows all Apps, Databases and Library files. Use the ‘Add …’ options in the right-click context menu to add Apps, databases and Library files to your Project.
Just add the database(s) you want to use to your Project. Your Project will only have the resources (Apps, databases, Library files) that you have added to it.
Q:
I have a big monitor (Philips BDM4065UC) which I run at 3840 x 2160.
On my monitor I find some of the fonts in Lianja rather small
A:
On the desktop shortcut for the App Builder (and the App Center) try specifying –fontsize 20 or whatever until it looks right.
It is common for Windows to set the font display as 150% on hi resolution displays.
I’ve added a new command line switch in 3.4
–dpiawareness xxx
where xxx can be 0, 1 or 2
We will try this internally first to try and resolve this issue.
DPI Awareness Level Meaning
[0] DPI Unaware This level has been introduced in Windows-Vista. Windows will pretend to the application that it is running on a standard display of 96 DPI of 1920×1080 and scale the application accordingly. It is intended to accommodate older applications designed for low DPI displays. Some artifacts may result from this type of scaling.
[1] System-DPI Aware This level has been introduced in Windows-Vista. It differs from Per-Monitor DPI Aware only when multiple monitors are connected. Windows will calculate a scaling suitable for all connected monitors.
[2] Per-Monitor DPI Aware This level has been introduced in Windows 8.1. Windows does not perform any scaling at all.
Can you try setting an environment variable:
QT_AUTO_SCREEN_SCALE_FACTOR=1
and let me know if that had any effect.
Additionally, you can specify the startup window size for the App Builder or App Center using the –geometry command line switch.
Right Click “Computer”
“advanced system settings”
environment variables.
“However, when I maximize the app I see no improvement.”
Thats expected. Maximizing the window will not scale to the device DPI.
Also try placing a text file in \lianja\bin called qt.conf which contains.
[Platforms]
WindowsArguments = dpiawareness=0
Running at that resolution even your windows desktop icon text and task bar is small.
Play about with dpi awareness and see what effect it has.
Edit \lianja\bin\qt.conf
[Platforms]
WindowsArguments = dpiawareness=0
[Platforms]
WindowsArguments = dpiawareness=1
[Platforms]
WindowsArguments = dpiawareness=2
You could set the text size in “display settings” to 125% or 150% and it would be much easier to read.
Q:
I just can’t find a way to close the Script Editor
A:
You close each script editor by clicking the x in the editor tab.
Double click an editor tab to undock it into a floating editor window.
Q:
When I tried to create a second section, a grid section, after selecting the Grid options on the Section Popup, the left sidebar displayed the App Inspector window (contrary to what the tutorial shows). I can’t back the Database window on the left sidebar. How do I redisplay the database panel
A:
Since Lianja 3.4 you can drag and drop tables and/columns from either the “Data files” or the “Pages files”. The app Inspector is tabbed so select a tab from the vertical tabbar on the left side of the app Inspector.
Double click a tab (e.g Data files) to undock it into its own floating window.
Q:
Can I set default values for App settings? For example, I would like to have default values for:
- Window Title
- Login required
- Navigation menu caption
- Author.
A:
Look at the files in the themes directory. Look in the headerbar and change the UI theme using the themes combo.
I copied one of your themes and added these lines:
app.apptitle=Cyril app
app.appauthor=Cyril
app.pagesmenucaption=My navigation
.