Navigation Menu

[Giancarlo Cavadini]

Hi Neil,
Fixed: the problem happens when you start Superbase and is caused by the printer driver.
In the specific case the driver is the one for HP Laser Jet 600 M602 M603 PCL6 but could also be any other recent driver.
The fix is to change the default printer in the Windows Control Panel or find an older driver for the printer that creates the problem.
Ciao.
Giancarlo

[Giancarlo Cavadini]

Thanks Ian, I wrote to Neil
Giancarlo

[Giancarlo Cavadini]

Hi Jim,
I'm sorry to answer with a considerable delay, I am engaged in the
conversion from SBL to SIMPOL … I have no more time for anything else …

Thank's for your offer. Please send me your software, I see him with
pleased to see how you solved. However, realize that I am only at the
beginning of my adventure with SIMPOL …

Greetings.

On 24.10.2013 09:10:11 Jim wrote:
>
> I have a working "request 20" with optional drilldown mode.
>
> I implemented it using a list box and I plan to redo it with a grid.
> Won't take long; I just have not done it.
>
> Also, it uses my structure for database access and not yours.
>
> If you like, I could send you all the code, AND the requisite backend
> functions so you could see how I access the database and what is needed
> in order to access it more like how you do it.
>
> It took a long time to write, but it is pretty much debugged now. You
> would not have to change it much to make it work in your format, however
> you would have to change it considerably to make it internally consistent
> with your format.
>
> Basically, my backend loads arrays with record information and passes
> those arrays to the requester rather than having the requester process
> record objects directly.

[Giancarlo Cavadini]

On 21/10/2013 11:25, Neil Robinson wrote:
>
> On 20/10/2013 11:02, Giancarlo wrote:
>> Hi Neil,
>> in SIMPOL there is something similar to the beautiful function
>> GTDrillDown3%%() of Superbase?
>> Thanks.
>> Giancarlo
>>
>
> Hi Giancarlo,
>
> I remember writing that one and it took quite a while. I have been thinking
> about redoing it for SIMPOL, but it is a pretty big
> bit of work, so it has kept getting put off. One thing that it uses is a
> tabbed list box, and I don't think we have support for
> tabbed list boxes in SIMPOL currently. There are a couple of very
> interesting controls from wxWidgets that would be a really good
> vehicle for this function, which is probably why I haven't done it yet.
> I could do it with the grid, but it wouldn't be the saem
> thing, but may still be quite useful, let me think about it.
>
> Ciao, Neil
>
okay, thanks
Giancarlo

[Giancarlo Cavadini]

Neil Robinson wrote:
>
> On 20/10/2013 09:58, Giancarlo wrote:
>> Hi Neil,
>> I made my first small application using the examples provided with
>> addressbook and sbair and verified strange effects using the
>> SBLNumSettings.new() function.
>> In practice, if the parameters are not correctly passed the program
>> crashes with a GPF.
>> After several experiments I think I found the solution and I
>> commented my code as follows:
>>
>> // WARNING: SBLNumSettings.new()
>> // – If the last parameter passed to the function SBLNumSettings.new()
>> // (Boolean "CurrencySuffix") has the value .false then the
>> // first parameter (string "CurrencySymbol") MUST have
>> // Value == "" (empty string) i.e.:
>> // me.__app.SBLlocale.numlocale =@ SBLNumSettings.new("", "'", ".", .false)
>> //
>> // – If the last parameter passed to the function SBLNumSettings.new()
>> // (Boolean "CurrencySuffix") has the value .true then the
>> // First parameter (string "CurrencySymbol") MUST be
>> // One-letter words, e.g. "�", and CAN NOT BE e.g. "CHF" i.e.:
>> // me.__app.SBLlocale.numlocale =@ SBLNumSettings.new("�", "'", ".",
>> true)
>>
>> is that correct?
>> Saluti
>> Giancarlo
>>
>
> Hi Giancarlo,
>
> me.__app.SBLlocale.numlocale =@ SBLNumSettings.new("�", "'", ".", true)
>
> The above line is almost correct, the true is missing the . at the
> beginning. If you use the Euro symbol by typing it, you may
> have a problem if you are saving in *.sma format. As an alternative, you
>can use "{20ac}", which is the Unicode value for the Euro
> symbol.
>
> If it crashes out and shows nothing, that is typically the result of a
> syntax error. If it GPFs, then that is something else
> entirely, though I wouldn't expect this code to do that. One thing that
> SIMPOL code can often do, is check the input for being
> within range, etc. before using it, but it can't do anything about being
> passed the wrong type, or an invalid object.
>
> Ciao, Neil

of course. . . working too many hours continuously then you make the most
stupid mistakes.
Saluti
Giancarlo

[Giancarlo Cavadini]

Neil Robinson wrote:

> On 17/10/2013 09:39, Giancarlo wrote:
>> Thanks Neil,
>> for me is Ok that the Paste and Cut are not implemented. But it is
>> important to avoid SIMPOL Personal is killed unexpectedly without ability
>> to save.

> If there is a runtime syntax error, the program crashes. There is no way to
save things at the last minute. That is why it is very
> important to do as much testing as possible. This feature slipped into the
past release but was apparently not tested.

I know, I just want to report the bug to fix it for the next release.

> There should be very few situations where you have any unsaved data in
SIMPOL Personal and it crashes.

I found a similar situation in the menu View –> Record (Ctrl+R). Please
see if you can correct it for the next release.

> Ciao, Neil

Note: I'm not angry with you if a crash happens to me while been
programming. I just want to report to fix it in the next release.
I do not know if it is right to report bugs of SIMPOL Personal in the
"Programming" Blog. Would you rather have notify you in any other way?

Cordiali saluti
Giancarlo

>> Giancarlo
>>
>> Neil Robinson wrote:
>>
>>> On 16/10/2013 04:38, Giancarlo wrote:
>>>> Yes, I'm using windows 7 32bit.
>>>> Both with nothing selected (only the record is selected without any text
>>>> in a field) that with the selection of a text in a field, if I use the
>>>> menu Edit –> Copy (or Ctrl+c) SIMPOL Personal is killed.
>>>> Giancarlo
>>>>
>>
>>> Thank you for the bug report, this problem is fixed in the next release of
>> SIMPOL Personal. However, the Paste and Cut are not yet
>>> implemented. In part, this is because to work the way the original worked,
>> records are placed on the clipboard in the format of:
>>> <field><tab><field><tab>…<field><crlf> which means that any embedded
crlfs
>> in text fields will mess it up. If you are pasting
>>> into a text document, then that doesn't probably matter, but pasting into
a
>> database will cause you to create multiple records
>>> with inappropriate content (which also happened in Superbase). We are
>> thinking about the best way to handle this (though the paste
>>> solution won't help if you are pasting into some other program, just into
>> SIMPOL Personal. Also, please note that in SIMPOL
>>> Personal there is no way to currently respect any field level constant or
>> calculation requirements, so these would not get carried
>>> out.
>>
>>> Ciao, Neil
>>
>>
>>

[Giancarlo Cavadini]

Thanks Neil,
for me is Ok that the Paste and Cut are not implemented. But it is
important to avoid SIMPOL Personal is killed unexpectedly without ability
to save.
Giancarlo

Neil Robinson wrote:

> On 16/10/2013 04:38, Giancarlo wrote:
>> Yes, I'm using windows 7 32bit.
>> Both with nothing selected (only the record is selected without any text
>> in a field) that with the selection of a text in a field, if I use the
>> menu Edit –> Copy (or Ctrl+c) SIMPOL Personal is killed.
>> Giancarlo
>>

> Thank you for the bug report, this problem is fixed in the next release of
SIMPOL Personal. However, the Paste and Cut are not yet
> implemented. In part, this is because to work the way the original worked,
records are placed on the clipboard in the format of:
> <field><tab><field><tab>…<field><crlf> which means that any embedded crlfs
in text fields will mess it up. If you are pasting
> into a text document, then that doesn't probably matter, but pasting into a
database will cause you to create multiple records
> with inappropriate content (which also happened in Superbase). We are
thinking about the best way to handle this (though the paste
> solution won't help if you are pasting into some other program, just into
SIMPOL Personal. Also, please note that in SIMPOL
> Personal there is no way to currently respect any field level constant or
calculation requirements, so these would not get carried
> out.

> Ciao, Neil

[Giancarlo Cavadini]

Yes, I'm using windows 7 32bit.
Both with nothing selected (only the record is selected without any text
in a field) that with the selection of a text in a field, if I use the
menu Edit –> Copy (or Ctrl+c) SIMPOL Personal is killed.
Giancarlo

[Giancarlo Cavadini]

Thank you,
now I'm finally able to see guisimpolserver.exe run!
Having time would be nice to be able to write a program based on
simpolserver.smp. . .

I've seen the conversion utilities that are a good thing.

For the moment I am converting from Superbase to SIMPOL, and I have to
still use database files *.SBF.
Since PPCS should be able to allow the sharing of tables *.SBF and *.SBM
at the moment I am checking if I can live together Superbase programs
(*.SBP) and SIMPOL (*.SMP) that interact both at the same time with the
two database systems.
Giancarlo

kromkowski wrote:

> On 10/07/13 3:20 AM, Giancarlo wrote:
>> Question 2:
>>>>with guisimpolserver.exe can I open and manage Superbase database (*.SBF)
>>>>file?

> No. the simpol server works with the .sbm datasources and the table(s)
> therein, not with SBFs.

> There is a utility to convert an .SBF to a Simpol database. Also
> Personal has a utility to import .csv, ascii delimited or xml into a
> simpol database.

[Giancarlo Cavadini]

Merci Ian,
maintenant je suis enfin en mesure de voir guisimpolserver.exe au travail
Giancarlo

Ian Macpherson wrote:

> Giancarlo hello Pleased to help
> This has happened to all of us
> The simpolserver dos program works when placed in the
> Utilitiessimpolserver folder but the guisimpolserver does NOT
> You have to put guisimpolserver.exe & the associated icon in the simpolbin
> folder You can leave your cfg file in the other folder but you have to
> tell it where to look
> C:SIMPOLbinguisimpolserver.exe c:simpolutilitiessimpolserverwhatever.cfg

> Neil says he is working on another utility for this that will open
> automatically etc etc but not ready yet apparently.
> Re opening the sb files I cannot help you but I can say the conversion
> utility works very well once the calcs, validations, lookups etc have been
> removed.
> Ian macpherson

[Giancarlo Cavadini]

Thanks Neil,
that's what I thought to do after seeing your tutorials and guides.
I hope I can make it.
Giancarlo

On 08/10/2013 12:36, Neil Robinson wrote:

> On 08/10/2013 10:26, Giancarlo wrote:
>> Thank you,
>> now I'm finally able to see guisimpolserver.exe run!
>> Having time would be nice to be able to write a program based on
>> simpolserver.smp. . .
>>
>> I've seen the conversion utilities that are a good thing.
>>
>> For the moment I am converting from Superbase to SIMPOL, and I have to
>> still use database files *.SBF.
>> Since PPCS should be able to allow the sharing of tables *.SBF and *.SBM
>> at the moment I am checking if I can live together Superbase programs
>> (*.SBP) and SIMPOL (*.SMP) that interact both at the same time with the
>> two database systems.

> Hi Giancarlo,

> Sorry not to get back to you sooner, we have been pretty tied up lately
trying to complete the 1.8 release. Still, I see the other
> forum members have put you right. The approach you will need is to convert
to Simpol SBM files, and in your Superbase program
> change the OPEN FILE statements to use PPCS. You can also still take
advantage of the Calc, Con, and Val formulas in your fields,
> if you have any, by using the syntax: OPEN FILE SHARE,0"UDP1:MYFILE" BLANK
USING "MYFILE.SBD". That is the fastest open command
> for Superbase when using PPCS. You cannot use th SER() command however, so
you should consider migrating to a table and a serial
> number function for retrieving one.

> Ciao, Neil

>> Giancarlo
>>
>> kromkowski wrote:
>>
>>> On 10/07/13 3:20 AM, Giancarlo wrote:
>>>> Question 2:
>>>>>> with guisimpolserver.exe can I open and manage Superbase database
(*.SBF)
>>>>>> file?
>>
>>
>>> No. the simpol server works with the .sbm datasources and the table(s)
>>> therein, not with SBFs.
>>
>>> There is a utility to convert an .SBF to a Simpol database. Also
>>> Personal has a utility to import .csv, ascii delimited or xml into a
>>> simpol database.
>>
>>
>>
>>
>>

[Giancarlo Cavadini]

> On 10/07/13 17:43:40, Giancarlo wrote:

>> Hello,
>> I'm doing my first experiments with PPCS.
>> With Superbase all OK.
>> Now I'm trying to use guisimpolserver.exe but when I start the program,
>> after setting the *.cfg as described in the readme.txt file, I get the
>> message "Unable to start the program because SMPOL32.DLL is not present"!
>> After copying SMPOL32.DLL in the startup folder of guisimpolserver.exe am
>> no longer receiving any message but apparently nothing happens (the
>> program does not start).

>> Question 1:
>> Someone can tell me how to do?

>> Question 2:
>> with guisimpolserver.exe can I open and manage Superbase database (*.SBF)
>> file?

>> Thanks in advance.
>> Giancarlo

On 10/07/13 06:14:08, Giancarlo wrote:

> I have seen the indications of Jean Vallee of 29.05.2013
> http://www.simpol.com/forum/article.php?id=942&group=simpol.programming #
> 942
> (thanks Jean).
> Following the suggestions of Jean I added, to what was found in
> utilitysimpolservr, the dll's mentioned namely smppcs32.dll, smsbme32.dll,
> smslib32.dll, wxbase28u_vc_simpol.dll, wxmsw28u_adv_vc_simpol.dll and
> wxmsw28u_core_vc_simpol.dll, but. . .
> NOTHING HAPPENS! The program guisimpolserver.exe don’t start.
> Someone can give me the correct informations?
> I use the trial version of guisimpolserver.exe (3 licenses LAN) provided
> with SIMPOL Professional. Could this be the problem? Should I buy a
> regular license for 5 users to make my tests?
> Thank you for each other relevant information.
> Giancarlo

For your information: purchased and installed SIMPOL Database Engine
5-User Licence but nothing changes.
Giancarlo

[Giancarlo Cavadini]

I have seen the indications of Jean Vallee of 29.05.2013
http://www.simpol.com/forum/article.php?id=942&group=simpol.programming #
942
(thanks Jean).
Following the suggestions of Jean I added, to what was found in
utilitysimpolservr, the dll's mentioned namely smppcs32.dll, smsbme32.dll,
smslib32.dll, wxbase28u_vc_simpol.dll, wxmsw28u_adv_vc_simpol.dll and
wxmsw28u_core_vc_simpol.dll, but. . .
NOTHING HAPPENS! The program guisimpolserver.exe don’t start.
Someone can give me the correct informations?
I use the trial version of guisimpolserver.exe (3 licenses LAN) provided
with SIMPOL Professional. Could this be the problem? Should I buy a
regular license for 5 users to make my tests?
Thank you for each other relevant information.
Giancarlo

[Author]

Posts