Re: Working with text files larger than 2GB (VFP9SP2)

2013-11-09 Thread AndyHC
From VFP Help! /FSEEK( ) returns the number of bytes the file pointer is positioned from the beginning of the file. The file pointer can also be moved with FREAD( ) and FWRITE( )./ So you can't use FSEEK on a file 2GB (?4Gb) because the return value would cause an error. iirc FREAD and FWRITE

RE: Working with text files larger than 2GB (VFP9SP2)

2013-11-09 Thread Darren
Andy You can use the API for this easily. Just need to handle the High Byte / Low Byte addressing. VFP has no issue with it and handles multi - terabyte files if one is inclined to play with files that large. I've tested with files up to 300Gb and no issue. -Original Message- From:

Re: [NF] Remote Desktop Windows 7

2013-11-09 Thread Rafael Copquin
I'm not sure if this can be of any help. Have you tried Google remote desktop? It does not need any twicking with W7, just install it in your machine and theirs and you get in with no hassles. The only drawback so far is it does not have file transfer. But I resolved that by installing

Re: [NF] Remote Desktop Windows 7

2013-11-09 Thread Jeff Johnson
Jeff --- Jeff Johnson j...@san-dc.com (623) 582-0323 www.san-dc.com www.arelationshipmanager.com On 11/08/2013 04:45 PM, Ted Roche wrote: On Fri, Nov 8, 2013 at 5:36 PM, Jeff Johnson j...@san-dc.com wrote: Ted: I only tried about 250 suggestions and worked on it for about

Re: [NF] Remote Desktop Windows 7

2013-11-09 Thread Jeff Johnson
Interesting. I will look at this, but I really need to get RDT working. Thanks! Jeff --- Jeff Johnson j...@san-dc.com (623) 582-0323 www.san-dc.com www.arelationshipmanager.com On 11/09/2013 06:55 AM, Rafael Copquin wrote: I'm not sure if this can be of any help. Have you

RE: [NF] Remote Desktop Windows 7

2013-11-09 Thread Allen
I deleted a load of messages so not sure if anyone responded with ports on a NAT/Firewall. TCP and UTP port 3389 is what I had open. I closed it because of hackers. Al -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jeff Johnson Sent: 09 November

Re: [NF] Remote Desktop Windows 7

2013-11-09 Thread Alan Bourke
On Sat, Nov 9, 2013, at 01:55 PM, Rafael Copquin wrote: I'm not sure if this can be of any help. Have you tried Google remote desktop? For clarity, it's Chrome Remote Desktop and both ends need to be running Chrome as the browser. ___ Post Messages

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 M Jarvis
On Sat, Nov 9, 2013 at 10:42 AM, John R. Sowden jsow...@americansentry.net wrote: 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

Re: Foxpro/DOS not a dbf file error

2013-11-09 Thread Alan Bourke
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 Rafael Copquin
If you have VFP you set tablevalidate to 0 and try to open the table If you can, append an empty record, delete it, pack the table and recreate the index. I do that with old fox dos tables and it usually works Rafael Copquin El 09/11/2013 15:42, John R. Sowden escribió: We had a computer

Re: Foxpro/DOS not a dbf file error

2013-11-09 Thread Jean MAURICE
May be it is due to a wrong record number in theheader of the file. I don't rememberin wich bytes it is (and it is in a 'reverse mode' ?) and try to add 1 to it (or minus 1). When the computer freeze, may be the 'last' record was added but it has no time to update the header. HTH The Foxil

Re: Foxpro/DOS not a dbf file error

2013-11-09 Thread Jean MAURICE
Collapse imageTable Header Record Structure Byte offset Description 0 *File type:* 0x02 FoxBASE / dBase II 0x03 FoxBASE+ / FoxPro /dBase III PLUS / dBase IV, no memo 0x30 Visual FoxPro 0x31 Visual FoxPro, autoincrement enabled 0x32 Visual FoxPro, Varchar, Varbinary, or

Re: Foxpro/DOS not a dbf file error

2013-11-09 Thread Jean MAURICE
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 jerry foote
I have used the recovery tools from abri for years. http://www.abri.com/ jerry -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Jean MAURICE Sent: Saturday, November 09, 2013 1:20 PM To: profox@leafe.com Subject: Re: Foxpro/DOS not a dbf file error

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: [NF] Remote Desktop Windows 7

2013-11-09 Thread Jeff Johnson
Thanks Alan. At least we know it is secure! Jeff --- Jeff Johnson j...@san-dc.com (623) 582-0323 www.san-dc.com www.arelationshipmanager.com On 11/09/2013 11:26 AM, Alan Bourke wrote: On Sat, Nov 9, 2013, at 01:55 PM, Rafael Copquin wrote: I'm not sure if this can be of any

Is their a way to turn off some of the intellisense?

2013-11-09 Thread Michael Savage
I find the popup for the select (SQL) command most annoying. It often covers what I'm trying to type. How could I turn this off? Mike ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

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

Re: Foxpro/DOS not a dbf file error

2013-11-09 Thread Jean MAURICE
I am glad to see that 'old science' is still alive ! 04 19 00 00 : number of records : 4868 I made a mistake, 19 is hexadecimal so number of records should be 8404 ... Regards The Foxil ___ Post Messages to: ProFox@leafe.com Subscription