ProFox

profox@leafe.com

2704 discussions

Got A Strange One For You To Consider (AppendXLSX.prg)
by Paul H. Tarver 17 Apr '18

17 Apr '18

I have been using AppendXLSX.prg written by Craig Boyd for many years with great success. Until now. Last week, I was training a client on some software I wrote for them which had been extensively tested (I thought!) but when I tried to import an Excel file (which I HAD tested at least a hundred times on this project in development mode), it failed and I got an error about a missing ')'. Nothing I tried in front of the client would work and so I asked them to use CSV files in the interim until I could get the problem figured out. After extensive review today, I narrowed the problem down to this line in Craig's code: INSERT INTO (m.tvWorkarea) (&lcFieldList) SELECT &lcNvlFieldList FROM (m.lcSQLAlias) WHERE &tcTableForExpr I tested the problem in development mode and after I compiled to an .EXE about 50 times, I think. Every time, it would work perfectly in development mode and fail in executable mode. I added lots of messagebox items to see the values of the compiled code and eventually I changed the line above into a TEXT..ENDTEXT command so I could put the fully expanded command into a variable and save the string to a file to do in-depth comparisons between development and compiled. But, even after changing from the macro expansion to using delimited merge elements, it would still work in development mode and fail in executable. When I began reviewing the expanded commands after the STRTOFILE command was put in place, I realized the client had a field header in their spreadsheet which started with a number: '3RDPARTYSICKPAY'. Prior to the INSERT INTO SELECT command mentioned above, Craig issues the following command to retrieve the columns of data from the Excel worksheet: m.lnResult = SQLEXEC(m.lnSQL,[SELECT ] + m.tcExcelFieldList + [ FROM "] + m.tcSheet + [" Where ] + m.tcExcelWhereExpr, m.lcSQLAlias) The weird part is when this command is issued from within the development environment, the command automatically changes the field name '3RDPARTYSICKPAY' to '_RDPARTYSICKPAY' whereas this substitution DOES NOT occur when the command is issued from a compiled EXE and the column name remains '3RDPARTYSICKPAY' which then causes a failure in the INSERT INTO SELECT command that occurs after the remote table has been created. I tried just renaming the field name prior to the INSERT INTO command, but this creates a field not found error. I tried ALTER TABLE after the cursor is returned from the SQLEXEC command to rename the column earlier in the procedure, but the command failed first because the initial cursor is a remote table and second because if I try to make the cursor a readwrite cursor it fails again because I have field names larger than 10 characters. My client's files are created with automated processes and reflect the fieldnames within their software datastore. I do not have access to change these variable names nor do I want to do. However, I need some suggestions for potential workarounds short of having the client manually rename the column each time they create the file. Ideally, I'd like to come up with a solution that would be applicable in all cases for all clients but that may be too much to hope for. Sorry this is so long, but I wanted to include all I learned today about this problem. Any thoughts? Paul

1 0

Modulo 97 of a very large number
by Dave Crozier 17 Apr '18

17 Apr '18

Sending this message on behalf of Paul Newton who has asked me to relay it to the group as he is having problems sending emails to Profox. He asks the following: Hi all I need to calculate N % 97 aka Mod(N,97) for very large numbers containing 28 digits. Obviously VFP can't handle numbers that large but maybe somebody can suggest some kind of piece-wise method that would enable me to calculate what I need? Is there a library out there for VFP which would facilitate arbitrary-precision arithmetic? Many thanks Paul Newton Thanks in advance Dave Paul Dave Crozier Software Development Manager Flexipol Packaging Ltd. --------------------------------------------------------------- This communication and the information it contains is intended for the person or organisation to whom it is addressed. Its contents are confidential and may be protected in law. If you have received this e-mail in error you must not copy, distribute or take any action in reliance on it. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email. Flexipol Packaging Ltd. has taken every reasonable precaution to minimise the risk of virus transmission through email and therefore any files sent via e-mail will have been checked for known viruses. However, you are advised to run your own virus check before opening any attachments received as Flexipol Packaging Ltd will not in any event accept any liability whatsoever once an e-mail and/or any attachment is received. It is the responsibility of the recipient to ensure that they have adequate virus protection. Flexipol Packaging Ltd. Unit 14 Bentwood Road Carrs Industrial Estate Haslingden Rossendale Lancashire BB4 5HH Tel:01706-222792 Fax: 01706-224683 www.Flexipol.co.uk --------------------------------------------------------------- Terms & Conditions: Notwithstanding delivery and the passing of risk in the goods, the property in the goods shall not pass to the buyer until the seller Flexipol Packaging Ltd. ("The Company") has received in cash or cleared funds payment in full of the price of the goods and all other goods agreed to be sold by the seller to the buyer for which payment is then due. Until such time as the property in the goods passes to the buyer, the buyer shall hold the goods as the seller's fiduciary agent and bailee and keep the goods separate from those of the buyer and third parties and properly stored protected and insured and identified as the seller's property but shall be entitled to resell or use the goods in the ordinary course of its business. Until such time as the property in the goods passes to the buyer the seller shall be entitled at any time

6 8

Got A Strange One For You To Consider (AppendXLSX.prg)
by Paul H. Tarver 16 Apr '18

16 Apr '18

1 0

FoxyPreviewer Issue
by Paul H. Tarver 14 Apr '18

14 Apr '18

I've been using FoxyPreviewer v299z30 for quite a while and I've never had any problem with it. However, this week I was alerted by a new client it was taking about 4 minutes to create a 3 or 4 page report. I had them delete the FoxUser files to see if there was a problem there (there wasn't) and ultimately, I had them rename the .app file to see how it worked without FoxyPreviewer and report generation was much faster. My questions are: 1) Is there a later version that I can download somewhere? 2) Has anyone else run into the slow performance issue because I can't replicate it on my system. PS: I tried downloading the Codeplex archive, but didn't get too far with it because I couldn't tell what version of FoxyPreviewer was included. Thanks! Paul --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

2 2

Re: Appending from a Cursor
by Gene Wirchenko 12 Apr '18

12 Apr '18

At 06:21 2018-04-12, Alan Bourke <alanpbourke(a)fastmail.fm> wrote: >On Thu, 12 Apr 2018, at 1:31 PM, Jean MAURICE wrote: > > Hi Gene, > > > > 'append from' appends data from a file on the disk and a cursor > is not a file ! > >A cursor may or may not have a disk presence depending on various factors. > >But SQL is a a better way to do it. > >insert into mytable (f1, f2, f3) select (f1, f2, f3) from mycursor That was the way I ended up doing it. Sincerely, Gene Wirchenko

1 0

RE: Appending from a Cursor
by Gene Wirchenko 12 Apr '18

12 Apr '18

At 11:10 2018-04-11, "John Weller" <john(a)johnweller.co.uk> wrote: >You could try > >APPEND FROM DBF(alimport) [whack object="hand" target="forehead"] I have used it in the past, just not very often. When I checked my code, I searched for "append from (" instead of just "append from". Sometimes, 90% of the battle is knowing what to look for. I ended up using <vfp> insert into (this.thiscode+"_cwkt") select * from (alimport) </vfp> I am puzzled why (alimport) works for the SQL but not the append from, but whatever. [snip] Sincerely, Gene Wirchenko

7 8

Appending from a Cursor
by Gene Wirchenko 12 Apr '18

12 Apr '18

Hello: I have some code where I am importing transactions. I have a cursor for these transactions where I validate them. After doing this, I want to add them to the transaction table. I select the transaction alias and then do append from (alimport) alimport is an alias variable. It works for creating the cursor: SQLSEL * from cwkt; where .f.; into cursor (alimport) readwrite nofilter It works to select the cursor: select (alimport) So why does the append not work? I get error 1 with the text "File 'c:\cbs2dev\cutlblas_import.dbf' does not exist." I figured out how to do this using SQL, but I would still like to know why the append does not work. Sincerely, Gene Wirchenko

6 5

RE: NF525 POS laws (France)
by Paul Hill 11 Apr '18

11 Apr '18

>Posted: 2017-06-22 04:44:44 > >Hi All, > >Has anyone implemented the French NF525 point of sale (anti-tax fraud) >laws that are mandatory from January 2018? > >I've been trying to read the specification but it's missing important >info in places. Just got home from Paris. After lots of development, much confusion, incorrect documentation and repeated delays I finally have confirmation of certification. The only thing I am thankful of is that I managed to avoid the French railway strikes. It's gonna be hell to sync my offline changes back to source control! -- Paul

1 0

[NF] No passwords in web logins?
by Stephen Russell 11 Apr '18

11 Apr '18

The FIDO Alliance <https://www.engadget.com/2014/12/09/fido-alliance-publishes-specs/> and W3C have launched <https://www.w3.org/TR/2018/CR-webauthn-20180320/> a Web Authentication standard that makes it easier to offer truly unique encryption credentials for each site. https://www.engadget.com/2018/04/10/fido-w3c-web-authentication/ -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

2 1

.tmp Is Read-Only
by Paul H. Tarver 09 Apr '18

09 Apr '18

I think this is a two part question for VFP9: 1) Has anyone had any experience with getting a program error at runtime like this: File c:\users\paul\appdata\local\temp\xxxxxxxxxxxxxxx.tmp is read-only? I do not get a similar error when running in development mode and I have explicitly set SORTWORK, PROGWORK, EDITWORK and TMPFILES in the CONFIG.FPW file. 2) Why does VFP continue to create cursor temp files in the aforementioned path at all when I've manual set the path for temporary files in the CONFIG.FPW file? I'm sure it is something I'm doing wrong, so feel free to provide constructive OR destructive criticism. J Thanks! Paul --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

6 13

Jump to page:

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox