Alpha Software Mobile Development Tools:   Alpha Anywhere    |   Alpha TransForm subscribe to our YouTube Channel  Follow Us on LinkedIn  Follow Us on Twitter  Follow Us on Facebook

Announcement

Collapse

The Alpha Software Forum Participation Guidelines

The Alpha Software Forum is a free forum created for Alpha Software Developer Community to ask for help, exchange ideas, and share solutions. Alpha Software strives to create an environment where all members of the community can feel safe to participate. In order to ensure the Alpha Software Forum is a place where all feel welcome, forum participants are expected to behave as follows:
  • Be professional in your conduct
  • Be kind to others
  • Be constructive when giving feedback
  • Be open to new ideas and suggestions
  • Stay on topic


Be sure all comments and threads you post are respectful. Posts that contain any of the following content will be considered a violation of your agreement as a member of the Alpha Software Forum Community and will be moderated:
  • Spam.
  • Vulgar language.
  • Quotes from private conversations without permission, including pricing and other sales related discussions.
  • Personal attacks, insults, or subtle put-downs.
  • Harassment, bullying, threatening, mocking, shaming, or deriding anyone.
  • Sexist, racist, homophobic, transphobic, ableist, or otherwise discriminatory jokes and language.
  • Sexually explicit or violent material, links, or language.
  • Pirated, hacked, or copyright-infringing material.
  • Encouraging of others to engage in the above behaviors.


If a thread or post is found to contain any of the content outlined above, a moderator may choose to take one of the following actions:
  • Remove the Post or Thread - the content is removed from the forum.
  • Place the User in Moderation - all posts and new threads must be approved by a moderator before they are posted.
  • Temporarily Ban the User - user is banned from forum for a period of time.
  • Permanently Ban the User - user is permanently banned from the forum.


Moderators may also rename posts and threads if they are too generic or do not property reflect the content.

Moderators may move threads if they have been posted in the incorrect forum.

Threads/Posts questioning specific moderator decisions or actions (such as "why was a user banned?") are not allowed and will be removed.

The owners of Alpha Software Corporation (Forum Owner) reserve the right to remove, edit, move, or close any thread for any reason; or ban any forum member without notice, reason, or explanation.

Community members are encouraged to click the "Report Post" icon in the lower left of a given post if they feel the post is in violation of the rules. This will alert the Moderators to take a look.

Alpha Software Corporation may amend the guidelines from time to time and may also vary the procedures it sets out where appropriate in a particular case. Your agreement to comply with the guidelines will be deemed agreement to any changes to it.



Bonus TIPS for Successful Posting

Try a Search First
It is highly recommended that a Search be done on your topic before posting, as many questions have been answered in prior posts. As with any search engine, the shorter the search term, the more "hits" will be returned, but the more specific the search term is, the greater the relevance of those "hits". Searching for "table" might well return every message on the board while "tablesum" would greatly restrict the number of messages returned.

When you do post
First, make sure you are posting your question in the correct forum. For example, if you post an issue regarding Desktop applications on the Mobile & Browser Applications board , not only will your question not be seen by the appropriate audience, it may also be removed or relocated.

The more detail you provide about your problem or question, the more likely someone is to understand your request and be able to help. A sample database with a minimum of records (and its support files, zipped together) will make it much easier to diagnose issues with your application. Screen shots of error messages are especially helpful.

When explaining how to reproduce your problem, please be as detailed as possible. Describe every step, click-by-click and keypress-by-keypress. Otherwise when others try to duplicate your problem, they may do something slightly different and end up with different results.

A note about attachments
You may only attach one file to each message. Attachment file size is limited to 2MB. If you need to include several files, you may do so by zipping them into a single archive.

If you forgot to attach your files to your post, please do NOT create a new thread. Instead, reply to your original message and attach the file there.

When attaching screen shots, it is best to attach an image file (.BMP, .JPG, .GIF, .PNG, etc.) or a zip file of several images, as opposed to a Word document containing the screen shots. Because Word documents are prone to viruses, many message board users will not open your Word file, therefore limiting their ability to help you.

Similarly, if you are uploading a zipped archive, you should simply create a .ZIP file and not a self-extracting .EXE as many users will not run your EXE file.
See more
See less

A5 V11 compatability with Windows 10

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    A5 V11 compatability with Windows 10

    My previous post was because I was having problems adding a bcc to sendmail. That is now solved thank you. Now I am trying to put A5V11 on a windows 10 machine and whilst most other tables work properly, this sendmail code in the acounts table doesn't. The error message says 'File not found: 'C:\Program Files (x86)\A5V11\Laprima\Accounts June\Acct 001.pdf''
    The code works on an XP machine, and on the W10 machine, the directory Accounts June is made but there is no Acct 001.pdf or anything else in it, so it looks to me as if the report is not being saved. Any help would as always be appreciated.

    Here is the code;
    'Date Created: 19-Oct-2013 03:07:47 PM
    'Last Updated: 05-Jun-2016 07:32:53 PM
    'Created By : usuario
    'Updated By : Laura Johnson
    parentform.commit()
    tbl = table.current()
    tbl.fetch_first()
    'debug(1)
    while .not. tbl.fetch_eof()
    query.filter = "cuscode = "+quote(alltrim(tbl.cuscode))
    query.order = ""
    to_param = Lookup("Customers2","cuscode = "+quote(alltrim(tbl.cuscode)),"alltrim(email)")
    if alltrim(to_param) > "" 'only execute this section if an email address is found
    subject_param = "Monthly account from Laprima S.L."
    message_param = "Your attached account covers the month of "+cmonth(date())+"."
    'attachments_param = ""
    'cc_param = a5_eval_expression("",local_variables())
    bcc_param = a5_eval_expression("[email protected]",local_variables())
    if filefind.get(a5.Get_Path()+chr(92)+"Accounts "+cmonth(date()),FILE_FIND_DIRECTORY,"PN") = ""
    dir_create(a5.Get_Path()+chr(92)+"Accounts "+cmonth(date()))
    end if
    :report.SaveAs("AccMonthly","PDF",query.filter,query.order,a5.get_path()+chr(92)+"Accounts "+cmonth(date())+chr(92)+"Acct "+alltrim(tbl.cuscode)+".pdf")
    sleep(4)
    email_send(to_param,subject_param,message_param,a5.get_path()+chr(92)+"Accounts "+cmonth(date())+chr(92)+"Acct "+alltrim(tbl.cuscode)+".pdf","",bcc_param)
    sleep(4)
    end if 'end of section to create and send email if address found
    tbl.fetch_next()
    end while
    fil.flush()
    fil.close()

    #2
    Re: A5 V11 compatability with Windows 10

    Windows versions after XP don't like programs saving data in the C:\Program Files folder for antivirus and antimalaware purposes. Many have recommended installing Alpha outside of C:\Program Files and putting the database in yet another directory.
    There can be only one.

    Comment


      #3
      Re: A5 V11 compatability with Windows 10

      Thank you again, Stan. I've moved the folders as you suggest to no avail. I've also tried a new download of A5V11 but I can't find anything except a patch on the A5 site. I tried that and another one from another site, both asked for dll's but didn't work even when I found and installed them. I'll keep trying thanks.

      Comment


        #4
        Re: A5 V11 compatability with Windows 10

        From another thread, courtesy of Steve Wood.

        You can still get to Alpha's "Store" and login to get your order and download. This is a priceless link not found anywhere else: https://www.alphasoftware.com/shop/Login.asp
        There can be only one.

        Comment


          #5
          Re: A5 V11 compatability with Windows 10

          Thanks Stan, I'm working on it, getting a system error on the a5 login page at the moment ! Just my luck.

          Comment


            #6
            Re: A5 V11 compatability with Windows 10

            Try the old Compatibility test, then run as Admin.
            Win 10 is a piggy sometimes.
            But then so was Win7
            See our Hybrid Option here;
            https://hybridapps.example-software.com/


            Apologies to anyone I haven't managed to upset yet.
            You are held in a queue and I will get to you soon.

            Comment


              #7
              Re: A5 V11 compatability with Windows 10

              O.k., I couldn't login to the link, I consistently got a system error. If I put in a rogue username and password I get a username doesn't exist so the system obviously recognizes my details. Then I remembered that I had saved a copy of the original a5v11 on dropbox. So I've downloaded that, installed it and after the prompt, updated it to the latest version. Following Stan's advice I've installed in to C:\ drive, not program files.
              Everything works fine, except the good old send_email part. The script is creating the directory (see first post) but not saving the report in it as the following;

              :report.SaveAs("AccMonthly","PDF",query.filter,query.order,a5.get_path()+chr(92)+"Accounts "+cmonth(date())+chr(92)+"Acct "+alltrim(tbl.cuscode)+".pdf")

              So the error message is that it can't find the pdf in the directory that it has created. Any suggestions would be appreciated big time.
              In the meantime I've rolled back a recently updated computer back to Windows 7 and it works properly so this is obviously a windows 10 issue. I know that v11 doesn't support W10 but I don't want to use Alpha Anywhere and I feel that this is a do-able issue.

              Comment


                #8
                Re: A5 V11 compatability with Windows 10

                So did you do a compatability check forV11in Win10?
                Then did you run as admin?
                V11 works on Win10
                See our Hybrid Option here;
                https://hybridapps.example-software.com/


                Apologies to anyone I haven't managed to upset yet.
                You are held in a queue and I will get to you soon.

                Comment


                  #9
                  Re: A5 V11 compatability with Windows 10

                  No luck yet, I've tried W7, 8, Vista and XP sp2. Everything about the application works, except this send-mail. I've changed permissions to allow full control to anyone and run as administrator. Every time I get;
                  File not found: 'C:\A5V11\Laprima\Accounts June\Acct 001.pdf'

                  Comment


                    #10
                    Re: A5 V11 compatability with Windows 10

                    I don't know if this might help, but I've just placed a random pdf in the Accounts June folder and renamed it to Acct 001.pdf and run the email send script. It still returns the same error.

                    Comment


                      #11
                      Re: A5 V11 compatability with Windows 10

                      May I suggest removing the spaces? May not help, but then??
                      If you have tried this on win, xp/7/10 and it worked on none of them. Then there is something else wrong.
                      Dave Mason
                      [email protected]
                      Skype is dave.mason46

                      Comment


                        #12
                        Re: A5 V11 compatability with Windows 10

                        Thanks Dave, I have tried removing spaces before the file names to no avail but I'll look at it again tomorrow. I would agree with your suggestion that something else must be wrong, but the self same code works on an actual XP machine and on an actual W7 machine ! I just tried it again beause I was doubting myself!

                        Comment


                          #13
                          Re: A5 V11 compatability with Windows 10

                          Try this.

                          Right click on the Windows startbar icon and select "command prompt (admin)"

                          In the command prompt window enter
                          Code:
                          cacls.exe "path where file is being saved" /e /t /c /g Users:f
                          In your case if you moved everything to just C:\ it would be:
                          Code:
                          cacls.exe "C:\Laprima" /e /t /c /g Users:f
                          This will remove any permission restriction Win 10 may be enforcing on that path.

                          Comment


                            #14
                            Re: A5 V11 compatability with Windows 10

                            Hello Folks,
                            I placed the Laprima folder in C:\a5v11 so I used cacls.exe "C:\a5v11\Laprima" /e /t /c /g Users:f and I saw it work through all the files in the folder but still no luck This must be a compatability issue though if the same code works and has worked in xp and w7. Thank you for trying though.

                            Comment


                              #15
                              Re: A5 V11 compatability with Windows 10

                              I also tried taking out the spaces and placing a pdf in the accounts June folder (which the code DOES create) acct001.pdf

                              Comment

                              Working...
                              X