Home Members Coralie

Welcome to the OMNIS developer community

  • Profile picture of Coralie

    Coralie started the topic Excel Automation for import in the forum Omnis General Coding 11 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]

  • Profile picture of Coralie

    Coralie replied to the topic refresh page jsForm in the forum Omnis forum 1 year, 1 month 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]

  • Profile picture of Coralie

    Coralie replied to the topic refresh page jsForm in the forum Omnis forum 1 year, 1 month 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]

  • Profile picture of Coralie

    Coralie replied to the topic refresh page jsForm in the forum Omnis forum 1 year, 1 month 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.

  • Profile picture of Coralie

    Coralie started the topic refresh page jsForm in the forum Omnis forum 1 year, 1 month 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]

  • Profile picture of Coralie

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

    Hi Gav,

    Many thanks for this !

    Happy holidays,
    Regards,
    Coralie.

  • Profile picture of Coralie

    Coralie‘s profile was updated 1 year, 2 months ago

  • Profile picture of Coralie

    Monnet started the topic sys() function for windows bit in the forum Omnis forum 1 year, 2 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.

  • Profile picture of Coralie

    Monnet started the topic Import data encoding App Web in the forum Omnis General Coding 1 year, 5 months 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]

  • Profile picture of Coralie

    Monnet started the topic web import data in the forum Omnis forum 1 year, 6 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

  • Profile picture of Coralie

    Monnet replied to the topic SqLite multiple user in the forum Omnis forum 1 year, 8 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]

  • Profile picture of Coralie

    Monnet replied to the topic SqLite multiple user in the forum Omnis forum 1 year, 8 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]

  • Profile picture of Coralie

    Monnet started the topic SqLite multiple user in the forum Omnis forum 1 year, 8 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]

  • Profile picture of Coralie

    Monnet started the topic SqlLite update not working in the forum Omnis General Coding 1 year, 9 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]

  • Profile picture of Coralie

    Monnet replied to the topic Subform Set Panels in the forum Omnis General Coding 1 year, 10 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]

  • Profile picture of Coralie

    Monnet replied to the topic Subform Set Panels in the forum Omnis General Coding 1 year, 10 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.

  • Profile picture of Coralie

    Monnet started the topic Subform Set Panels in the forum Omnis General Coding 1 year, 10 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]

  • Profile picture of Coralie

    Monnet replied to the topic scope variable in the forum Omnis General Coding 1 year, 10 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.

  • Profile picture of Coralie

    Monnet started the topic JsForms et valeur d’une variable in the forum Forum Omnis en Français 1 year, 10 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.

  • Profile picture of Coralie

    Monnet started the topic scope variable in the forum Omnis General Coding 1 year, 10 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.

  • Load More

Groups

Recent Topics

Recently Active Members

Profile picture of lanabianca
Profile picture of Paul Mulroney
Profile picture of Jacques Couédor
Profile picture of Jim Creak
Profile picture of Mike Motter
Profile picture of Denis Woodbury

Forum Statistics

Registered Users
1,083
Forums
9
Topics
228
Replies
346
Topic Tags
173

© Omnis Software Ltd 2021 - Help with setup and design by Ädelfors Consult AB, Sweden Disclaimer: Omnis Software disclaims any responsibility for or liability related to Software, or any content or advice, obtained through this site. IN NO EVENT WILL OMNIS SOFTWARE BE LIABLE FOR ANY INDIRECT, PUNITIVE, SPECIAL, INCIDENTAL OR CONSEQUENTIAL DAMAGES HOWEVER THEY MAY ARISE AND EVEN IF OMNIS SOFTWARE HAS BEEN PREVIOUSLY ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.

Log in with your credentials

or    

Forgot your details?

Create Account