Have you ruled out an external program locking the DBF/CDX/FPT file to do
some type of check. Meaning, is there anti-virus, or on-demand back up tools
running and keeping an eye on that network path?
Has someone setup a local anti-virus tool to check network drives? (very
bad setting, most
RTF? How... quaint.
How ... (still, for the time-being) universally readable and
non-proprietary. :)
Ken
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this
Can't wait to find out who plays you in the movie. Quite the novel.
I've skimmed, but can't possibly comprehend, all 20 pages.
If this is production code you have had in production with many people
using it for a long time, it's unlikely they just found a new way to
break it. So my first
On Thu, Jul 16, 2015 at 2:12 PM, Kevin Cully
kcu...@cullytechnologies.com wrote:
Confirmed! I wrote a test sample in VFP9 that inserted 100 records into a
FPW table. I then was able to open the FPW table in FPW2.6 and append
another record without issue. Thank you to everyone for their help.
On Mon, Jul 13, 2015 at 11:27 PM, Ken Dibble krdib...@stny.rr.com wrote:
Question 1: Does a SQL SELECT place a lock on a VFP .dbf table such that the
same user can't issue a USE on the table while the query is running?
It will open a table in shared mode. It seemed that a table or an
alias
I just tried this:
Open a (free) VFP9 table with 1 V(10) column.
Copy to xxx TYPE FOX2X.
V(10) column is changed to M.
Header differences:
VFP9 byte offset 0 is 0x32
2.x byte offset 0 is 0xF5.
These values seem different to those contained in the help file (File
Structures).
Laurie
On 16 July
I know that I can access PostgreSQL data via VFP, but I can't recall if
FPW2.6 can access PG data directly via ODBC.
No, because it's 16-bit.
--
Alan Bourke
alanpbourke (at) fastmail (dot) fm
___
Post Messages to: ProFox@leafe.com
Thanks Ted, although I don't like macros, I'll give it a try.
Laurie
On 15 July 2015 at 21:09, Ted Roche tedro...@gmail.com wrote:
On Wed, Jul 15, 2015 at 2:54 PM, Darren fox...@ozemail.com.au wrote:
Ted,
This works ok for me here (haven't you heard that before)
Oh, I think I've said
If I was to make any data structure changes, I could always use FPW to
do so.
I'm going to run some tests shortly and see what's what. Basically
write a VFP app to insert some dummy records into a FPW table, and then
make sure that FPW can see that data and that the indexes still work,
etc.
Hi Ted,
I modified your macro code to get it to work to this:
lcCmd = REPLACE ALL
FOR i = 1 TO n
IF laCols[i,2] == V
lcFld = laCols[i,1]
lcCmd = lcCmd + lcFld + WITH ALLTRIM( + lcFld + ),
ENDIF
ENDFOR
IF LEN(lcCmd) LEN(REPLACE ALL )
lcCmd = LEFT(lcCmd, LEN(lcCmd)-1)
lcCmd
ENDIF
I did some
Kevin - AFAIK - here's the problem.
If you make a Structure change - like add a field via VFP - then, the DBF can
NOT be read by FPW/FPD. I believe this is the case - although it was years ago
that I ran into the issue.
-K-
-Original Message-
From: ProfoxTech
A quick-and-dirty solution is to check USED(_table_name_) before
issuing any USE _table_name_! Here is an example:
Thank you. I always do that. In fact, my framework has a data manager class
that handles this, so USE and SELECT are only issued in one place. If
USED() is .T., then I SELECT
On Wed, Jul 15, 2015 at 3:47 PM, Kevin Cully kcu...@cullytechnologies.com
wrote:
Situation: I've created a proposal for a new client for upgrading an old
FPW2.6 application to a web based application using PostgreSQL as the DB.
The client likes my proposal but they're wondering that if they
On 16/07/2015 14:43, Kevin Cully wrote:
Basically write a VFP app to insert some dummy records into a FPW
table, and then make sure that FPW can see that data and that the
indexes still work, etc.
Been doing that for years here. We have an old accounting system called
Opera that uses FPW
Very good! I hadn't tested the code; it worked fine in an email message g.
On Thu, Jul 16, 2015 at 8:47 AM, Laurie Alvey trukke...@gmail.com wrote:
Hi Ted,
I modified your macro code to get it to work to this:
lcCmd = REPLACE ALL
FOR i = 1 TO n
IF laCols[i,2] == V
lcFld = laCols[i,1]
I've gotten into the habit of using:
USE mytable IN SELECT([mytable])
If it's not USED the SELECT() function returns the equivalent of the next
available workarea. If the assumption is that you just want that table open,
this eliminates any amibiguity. Of course as you've pointed out, if
On Thu, Jul 16, 2015 at 9:21 AM, Ken Dibble krdib...@stny.rr.com wrote:
However, I have also seen this before, rarely, in other situations:
IF NOT USED(mytable)
USE mytable IN 0 Error 3; File in use.
ENDIF
USED() only tells you if an ALIAS name is used, not a table.
create table
RTF? How... quaint.
On Thu, Jul 16, 2015 at 12:40 PM, Ken Dibble krdib...@stny.rr.com wrote:
I'm about to post a very long message providing excruciating detail about
this.
Which, apparently, is hung up in the spam filter. *sigh*
If anyone would like to read it, it's at:
Ken Dibble wrote on 2015-07-16:
I'm about to post a very long message providing excruciating detail about
this.
Which, apparently, is hung up in the spam filter. *sigh*
If anyone would like to read it, it's at:
www.stic-cil.org/CILData/Error 3.rtf
Thanks.
Ken
Ken,
I'm about to post a very long message providing excruciating detail about
this.
Which, apparently, is hung up in the spam filter. *sigh*
If anyone would like to read it, it's at:
www.stic-cil.org/CILData/Error 3.rtf
Thanks.
Ken
___
Post
USE mytable IN SELECT([mytable])
If it's not USED the SELECT() function returns the equivalent of the next
available workarea. If the assumption is that you just want that table
open, this eliminates any amibiguity. Of course as you've pointed out, if
another user or process has an
USED() only tells you if an ALIAS name is used, not a table.
create table temp (field1 c(10), field2 d)
USE
use temp alias nottemp in 0
? used(temp) .F.
Yup. But my code never sets up ALIASes that are different from the table name.
I'm about to post a very long message providing
1. Test all data files, index and data contents for corruption. Then
source code, too: SCX/VCX/FRX get corrupted sometimes.
All of this code is in .prg files once the user presses the GO button.
The production code has been fully recompiled and redistributed several
times in the last few
Fox is not on the list!
http://readwrite.com/2013/05/01/10-technology-skills-no-longer-in-demand
--
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)
Whew! Looks like we made a good choice in skill sets to acquire after all...
Mike
Stephen Russell wrote:
Fox is not on the list!
http://readwrite.com/2013/05/01/10-technology-skills-no-longer-in-demand
___
Post Messages to: ProFox@leafe.com
On Thu, Jul 16, 2015 at 3:09 PM, Ken Dibble krdib...@stny.rr.com wrote:
Is there some other quick test I should use?
I did put in a request years ago for MS to add a BROWSE FOR
CORRUPTED() but MS thought it would be too hard.
A real problem with a bit set in the wrong place is that you won't
Confirmed! I wrote a test sample in VFP9 that inserted 100 records into
a FPW table. I then was able to open the FPW table in FPW2.6 and append
another record without issue. Thank you to everyone for their help.
CULLY Technologies, LLC
http://cullytechnologies.com
http://cully.biz
On
I am trying to recompile a vfp8 file that was built using stonefield, the
problem is with variables such as ccmsg_error_num i am assuming that the
vars with a leading cc are defined from .h file. how are they included in a
proj file?
--- StripMime Report -- processed MIME parts ---
On 7/16/2015 9:21 AM, Ken Dibble wrote:
A quick-and-dirty solution is to check USED(_table_name_) before
issuing any USE _table_name_! Here is an example:
Thank you. I always do that. In fact, my framework has a data manager
class that handles this, so USE and SELECT are only issued in one
I have discovered by looking at others code that one can access properties
of the control via:
- thisform.ControlName.object.value
- thisform.ControlName.object.MinDate
- thisform.ControlName.object.MaxDate
I am sure there are more properties but since they don't show in the VFP
30 matches
Mail list logo
