Re: Another refactoring question regarding unused columns in a DBF table

2019-10-02 Thread John R. Sowden
I would very carefully document any changes, and the structure of any deleted fields, document the indices prior to deleting the fields; all so you can accurately recreate the database without the changes.  I would run the apps and (assuming  no source) add the fields and indices as it crashes

Re: [NF] What do you use to manage your clients & notes/work for each?

2017-07-11 Thread John R. Sowden
Kevin- Are you a small business person who does a little programming, or a software developer? I ask because I started with dBASE II and found it a 'business person's language', but there doesn't seem to be one for Linux unless you subscribe to some proprietary system. If you are the former

Re: WOULD LOVE TO BUY VFP 9 +SP2 .

2017-02-10 Thread John R. Sowden
It looks a little flakey. You get a usb stick with the iso and 3-4 other files. A "genuine" product key code is included (whose :) ? ). doesn't sound very 'microsoft'. It was also on sale in England's ebay. I'll report back when I get it AND register it. Never was able to get 5.0 to

Re: [NF] Arago

2016-12-19 Thread John R. Sowden
These were the fun days. New software coming on the market all the time. The annual West Coast Computer Faire was where 'it was' in the SF Bay Area. This is where I bought my copy of dBASE II for CP/M from George Tate of Ashton-Tate while he was manning a dealer's booth! Word Tech, from

Do you rebuild your indexes every night or do you leave them alone.

2016-11-09 Thread John R. Sowden
FPD v2.6: Our computers are typically up 24 hours, they are programmed to send to my office any error reports, which I see first thing in the morning; and every 10 uses of a program that uses a particular database, a reindexing routing is run at execution. John On 11/09/2016 09:51 AM,

Re: Friday Poll (while dl'ing MS Flash Patch)

2016-10-28 Thread John R. Sowden
On 10/28/2016 06:00 AM, Ted Roche wrote: So, where's your data stored today? X_ DBFs __ MS SQL Server __ Azure __ Postgres __ My/MariaDB __ Oracle __ Excel __ Other (please specify) (P.S. Microsoft released an out-of-band (i.e., emergency) patch for Adobe Flash. You likely want to

Re: hash code for foxpro/dos

2016-08-16 Thread John R. Sowden
that's "now playing with" John On 08/16/2016 09:08 AM, John R. Sowden wrote: Thanks. I read the pdf only to find that he referenced a hash method that I am using (salted 2007 without going farther on an open forum). Unfortunately, the .fll file is compiled and I cannot see the so

Re: hash code for foxpro/dos

2016-08-16 Thread John R. Sowden
://www.sweetpotatosoftware.com/spsblog/2005/09/01/VisualFoxProEncryptAndDecryptFiles.aspx On Mon, Aug 15, 2016 at 2:20 PM, John R. Sowden <jsow...@americansentry.net> wrote: I am currently using some code that I acquired years ago to hash (1 way encrypt) passwords. Now I am wondering if it is suff

Re: hash code for foxpro/dos

2016-08-16 Thread John R. Sowden
I use this function to determine who accessed any database program (and therefore its dbfs) , and sets the authority level so only I can see the good stuff :) and it also decrypts the necessary dbf files with an external encryption program using aes256. John On 08/15/2016 11:30 AM, Alan

hash code for foxpro/dos

2016-08-15 Thread John R. Sowden
I am currently using some code that I acquired years ago to hash (1 way encrypt) passwords. Now I am wondering if it is sufficient for the use. Is there either a foxpro (.prg) source that I can incorporate into my log on program or binary that I can load into memory? This is for my alarm

Re: [NF] Password instructions from my local credit union

2016-06-28 Thread John R. Sowden
You exposed my knee jerk response to the issue. actually we do that. I started doing that in the '90s (in Foxpro/DOS) when I found that is what linux does! On 06/28/2016 09:44 AM, Paul Hill wrote: On 28 June 2016 at 17:26, John R. Sowden <jsow...@americansentry.net> wrote: Th

Re: [NF] Password instructions from my local credit union

2016-06-28 Thread John R. Sowden
They may be using a fixed length field limited to 10 characters. Of course if you entered > 10 they would give you an error instead of truncating the added characters. Then they would test to make sure the count is > 5 for added security. John On 06/28/2016 09:13 AM, Alan Bourke wrote:

Re: [NF] Which Programming Language Should I Learn?

2016-06-17 Thread John R. Sowden
This is interesting. When I started with computers in 1977 (TRS-80 Model I), I was the target market for computers, software, etc. I am a small businessperson who invested time and energy into using computers. I loved it! Now, I am not recognized at all. Either I use canned software

Re: security in programming

2016-03-07 Thread John R. Sowden
security levels. I ID each user from 0 to 9. Maybe that is too simple to avoid tampering. I have 10ish employees, so I have 20 ID 'numbers'. That is also easy to tamper with. These are my concerns. John On 03/07/2016 09:33 AM, Peter Cushing wrote: On 07/03/2016 17:16, John R. Sowden

Re: security in programming

2016-03-07 Thread John R. Sowden
a better way to solve it. I consider security to be a series of chain links. I attack them individually, not as a big blob. John On 03/05/2016 03:18 PM, John R. Sowden wrote: applications that I use need to be secure and have an audit trail. I encrypt entered passwords, compare them to encrypted

security in programming

2016-03-05 Thread John R. Sowden
applications that I use need to be secure and have an audit trail. I encrypt entered passwords, compare them to encrypted stored passwords, ala linux. I am comfortable with that. My concern is relating the authorized user, with their access level to the actual programs. Currently I use

Re: [NF] Are you using your own VPN outside the office?

2015-12-19 Thread John R. Sowden
You can replace the small battery with a larger one. If your existing UPS has a 12v 7AH battery, replacing it with a 12v 60 AH battery (deep cycle, not auto) will extend your run time about 8 times. It will not increase the output power (watts or VA). The big issue is the charging current

Re: FPD 2.6 test for a drive without crashing

2015-10-25 Thread John R. Sowden
> 0 -Lew Schwartz On Sat, Oct 24, 2015 at 6:28 PM, John R. Sowden <jsow...@americansentry.net> wrote: Is there is way in FPD 2.6 to test to see if a drive is working without having the program crash. I have a network where I test for a remote drive (peer to peer net) before attempting t

FPD 2.6 test for a drive without crashing

2015-10-24 Thread John R. Sowden
Is there is way in FPD 2.6 to test to see if a drive is working without having the program crash. I have a network where I test for a remote drive (peer to peer net) before attempting to connect to it. I set a variable (above is done in the autoexec.bat) re: the sytatus of the remove node

Re: Foxuser

2015-07-26 Thread John R. Sowden
, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: On 2015-07-21 16:28, John R. Sowden wrote: I am running fpd 2.6, have the same issue with multiple foxuser files. tried to specify in config.fp where it should go, no help, tried to turn it off in config.fp (resource=off), no help. I have a routine I

Re: Foxuser

2015-07-21 Thread John R. Sowden
I am running fpd 2.6, have the same issue with multiple foxuser files. tried to specify in config.fp where it should go, no help, tried to turn it off in config.fp (resource=off), no help. I have a routine I use for all of my apps (procedure file), have not tried to put 'set resource off' in

FoxPro/DOS 2 Lines per record in a browse?

2015-03-25 Thread John R. Sowden
I am trying to generate a browse window with thinks kine ticket #, Account Number, Name, City on line one, and about a 70 char field of text on line 2 in a browse window. The help screen does not reference this, in fact the word 'line' does not exist in the help for browse. help? John

Re: [NF] Recommendation for personal accounting program/service for Mac or web

2015-02-06 Thread John R. Sowden
sorry-I probably didn't use the correct sender address. John Sowden On 02/06/2015 04:38 PM, Ted Roche wrote: On Fri, Feb 6, 2015 at 5:31 PM, Paul McNett p...@mcnettware.com wrote: https://beansbooks.com/home Holy moly, and you can download and host it for free (open source). Not not NOT

problem with missing cdx file

2014-11-06 Thread John R. Sowden
I am trying to deal with a bad or missing cdx file. I have a program that recreates indices. I test for the existence of the cdx file. If found I delete it. Then I recreate the index with the various tags. Problem is the program crashes if it cannot find the index the first time. Of

Re: Problem with Missing CDX

2014-11-06 Thread John R. Sowden
On 11/06/2014 03:16 PM, Dan Covill wrote: John Sowden: Re-formatting this msg per Tracy Pearson's suggestion: We solved this same problem with the following code in our ErrorTrap procedure:if error() = 1707 or upper(message(1)) = STRUCTURAL CDX FILE NOT FOUND. *-- ignore it, because our

Re: Problem with Missing CDX

2014-11-06 Thread John R. Sowden
my text disappeared. I'll try again in a bit. John On 11/06/2014 04:37 PM, John R. Sowden wrote: On 11/06/2014 03:16 PM, Dan Covill wrote: John Sowden: Re-formatting this msg per Tracy Pearson's suggestion: We solved this same problem with the following code in our ErrorTrap

Re: Problem with Missing CDX

2014-11-06 Thread John R. Sowden
I like the trap the error message routine. I found the sys(2018) function. I am concerned though re: when the error occurs vs. when it is trapped. I am running v2.6/DOS. I have a standard error routine that even lets me know when I come to work in the morning that an error occurred and

Re: Problem with Missing CDX

2014-11-06 Thread John R. Sowden
Thank you! Let's see, what did I learn. Retry, never saw it in 20 years. And testing for a specific error code with error() allows me to create custom error solutions in my one error procedure. FP/DOS lives for a few more years, John On 11/06/2014 07:42 PM, Dan Covill wrote: John:

Re: fp/dos strange error

2014-09-23 Thread John R. Sowden
On 9/23/2014 1:18 AM, Paul Hill wrote: On 23 September 2014 05:25, John R. Sowden jsow...@americansentry.net wrote: The computer is running freedos/4dos via a multiboot (linux/dos). I have a billing program that evolved from dBASE II in 1981, and has had few changes in the last year. I have

Re: fp/dos strange error

2014-09-23 Thread John R. Sowden
On 09/23/2014 06:42 AM, Man-wai Chang wrote: My guess: Check the index expressions. Maybe one of them referred to a variable D. You can loop through index expressions of an index by sys(14,1), sys(14,2). On Tue, Sep 23, 2014 at 12:25 PM, John R. Sowden jsow...@americansentry.net wrote

fp/dos strange error

2014-09-22 Thread John R. Sowden
The computer is running freedos/4dos via a multiboot (linux/dos). I have a billing program that evolved from dBASE II in 1981, and has had few changes in the last year. I have a line: use (depfile) and am getting an error: Error 12, Variable 'D' not found. There is no variable D (I rarely

Re: fox dos

2014-09-07 Thread John R. Sowden
On 09/07/2014 03:46 AM, Man-wai Chang wrote: Reminder: 64-bit Window$ does NOT run 16-bit programs; 32-bit, no problem. On Sat, Sep 6, 2014 at 3:29 AM, Jack Skelley jskel...@newjerseydevils.com wrote: I have it on one of my external drives in Windows 7 SP 1 x64 and it will not launch... I

Re: fp dos 2.6 full screen a browse window

2014-09-07 Thread John R. Sowden
On 09/07/2014 05:32 AM, Alan Bourke wrote: In other words, drivers adhering to the Windows Display Driver Model used from Vista onwards cannot support these text-only VGA modes. Good Morning All: I am running Free-DOS and 4DOS for the command processor. No windows, no gates, no apache

fp dos 2.6 full screen a browse window

2014-09-05 Thread John R. Sowden
I am trying to get my browse windows to go full screen when ctrl F10 is pressed. It used to work, but no more. I am using normal as an attribute, but I have not used zoom, I don't think. I have heading an menu off. Not sure about zoom-I can't see the source code now. Thoughts? John

Re: Passwords -- encrypted, hashed, or encrypted+hashed?

2014-04-24 Thread John R. Sowden
On 04/23/2014 02:12 PM, Kevin Cully wrote: On 04/23/2014 05:05 PM, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: Minor comment: you'd want to look to go to nMyHashIterations - 1 since you do the 1st one before the FOR loop. As long as the program is consistent, it's all good! :D

Re: In and Out of Dos Box

2014-03-13 Thread John R. Sowden
On 03/13/2014 10:43 AM, Gene Wirchenko wrote: At 20:05 2014-03-12, Mike Copeland m...@ggisoft.com wrote: I tried it several years ago, but the lack of printing (to paper) was a deal breaker for me. (And if it DOSBOX is able to print to paper printing devices, then either I didn't realize it

Re: [NF] Was Encryption now Privacy

2014-03-13 Thread John R. Sowden
On 03/13/2014 02:33 PM, Mike Copeland wrote: Original Message Subject: Re: Encryption From: Geoff Flight data...@adam.com.au To: profoxt...@leafe.com Date: 3/13/2014 4:26 PM The govt demands access to ALL your data but in the name of privacy demands YOU deny access to that

Re: [NF] Was Encryption now Privacy

2014-03-13 Thread John R. Sowden
On 03/13/2014 02:38 PM, John R. Sowden wrote: On 03/13/2014 02:33 PM, Mike Copeland wrote: Original Message Subject: Re: Encryption From: Geoff Flight data...@adam.com.au To: profoxt...@leafe.com Date: 3/13/2014 4:26 PM The govt demands access to ALL your data but in the name

record count math issue

2013-12-23 Thread John R. Sowden
So I have this mathematical problem: Database has 7,210 records. Each record is 76 bytes in length (75 data plus 1 delete flag) # records times record length is 547,960 bytes. DIR the file (from the O/S) and get a length of 541,040, and that doesn't take the header into count. Whatsup? John

Re: set order

2013-12-11 Thread John R. Sowden
On 12/06/2013 06:15 PM, John R. Sowden wrote: On 12/06/2013 04:22 PM, Dan Covill wrote: Allen, Gene W. has it right. This is an old problem. When you have an index set, modifying a field that's part of the index expression changes where the modified record appears in the order. It's one

Re: set order

2013-12-11 Thread John R. Sowden
to emulate the 'scatter' and 'compobj' functions. The 'scatter' proc builds an array matching the record, the 'compobj' compares two arrays. Yes, you'll have different procs for each table, but they won't need a lot of code. Dan On 12/11/13 02:27 PM, John R. Sowden wrote: Haven't heard a response

Re: set order

2013-12-06 Thread John R. Sowden
On 12/06/2013 04:22 PM, Dan Covill wrote: Allen, Gene W. has it right. This is an old problem. When you have an index set, modifying a field that's part of the index expression changes where the modified record appears in the order. It's one way to generate an infinite loop! It's not a

Re: Foxpro/DOS not a dbf file error

2013-11-10 Thread John R. Sowden
On 11/10/2013 07:47 AM, Jean MAURICE wrote: You are right ! Thanks The Foxil Le 10/11/2013 16:13, Laurie Alvey a écrit : I make 0x1904 = 6404 - 8404 is 0xD420. Unless I'm going crazy. all the hex math aside, the database in question has 6,403 records. :) John

Foxpro/DOS not a dbf file error

2013-11-09 Thread John R. Sowden
We had a computer freeze during the night (it gets cold in the SF Bay Area), and the worker was doing data enter into a dbf using foxpro/dos 2.6, under program control. I flush the buffer after every record entered, due to some 'segment errors' of yesteryear. Now we cannot get back into the

Re: Foxpro/DOS not a dbf file error

2013-11-09 Thread John R. Sowden
On 11/09/2013 11:09 AM, Alan Bourke wrote: On Sat, Nov 9, 2013, at 06:53 PM, M Jarvis wrote: On Sat, Nov 9, 2013 at 10:42 AM, John R. Sowden jsow...@americansentry.net wrote: Now we cannot get back into the dbf because it comes up as a 'not a dbf' error. I hope it ain't Cryptolocker

Re: Foxpro/DOS not a dbf file error

2013-11-09 Thread John R. Sowden
On 11/09/2013 11:09 AM, Alan Bourke wrote: On Sat, Nov 9, 2013, at 06:53 PM, M Jarvis wrote: On Sat, Nov 9, 2013 at 10:42 AM, John R. Sowden jsow...@americansentry.net wrote: Now we cannot get back into the dbf because it comes up as a 'not a dbf' error. I hope it ain't Cryptolocker

Re: Foxpro/DOS not a dbf file error Solved

2013-11-09 Thread John R. Sowden
On 11/09/2013 11:25 AM, Jean MAURICE wrote: 03 0D 0B 09 04 19 00 00-21 01 4B 00 00 00 00 00 03 : foxpro dbf without memo 0D 0B 09 : last update november, 9th 2013 04 19 00 00 : number of records : 4868 Try to write 05 or 03 instead of 04 in byte n° 4 (beginning with 0) HTH The Foxil

Re: Foxpro/DOS not a dbf file error

2013-11-09 Thread John R. Sowden
Thank you all for your input. Sorry for the delay, had to repair my wife's car. Anyway I needed a hex editor that would work on fat32. Found uhex.zip. It is part of the freedos family of programs. Per suggestion, I changed the 5th byte (byte 4) from 04 to 05 assuming that the added record

FPDOS browse issue

2013-08-26 Thread John R. Sowden
I am creating a gl program. I need to browse transactions in date order. two issues: little issue: in all of by browses, the first line is empty, including set heading off. I put the field titles in the title bar to save a line, look nice. big issue: I am dealing with 3 dbfs: accounts,

Foxpro 2.6 DOS/dosemu/ubuntu issues

2013-08-24 Thread John R. Sowden
I program internal applications in foxpro/dos because I can run it under dosemu. Occasionally I run into problems that I am unable to solve. Is this an ok forum to voice these issues, or is there a better one for foxpro/dos. I bought vp5 when it came out, but it immediately crashed. One of