ProFox April 2018

profox@leafe.com

36 participants
51 discussions

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

Re: Comparing Table Structures
by Gene Wirchenko 07 Apr '18

07 Apr '18

At 15:32 2018-04-06, Frank Cazabon <frank.cazabon(a)gmail.com> wrote: >Would afields() do what you want? Yes. Someone else on Foxite just suggested it, too. I missed that afields() returns an array, and having a near-solution with arrays, I blindsided myself. Thank you. [snip] Sincerely, Gene Wirchenko

3 2

Comparing Table Structures
by Gene Wirchenko 07 Apr '18

07 Apr '18

Hello: I wish to compare two tables' structures. I have a transaction table, and I wish to check that an import table matches up well enough. Well enough? All columns in the transaction table must be in the import table and of the same type and size. If there are additional column in the import table or if the columns are in a different order, it does not matter. It would be nice to able to copy each structure into an array and then compare them using scan(). Instead, I think that I have to copy structured extended to a temporary table -- I would prefer a cursor -- and then copy from that to an array for each of the two tables and only then compare. That seems rather Rube-Goldbergian. I could be missing something. I hope I am. What is a good way of doing this? Sincerely, Gene Wirchenko

3 2

Re: Numeric(x,0) vs Integer field type in VFP tables
by Gene Wirchenko 06 Apr '18

06 Apr '18

At 14:14 2018-04-05, mbsoftwaresolutions(a)mbsoftwaresolutions.com wrote: >On 2018-04-05 13:19, Gene Wirchenko wrote: >>At 12:43 2018-04-04, mbsoftwaresolutions(a)mbsoftwaresolutions.com wrote: >>>VFP9 >>>I don't see why folks would use Numeric(X,0) where X > 4 instead >>>of an Integer field. Can you tell me why? I'm guessing it's >>>leftover legacy design? >> There are a couple that I can think of: >> 1) Often, the numbers that I am dealing with are defined by number >>of digits. For example, my app has work order numbers of up to >>999999. "N(6)" covers that nicely and even documents it. >> 2) The column width in a browse for a column defined as N(?) will be >>just right (assuming the caption is not too wide). If I declare the >>column as integer, it will be wider than necesssary. >Interesting...thanks, Gene! You are welcome. 3) Some other software might be expecting only values of the particular size and if you do not make sure that the values are that way, interesting things might happen. For example, N(4) is just right for four-digit numbers and that other program might be defined that way. If your declaration is 16-bit int ... <I am sure you have a good imagination>. COBOL has numbers declared by number of digits as does PL/I. There may be other languages. Sincerely, Gene Wirchenko

2 1

Re: Numeric(x,0) vs Integer field type in VFP tables
by Gene Wirchenko 05 Apr '18

05 Apr '18

At 12:43 2018-04-04, mbsoftwaresolutions(a)mbsoftwaresolutions.com wrote: >VFP9 > >I don't see why folks would use Numeric(X,0) where X > 4 instead of >an Integer field. Can you tell me why? I'm guessing it's leftover >legacy design? There are a couple that I can think of: 1) Often, the numbers that I am dealing with are defined by number of digits. For example, my app has work order numbers of up to 999999. "N(6)" covers that nicely and even documents it. 2) The column width in a browse for a column defined as N(?) will be just right (assuming the caption is not too wide). If I declare the column as integer, it will be wider than necesssary. Sincerely, Gene Wirchenko

2 1

[NF] M$ teaches about AI (free)
by Stephen Russell 05 Apr '18

05 Apr '18

Have not looked into this much have other irons in the fire right now. https://techcrunch.com/2018/04/02/microsoft-launches-entry-level-software-d… Saw a lecture on AI in an end user pharmacy app last night. -- 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 ---

4 3

Numeric(x,0) vs Integer field type in VFP tables
by mbsoftwaresolutions＠mbsoftwaresolutions.com 05 Apr '18

05 Apr '18

VFP9 I don't see why folks would use Numeric(X,0) where X > 4 instead of an Integer field. Can you tell me why? I'm guessing it's leftover legacy design? tia, --Mike

3 5

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox April 2018