[Andreas Pfeiffer]

Hi Martin,

I do not understand. An Omnis remote form is per se in the cloud.

Maybe I do not get it. How do you define a “cloud” in this respect?

Best,

Andreas

• This reply was modified 1 year, 2 months ago by  Andreas Pfeiffer.

[Andreas Pfeiffer]

Hi Paul,

Sorry – there was no video recording I am afraid.

All the best to the other side of the earth! Regards to Caroline.

Best,

Andreas

[Andreas Pfeiffer]

Hi Serge,

Only the Omnis application can write into the Omnis datafile. So you would need to write a little Omnis app that reads data from the MS SQL Server and writes it back to the Omnis datafile.

Best,

Andreas

[Andreas Pfeiffer]

Serge,

re-reading your post. You might be able to read from an Omnis datafile via ODBC. However tables inside the Omnis datafile must be accessible. So the Omnis developer would need to give access.

Best,

Andreas

[Andreas Pfeiffer]

.. although I would doubt if it makes sense to have the country list as a droplist inside the grid since a City rarely changes its country ..

[Andreas Pfeiffer]

Hi Martin,

I have uploaded another version that shows how you can get the countries with main cities using a rest call.

Just try jsRestTest. That form will take a little time (depending on the internet speed you have) because it reads a lot of data. Once it is open it shows a list of countries and for each country a list of cities in that country. You can use the search box to quickly find a country in that list.

Best,

Andreas

• This reply was modified 1 year, 3 months ago by  Andreas Pfeiffer.

complexgrid_with_countries_and_rest-1.lbs 70 KB Omnis LBS - Click to view

Options

• Copy Download Link

[Andreas Pfeiffer]

Hi Robert,

Should be compatible yes. You may want to check out the install.txt: https://filestore.omnis.net/OmnisStudio/Studio1100_36251/Installers/Install.txt

The minimum requirements for developing applications in Omnis Studio 11 are as follows:

    
1.1 Windows
-----------

Intel system, 2GB RAM, and 250 MB free hard disk space, Windows 10 or above, including Windows 11. Specifically, support for SVG requires the Windows 10 Creators Update (1703) or later. 

filestore.omnis.net

404 - File or directory not found.

404 - File or directory not found.

[Andreas Pfeiffer]

Martin,

Ok. Let me define the cloud then: It is a server that is somehow hosted from a bigger or smaller brand. If you want to host the Omnis application on that cloud you would need to find a cloud server that allows you to install an Omnis server runtime and the database you want to use.

Does that make sense?

Best,

Andreas

[Andreas Pfeiffer]

Note, I added a plus button to allow inserting new lines

[Andreas Pfeiffer]

Attached please find a modified version that might suit your needs.

Best,

Andreas

complexgrid_with_countries.lbs 50 KB Omnis LBS - Click to view

Options

• Copy Download Link

[Andreas Pfeiffer]

Martin,

CE edition library attached.

Best,

Andreas

complexgrid_with_picklist.lbs 50 KB Omnis LBS - Click to view

Options

• Copy Download Link

[Andreas Pfeiffer]

I beg you pardon. I will upload a CE version of this library after lunch break.

[Andreas Pfeiffer]

well and is the list data filled?

[Andreas Pfeiffer]

So in fact I did understand in the first place. Please check out the library I sent you.

Best,

Andreas

[Andreas Pfeiffer]

Ok – it shows a droplist outside of the datagrid. The datagrid remains empty.

What is your question/problem then?

You could simply load the city list when the user picks a continent in the drop list. That would then show the cities for that country, wouldn’t it?

• This reply was modified 1 year, 3 months ago by  Andreas Pfeiffer.