Forum Replies Created
- AuthorPosts
- Ian MacphersonParticipant
ROBERT No News since 2022 Did you go any further ? Best regards Ian Macpherson
Ian MacphersonParticipanthello 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 MacphersonParticipantRobert 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 MacphersonParticipantHello 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 MacphersonParticipanthello 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 regardsIan MacphersonParticipantJesus 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 MacIan MacphersonParticipantJesus 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 MacIan MacphersonParticipantPleased 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 MacphersonParticipanthello 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 macphersonIan MacphersonParticipanthello 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 MacphersonIan MacphersonParticipantGiancarlo 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.cfgNeil 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 macphersonIan MacphersonParticipantGood 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.dllNeil 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 MacphersonIan MacphersonParticipantthanks 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 MacphersonParticipantNeil 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 bestIan MacphersonParticipantYeah ! I know how you feel ! I've spent approx 6 to 8 hours a day 5 or 6
days a week since last October I don't dare calculate how many hours.
I knew there would be hurdles but didn't realise how frustrating it would
become.
I read your message about dialogs playing up …. I'm having similar
problems with my main case file form where I use listpickers to allow user
input selection from other files with ongot and onlost focus functions but
for some reason ( & Neil doesn't know either for the moment I gather)
there are 2 dialogs that refuse to either validate the user choice & go to
the next setfocus or to Cancel & quit the form & I need these badly !!
Plus a number format problem I posted today !
I programmed my app with the SB30 PPCS Server/Client about 4 years ago too
see how it worked but gave up in the end because of slow transfer rates
for 2 heavy REPORT things & I wanted to see how SIMPOL PPCS handled them
so I asked Neil for explicit information about the PPCS He has only
replied vaguely and for the moment things are still nebulous in my head.
What i need is a full Server example & Client example as was given with
SB30 !! To be truthful I am waiting for Neil to reply to you !!
I wanted to use the Demo 3 user db engine as my customer would never agree
to putting up the money until he has seen it working ( He's a lawyer so a
cautious guy … laughs !!!) but for the moment all I've had are file
single user error messages. I got the app working on another machine
linked as a Microsoft network as z: & using the sbme files rather than
PPCS but impossible to run the app on 2 machines simultaneously obviously
due to sbme being single access I found the access time a bit slow but
have not talked to Neil about it as it is outside the specifications
anyway.
Can't see how you are going to please that customer. In an email dated
april 18th Neil said with respect to the db engine < Normally people don't
need the database engine until much later in the process>> so you need to
talk to him I think !!
Regards Ian Mac - AuthorPosts