Skip to content

JD Kromkowski

Forum Replies Created

Viewing 15 posts - 31 through 45 (of 284 total)
  • Author
    Posts
  • in reply to: Minimum files to run smp app #3470
    JD Kromkowski
    Participant

    Thanks. I’ll review. No data being stored. I do read from a table that holds basic deck of cards, but I would even need to do that, I could just load deck into array.

    Another likely dumb question. I have 53 png s for cards (one back). Would it make more sense to convert these to blobs in an images.sml. Is there a png to blob converter somewhere in SBNG.

    I know most game apps are written in Java, and here is my I’m-not-really-a-programmer (can I still say that 20+ years later) mentality: Can a Simpol/Superbase app be distributed as an app for android or iphone/ipad? Maybe I should email you directly. It’s a silly game (played by Italian Americans in one small midwestern community. It may be down my extended family.)

    JDK

    in reply to: save to sfx #3469
    JD Kromkowski
    Participant

    Thanks. It seems like wxwidgets already has a better calendar. wxMSW Appearance http://docs.wxwidgets.org/3.1/classwx_calendar_ctrl.html

    but maybe you’re not using 3.1

    There are simple things like the time picker tab sequence.
    Hours, Minutes, AM/PM (which should be spinner too), selection

    NOT Hours, uparrowhours, downarrowhours, Minutes, minarrowup, minarrowup , am/pm, selection

    in reply to: Sending Email from within Simpol #3460
    JD Kromkowski
    Participant

    Did you just post yours or someones gmail password, here?!!

    in reply to: Mouse #3454
    JD Kromkowski
    Participant

    testing

    in reply to: Mouse #3453
    JD Kromkowski
    Participant

    test

    in reply to: Update #3448
    JD Kromkowski
    Participant

    That was my first instinct – SORT OF.

    Ah, you must use TWO single quotes not a double quote.

    Maybe add this to the documentation.

    in reply to: access to the quickreport filter window #3447
    JD Kromkowski
    Participant

    would you consider releasing the quick report filter code (which allows for joins) or the form that the quick report filter dialog contains so that we wouldn’t have to start from scratch?

    in reply to: access to the quickreport filter window #3444
    JD Kromkowski
    Participant

    So I have pinned down the problem to how repguilib evaluates where clauses in this particular situation. The problems lies with the joining statement. If you separate the joining statement out, and then later rebuilding it back up you can have a custom filter. See below, which works. It seems like this guigetsimplefilter is by design or error preventing JOINS. Why?

    string whereclause1, whereclause2
    whereclause1 = “CUSTOMER.CustSerNo = ORDERMST.CustSerNo AND ”
    whereclause = “ORDERMST.OrderedOn >= DATE(‘” + \
    DATESTR(startdate, “yyyy-mm-0d”, app.SBLlocale.datelocale) + \
    “‘) AND ORDERMST.OrderedOn <= DATE(‘” + \
    DATESTR(enddate, “yyyy-mm-0d”, app.SBLlocale.datelocale) + “‘)”

    whereclause2 = guigetsimplefilter(appw.w,whereclause,\
    tablename, disp.defboolean, disp.definteger, disp.defnumber,\
    disp.defdate, disp.deftime, disp.defdatetime, app.SBLlocale.datelocale, \
    app.SBLlocale.numlocale, app.datasources, tables, app.ppcs)

    // try as example 1 doing nothing in the simple filter just leave the dates you picked –
    // things work as expected and intended no “internal error from repguilib.sml”
    // try as example 2 add with gui filter “AND ORDERMST.CustSerNo <= 24”
    // you’ll see that this also works as expected.

    whereclause = whereclause1 + whereclause2

    in reply to: access to the quickreport filter window #3443
    JD Kromkowski
    Participant

    So I sort of got it working but with addition significant problems.

    In the simpol business example in function sb_salesreport(…), I add the following

    string tablename
    tdisplayformats disp

    appw =@ getappwindowfromwindow(getmenuitemwindow(me))
    disp =@ app.displayformats
    tables =@ gettablesarray(appw)
    tablename = appw.currenttable.table.tablename

    then later in the code where there is whereclause is being assigned, mine as a test now looks like (I’ve add \ here and there to avoid wrap)

    //// this part is original code //////
    if qr =@= .nul
    wxmessagedialog(appw.w, “Error opening quick report ‘” + reportname + “‘”, sAPPMSGTITLE,\
    “ok”, “error”)
    else
    whereclause = “CUSTOMER.CustSerNo = ORDERMST.CustSerNo AND ORDERMST.OrderedOn >= DATE(‘” + \ DATESTR(startdate,”yyyy-mm-0d”,app.SBLlocale.datelocale) +”‘) AND ORDERMST.OrderedOn <= DATE(‘” + \
    DATESTR(enddate, “yyyy-mm-0d”, app.SBLlocale.datelocale) + “‘)”

    /// this part is new using guigetsimple filter /////////////////////

    whereclause = guigetsimplefilter(appw.w,whereclause,\
    tablename, disp.defboolean, disp.definteger, disp.defnumber,\
    disp.defdate, disp.deftime, disp.defdatetime, app.SBLlocale.datelocale, \
    app.SBLlocale.numlocale, app.datasources, tables, app.ppcs)
    ////////////////////////////////////////////////////////////////////

    So, you’ll see that it does now open the gui (not sure why it didn’t before)

    1. If you hit OK and don’t change anything in the whereclause – you get an error. But you really shouldn’t because if you comment everything new out the whereclause is perfectly fine.

    So, this means there is an alleged error being caught in the repguilib.sml (code to which we don’t have access)

    2. If you do try to create your own filter (either by addition or edit mode), well good luck

    in reply to: access to the quickreport filter window #3442
    JD Kromkowski
    Participant

    I’m going to take a closer look at how it works in
    donewuserfilter, where it does definitely work

    which btw took me awhile to figure out its name as I read it

    done w user filter, i.e. “done with user filter” which made no sense to me

    instead of

    donewuserfilter,i.e. “do new user filter”

    in reply to: access to the quickreport filter window #3441
    JD Kromkowski
    Participant

    As to what you release or not, that’s up to you; figuring out errors is sometimes hard without. QuickReport is a function in SBNG Personal (which includes a filter gui). So far as I understand, SBNG Personal is written in simpol. I like to be able to call QuickReport programmatically and have it as a menu item. That doesn’t seem so complicated and is in the spirit of a SBNG as a RAD tool.

    in reply to: access to the quickreport filter window #3440
    JD Kromkowski
    Participant

    So as a further test, I added the following to sb_salesreport function in the Business example. I get error 200. So something is wrong.

    whereclause = guigetsimplefilter(appw.w,\
    whereclause,\
    app.tables.ordermst.tablename,\
    app.displayformats.defboolean,\
    app.displayformats.definteger,\
    app.displayformats.defnumber,\
    app.displayformats.defdate,\
    app.displayformats.deftime,\
    app.displayformats.defdatetime,\
    app.SBLlocale.datelocale,\
    app.SBLlocale.numlocale,\
    app.datasources,\
    app.tables,\
    app.ppcs,\
    “Test of GUI SIMPLE FILTER”)

    in reply to: Update #3435
    JD Kromkowski
    Participant

    I thought I some something. where you see ? ‘ I had typed ” & r s q u o ;” no spaces

    in reply to: Update #3434
    JD Kromkowski
    Participant

    epiphany just now.

    = ‘Workers’||’&#39 ‘||’Compensation Commission’

    But alas wrong, too also no love for &apos either.
    Haven’t tried these, but there must be a solution (with programmatically doing it outside of Personal) if not it seems like a bug to me.

    ? ’
    ? {U209}

    in reply to: access to the quickreport filter window #3432
    JD Kromkowski
    Participant

    I noticed your post included the caveat ” Yes, you should be able to call that to allow the user to construct a filter for a single table.” single table

    The filter gui in Personal obviously is robust enough to allow multiple tables.

    There is a wheel, why can’t we have access to the wheel.

    JDK

Viewing 15 posts - 31 through 45 (of 284 total)