Hi All
I have a form with lots of remote views and despite being set to no data on
load the form still has a delay when loading, is their anyway to avoid this? I
presume the connection is being checked?
Thanks
Chris.
__
On Thu, Jul 18, 2013, at 04:15 PM, Stephen Russell wrote:
Would you embrace services that the ERP system has developed for data
CRUD
operations or just deal with the direct tables yourself?
My ERP is named LN by InFor. They are a larger version of Stage buying
up
all the accounting
Chris Davis wrote:
Hi All
I have a form with lots of remote views and despite being set to no data on
load the form still has a delay when loading, is their anyway to avoid this? I
presume the connection is being checked?
Are you using the data environment?
Peter
On Thu, Jul 18, 2013 at 11:47 PM, Paul McNett p...@ulmcnett.com wrote:
XML saves you a lot of time because things are all messed up to begin
with.\
lol!
+1
--
Ted Roche
Ted Roche Associates, LLC
http://www.tedroche.com
--- StripMime Report -- processed MIME parts ---
On Thu, Jul 18, 2013 at 10:47 PM, Paul McNett p...@ulmcnett.com wrote:
On 7/18/13 8:15 AM, Stephen Russell wrote:
Would you write to 30+ tables or would you write the XML to one?
Depends. With raw table access you have far more control, but it will take
a lot of
time to understand how not
Can't you check all your necessary connections as a separate routine?
-Lew Schwartz
On Fri, Jul 19, 2013 at 5:24 AM, Peter Cushing pcush...@whisperingsmith.com
wrote:
Chris Davis wrote:
Hi All
I have a form with lots of remote views and despite being set to no data
on load the form
On Fri, Jul 19, 2013 at 3:14 AM, Chris Davis chr...@actongate.co.uk wrote:
Hi All
I have a form with lots of remote views and despite being set to no data
on load the form still has a delay when loading, is their anyway to avoid
this? I presume the connection is being checked?
http://www.geekculture.com/joyoftech/joyarchives/1872.html
--
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
---
Set DELETED ON gives partial.
Set DELETED OFF gives full.
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Alan
Bourke
Sent: Saturday, 20 July 2013 2:10 AM
To: profoxt...@leafe.com
Subject: Re: Why is this SQL not fully optimized?
Is lastDOS of type
Is lastDOS of type Date, and did you mean 'Test' in the Select
statement?
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list:
Hi Folks,
Please check the following scenario:
This is an intermittent problem for some users but not all users. The
common points are:
Restricted Domain Users running my application on Windows XP or Windows 7.
My application is installed in C:\Program Files\My Application on XP, and
in
So why are you indexing Test and then selecting from MyTable?
Fred
On Fri, Jul 19, 2013 at 8:40 AM, MB Software Solutions, LLC
mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
(VFP9SP2)
select Test
index on LastDOS tag LastDOS
SYS(3054,11,lcRushmore)
SELECT a1.* FROM MyTable a1 WHERE
Are you closing the table, SomeTable1, and then trying to erase it within
milliseconds? If the tables are located on a server (instead of your local
drive) then it is likely that the server is not releasing the handle
(flag, marker, user connection) on the file fast enough, and your
Couple of thoughts.
Make sure everyone has write ahead cache off on disk drives. Also it seems
VFP requires full permissions.
Al
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ken
Dibble
Sent: 19 July 2013 18:32
To: profoxt...@leafe.com
Subject:
On Fri, Jul 19, 2013 at 11:40 AM, MB Software Solutions, LLC
mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
select Test
index on LastDOS tag LastDOS
SYS(3054,11,lcRushmore)
SELECT a1.* FROM MyTable a1 WHERE LastDOS = DATE(2012,1,1) INTO CURSOR Test
messagebox(lcRushmore) says rushmore
On 7/19/13 4:26 AM, Ted Roche wrote:
On Thu, Jul 18, 2013 at 11:47 PM, Paul McNett p...@ulmcnett.com wrote:
XML saves you a lot of time because things are all messed up to begin
with.\
lol!
I was able to get them to accept JSON for most of the data-exchanges, but they
stuck
to XML
Ah. Two (or more) computers are involved. That makes it dicey to delete
files except in this case it should work since you have an obvious
master slave thing going. I'm guessing that the Master computer
creates the table and the Slave is checking if the tables existe, and
when found the report
Do While's are troublesome, but I do use them from time to time. I
usually add a Sleep() to inject a system-induced pause to keep the loop
from running at full-tilt top speed. Psuedocode example follows...
DECLARE Sleep IN Win32API INTEGER nMilliseconds
local lnMaxIterations, lnCounter
Ah. Two (or more) computers are involved. That makes it dicey to delete
files except in this case it should work since you have an obvious
master slave thing going. I'm guessing that the Master computer
creates the table and the Slave is checking if the tables existe, and when
found the
On Jul 19, 2013, at 12:16 PM, Paul McNett p...@ulmcnett.com wrote:
I was able to get them to accept JSON for most of the data-exchanges, but
they stuck
to XML for the largest ones, because that's what the other side wanted. But
the other
side has no clue how to write an XSD to fit the
On Fri, Jul 19, 2013 at 2:27 PM, Mike Copeland m...@ggisoft.com wrote:
\
Do While .t.
lnCounter=lnCounter + 1
* if we have reached our max try count, bail
if lnCounter = lnMaxIterations
exit
endif
endd
Do you mean:
Do While lnCounter lnMaxIterations
At 11:06 2013-07-19, Ken Dibble krdib...@stny.rr.com wrote:
[snip]
I went with this approach because with earlier systems, users were
somehow able to badly corrupt the data while attempting to make data
entry changes at the same time that reports involving that data were
printing. I used the
Don't both of you mean:
for nI = 1 to lnMaxIterations
...process..
endfor
? :-)
Mike Copeland wrote:
Well sure, if you want efficient code...but...well...uh... :-)
Thanks Ted!
Mike
Do While .t.
lnCounter=lnCounter + 1
* if we have reached our max try count, bail
Well sure, if you want efficient code...but...well...uh... :-)
Thanks Ted!
Mike
Original Message
Subject: Re: Unexplained Error 1705 Access Denied Errors
From: Ted Roche tedro...@gmail.com
To: profoxt...@leafe.com
Date: 7/19/2013 2:15 PM
On Fri, Jul 19, 2013 at 2:27 PM, Mike
Yeah, that's it.
Avoid the Do While completely! Which reinforces the stereotypical fear
of using Do While... :-)
Mike
Original Message
Subject: Re: Unexplained Error 1705 Access Denied Errors
From: Vincent Teachout tea...@taconic.net
To: profoxt...@leafe.com
Date: 7/19/2013
On 7/19/2013 12:10 PM, Alan Bourke wrote:
Is lastDOS of type Date, and did you mean 'Test' in the Select
statement?
Yes and Yes
--
Mike Babcock, MCP
MB Software Solutions, LLC
President, Chief Software Architect
http://mbsoftwaresolutions.com
http://fabmate.com
http://twitter.com/mbabcock16
On 7/19/2013 12:11 PM, Darren wrote:
Set DELETED ON gives partial.
Set DELETED OFF gives full.
BINGO WE HAVE A WINNER
Thanks, Darren!!! Now just how much difference between the two modes
given my data is always insert and query/select only (no updates or
deletes), who knows.
On 7/19/2013 1:07 PM, Ted Roche wrote:
Do you have a tag on DELETED()
No, I didn't. This data is only inserted into the database and then
queried; there's no updates or deletes. I'm going to test the SET
DELETED and/or index on DELETED strategy next week. Since no records
will ever be
Either way you want a bail out option. Mike doesn't like DO WHILE, and I
prefer not to EXIT or manually tweak a counter in a FOR NEXT. To each their
own.
On Fri, Jul 19, 2013 at 3:38 PM, Vincent Teachout tea...@taconic.netwrote:
Don't both of you mean:
for nI = 1 to lnMaxIterations
On 7/19/2013 11:40 AM, MB Software Solutions, LLC wrote:
(VFP9SP2)
select Test
index on LastDOS tag LastDOS
SYS(3054,11,lcRushmore)
SELECT a1.* FROM MyTable a1 WHERE LastDOS = DATE(2012,1,1) INTO CURSOR Test
messagebox(lcRushmore) says rushmore optimization level for MyTable:
partial
I don't
(VFP9SP2)
select Test
index on LastDOS tag LastDOS
SYS(3054,11,lcRushmore)
SELECT a1.* FROM MyTable a1 WHERE LastDOS = DATE(2012,1,1) INTO CURSOR Test
messagebox(lcRushmore) says rushmore optimization level for MyTable:
partial
I don't understand why it wouldn't be full optimization?
--
On 7/19/2013 12:03 PM, Fred Taylor wrote:
So why are you indexing Test and then selecting from MyTable?
Fred
Because I changed the names for the paste here. ID10T or PEBKAC error.
--
Mike Babcock, MCP
MB Software Solutions, LLC
President, Chief Software Architect
On 7/19/2013 1:59 PM, Ed Leafe wrote:
On Jul 19, 2013, at 12:16 PM, Paul McNett p...@ulmcnett.com wrote:
I was able to get them to accept JSON for most of the data-exchanges, but they
stuck
to XML for the largest ones, because that's what the other side wanted. But the
other
side has no clue
I'll take a stab at it...
Are you closing the table, SomeTable1, and then trying to erase it
within milliseconds? If the tables are located on a server (instead of
your local drive) then it is likely that the server is not releasing the
handle (flag, marker, user connection) on the file fast
Either way you want a bail out option. Mike doesn't like DO WHILE, and I
prefer not to EXIT or manually tweak a counter in a FOR NEXT. To each their
own.
Thanks everybody for all your suggestions. I'll be back on this on Monday.
Roll on the weekend!
Ken Dibble
www.stic-cil.org
I don't think it will make any difference if there are no deleted records -
I am not 100% but I believe SYS(3054, .. reports partial because of the
issues around deleted records.
When I am testing stuff like that I use the high resolution timers - run
one and the other and look for any
36 matches
Mail list logo