Navigation Menu

[Ian Macpherson]

hello I sent you an email yesterday introducing myself but no direct reply so posting this.
I can help you in purchasing a version of simpol … just need to know a bit more about who you are etc
Je vous ai envoyé un courriel hier but pas de réponse. Je peux vous aider pour acheter une version de simpol mais seulement besoin de vous connaitre un peu ian.mac*******@**ox.fr

[Ian Macpherson]

ROBERT No News since 2022 Did you go any further ? Best regards Ian Macpherson

[Ian Macpherson]

hello I am sorry to say that you will not get a reply from Superbase NG as the team has more or less disintegrated. My name is ian Macpherson Simpol and superbase user for many years. i use Windows only but I know other people who use the linux version. If you give me your email address I can perhaps contact someone and ask him to contact you. There is a free version on the web site which you can download. sorry for not replying earlier …. i look only from time to time. regards

[Ian Macpherson]

Robert Hi I haven’t been on the forum for a while Just saw your message If you would like to tell me a bit more about what you want to do by email you can ian.mac*******@**ox.fr i am afraid you will not get a reply from superbase directly as there are some problems i am an original superbase 95 user who went to Simpol so i can answer your questions

[Ian Macpherson]

Hello Tiag For me a 5 user LAN licence allows you to share the files on your main computer and then access them through a network link ( NETBIOS if I remember correctly from the old Superbase days ) …I moved from Superbase to Simpol in 2013 so I have forgotten most of it. From memory you have to install the RunTime system on your main computer and also on the network machines … set up your NETBIOS links and the network machines will access the files on the main machine. If I remember correctly you can install forms on the network machines but the program code comes from the main machine. So you should have a RunTime CD or floppy and a RunTime licence. Hope this helps. If you want to communicate directly you can email me on macpher*******@**ox.fr I am English but I live in France.

[Ian Macpherson]

hello Did you eventually manage to find how to do the border with OLE ? Did you have a look at the ole example that was included with the install package ? It says in the Superbase documentation that if you record a Excel macro for what you want to do Superbase is capable of understanding it IF a couple of things are modfied or Added. If you get this message and want further information you can contact me directly at macpher*******@**ox.fr
For info Nikolaus who replied to you is the new Superbase NG project manager but he does not know the old Superbase I think. Best regards

[Ian Macpherson]

Jesus Hi Ian Macpherson in Paris I lost your email address through a Windows Live mail hangup Could you please send it back to me macpher*******@**ox.fr
We ( JD Kromkowski, Jean Vallee, Kurt Hansen + others are trying to establish exactly how many of us there are out there using Superbase NG / Simpol plus the old Superbase
if you know of any others ???
PS Did David King send you the old Superbase code I sent him for emails ??? If not I can send it directly but DK did say to me that it didn’t work in all cases. I also have code for sending an email with Simpol if you are interested. Best regards Ian Mac

[Ian Macpherson]

Jesus Hi Ian Macpherson in Paris I lost your email address through a Windows Live mail hangup Could you please send it back to me macpher*******@**ox.fr
We ( JD Kromkowski, Jean Vallee, Kurt Hansen + others are trying to establish exactly how many of us there are out there using Superbase NG / Simpol plus the old Superbase
if you know of any others ???
PS Did David King send you the old Superbase code I sent him for emails ??? If not I can send it directly but DK did say to me that it didn’t work in all cases. I also have code for sending an email with Simpol if you are interested. Best regards Ian Mac

[Ian Macpherson]

Pleased to be able to help You’ll find the same thing with qr.setnulliszero() used to display 0.00 if a fiend has a .null value cheers

[Ian Macpherson]

hello My name is ian Macpherson i live in France
regarding your comment about the setwhereclause() error … Mr Robinson knows about it …. you can just ignore the error messages …. your app will compile no problem. I have the same thing happening but it doesn’t stop my quickreports from working.
i do not use graphic report at all …. i wrote all my invoicing code because graphic report had some bugs when I wanted to use it. all i can suggest is looking at Mr Robinson’s code in the simpol business demo … the function is called sb_invoice() i think & look at his invoice.sxr in Personal. For info Mr Robinson has had some health problems & is not replying to requess as far as i can gather.
best regards Ian macpherson

[Ian Macpherson]

hello I would suggest you send an email to the Superbase guru in England ne**@**mpol.com
For info my machine was a Win 7 32 bit which I recently converted to Windows 10 Superbase runs perfectly so I reckon the problem might be elsewhere
Neil Robinson should be able to help you but in my opinion you should try to consider converting your application to Simpol. It takes time I agree but is very worth while in the long run Best regards Ian Macpherson

[Ian Macpherson]

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

[Ian Macpherson]

Good morning I was going to send you an email to say thanks for the
code you posted for the month & quarter dialog. Very pro !!!
The problem with guisimpolserver is that it is in an .exe form & therefore
not in the right place. I spoke to Neil about this 2/3 months ago & he
said he was going to fix it in the next release but we spoke again few
days ago & he said he was working on it. I think he wants to change to
smp format as with simpolserver.
He did say however that he was adding more specific & complete
instructions on setting up the server with guisimpolserver.
I just transferred guisimpolserver.exe and bzip2.dll into the bin & did a
cmd on it with c:simpolutilitiessimpolserversample_gui.cfg as the
extension
Got me a "Can't load image from file simpolserver.png file does not
exist" message BUT the program came up & it works.
PS Re the sample.cfg file in the simpolserver folder there is a typing
error
port1=4000
txfactor1=0
port2=4001
txfactor=6 should be txfactor2
tcpport=4002
logfilename=samplelog.txt
bz2libdll=x:simpolprojectsppsrguisimpolserverbinbzip2.dll

Neil explained to me that you only need the 4001 port if you are doing LAN
and WAN otherwise you can take it out. However if you do need it the
txfactor after port2=4001 should read txfactor2
You'll also have to modify the destination code for the bz2libdll= to just
bzip2.dll as it is in the same folder.
For the moment i'm using the simpolserver.smp & waiting for news from Neil.
However the gui version does a lot more & is certainly more pro Windows. I
tried doing a database backup once I'd created the c:usersetc etc etc
folder It executed something but there was nothing in the folder so need
more info on this.
Hope this helps & once again thanks for the code Ian Macpherson

[Ian Macpherson]

thanks to Mr Kromkowski for his interest.
Actually the code is completely yours as done in your payroll app and by
RunTime I mean effectively the stand alone version with the program
looader.
Actually I made a mistake on my machine the second datepicker crashes be
it in the runtime stand alone OR the IDE & it does it at the end of the
ChgDate function after me.form.setcontainer(.nul) & the last line
setcontainer(dlg)
I finally ended up using Jean Vallées way of doing it with a dialog form
using 2 datepickers calling 2 functions rather than putting the two
datepickers one after the other and it works fine
Though why the first one would work & not the second time around is beyond
me
Thank you for the getdate() hint Will have a look tomorrow
All the best to all on the forum
Ian Macpherson
PS It took me 8 months but I think the transfer to SIMPOL is done & hope
to install end July Champagne !!! ( with thanks to Neil for his
patience & help)

[Ian Macpherson]

Neil discovered this pm that Personal was using the French number format
So the option button was programmed to give Value if selected of 19.60
(decimal) & that was what showed up in the form designer but it was
actually using 19,60 (comma) so it gave 1960 instead of 19.60
He edited the form in the bloc note & the problem has disppeared.
So this only concerns anybody in a country where Microsoft use 123 456
789,00 ( comma) as the number format
All the best

[Author]

Posts