Joel_Eisenstat

Member

Last active [hidden]

  1. 2 months ago
    Mon Mar 11 13:23:36 2019
    Joel_Eisenstat started the conversation In-Memory SQite.

    Good morning,
    I am using an In-Memory SQite file as a cache/holder for table rows before being uploaded to Postgres.
    However I a having difficulty reading the memory file.

    lineitemTableView.dataSet = SQLiteDatabase1.rows
    var rs = lineitemTableView.dataSet;
    var count = rs.rowCount; // count = 0 , should be 3
    rs.moveFirst();

    where count gives 0 instead of 3 - (verified as seen in the screen shot) .
    This particular code was tested on its own successfully before being included in the project .
    Is there a 'more' specific way of pointing to the SQlite memory file when there are other db files in the project ?
    Any suggestions are appreciated.

  2. Wed Mar 6 18:12:44 2019
    Joel_Eisenstat posted in SQLIte text type insert .

    Actually didn't use the $$ initially , was part of testing despairation,
    var sql = "INSERT INTO rows (code,description,tooth,surface,amount,provider) VALUES (\(codeText.text),\(descriptionText.text),\(toothText.text),\(surfaceText.text),\(amountText.text),\(providerText.text))";
    was the original code but adding '' fixed it .
    Thanks

  3. Wed Mar 6 17:44:54 2019
    Joel_Eisenstat posted in SQLIte text type insert .

    var sql = "INSERT INTO rows (code,description,tooth,surface,amount,provider) VALUES ($$\(codeText.text)$$,$$\(descriptionText.text)$$,$$\(toothText.text)$$,$$\(surfaceText.text)$$,$$\(amountText.text)$$,$$\(providerText.text)$$)";
    SQLiteDatabase1.execute(sql);
    Console.write("\(SQLiteDatabase1.errorMessage)");

    if descriptionText.text = "oral" , no error message while " oral exam" produces an error

  4. Wed Mar 6 17:35:36 2019
    Joel_Eisenstat started the conversation SQLIte text type insert .

    An error keeps coming up for a TEXT field when there is a space between characters when trying to insert into an In-Memory db.
    I am not sure if this normal behaviour.

  5. Sun Mar 3 12:21:57 2019
    Joel_Eisenstat posted in Insert selected rows.

    map = ["id":rs.stringValue(0),"date":rs.stringValue(1),"code":rs.stringValue(2)]
    just now have to move it along the selectedRows list ....

  6. Sun Mar 3 11:49:40 2019
    Joel_Eisenstat posted in Insert selected rows.

    Hey Konrad,
    Thanks on that path with ;
    var map = ["id":identifier,"date":text,"code":text]; //exposed property
    var translist = TableView1.selectedRows; // list of index paths
    for ( var index in translist) { //index path
    TableView2.insertRow(index, map, 100)
    }
    Just hung up on the map list at the moment
    No errors but values are not seen in TableView2 but the rows seem to be there

  7. Sat Mar 2 15:13:50 2019
    Joel_Eisenstat started the conversation Insert selected rows.

    Good morning,
    Some direction in transferring selected rows from one to TableView to an other is appreciated.
    // transfer selected rows only
    var translist = TableView1.selectedRows; // list of index paths
    TableView2.insertRows(?, translist, 100); // indexpaths?
    TableView2.reload(true, true);
    I am not sure of how to provide the first parameter of index paths.
    Thanks
    Joel

  8. Wed Feb 20 22:33:43 2019
    Joel_Eisenstat posted in PageSplit-Master .

    Thanks Andreas.

  9. Wed Feb 20 15:49:15 2019
    Joel_Eisenstat started the conversation PageSplit-Master .

    Is there any way of detecting if the Master window of a PageSplit navigation in portrait mode is "open or closed " ?

    Thanks

  10. Sun Feb 17 18:33:06 2019
    Joel_Eisenstat posted in Date manipulation.

    Again after hitting send got it - count is adding new date .

View more