Coralie – Omnis Forum

Coralie started the topic Excel Automation for import in the forum Omnis General Coding 1 year, 6 months ago

Hi everyone,

I’m working on a web app (so remote forms), on OS10.1 and I have a page where the user can import a file, and it is then rendered on a jsGrid, on the very same page. So far it works with .txt and .csv but I was wondering if there is a way, with the Automation, to make it works with .xls. I know there is TMObjs.dll, but since we are…[Read more]

Coralie replied to the topic refresh page jsForm in the forum Omnis forum 1 year, 9 months ago

Hi Gav,

None of the methods from the log come from my library. I have no idea either where they come from but after multiples attempts, those lines never showed up again so I don’t think it is related.

After a closer look, I noticed that I did not used the jsNavMenu sample but more the “myapplication.lbs” used during the Omnis formation. So I…[Read more]

Coralie replied to the topic refresh page jsForm in the forum Omnis forum 1 year, 9 months ago

Hi Andreas,
I am using the Startup_Task just so I can have the page launched when opening the library on development. I only have Do $clib.$remoteforms.jsMenuNavMenu.$open() written in it.
However, with the use of sys(3000), I got this log below just after my last method (it is quite long sorry) :

SQL.Startup_Task/$resume Calculate tSystemCall…[Read more]

Coralie replied to the topic refresh page jsForm in the forum Omnis forum 1 year, 9 months ago

Hi Gav,
As for the browser, the same thing happens regardless of which one I am using.
The methods used for the navigation basically come from the “jsnavmenu sample” of Omnis’s hub, so I have an object oNavMenu, with an iNavObj that $construct, $buildmenu, $getMenu, defineMenuList, and $getJsFormName throughout the site.

Thanks,
Coralie.

Coralie started the topic refresh page jsForm in the forum Omnis forum 1 year, 9 months ago

Hi everyone,

I have been struggling with something for a while now.

I am creating a website with OS10.1 and I have a classic jsHome page and some other pages linked by a jsMenuNavMenu, being launched by the Startup_Task. On the homepage I can refresh the page using the web bowser, but once I changed the page, if I refresh it, Omnis studio…[Read more]

Coralie replied to the topic sys() function for windows bit in the forum Omnis forum 1 year, 10 months ago

Hi Gav,

Many thanks for this !

Happy holidays,
Regards,
Coralie.

Monnet started the topic sys() function for windows bit in the forum Omnis forum 1 year, 10 months ago

Hi everyone,

I was wondering if there is a way, with sys() function for example (if so, I must have missed the correct number, my bad), to know if the user is running the x32bits or x64bits of Omnis Studio?

Regards,
Coralie.

Monnet started the topic Import data encoding App Web in the forum Omnis General Coding 2 years, 1 month ago

Hi everyone,

I need help regarding an import method for a web application.
Right now, the method works but only for one type of encoding :

//For UTF-8 encoding type:
Do iJSFileRow.$loadcols()

Do iJSMimeList.$search(low(iJSMimeList.name)=’content-disposition’;kTrue;kFalse;kFalse;kFalse)
Do iJSFileMimeList.$line.$assign(1)
Calculate…[Read more]

Monnet started the topic web import data in the forum Omnis forum 2 years, 2 months ago

Hi everyone,

I have a web form with a grid that needs to be filled when a user upload a .txt or .csv file. Since it is web, I’m using the JSFormFile obj so I get the data in binary.
Is there an easy way to pass those data in a list or do I have to analyze its content and build the list?

Thanks in advance,
Regards,
Coralie

Monnet replied to the topic SqLite multiple user in the forum Omnis forum 2 years, 3 months ago

I spent several hours trying to figure out how to set up correctly the WAL mode. I have tried some different PRAGMA set ups, as explained in the doc.
From what I understood and tried without success, there is no way to have multiple writers and readers concurrently, without having to filter user’s authorizations throughout the code.

I am…[Read more]

Monnet replied to the topic SqLite multiple user in the forum Omnis forum 2 years, 3 months ago

Thank you Alex,

It seems to have done something but it made me lost the connection to the database.
Technically, when there are two users and one of them wants to update/insert something, I get the $nativeerrortext as “database is locked” and if one of them is not logged in, the transaction does work. From there and what I have read, the WAL…[Read more]

Monnet started the topic SqLite multiple user in the forum Omnis forum 2 years, 3 months ago

Hi everyone,
While working on my web application under OS10, I did some tests and ran into an issue.

The app is using a SQLite database and is supposed to have several users at the same time, updating, creating or deleting datas, sharing the same db. I read that SQLite doesn’t allow that, unless you convert the database connection to WAL mode.…[Read more]

Monnet started the topic SqlLite update not working in the forum Omnis General Coding 2 years, 4 months ago

Hi everyone,
I’m working with JsRemote form under Omnis 8.1 and I’m having a really hard time with an update…

I’m using an SqlLite database and my main form is made of a tab component. First tab is a smartlist, second tab is a row.

Both are linked with the PK/FK, I can insert both in the database, and I can update the second tab (therefore the r…[Read more]

Monnet replied to the topic Subform Set Panels in the forum Omnis General Coding 2 years, 5 months ago

Hi again,

small update, I’ve changed my NavBar to a MenuList so I can handle the destruct of the SFS. But when I execute the $RemoveSFS method, I get ” E101697: Notation not supported “. I’ve tried your code, I’ve tried the
Do $cinst.$clientcommand(“subformset_remove”,lSetRow).
If anyone has any idea on what I am doing wrong…
Thanks e…[Read more]

Monnet replied to the topic Subform Set Panels in the forum Omnis General Coding 2 years, 5 months ago

Hi Paul,

Thanks for your answer. The thing is, I’m using the subform as a kind of CRUD so I can’t use a “done” button. I only have the “back” button in the NavBar, which is implemented in the very first form so I’m not sure on how/where to handle the destruct of the SFS.

Monnet started the topic Subform Set Panels in the forum Omnis General Coding 2 years, 5 months ago

Hi everyone,

I’m using a JsSubformSetPanels (running under Omnis 8).
The last line of the openSubForms method is :

Do lSetRow.$define(lSetName,lParent,lFlags,lOrderVar,lFormList)
Do lSetRow.$assigncols(‘SubformSet’,”,kSFSflagSingleOpen+kSFSflagMinButton+kSFSflagAutoLayout+kSFSflagParentWidth,’iOpenForms’,lFormList)
Do…[Read more]

Monnet replied to the topic scope variable in the forum Omnis General Coding 2 years, 6 months ago

Hi Klaus,
I had tried the task type variable but it didn’t work (I don’t how I failed that…). But your solution went great.

Thank you very much once again Klaus,

Regards,
Coralie.

Monnet started the topic JsForms et valeur d’une variable in the forum Forum Omnis en Français 2 years, 6 months ago

Bonjour à tous,

Je travaille sous Omnis 8.
J’ai une iVar dans un JsForm et j’ai besoin de récupérer la valeur de cette variable depuis un autre JsForm. J’ai essayé plusieurs solutions (qui ne fonctionnent pas) mais je pense que je passe à côté de quelque chose… Une idée?

Merci,
Coralie.

Monnet started the topic scope variable in the forum Omnis General Coding 2 years, 6 months ago

Hi everyone,

I’m using Omnis 8 and Js Forms.
I have an iVar in the first form and I need its value in the second form. How can I change the scope of my var so that I can access it?

Regards,
Coralie.