[Gav]

Hi @segno

I wonder if this is a property of the browser, rather than the application. Whilst we can tell Omnis that we want commas and decimal points, this might get re-interpreted by the browser language setting. See here: https://support.google.com/looker-studio/thread/9967878?msgid=9969173

Rgds,
Gav

[Gav]

Hi James,

Where is your client based and in what industry? It might be useful to provide this information in order to narrow down the search for the most suitable providers.

Rgds, Gav

[Gav]

Hi @surojit4

We’re using the VCS and have been for many years without any problems. I’m wondering if you are logging onto the VCS but there is nothing to see yet?

In your Studio Browser window, you will see the following sections:

– Hub
– Libraries
– SQL Browser
– VCS
– Web ServiceServer

Because this is a new VCS repository, it is empty.
Maybe you need to drag one of your libraries onto the VCS (or some of the classes) in order to create a project within it. Then, when you next log onto the VCS, you will see the projects in there.

Rgds, Gav

[Gav]

Hi Paul,

I don’t know the Studiotips solution to type-ahead, so can’t comment on that. However, if you are looking to perform type-ahead searching against a SQL database, then I imagine a SQL Worker object could be used.

You would instantiate and initialise the worker object and $start it with the first character(s) in the query. Have $keyevents turned on for your entry field and upon a key event, immediately $cancel the worker task and $start with the new entry string.

This is just an idea and not something I’ve personally used yet. How the performance pans out would depend on the amount of data in the table your users are querying, whether the query uses an index on the queried column, and how many lines (i.e. how much data) are returned from a typical type-ahead query.

It could potentially lead to a fairly slow user experience where they see nothing returned until they stop typing for long enough to allow the worker object to complete and return some results. Therefore, it might be an idea to have two worker objects, allowing one to continue running while you start the other? You might also want to limit the number of rows returned by this background process (select top 10….from <tablename>…) and only return a larger dataset if this completes and no further key events have been detected.

As I say, this is thinking out loud. Hope it gives you some ideas.

Rgds,
Gav

[Gav]

Hi Coralie,
None of the methods in the log are in the JsNavMenu library so I don’t know where they have come from.
I guess you need to track down what is calling SQL.Startup_Task/$resume
Also, is $close_Session_windows designed to close ‘window’ classes or ‘remote form’ classes?
As you say Studio is ‘crashing’, it may be trying to reference something (close a window instance) that does not exist, so you would want to put a ‘Breakpoint’ command in there before the ‘Close window instance’ command and see what it is doing.
Rgds,
Gav

[Gav]

Hi Coralie,
I haven’t studied the Navigation Menu Object before but just took a look at the sample library.
The sample library does not crash when I use it, so I assume it’s something that happens in the On evMenuEntryClicked event.
The sample library has:
On evMenuEntryClicked
If not(iNavObj.$handleclick($cfield,pLineTag))
Do $cinst.$showmessage(con('Ident ',pLineIdent),'Click')
End If
Have you changed this code and if so, to what?
Rgds,
Gav

[Gav]

Hi Coralie,
The first thing I would ask is what browser you are using.
Secondly, you say ‘once I changed the page’…do you mean that you have performed a $changeform?
Rgds,
Gav

[Gav]

Hi shital,
I believe you are looking for the event ‘evAfter’
Remember to turn it on in he edit control’s property ‘$events’
Remember that this event will trigger if the user clicks on another control (not just upon tab).
As far as I can see, there is no way of detecting specifically if the user hit the ‘Tab’ key.
Regards,
Gav

[Gav]

Hi Monnet,
Calculate lvPlatform as sys(8)
returns the platform type of the current Omnis program as a string: ‘MAC64’, ‘WIN32’, ‘WIN64’, ‘UNIX’
Regards,
Gav

[Gav]

Hi Dario,
The slides etc are only available at Euromnis. They are stored on a network drive for participants at the conference to obtain during or after sessions but the network is taken down on Thursday evening. We don’t then publish them on the website.
Rgds,
Gav

[Gav]

Hi Ghiara,
On a fat client window, the only option I can think of is to use a background text object.
Your users would have to enter their text in a ‘markup’ form, with tags that you interpret.
This would give you the ability to:
– bold
– underline
– include fields
It would not permit ‘tabs’, which really are a Word Processing function and would require oWrite.
In order to to turn bold on, include ascii(27) character, then ‘00000001#’) in $text.
In order to to turn underline on, include ascii(27) character, then ‘00000004#’ in $text.
In order to to turn either off (return to standard text), include ascii(27) character, then ‘00000000#’ in $text.
In order to include a field, get users to wrap it in square brackets.
Try setting the $text property of a background text object to the below. Sorry that asc27) doesn’t show in the code I’ve pasted here:

00000001#This is a bold line00000000#
This is an 00000004#underlined00000000# word
This is a #S1 – [#S1] – field

[Gav]

Hi Patricia,
The ‘Too many workstations in use’ is an error presented by Omnis when more than the licenced number of users is trying to open an Omnis application or datafile. So it is possible that you do not have the required number of licences.
ODB:
However, there are other possibile causes associated with file sharing across the network.
When sharing an Omnis datafile (not SQL), the datafile is opened across the network by each user.
As each user opens the datafile, a lock is placed on one byte in the header record of that file.
File servers changed a whle back and stopped supporting the ‘byte range protocol’ of old.
Omnis introduced something called the Omnis Data Bridge to resolve that. It’s not something I’ve ever had to use as I’ve been building SQL systems for years.
In summary, you might just need to contact Omnis Software and purchase a multi-user serial number to allow multiple users to run this application simultaneously. However, you might need someone experienced in Omnis programming to set up the ODB for you. Either way, I would look for an Omnis developer to support this application going forwards and consider getting trained in Omnis if you want to do this yourself.
Rgds,
Gav