• 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 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,

  • Monnet replied to the topic SqLite multiple user in the forum Omnis forum 3 months, 2 weeks 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 3 months, 3 weeks 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]

  • 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]

  • 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]

  • 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]

  • 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.

  • 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 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,


  • 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?


  • Monnet started the topic scope variable in the forum Omnis General Coding 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?


  • Hi everyone,

    I’m using Omnis 8 and a DataGrid within a Js Remote form.

    I’m having a bit of an issue to fetch back the last inserted Id.

    Do iSqlRow.$insert() Returns lReturnFlag
    If lReturnFlag
    Calculate iOldRow as iSqlRow
    End If

    Do iChildList.$dowork() Returns lFlag
    If not(lFlag)
    Do method showLastError (lStatRef)
    OK message OK…[Read more]

  • Hi everyone,

    I did it with the JsClient, just the way Klaus explained, and it works perfectly.
    In case someone needs it:

    -Change the $userdefined property to kTrue
    -Change the $columnType property to kJSDataGridModeDropList
    -For each column of the data grid, set the $columndatacol property to the number corresponding to your datalist’s…[Read more]

  • Hi again,
    Never mind the question, I did it 🙂 !
    For those who would end up on this thread, searching for a solution, I managed to do it, doing this:
    Do $cinst.$objs.EnterableGrid.$selectedlinetextcolor.$assign(rgb(255;0;0))

  • Hi Klaus,
    Thank you for the reply. I’m deeply sorry for forgetting to say that I am actually using a Js Remote Form but I’m hoping it doesn’t change much what you (very well as a matter of fact) explained…


  • Hi everyone,

    I would like to add a droplist inside of an enterable data grid. Is there any way to achieve this?

    Thanks in advance.

  • Hi everyone,

    I’m using an Enterable Grid and I need to add some securities regarding entries.
    What I’m trying to achieve is that if one entry doesn’t match what was expected, then the cell turns to red (either background or text).
    I’ve tried several things such as:
    Calculate MyList.MyCol as style(kEscColor;kRed)
    Do…[Read more]

  • Monnet became a registered member 6 months, 4 weeks ago

  • Load More

© Omnis Software Ltd 2019 - Help with setup and design by Ädelfors Consult ABSweden 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


Forgot your details?

Create Account