Forum Replies Created
- AuthorPosts
- JD KromkowskiParticipant
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
JD KromkowskiParticipantThanks. 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), selectionNOT Hours, uparrowhours, downarrowhours, Minutes, minarrowup, minarrowup , am/pm, selection
JD KromkowskiParticipantDid you just post yours or someones gmail password, here?!!
JD KromkowskiParticipanttesting
JD KromkowskiParticipanttest
JD KromkowskiParticipantThat was my first instinct – SORT OF.
Ah, you must use TWO single quotes not a double quote.
Maybe add this to the documentation.
JD KromkowskiParticipantwould 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?
JD KromkowskiParticipantSo 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
JD KromkowskiParticipantSo 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 dispappw =@ getappwindowfromwindow(getmenuitemwindow(me))
disp =@ app.displayformats
tables =@ gettablesarray(appw)
tablename = appw.currenttable.table.tablenamethen 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
JD KromkowskiParticipantI’m going to take a closer look at how it works in
donewuserfilter, where it does definitely workwhich 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”
JD KromkowskiParticipantAs 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.
JD KromkowskiParticipantSo 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”)JD KromkowskiParticipantI thought I some something. where you see ? ‘ I had typed ” & r s q u o ;” no spaces
- This reply was modified 7 years, 2 months ago by JD Kromkowski.
- This reply was modified 7 years, 2 months ago by JD Kromkowski.
- This reply was modified 7 years, 2 months ago by JD Kromkowski.
JD KromkowskiParticipantepiphany just now.
= ‘Workers’||’' ‘||’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}JD KromkowskiParticipantI 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
- AuthorPosts