Navigation Menu

[Michael]

The OutputFile= parameter is for you to fill out as desired. You may not even have a c:\temp folder. Just choose where you want the output to go (valid path name on your machine).

Once you have the parameter file built, you pass it to the sendmail program and it will output its results in the Outfile= file.

Ciao, Neil

[Michael]

You can download and configure stunnel https://www.stunnel.org/downloads.html and then instead of sending to your smtp host directly, you send it to localhost:25 for example. There are pre-built configuration entries for gmail smtp, pop3, and imap.

As for the syntax, do you mean you don’t know how to create the output file in Superbase Classic?

[Michael]

Hi John,

This is more a documentation issue than anything else. The item you are looking for is in commonreportgui.sml. Here is the definition:

function dofilter(report1 report, type(wxdialogparent) w, array tables, string filter, \
                  string newclause, function okhandler, boolean allowtablechange=.true, \
                  boolean showjoinbutton=.true, string deftablename, \
                  boolean iscalculation=.false, string asname, boolean ismodify=.false, \
                  wxform mainform, string errmsgtitle=sCMNERRMSGTITLE, type(*) ref, \
                  type(dataform1) form, \
                  string caption="Superbase NG Quick Report Filter Definition") \
                  information "[simpol::return::boolean]" export

This function is used for both the filter and the calculation code in the update. I haven’t had the time to document the use of this for out of house, but you should be able to get it to do what you want.

The okhandler needs to be a function with the following prototype:

function myfilterok(commonfilterinfo finfo, wxform form)

The item you are looking for is form!tbFilter.

I hope that helps. I really don’t have the time to document this in detail right now.

Ciao, Neil

[Michael]

Hi John,

You define the onmouse handler as a function with the following parameter list:

function myonmouse(type(wxformcontrol) control, integer etype, integer keys, integer x, integer y, type(*) reference)

So you would set that function as the onmouse.function, the reference (if required) as the onmouse.reference, and then decide which events you wish to handle, by setting the onmousemask using setonmousemask(). The list is:

left button down: 0x00000001
left button up: 0x00000002
left button double click: 0x00000004
middle button down: 0x00000010
middle button up: 0x00000020
middle button dbl click: 0x00000040
right button down: 0x00000100
right button up: 0x00000200
right button dbl click: 0x00000400
motion: 0x00001000

Any or all of these bit values can be combined and using the etype parameter you can determine which event has been sent to the handler.

Ciao, Neil

[Michael]

Thanks John,

I will have a look at them. There are a few older applications that are in need of a refresh and we will be dealing with them this month as part of a release towards the end of the month.

Ciao, Neil

[Michael]

guigetsimplefilter() was designed to be used for the = in the selection panel. As such, it is limited to a single table statement. It intentionally disables/hides the Links button in the filter dialog.

[Michael]

Hi John,

It is actually easier than you thought. Just put two apostrophes instead of 1:
= ‘Worker”s Compensation Commission’

[Michael]

Sorry to hear you are having problems with it. I will have a look today.

We haven’t chosen to release the code that implements the report1, quickreport1, graphicreport1, the quick report GUI, etc. because we still make changes to that (we are currently playing around with adding ODBC-based SQL support to the whole thing). Also some libraries may never be delivered in source.

[Michael]

Hi John,

Your initial post looked relatively good from here. Yes, you should be able to call that to allow the user to construct a filter for a single table. The return value is the where clause.

As for the problem in SIMPOL Business, thanks for the heads up. I have removed the paths from the label definitions in the current version so in the next release, they should work fine. You can do the same, just remove the entire path in the andtags from customerlabels.sxf and customerlabels_us.sxf. The first one is for A4 paper and the second one is for US Letter paper.

If you are having problems with guigetsimplefilter(), can you tell me what is happening and how far you get?

Ciao, Neil

[Michael]

Interesting that you should mention that. I literally only this past week finished adding the functionality to the form open, print form open, and graphic report open code to allow you to go find the correct data source when it isn’t found. Normally, if the forms and the database files are in the same directory, when you open them it will just try the current directory and succeed. However, if you store the database files in a different folder to the application folder and have moved the forms to another machine in a new path, then it won’t be able to find them, that is what the new code is for.

• This reply was modified 7 years, 7 months ago by Michael.

[Michael]

Yes, the control detects that you are typing, but it doesn’t detect the paste from the clipboard. For that you need to display the edit control (F2 works as well).

[Michael]

It depends on what you are trying to accomplish. The grid would not know how to interpret what is on the clipboard, so if you were to place focus in a single grid cell and then use CTRL+V, I would expect all of the clipboard contents to go into that one cell. If what you want is to have several records worth of stuff on the clipboard and to paste it into the grid splitting it into the correct cells and into separate records, then it isn’t automatic, but it is certainly possible. The risk is that the clipboard format needs to match what you expect when you pull it down into a variable and then try to parse that into columns and rows.

[Michael]

I did some testing and it appears that the system themes are not being applied to our wxWidgets components when run from the IDE, but they are being applied when they are run from our runtime system. You can easily test this. Bring up your program, then go to the Start menu, Settings->Personalization->Themes->Theme settings and then click on some of the different themes (easiest is to try the high contrast white). Don’t apply, just click on them and they will change (and so will the elements on the form).

[Michael]

SIMPOL inherits the Windows theme look and feel, so it may be that this is literally down to that. You might be able to adjust it by fiddling with the theme settings.

[Michael]

Interesting idea. I am not convinced about doing it the way Superbase did, however. It may be worth think about a whole different type of view element that allows this and other types of manipulation. Definitely worth brainstorming about here on the forum though.

[Author]

Posts