Skip to content

Ian Macpherson

Forum Replies Created

Viewing 15 posts - 1 through 15 (of 18 total)
  • Author
    Posts
  • in reply to: SuperBase95 #9280
    Ian Macpherson
    Participant

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

    in reply to: Superbase NG under Linux? #4948
    Ian Macpherson
    Participant

    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

    in reply to: SuperBase95 #4767
    Ian Macpherson
    Participant

    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

    in reply to: 5-User LAN Licence #3680
    Ian Macpherson
    Participant

    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.

    in reply to: Superbase OLE to Excel #3645
    Ian Macpherson
    Participant

    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

    in reply to: Graphic Report in landscape #3569
    Ian Macpherson
    Participant

    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

    in reply to: Graphic Report in landscape #3568
    Ian Macpherson
    Participant

    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

    in reply to: Graphic Report in landscape #3559
    Ian Macpherson
    Participant

    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

    in reply to: Graphic Report in landscape #3555
    Ian Macpherson
    Participant

    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

    in reply to: Superbase: Floating-point math error #3362
    Ian Macpherson
    Participant

    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

    in reply to: PPCS using guisimpolserver.exe #1602
    Ian Macpherson
    Participant

    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

    in reply to: GUISIMPOLSERVER #2286
    Ian Macpherson
    Participant

    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

    in reply to: datepicker & RunTIme #2268
    Ian Macpherson
    Participant

    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)

    in reply to: dataform1 option button value bug #1393
    Ian Macpherson
    Participant

    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

    in reply to: setting up ppcs server #2254
    Ian Macpherson
    Participant

    Yeah ! 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

Viewing 15 posts - 1 through 15 (of 18 total)