RE: Anyone heard of MV.Base?

[Graham Brown (CompSYS)]

Thanks Dave


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Dave Crozier
Sent: 28 April 2008 15:44
To: 'ProFox Email List'
Subject: RE: Anyone heard of MV.Base?


Graham,
I know a colleague who says he used it up to a couple of years ago. He says
that there is an ODBC client available called Liberty ODBC. Other than that
he doesn't know of anny connectors apart from writing one yourself using the
SDK.

http://www.multivalue.com/LibODBC.html

Evidently there is an evaluation version that comes with MV.Base itself.

Dave Crozier


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Graham Brown (CompSYS)
Sent: 28 April 2008 11:48
To: ProFox Email List
Subject: Anyone heard of MV.Base?

Hi

I've been asked about linking into a piece of software called MOS which uses
MV.Base (pick based?) as its underlying database. The MOS product has a
query builder for extracting information to Excel which is a pig to use.
I've checked control panel and there aren't any ODBC drivers or DSNs.

Anybody come across this before please?

Graham Brown
CompSYS Software Solutions
T:0845 202 8480
F:0845 202 8480 / 0845 009 4480
M:07973 988939
E:[EMAIL PROTECTED]

BNI Member. The Business Referral Organisation
For more information please go to http://www.bni-plains.co.uk


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Anyone heard of MV.Base?

[Graham Brown (CompSYS)]

Hi

I've been asked about linking into a piece of software called MOS which uses
MV.Base (pick based?) as its underlying database. The MOS product has a
query builder for extracting information to Excel which is a pig to use.
I've checked control panel and there aren't any ODBC drivers or DSNs.

Anybody come across this before please?

Graham Brown
CompSYS Software Solutions
T:0845 202 8480
F:0845 202 8480 / 0845 009 4480
M:07973 988939
E:[EMAIL PROTECTED]

BNI Member. The Business Referral Organisation
For more information please go to http://www.bni-plains.co.uk


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

[NF] Exists query from mySQL table

[Graham Brown (CompSYS)]

Hi all

I'm trying to figure out what I think should be an exists query

What I have is two tables

Lookup List has two fields ID (autonumber) and a description


ID=1, description=Red
ID=2, description=blue
ID=3, description=Green
ID=4, description=Purple

The customer table has a name field and a memo. The memo contains which
colour preferences the customer has, customer can choose as many preferences
as they like
so

Name=Graham, Memo=1,2,  (Graham prefers red and blue)
Name=Fred, Memo=2,3,
Name=Sue, Memo=2,4,
Name=Chris, Memo=1,

What I'm trying to do is end up with this : -

Red is preferred by 2 customers
Blue is preferred by 3 customers
Green is preferred by 1 customer
Purple is preferred by 1 customer

This table will help the user figure out which items to stock. I know I can
do this long hand by creating a temporary cursor but was looking for
something easier.

I've been messing with : -

select distinct description, count(*)  from lookup_list where exists (select
memo from customers where instr(cast(lookup_list.id as char),memo)>0) group
by lookup_list.description order by lookup_list.description

But that doesn't want to play.

Any pointers would be gratefully received.

Thanks!
Graham Brown
CompSYS Software Solutions

BNI Member. The Business Referral Organisation
For more information please go to http://www.bni-plains.co.uk


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

[NF] Any Ajax gurus out there please!

[Graham Brown (CompSYS)]

Hi all

I have this code on one site (test_site_a.co.uk...) what it does is call an
asp file called higson.asp on a completely different website which then
returns a html table of subscribers. The code in this JS then writes out
that table directly with document.write.

This works just fine in IE but fails miserably in Firefox. No error message
just doesn't do anything.

I've read that FF does not allow http ajax calls across different domains,
anybody know if that is correct please?

Cheers
Graham



  
var xmlHttp;
try
{
  xmlHttp=GetXmlHttpObject()
  xmlHttp.onreadystatechange=function()
  {
if(xmlHttp.readyState==4)
{
 document.write(xmlHttp.responseText);
}

  }

  xmlHttp.open("GET","<a  rel="nofollow" href="http://www.bni-plains.co.uk/higson.asp",true">http://www.bni-plains.co.uk/higson.asp",true</a>);
  xmlHttp.send(null);
}
catch (e)
{
  try
  {  // Firefox, Opera 8.0+, Safari
xmlHttp=new XMLHttpRequest();
xmlHttp.onreadystatechange=function()
{
  if(xmlHttp.readyState==4)
  {
document.write(xmlHttp.responseText);
  }

}

xmlHttp.open("GET","<a  rel="nofollow" href="http://www.bni-plains.co.uk/higson.asp",true">http://www.bni-plains.co.uk/higson.asp",true</a>);
xmlHttp.send(null);
  }
  catch (e)
  {  // Internet Explorer
try
{
  xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
  xmlHttp.onreadystatechange=function()
  {
if(xmlHttp.readyState==4)
{
  document.write(xmlHttp.responseText)
}

  }
  xmlHttp.open("GET","<a  rel="nofollow" href="http://www.bni-plains.co.uk/higson.asp",true">http://www.bni-plains.co.uk/higson.asp",true</a>);
  xmlHttp.send(null);
}
catch (e)
{
  try
  {
xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
xmlHttp.onreadystatechange=function()
{
  if(xmlHttp.readyState==4)
  {
document.write(xmlHttp.responseText)
  }

}
xmlHttp.open("GET","<a  rel="nofollow" href="http://www.bni-plains.co.uk/higson.asp",true">http://www.bni-plains.co.uk/higson.asp",true</a>);
xmlHttp.send(null);
  }
  catch (e)
  {
alert("Your browser does not support
AJAX!"+chr(13)+chr(10)+e.description);

  }
}
  }
}

   

Graham Brown
CompSYS Software Solutions
E:[EMAIL PROTECTED]

BNI Member. The Business Referral Organisation
For more information please go to http://www.bni-plains.co.uk



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

SQL Pass Thru question

[Graham Brown (CompSYS)]

Hi

I've written a simple routine to upload into Quickbooks via the QODBC.com
link. What I'm finding is periodically some records are not getting written
into quickbooks. I can run the insert statements manually and they work so I
suspect it has something to do with firing the inserts one after the other.

Does SQLExec need a delay loop to wait until it has finished executing each
insert command?

This is the code for QB. It looks to see if the customer record is already
on file, inserts if not then checks again to see if went through, finally it
adds a child record for the job card.

Regards
Graham


Select emails
Go Top
nH=SQLConnect("QuickBooks Data")
If nH<=0
Wait Window "Unable to connect to Quickbooks"
Else
N=1
Scan For emails.f_imported="No"
=SQLEXEC(nH,"Select * from customer where
name='"+Strtran(Proper(Alltrim(emails.f_forename)+"
"+Alltrim(emails.f_surname)),"'","''")+"'","MyCust")
If Reccount("MyCust")=0
** Need to add the customer record
cSQL="Insert into customer
(Name,BillAddressAddr1,BillAddressAddr2,BillAddressAddr3,BillAddressAddr4,Bi
llAddressCity,email,isActive,CompanyName) values("

cSQL=cSQL+"'"+Strtran(Proper(Alltrim(emails.f_forename)+"
"+Alltrim(emails.f_surname)),"'","''")+"',"
cSQL=cSQL+"'"+Rtrim(m.add1)+"',"
cSQL=cSQL+"'"+Rtrim(m.add2)+"',"
cSQL=cSQL+"'"+Rtrim(m.add3)+"',"
cSQL=cSQL+"'"+Rtrim(m.add4)+"',"
cSQL=cSQL+"'"+Rtrim(m.add5)+"',"
cSQL=cSQL+"'"+Rtrim(emails.f_email)+"',"
cSQL=cSQL+"1,"

cSQL=cSQL+"'"+Strtran(Proper(Alltrim(emails.f_forename)+"
"+Alltrim(emails.f_surname)),"'","''")+"'"
cSQL=cSQL+")"
oSecurity.recordEvent("SQL","",cSQL)
=SQLEXEC(nH,cSQL)
=Sqlcommit(nH)

Endif
cSQL="Select * from customer where name like
'"+Proper(Alltrim(emails.f_forename)+" "+Alltrim(emails.f_surname))+"%'"
=SQLEXEC(nH,cSQL,"MyCust")
If Reccount("MyCust")>0
**name,parentreflistid,parentreffullname,companyname,jobdesc
m.faultinfo="Fault Desc here"
cSQL="Insert into customer
(name,notes,jobstatus,parentreflistid,parentreffullname,jobdesc) values("
cSQL=cSQL+"'Job:"+Alltrim(Str(emails.f_jobno))+" -
"+Strtran(Proper(Alltrim(emails.f_make)+"
"+Alltrim(emails.f_model)),"'","''")+" ("+Strtran(Time(),":","")+")',"
cSQL=cSQL+"'"+Rtrim(Strtran(m.faultinfo,"'","''"))+"',"
cSQL=cSQL+"'Pending',"
cSQL=cSQL+"'"+Rtrim(MyCust.listid)+"',"
cSQL=cSQL+"'"+Rtrim(MyCust.parentreffullname)+"',"
cSQL=cSQL+"'"+Rtrim(MyCust.companyname)+"',"

cSQL=cSQL+"'"+Rtrim(Proper(Strtran(Alltrim(emails.f_make)+"
"+Alltrim(emails.f_model),"'","''")))+"'"
cSQL=cSQL+")"
=SQLEXEC(nH,cSQL)
=Sqlcommit(nH)

Endif
N=N+1
Select emails
Replace f_imported With "Yes"
=Tableupdate()
Endscan
=SQLDISCONNECT(nH)
Endif



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Form off side of the screen VF6

[Graham Brown (CompSYS)]

Can you close the form with ctrl f4? then reopen?


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Adam Buckland
Sent: 01 April 2008 11:36
To: ProFox Email List
Subject: RE: Form off side of the screen VF6


The top of the form is off the top of the program so all I have is the
bottom right 1/4 of the form...



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Alan Bourke
Sent: 01 April 2008 11:35
To: profox@leafe.com
Subject: Re: Form off side of the screen VF6

Adam Buckland wrote:
> Client has managed to drag a form ¾ of the way off the screen and can't
get it back.
>
Does right-clicking on the top bar of the form present any options?




[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Disable one cell in a grid

[Graham Brown (CompSYS)]

Hi all

I'm having a numpty moment.

I've got this code to build a grid on a form. The underlying table (QTE_D)
has a field called "QTY_LOCKED" which means the user is not allowed to
change the qty for that one line item. I would have thought that
.columns(4).enabled=iif(QTY_LOCKED=="Y",.f.,.t.) would have worked but it
doesn't

Is there an easier way than setting the dynamic forecolor to "grey" and
changing the "when" event for the column?

Thanks

With Thisform.pageframe1.page1.grid1
.Top=thisform.pageframe1.page1.cssShape1.Top+3
.Height=300
.Width=thisform.pageframe1.width-50
.Visible=.F.
.Left=5
.GridLines=0
.RecordMark=.F.
.DeleteMark=0
.RecordSourceType=1
.RecordSource="qte_d"
.ColumnCount=7

.Columns(1).Name="column1"
.Columns(1).ControlSource="qte_d.qd_desc1"
.Columns(1).Width=250
.Columns(1).HEADER1.Caption="Description"

.Columns(2).Name="column2"
.Columns(2).ControlSource="qte_d.qd_LENGTH"
.Columns(2).Width=70
.Columns(2).HEADER1.Caption="Length"
.columns(2).alignment=1
.columns(2).inputmask="999"

.Columns(3).Name="column3"
.Columns(3).ControlSource="qte_d.qd_width"
.Columns(3).Width=70
.Columns(3).HEADER1.Caption="Width"
.columns(3).alignment=1
.columns(3).inputmask="999"

.Columns(4).Name="column4"
.Columns(4).ControlSource="qte_d.qd_qty"
.Columns(4).Width=70
.Columns(4).HEADER1.Caption="Qty"
.columns(4).alignment=1

.Columns(5).Name="column5"
.Columns(5).ControlSource="qte_d.qd_itemprice"
.Columns(5).Width=120
.Columns(5).HEADER1.Caption="Each"
.columns(5).alignment=1

.Columns(6).Name="column6"
.Columns(6).ControlSource="qte_d.qd_disc"
.Columns(6).Width=70
.Columns(6).HEADER1.Caption="Discount"
.columns(6).alignment=1

    .Columns(7).Name="column7"
.Columns(7).ControlSource="qte_d.qd_totalprice"
.Columns(7).Width=120
.Columns(7).HEADER1.Caption="Total"
.columns(7).alignment=1
.highlightstyle=2
.Refresh()
Endwith


Graham Brown
CompSYS Software Solutions
T:0845 202 8480
F:0845 202 8480 / 0845 009 4480
M:07973 988939
E:[EMAIL PROTECTED]

BNI Member. The Business Referral Organisation



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: [OT] Red Light Cameras work too well

[Graham Brown (CompSYS)]

You haven't got mobile speed (revenue) cameras yet?

We have unmarked white vans at the side of the road in the UK. They park up
with the backdoor or side door open with the cameras rolling.
We also have average speed cameras on many of our motorways so even if you
slow for the camera you still get the fine and points because it's averaged
out over a longer distance.

... and where there aren't cameras they've put speed ramps just to make sure
either you get a fine or a wrecked suspension. The best one though is where
we have the roads with 1 lane in either direction and they put road
narrowing ramps in so there is just enough room for 1 car to go in one
direction so you have to go onto the wrong side of the road into the path of
oncoming cars. What actually happens is you get drivers playing chicken with
oncoming traffic. Not quite sure how that makes things safer but there you
go.

They've also just announced today that the fines for central London for
parking on yellow lines has gone up to ?120 and about ?80 everywhere else.
The traffic wardens don't even need to ticket you as they have digital
cameras so the first you know is when the fine is posted out.

Don't you just love it...




-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Stephen Russell
Sent: 31 March 2008 13:44
To: ProFox Email List
Subject: Re: [OT] Red Light Cameras work too well


On Sat, Mar 29, 2008 at 7:00 AM, Michael Madigan <[EMAIL PROTECTED]>
wrote:

> Listen to this nonsense.  Some cities have seen a drop
> in revenue from red light violations and are
> considering turning off the cameras.  It seems too
> many people are obeying the traffic stops.
>
> I thought the idea of cameras was to improve safety
> and save lives?
>
---

Wait till they take them mobile, where they pick a new corner every other
week.

--
Stephen Russell
Sr. Production Systems Programmer
Mimeo.com
Memphis TN

901.246-0159


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Which version of Vista for Fox

[Graham Brown (CompSYS)]

Thanks

Thats kinda what I thought, the local computer store said that Home Premium
will connect to a domain but it looks like Home only sees the gateway.

I've ordered a Dell with Vista Business along with a brand new server to run
SBS2003.

Do VFP8 apps work on Vista?

Regards
Graham


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Alan Bourke
Sent: 31 March 2008 10:23
To: profox@leafe.com
Subject: Re: Which version of Vista for Fox


Graham Brown (CompSYS) wrote:
> Could anybody tell me which version of Vista I need so it connects my
> network the same as XP Pro? Also are there any specific editions which
work
> better or worse with database apps in v8?
>

'Business' or 'Ultimate' I reckon.


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Which version of Vista for Fox

[Graham Brown (CompSYS)]

Hi all

I've heard M$ are about to kill off XP (again) so I suppose I should go out
and buy a pc with Vista on it to see how my VFP8 apps work with it.
Could anybody tell me which version of Vista I need so it connects my
network the same as XP Pro? Also are there any specific editions which work
better or worse with database apps in v8?

I'm going to trawl the posts later to see what else is broken in Vista but
I've read on this list that VFP9 SP1 breaks more than it fixes?

Graham Brown
CompSYS Software Solutions
BNI Member. The Business Referral Organisation



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Getting at Excel data from VFP

[Graham Brown (CompSYS)]

Does Set NullDisplay to "" handle that?


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of NickC
Sent: 28 March 2008 10:08
To: 'ProFox Email List'
Subject: RE: Getting at Excel data from VFP


Stephen,

I do indeed now have the null problem but the only suggestion I can find is
IMEX=1 which doesn't actually help with the problem I have.

The problem is that any empty Excel fields get imported by the ADO
CursorAdapter as .null., then when I process that cursor through GenHTML
(which I am now using for creating the output) those fields are simply
ignored.

The best I can come up with at the moment is to loop through each record and
each field in each cursor converting nulls to blank, can anyone think of a
better way of doing this?

Cheers,
Nick


> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
> Of Stephen Russell
> Sent: 25 March 2008 19:34
> To: ProFox Email List
> Subject: Re: Getting at Excel data from VFP
>
> On Tue, Mar 25, 2008 at 1:57 PM, NickC <[EMAIL PROTECTED]> wrote:
>
> > Finally done, as always thanks for your suggestions.  Also a quick plug
> > for
> > Robert Abram's FTP_Service which looks to be doing the FTP upload
> > admirably.
> >
> > A bit of code for the archives, reading Excel into VFP:
> >
>
> -
>
>
> as a heads up google for excel null errors  and connection string.  Years
> back I found that there was another setting that would tell the jet engine
> to skip all the nulls that got in the way.
>
>
>
> > lcRegBkPath= ""
> > loConn = NewObject('ADODB.Connection')
> > loconn.Provider="Microsoft.Jet.OLEDB.4.0"
> > loconn.ConnectionString=[Data Source="]+lcRegBkPath+ ;
> >[";Extended Properties="Excel 8.0;HDR=Yes;";]
> > loconn.Open()
> > loRs = NewObject('ADODB.recordset')
> > oCA = CREATEOBJECT("CursorAdapter")
> > oCA.DataSourceType = "ADO"
> > lcWorksheet=""
> > lcRange="A1:Z99"
> > lcCursor=lcWorksheet
> > loRS.Open([SELECT * FROM `]+lcWorksheet+[$]+lcRange+[`],loConn)
> > oCA.Alias=lcCursor
> > oCA.CursorSchema = "Field1 C(50), Field2 C(50), Field3 C(50)"
> > IF NOT oCA.CursorFill(.T.,,,loRS)
> >? AERROR(laError)
> >? laError
> > ENDIF
> > oCA.CursorDetach()
> > EXPORT TO (lcWorksheet) TYPE XL5
> > loRS.Close
> >
> >
> >
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: [OT] Smart ForTwo by Mercedes

[Graham Brown (CompSYS)]

Nice cars, they did have a small problem with not being able to go round
corners though, well not quite true they *could* go round corners just
upside down thats all.

Always put me off them after that.


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of William Sanders / EFG
Sent: 26 March 2008 22:17
To: profox@leafe.com
Subject: RE: [OT] Smart ForTwo by Mercedes


Mr. B -
my apologies -
I seem to have the A110 stuck in the brain.
I Do, instead, mean the A160

here's some 'nice' info -
http://cgi.benl.ebay.be/MERCEDES-BENZ-Classe-A-W168-A-160-Classic-1998-1_W0Q
QitemZ320229282866QQihZ011

Mondo Regards [Bill]
--
William Sanders / efGroup



[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Any Quickbooks experts out there?

[Graham Brown (CompSYS)]

Thanks

QODBC looks promising.

I can get the info from the MySQL database without too much hassle. I guess
Fox8 should be able to do this with SQL/PT
Just trying to find some sample code to demo importing sales orders.

Cheers





-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Jeff Johnson
Sent: 26 March 2008 19:52
To: profox@leafe.com
Subject: Re: Any Quickbooks experts out there?


Hello Michael!  I have used the same format for 99 through 2007 without
any changes.

Jeff

Jeff Johnson
[EMAIL PROTECTED]
SanDC, Inc.
623-582-0323
Fax 623-869-0675

MB Software Solutions General Account wrote:
> Jeff Johnson wrote:
>> http://quickbooksgroup.com/webx/forums/importexport/2861
>>
>> Discusses Sales Orders.  I personally use .iif import files for bank
>> transactions and credit card transactions.
>>
>
> Hi Jeff,
>
> Do you mandate a certain version of QB be used?
>
> --Michael
>
>
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Any Quickbooks experts out there?

[Graham Brown (CompSYS)]

Hi

Nottingham (UK) is rather a long way to bring someone to demo!

It is supposed to be possible but just got through to their support line in
India and it is both possible and impossible to import to sales orders!




-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of MB Software Solutions General Account
Sent: 26 March 2008 18:01
To: ProFox Email List
Subject: Re: Any Quickbooks experts out there?


Graham Brown (CompSYS) wrote:
> Hi all
>
> I've been asked by a client if I can import sales order information into
> Quickbooks.
> The website refers to being able to import data in CSV format but doesn't
> say which modules.
>
> Appears that there are also three versions of QB so if anybody could tell
me
> which version I'd need to buy for them.
>
> Cheers
>
> Graham Brown
> CompSYS Software Solutions
> BNI Member. The Business Referral Organisation
>
>

I think Rick Borup advertises this as one of his services.  Also, Rick
Schummer could give some name(s), as I met the gentleman in Michigan
back in 2006.


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Any Quickbooks experts out there?

[Graham Brown (CompSYS)]

Hi all

I've been asked by a client if I can import sales order information into
Quickbooks.
The website refers to being able to import data in CSV format but doesn't
say which modules.

Appears that there are also three versions of QB so if anybody could tell me
which version I'd need to buy for them.

Cheers

Graham Brown
CompSYS Software Solutions
BNI Member. The Business Referral Organisation



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: [NF] PDF to DOC

[Graham Brown (CompSYS)]

Hi

I downloaded this
http://www.bluesquad.com/uk/prod.php?pid=1185&tr1=BS_UK_TR_PDFTW

hth
Cheers


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Charles Hart Enzer, M.D.
Sent: 25 March 2008 19:36
To: profox@leafe.com
Subject: Re: [NF] PDF to DOC


Dear Paul:

Looks neat.

Thank you.

I need one for XP SP2.

 Original message 
>Date: Tue, 25 Mar 2008 11:33:23 -0700
>From: Paul M¢Nett <[EMAIL PROTECTED]>
>Subject: Re: [NF] PDF to DOC
>To: [EMAIL PROTECTED]
>
>Charles Hart Enzer, M.D. wrote:
>> What tools do you suggest for:
>>
>>Text only
>>
>>Text and images
>
>This may or may not help. On Linux, there are some command-line tools
>such as:
>
>pdftotext
>pdftops
>pdftohtml
>pdfimages
>
>They do the job, with quality about what you'd expect from a tool that
>has to work backwards. pdftops (to postscript) tends to work the best,
>since postscript and pdf are related.
>
>pdftotext just gets the raw text with an attempt at formatting blocks of
>text that tends to miss the mark by a lot. But it gives good output for,
>e.g. indexing.
>
>I'm sure there are GUI tools built on top of these CLI tools, and I'm
>sure there are other solutions available on Windows, but I thought I'd
>mention these anyway. I've used them for years with good results.
>
>Paul
>
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: [NF] Unix webhosting - directory password protection

[Graham Brown (CompSYS)]

Thanks

I'll give that a go tomorrow.

Regards
Graham


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Ted Roche
Sent: 19 March 2008 19:40
To: profox@leafe.com
Subject: Re: [NF] Unix webhosting - directory password protection


On Wed, Mar 19, 2008 at 2:19 PM, Graham Brown (CompSYS)
<[EMAIL PROTECTED]> wrote:
>
>  Does anyone know how to retrieve the user name (and password) they used
to
>  login to the folder either with PHP/Perl?  I want to basically have
"Welcome
>  back..." then the persons name.
>



--
Ted Roche
Ted Roche & Associates, LLC
http://www.tedroche.com


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

[NF] Unix webhosting - directory password protection

[Graham Brown (CompSYS)]

Hi all

I have a few websites hosted on nix servers which have private folders so in
the online control panel they are set to require password.
When someone attempts to go to this folder in a browser they get a standard
windows login dialog.

Does anyone know how to retrieve the user name (and password) they used to
login to the folder either with PHP/Perl?  I want to basically have "Welcome
back..." then the persons name.


Graham Brown
CompSYS Software Solutions
M:07973 988939
E:[EMAIL PROTECTED]

BNI Member. The Business Referral Organisation



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Getting at Excel data from VFP

[Graham Brown (CompSYS)]

Hi Nick

The other link had some code to write back I think.
The problem looks like creating a new sheet with ADO which doesn't seem
possible. However I have dim distant recollections of ADOX (ADO
Extension/ADO Extensibility library) with Access Jet and a quick google
search for ADOX turned this up.

http://support.microsoft.com/kb/303814

Have a look and see if that's got it.

Please let us know how you get on...


Cheers


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of NickC
Sent: 17 March 2008 09:37
To: 'ProFox Email List'
Subject: RE: Getting at Excel data from VFP


Graham,

It certainly does work.  I currently have a small test, albeit VB script,
running on the server and reading from a spreadsheet.  Excel is not
installed on the server.

Next problem is seeing if ADO can also write to the new spreadsheet!

Thx for the ADO suggestion,

Nick



[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Getting at Excel data from VFP

[Graham Brown (CompSYS)]

Yep the articles looked interesting. Will have a look when I get 5 as well
as hadn't realised Excel can be queried with Jet.


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of NickC
Sent: 16 March 2008 15:54
To: 'ProFox Email List'
Subject: RE: Getting at Excel data from VFP


Thx Graham, looks like this will work.  ADO is apparently installed with IIS
so is present on the server.

Nick

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
> Of Graham Brown (CompSYS)
> Sent: 15 March 2008 15:17
> To: ProFox Email List
> Subject: RE: Getting at Excel data from VFP
>
> Hi
>
> What about this on technet?
>
> http://www.microsoft.com/technet/scriptcenter/resources/officetips/jun05/t
> ip
> s0607.mspx
>
> and this
>
> http://www.visualbasic.happycodings.com/Database_SQL_Stuff/code14.html
>
> It doesn't refer to having Excel loaded just the standard JET Oledb
> drivers.
> Not tried the code but it looks promising.
>
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Behalf Of NickC
> Sent: 15 March 2008 13:50
> To: 'ProFox Email List'
> Subject: RE: Getting at Excel data from VFP
>
>
> Thx Graham but that will only work on a machine that has Excel installed
> on
> it.
>
>
>
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Getting at Excel data from VFP

[Graham Brown (CompSYS)]

Hi

What about this on technet?

http://www.microsoft.com/technet/scriptcenter/resources/officetips/jun05/tip
s0607.mspx

and this

http://www.visualbasic.happycodings.com/Database_SQL_Stuff/code14.html

It doesn't refer to having Excel loaded just the standard JET Oledb drivers.
Not tried the code but it looks promising.


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of NickC
Sent: 15 March 2008 13:50
To: 'ProFox Email List'
Subject: RE: Getting at Excel data from VFP


Thx Graham but that will only work on a machine that has Excel installed on
it.




___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Getting at Excel data from VFP

[Graham Brown (CompSYS)]

This is some simple code I use to rip data from an Excel spreadsheet

Any use?


If messagebox("Import Suppliers",36,"Please confirm")=6
cFilename=getExFile("d:\suppliers.xls")  && getexfile just does a 
locfile
is the path is wrong
If !isnull(cFilename)
Sele 0

Use supplier
Zap

oXL=CREATEOBJECT("Excel.Application")
oWB=oXL.Workbooks.open(cFilename)
oWS=oWB.ActiveSheet
nMax=0

For EACH oRow IN oWS.Rows
If oRow.row=1
Loop
Endif
If empty(oRow.cells[1,1].value)
Exit
Endif

Append blank
Scatter memvar memo

m.changed_by="System"
m.changed_date=date()
m.created_by="System"
m.created_date=date()
m.su_add1=oRow.cells[1,4].value
m.su_add2=oRow.cells[1,5].value
m.su_add3=oRow.cells[1,6].value
m.su_add4=oRow.cells[1,7].value
m.su_add5=oRow.cells[1,8].value
m.su_add6=""
m.su_contact=""
m.su_email=""
m.su_fax=oRow.cells[1,13].value
m.su_ref=oRow.cells[1,1].value
m.su_telno=oRow.cells[1,12].value
m.su_vatcode="S"
m.su_vatrate=17.5

m.su_pcode=oRow.cells[1,9].value
m.su_name=oRow.cells[1,2].value
Gather memvar memo

Wait window m.su_name nowait noclear

Next
Use in supplier

Release oWS
Release oWB
Release oXL
Endif
Endif

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of NickC
Sent: 14 March 2008 14:54
To: 'ProFox Email List'
Subject: RE: Getting at Excel data from VFP


Hi Tracy,

The only reason for not installing Excel is that it is a Server that this
will run on; I am of the opinion that installing any MS Office product on a
server comprimises its security.  However, if there is an Excel 'Data part'
install that would be fine, unfortunately I can't fine anything like that.

Nick

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
> Of Tracy Pearson
> Sent: 14 March 2008 14:16
> To: profox@leafe.com
> Subject: RE: Getting at Excel data from VFP
>
> Disclaimer: I'm not a lawyer.
>
> Check into the licensing of Excel. Isn't there a part in there you can
> install it on multiple machines (up to 3 I think) as long as you are the
> only one using it, and only one instance at a time. Wouldn't this fall
> into
> that technically? You did mention this runs on its own in the middle of
> the
> night when most people which work in the office will be asleep.
>
> Tracy
>
> -Original Message-
> From: NickC
> Sent: Friday, March 14, 2008 10:11 AM
>
> Excel is being used as a database.  The initial problem with Append From
> is
> that on the first column (Id field) it adds a CHR(0) at the front of the
> field and chops off the last character.
>
> Nick
>
>
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: [NF] Search Engine Ranking Software

[Graham Brown (CompSYS)]

Hi all

Advanced Web Ranking looks like it will do the reporting.
http://www.advancedwebranking.com

You tell it the site URL, click the "Import meta keywords", select the
search engines and let it go.
This gives a readout of where a site is in the search engines. Took about an
hour to run through a fairly big site.
Very simple to use and also has a lot more functionality which I haven't
looked at yet.

Cheers
G



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Graham Brown (CompSYS)
Sent: 03 March 2008 17:09
To: ProFox Email List
Subject: [NF] Search Engine Ranking Software


Hi

Could anyone recommend any software which shows a sites ranking on the major
search engines.
I've come across a product called SEO Suite 8 but it is s complicated to
use I've given up with it.

Thanks

Graham Brown
CompSYS Software Solutions

BNI Member. The Business Referral Organisation



[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: [NF] Search Engine Ranking Software

[Graham Brown (CompSYS)]

Hi


The submission software I'm using sends to

Msn,AOL,Overture,Excite,Lycos,iWon,HotBot,DogPile,Ask Jeeves,
WebCrawler,MetaCrawler,Overture,InfoSpace,Netscape
Search,Alltheweb,About,Alexa
Go,Looksmart,NBCi, Search
King,Search.com,Espotting,EarthLink,ScrubTheWeb,Mamma,Teoma, Yahoo,altavista
Plus about 50 other SEs.

Some of these I'm not that fussed about because they probably share the same
database as google or yahoo (or nobody uses them!)

This is the info I get from an SEO company for one of my sites it arrives as
a pdf with lots of graphics so probably won't come out very well but it
shows me for certain keywords my sites position in certain search engines.
For approx $3000-$4000 per year I don't get all my search keywords or very
many search engines.

Page 1
Advanced Web Ranking Report
Project: Portable Floor Makers
25-Apr-2007 (Compare to 19-Apr-2007)
Visibility for www.portablefloormakers.co.uk
First Place: 13 In Top 10: 32 In Top 20: 38 In Top 30: 40
Moved Up: 6 Moved Down: 2 Gain/Loss: 4 Not Changed: 26
Added: 6 Dropped: 0 Ranked: 40 Not Ranked: 2
Visibility Score: 1022 Visibility Percent: 81.11% Keywords: 6 Search
Engines: 7
www.portablefloormaker
s.co.uk Altavista UK (UK) AOL UK (UK) Google UK Google UK (UK) Lycos UK MSN
UK Yahoo UK (UK)
banqueting chairs 13 5 6 2 5 1 16 3 14
banqueting tables 6 1 1 1 8 1 7
plastic chairs 25 5 5 1 5 2 1 22
plastic tables 11 2 3 2 2 2 1 12 1
portable bars 1 1 12 2 2 4 1 2
portable stages 1 1 4 1 4 1 2
Not Ranked Added Dropped
Moved Up Moved Down Not Changed

I can get Google Analytics stats for how well the site is doing but am
looking for more info to give the customer.

I don't know if that explains what I'm trying to achieve.

Regards




-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Paul McNett
Sent: 03 March 2008 19:09
To: profox@leafe.com
Subject: Re: [NF] Search Engine Ranking Software


Graham Brown (CompSYS) wrote:
> Could anyone recommend any software which shows a sites ranking on the
major
> search engines.
> I've come across a product called SEO Suite 8 but it is s complicated
to
> use I've given up with it.

What search engine, besides Google, do you consider "major"?

Paul


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

[NF] Search Engine Ranking Software

[Graham Brown (CompSYS)]

Hi

Could anyone recommend any software which shows a sites ranking on the major
search engines.
I've come across a product called SEO Suite 8 but it is s complicated to
use I've given up with it.

Thanks

Graham Brown
CompSYS Software Solutions

BNI Member. The Business Referral Organisation



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Tapi Intro

[Graham Brown (CompSYS)]

Hi

I've possibly got a project lined up which will be required to link my
existing fox 8 app to a Samsung PBX via tapi. The Samsung PBX has an API
library which ships with but I haven't seen this yet so don't know how good
it is or what it actually does. All I know is that it gives a tapi
interface.

If it happens the project is going to be to link a sales enquiry line, so
when the phone rings the operator answers it, the application shows all the
customers details. The current application without tapi asks for either the
client name or quotation reference and then uses this to pop up the info.

Could anyone point me in the direction of any general resources for fox and
tapi please?


Graham Brown
CompSYS Software Solutions
BNI Member. The Business Referral Organisation



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: [NF] charges on my bank card.

[Graham Brown (CompSYS)]

If it don't cost to query then I'd query just in case you're paying for
something you don't use.

I once had someone charge a lot of womens slinky underwear to my card. Gave
me some explaining to do, Mrs Brown thought she maybe had competition either
that or I'd started batting for the other team !!

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Michael Madigan
Sent: 21 January 2008 19:47
To: profox@leafe.com
Subject: [NF] charges on my bank card.


I'm getting this showing up on my online banking.  I
think it must be for an Internet service or something,
but I can't figure it out.

The bank can't tell me who it is unless I dispute it
and it will take a few days for me to find out who it
is.

This is how it shows up on my check card.  Does this
look familiar to anyone?

YBNMEMBE YBNMEMBERSE
LOS ANGELES CA

Nothing comes up when I Google it.  All the other
charges are clearly understandable, and most companies
put a telephone number with it.

They've been taking $7.50 a month out of my account
per month for a while.  I knew what it was when it
first started, but now I can't figure it out.  Today
they charged $165.40.

I think Alzheimer's is kicking in.






[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: interactivechange

[Graham Brown (CompSYS)]

Hi

I'd add another property to hold the original value/listindex and set this
in the gotfocus
Then in interactive if failed this.value/listindex =this.original

If that doesn't work please email back.


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Ailsom F. Heringer (OSKLEN)
Sent: 17 January 2008 17:41
To: profox@leafe.com
Subject: interactivechange


Hi All,

At a combobox, when InteractiveChange event is trigged, how can I cancel (or
not) the change and return to the original value ?



--
Aílsom F. Heringer
[EMAIL PROTECTED]
Skype: ailsom.osklen
Analista de Sistemas
--
Osklen
Departamento de Informática
Rio de Janeiro - RJ
BRASIL
http://www.osklen.com.br
55 21 22198971





--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Gantt Chart Source

[Graham Brown (CompSYS)]

Hi

Has anyone come across any freebie source for doing Gantt charts (like
Microsoft Project) in vfp8?

Cheers


Graham Brown
CompSYS Software Solutions
BNI Member. The Business Referral Organisation



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: combo box: How to undo changes ???

[Graham Brown (CompSYS)]

Not tried. What about adding a new property called original_value
In the gotfocus set this.original_value to this.value
InteractiveChange then has if failed this.value=this.original_value
I think you may need a nodefault in there as well.


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Ailsom F. Heringer (OSKLEN)
Sent: 15 January 2008 13:57
To: profox@leafe.com
Subject: combo box: How to undo changes ???


Foxers,



At the INTERACTIVECHANGE method of a combo box, depending on the item the
user must answer YES or NO to a message box. If the answer is NO, how can I
undo the change and set the combo box to its original selected item ?



--
Aílsom F. Heringer
[EMAIL PROTECTED]
Skype: ailsom.osklen
Analista de Sistemas
--
Osklen
Departamento de Informática
Rio de Janeiro - RJ
BRASIL
http://www.osklen.com.br
55 21 22198971





--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Cursor Adapters and autoinc field in vfp 8

[Graham Brown (CompSYS)]

Hi all

Hope someone can help with this because it is driving me nuts!!

I have this code snippet to insert a record into the customers table

** f_rn is auto Inc field in tblcustomers
** oCrCustomers is a cursor adapter to tblcustomers and returns alias of
customers
oCrCustomers.cSelectCMDFilter="f_rn=0"  && just create an empty cursor.
oCrCustomers.Cursorfill()
Select Customers
Append blank
repl cust_name with "Hello"
=tableupdate()

I'm trying to find an easy way to retrieve the value of f_rn for this
record, the only way I can see is to do

oCrCustomers.cSelectCMDFilter="cust_name='Hello'"
oCrCustomers.cursorfill()
m.f_rn=customers.f_rn

Thanks


Graham Brown
CompSYS Software Solutions
T:0845 202 8480

BNI Member. The Business Referral Organisation



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: [OT] computer job ads, then and now

[Graham Brown (CompSYS)]

The best one I had was from a chap I was interviewing for a promotion to the
development team.

He sat down and started running through his list of skills and then
proceeded to show me a Delphi project he'd written. I was just thinking this
guy is better than me when something just caught my eye.

I scrolled back to the top of the source file and there in big letters
"Copyright Borland Corporation". This chap was only trying to pass off the
Delphi samples as his own work !! Didn't even have the brains to remove the
standard comments.

He never did get the job...




-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Michael Madigan
Sent: 02 January 2008 23:10
To: ProFox Email List
Subject: Re: [OT] computer job ads, then and now


Yes.

Aditionally, the work ethic is lacking in many of
these guys.  We had one summer intern think nothing of
sleeping at his desk.  All he had to do was stay
awake, graduate, and he would have received an entry
level position.  But there was no way anyone was going
to sponsor him after catching him snoozing several
times.



--- Ricardo Aráoz <[EMAIL PROTECTED]> wrote:

> David Crooks wrote:
> > I can not imagine what the year 2020 will look
> like.  Can you?
> >
> >
> > Dec 27, 1994 ...
> >
> > PC REPAIR TECHNICIAN Individual must have 2-3
> years experience in the
> > repair of PC hardware with a strong electronics
> background Must able to
> > analyze run and take appropriate action. Must
> possess working knowledge
> > of MS-DOS ...
> >
> > ---
> >
> > Dec 21, 2007
> >
> > . Front end development with skills in JavaScript,
> CSS, Ajax, DOM,
> > DHTML, XHTML, XML, XSL, XSLT and 2-3 years with a
> server side
> > technology; PHP 5
> >and or Java.
> > . Experience building and integrating with AJAX
> frameworks, specifically
> > with DOJO widget driven architectures using dijit,
> and other JavaScript
> > frameworks. . Ability to quickly take mockups /
> comps and build
> > production ready CSS driven pages to defined
> specifications
> > incorporating cross browser rendering,
> >   performance and display issues.
> > . Ability to build scalable, efficient event
> driven UI features for
> > heavily trafficked site with 1.6 million+ daily
> unique visitors.
> > . Experiencing building and using Web services,
> JSON RPC, SOAP, WSDL,
> > REST, XML-RPC.
> > . Experience connecting widgets/Ajax enabled
> features with MySQL, Oracle
> > and other enterprise data sources.
> > . Test driven development experience and iterative
> process; SCRUM,
> > Agile, Pair / XP.
> > . Version control using Subversion.
> > . Flash, Actionscript experience a plus.
> > . Experience with servlet containers / app
> servers; Resin, Apache and
> > mod_caucho a plus
> >
> > David L. Crooks
> >
>
> I used to think I was under trained or something
> when reading those ads.
> Until in my previous job I met these young guys,
> average, some knowledge
> but what you would expect for their years. But if
> you took a look at
> their CV's you would've thought they were about to
> get a Nobel. All
> kinds of groups of upper case letters, but when you
> sat with them to
> solve a real problem they were average guys.
> Have you perceived the same thing over there?
>
>
>
>
>
> ___
> Post Messages to: ProFox@leafe.com
> Subscription Maintenance:
> http://leafe.com/mailman/listinfo/profox
> OT-free version of this list:
> http://leafe.com/mailman/listinfo/profoxtech
> Searchable Archive:
> http://leafe.com/archives/search/profox
> This message:
>
http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
> ** All postings, unless explicitly stated otherwise,
> are the opinions of the author, and do not
> constitute legal or medical advice. This statement
> is added to the messages for those lawyers who are
> too stupid to see the obvious.
>



[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: vfp9 report question - blank lines in the ASCII text file

[Graham Brown (CompSYS)]

I don't know if this helps but way back when I were a lad, blank lines in
dos report files were caused by overlapping fields.
Could I suggest creating a simpler version of your report and see if that
works.



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Rob Anderson
Sent: 24 December 2007 08:23
To: ProFox Email List
Subject: RE: vfp9 report question - blank lines in the ASCII text file


This works for me Kam :-

CREATE CURSOR rob (detail C(80))

INSERT INTO rob VALUES ("Line 1")
INSERT INTO rob VALUES ("Line 2")
INSERT INTO rob VALUES ("Line 3")

CREATE REPORT rep FROM rob

_ASCIIROWS = 66
_ASCIICOLS = 131

REPORT FORM rep TO FILE rep.txt ASCII

MODIFY FILE rep.txt

HTH,

Robbo.

Rob Anderson | Software Engineer | Pegasus, an Infor company | Tel: +44
(0)1536 49 5006 | Fax: +44 (0)1536 495214 | Mobile: +44 (0)7917 615401
Orion House, Orion Way | Kettering | Northants | NN15 6PE | UK
www.pegasus.co.uk



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of kam
Sent: 22 December 2007 23:47
To: ProFox Email List
Subject: vfp9 report question - blank lines in the ASCII text file

I want to get a plain ASCII file from the report writer. The manual says
use this code. this is an account's transaction listing

Set REPORTBEHAVIOR 80 && necessary to get an ASCII text file
*_Asciirows = 66<< I tried this, but it did not make any difference
*_Asciicols = 131   << I tried this, but it did not make any difference
Report Form (lcFrxTmpfname) To File (lctmpfile) Ascii
Set REPORTBEHAVIOR 90

This works, however, there is a blank line between every 2 transactions?
The report preview looks perfect? Anyone know how to stop
the extra blank lines?



[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Sub Reports/Joining two reports together

[Graham Brown (CompSYS)]

Hi all


I'm working on replacing a couple of Access products with Vis Fox. The
reports in Access use sub reports to join several together which looks kinda
nice.
I can do the same in fox with automation or using postscript and ghostscript
to send to a pdf. Both of these rely on external factors though (like having
word) so possibly not a good solution.

Could anyone think is there another way to accomplish the same in Fox v8?

Thanks

Graham Brown
CompSYS Software Solutions

BNI Member. The Business Referral Organisation



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Refox-concept for CHM?

[Graham Brown (CompSYS)]

Just seen the earlier posts saying its a hlp rather than a chm. Did the
command line thing work?
Failing that I'm fairly sure I have/had a piece of software on another pc
(Win98!) which may reverse it. The exe name to that is helpman but I can't
remember the name of the product.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Graham Brown (CompSYS)
Sent: 20 December 2007 14:37
To: ProFox Email List
Subject: RE: Refox-concept for CHM?


I've got something called html help workshop, no idea where it came from but
have just reversed a chm file with it.
This has given me all the html code and a HHC file. I've then opened the hhc
and can see the project.

If you want to email me the file off list to spam1 at compsysdotcodot.uk
I'll have a crack at it for you as long as I'm not going to breach anybody's
license !!


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of MB Software Solutions
Sent: 18 December 2007 20:37
To: Profox
Subject: Refox-concept for CHM?


We've got a CHM file but no source.  Is there a refox kind of
application for CHM files?

I found this via Google search:
http://www.grainge.org/pages/authoring/reverse_engineering/reverse_engineeri
ng.htm


...but wondered if others have successfully used a tool they could
recommend?

tia!
--Michael

--
Michael J. Babcock, MCP
MB Software Solutions, LLC
http://mbsoftwaresolutions.com
http://fabmate.com
"Work smarter, not harder, with MBSS custom software solutions!"



[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Refox-concept for CHM?

[Graham Brown (CompSYS)]

I've got something called html help workshop, no idea where it came from but
have just reversed a chm file with it.
This has given me all the html code and a HHC file. I've then opened the hhc
and can see the project.

If you want to email me the file off list to spam1 at compsysdotcodot.uk
I'll have a crack at it for you as long as I'm not going to breach anybody's
license !!


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of MB Software Solutions
Sent: 18 December 2007 20:37
To: Profox
Subject: Refox-concept for CHM?


We've got a CHM file but no source.  Is there a refox kind of
application for CHM files?

I found this via Google search:
http://www.grainge.org/pages/authoring/reverse_engineering/reverse_engineeri
ng.htm


...but wondered if others have successfully used a tool they could
recommend?

tia!
--Michael

--
Michael J. Babcock, MCP
MB Software Solutions, LLC
http://mbsoftwaresolutions.com
http://fabmate.com
"Work smarter, not harder, with MBSS custom software solutions!"



[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Recommendations for UK based touch screens.

[Graham Brown (CompSYS)]

Hi all

Has anyone got any recommendations for UK based touch screens suppliers?

I'm working on a shop floor data capture screen and the customer asked about
touch screens. (No doubt he has been playing one of those annoying higher or
lower card games you get in pubs/bars)

Thanks


Graham Brown
CompSYS Software Solutions
BNI Member. The Business Referral Organisation



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: outlook e-mail help

[Graham Brown (CompSYS)]

Any use?


oOutlook=Createobject("outlook.application")
If Type("oOutlook")="O" And Not Isnull(oOutlook)
oNameSpace=oOutlook.getNameSpace("MAPI")
If Type("oNameSpace")="O" And Not Isnull(oNameSpace)
oNameSpace.logon
oMSG=oOutlook.createItem(0)

With oMSG
.subject="Your Quotation from Portable 
FloorMaker Ltd"
cbody="Dear
"+Iif(Len(Trim(&cCursor..qh_salutation))=0,&cCursor..qh_salutation,"Sir/Mada
m")+Chr(13)+Chr(10)+Chr(13)+Chr(10)

.body=cbody
.recipients.Add(Rtrim(cEmail))
If File(cPDF)
.attachments.Add(cPDF)
Else
=Messagebox("Unable to open 
"+cPDF,16,"PDF Email Error")
Endif

.Display()
Endwith
Release oNameSpace
Endif
Release oOutlook

Endif


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Matthew Jarvis
Sent: 19 December 2007 00:17
To: profox@leafe.com
Subject: Re: outlook e-mail help


Bryant Minard wrote:
> I use the following code inside of VFP. I need to add an attachment like:
> "C:\CEMDATA.ZIP"
> Anyone have any ideas on addinf an attachment?
>


Somewhere on the VFUG website (www.vfug.org) should be my series on
Office Automation, and one of the articles should have an example of
doing the attachment.

Can't seem to pull up the website right now, but if I remember when I
get home tonight I'll try and dig up the code

Matthew S. Jarvis
IT Manager
Bike Friday - "Performance that Packs."
www.bikefriday.com
541/687-0487 x140
[EMAIL PROTECTED]


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: [OT] ? about one

[Graham Brown (CompSYS)]

"discuss philosophy"? why would you want to do that when Mr Tibbles has
already "volunteered"?


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Dave Crozier
Sent: 10 December 2007 17:25
To: 'ProFox Email List'
Subject: RE: [OT] ? about one


Kam,
The underlying theories are that:

1. If you drop a piece of toast, it will ALWAYS drop buttered side down.

2. When a cat falls it will always twist in mid air and hence land on its
feet.

Conundrum:
So, which of the "forces" would prevail, the buttered toast always landing
buttered side down, or the cat - always landing on its feet?

One to discuss in the Philosophy course I think.

Dave Crozier


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of kam
Sent: 10 December 2007 17:11
To: ProFox Email List
Subject: [OT] ? about one

at the risk of starting a stupid thread, I don't understand this one?

If you tied buttered toast to the back of a cat and dropped it from a
height, what would happen?




[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: [OT] ? about one

[Graham Brown (CompSYS)]

Would work equally well with Amy Winehouse but she is so out of it most of
the time, she probably wouldn't notice.


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Michael Madigan
Sent: 10 December 2007 17:27
To: ProFox Email List
Subject: RE: [OT] ? about one


Let's drop Hillary Clinton out of a plane with
buttered toast strapped to her back, and see what
happens.



--- Dave Crozier <[EMAIL PROTECTED]> wrote:

> Kam,
> The underlying theories are that:
>
> 1. If you drop a piece of toast, it will ALWAYS drop
> buttered side down.
>
> 2. When a cat falls it will always twist in mid air
> and hence land on its
> feet.
>
> Conundrum:
> So, which of the "forces" would prevail, the
> buttered toast always landing
> buttered side down, or the cat - always landing on
> its feet?
>
> One to discuss in the Philosophy course I think.
>
> Dave Crozier
>
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf
> Of kam
> Sent: 10 December 2007 17:11
> To: ProFox Email List
> Subject: [OT] ? about one
>
> at the risk of starting a stupid thread, I don't
> understand this one?
>
> If you tied buttered toast to the back of a cat and
> dropped it from a
> height, what would happen?
>
>
>
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: [OT] ? about one

[Graham Brown (CompSYS)]

lol

well toast does always land buttered side down and cats do always land on
their feet...

Would be cool to find out though, purely in the interests of science...
Give me a while and I'll try when both my wife and Tibbles the cat aren't
looking.

Cheers
G




-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of kam
Sent: 10 December 2007 17:11
To: ProFox Email List
Subject: [OT] ? about one


at the risk of starting a stupid thread, I don't understand this one?

If you tied buttered toast to the back of a cat and dropped it from a
height, what would happen?




[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

[OT] Finding new business

[Graham Brown (CompSYS)]

Hi all

I've been following the threads about coming out of contracting and getting
a proper job! Thought I'd share some thoughts with you.

All the business I get is from word of mouth referrals, I find this is a lot
easier than getting out there tendering for jobs etc.
I know at one stage a few years back I thought my business was going to dry
up so I set about finding ways to generate referral business. This is the
easiest way to find new work because someone else recommends me. This gives
me immediate credibility and also allows me to jump up the queue of
preferred suppliers.

Here in the UK we have various networking groups like the Business Link and
Federation of Small Business.

What I did was join the local chapter of a worldwide networking
organisation. Costs me about £700 per year which is far less than the cost
of advertising in the phone book!

In my local group I have 20 other companies all of whom introduce me to
contacts they have. As an example one of my products is aimed at
lift(elevator) servicing and I asked the group if someone could introduce me
into the largest lift installer in my home town (nottingham). Turns out one
of my fellow member's brothers is the national IT manager for that company
and I now have a meeting with him.

If you are struggling to find new work ask yourself if you have a word of
mouth referral strategy, if not then you really need one!

I've just started asking my existing customers to write me a bit of a
testimonial at the end of each project and if they could recommend me to
anyone else.
The testimonial is as much about advertising my customer as me so they also
get exposure. I also have various strategic partnerships with IT hardware
companies, they are an excellent source of referrals.

If you want to know more about how I find work for myself then take a look
at the BNI. Either http://www.bni.com (US) or http://www.bni.eu (Europe)
There are loads of Podcasts and advice about networking and referrals on the
site with links to other sites.

btw my customers don't care if I develop solutions in Vis Fox, they only
care if the solutions work so I don't get hung up on moving to other
products.
We need MS to sort out this vista nonsense for us and we're set for another
10 years!

I'd be interested to know what you think about this.


Graham Brown
CompSYS Software Solutions
BNI Member. The Business Referral Organisation

ps I'm not a salesman for the BNI/Business Link/Federation, I don't make any
commission and I'm not an affiliate!!



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: [NF] Audio Files on Web Page

[Graham Brown (CompSYS)]

Do you mean the file didn't get uploaded? Obvious things are to check to see
if it is going to the correct folder where you think it is going? Can you
use Secure FTP to upload all other types of files?

Also check with your hosting company, some prohibit certain file types so
possibly that could be a cause. I had one not allow Exes so had to zip
everything.

Just a thought.



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Allen
Sent: 04 December 2007 09:19
To: profox@leafe.com
Subject: RE: [NF] Audio Files on Web Page


I use frontpage :)
Allen

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Charles Hart Enzer, M.D.

I wrote a web page in html.

I put in a link to a WMA file.

Using Secure FTP, I could not find the WMA file in the local folder, let
alone SFTP it to the Web Server.

What do you suggest?

I want to put up 9 files for a total of about 30 minutes.

Thank you.


No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.503 / Virus Database: 269.16.13/1169 - Release Date: 03/12/2007
22:56




[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

[NF] .Net Crystal Reports

[Graham Brown (CompSYS)]

Hi all

When deploying a .NET application which uses Crystal Reports does the
customer need to buy crystal in order to run them?

Cheers

Graham
CompSYS Software Solutions
BNI Member. The Business Referral Organisation



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: [NF] Deploying a .NET application with Installshield

[Graham Brown (CompSYS)]

Hi Stephen

Isn't a setup normally an exe? Not used MSIs. I've VS2003 although I must
have 2005 in my actionpack somewhere.

I've been developing in fox for over 10 years but this one customer asked me
to port an Access database to VB so he can distribute it so although I've
done some ASP.NET it looks like I have to get my head VB.Net enough to give
him what he wants.

Cheers
Graham


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Stephen Russell
Sent: 23 November 2007 01:21
To: ProFox Email List
Subject: Re: [NF] Deploying a .NET application with Installshield


On Nov 22, 2007 5:25 PM, Graham Brown (CompSYS) <[EMAIL PROTECTED]> wrote:
> Hi all
>
> Is Installshield Express capable of building an installer for a VB.Net
> application? Can't make head nor tail of the installation project type in
> VS.

What are you trying to create for your final product, a msi?

What version of VS are you working with?

In VS2005 just rt click on the project and select publish.

HTH

__Stephen


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

[NF] Deploying a .NET application with Installshield

[Graham Brown (CompSYS)]

Hi all

Is Installshield Express capable of building an installer for a VB.Net
application? Can't make head nor tail of the installation project type in
VS.

Cheers


Graham Brown
CompSYS Software Solutions
BNI Member. The Business Referral Organisation



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Getting a Dropdown List to "loop"

[Graham Brown (CompSYS)]

Hi

I don't know if this post is still current but this works for me on the down
arrow.
Cheers



DEFINE CLASS frmdatamanagerformcustom1 AS frmdatamanagerformcustom


DoCreate = .T.
Name = "Frm1"

ADD OBJECT combo1 AS combobox WITH ;
ColumnCount = 0, ;
ColumnWidths = "", ;
RowSourceType = 1, ;
RowSource = "A,B,C,D", ;
FirstElement = 1, ;
Height = 24, ;
Left = 48, ;
NumberOfElements = 0, ;
Style = 2, ;
Top = 48, ;
Width = 100, ;
Name = "Combo1"


PROCEDURE combo1.KeyPress
Lparameters nKeyCode, nShiftAltCtrl

If nKeyCode=24 && down
If This.ListIndex=This.ListCount
This.ListIndex=1
NODEFAULT
Else

   Endif
ELSE
Endif
ENDPROC


PROCEDURE combo1.Init
=DODEFAULT()
this.ListIndex=1
ENDPROC


ENDDEFINE

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Paul Newton
Sent: 09 November 2007 15:19
To: profox
Subject: Getting a Dropdown List to "loop"


Hi all

I have a dropdown list with rowsource type 1 and three values and which is
working fine except that I would like it to "loop" if the user presses the
down-arrow key when its listindex is 3, or presses the up-arrow key when its
listindex is 1.  IOW if the user repeatedly presses either of these keys the
control will simply loop through the three values.

What would be the best way to achieve this - I've tried a couple of things
in the interactivechange and keypress events code but can't seem to get to
work the way I want

Thanks

Paul Newton


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: setting a form to autocenter based on a condition

[Graham Brown (CompSYS)]

Hi Jeff

Could you check sys(16) to see if it returns the .exe name? You should be
able to set autocenter true/false either in the form load or form init.
Not tried but I can't see why that wouldn't work.



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Jeff Roberts
Sent: 21 November 2007 22:13
To: profox@leafe.com
Subject: setting a form to autocenter based on a condition


Hi all,

I've been doing a lot of development on my laptop lately, and screen
space is tighter there.  I've got an app that most all the form's
autocenter property is set to true, and I'd like for that to be false
when I'm running the app or form under the vfp ide.  That way the form
pops up in the middle of the customer's screen when they are running
the exe but when I am working on the form it stays in the upper left,
not underlapping with my command window, debugger, etc.  Is there any
way to set a form's autocenter property before it runs, or is there an
alternative way to center the form?

Thanks,
Jeff


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

[OT] Our fantastic government

[Graham Brown (CompSYS)]

Hi

...and today's story of total incompetence is...

Our fantastic government have succeeded in "misplacing" two disks containing
the personal & banking info of 25 million people in the UK. Which is almost
half the population! They were evidently sending the disks in their internal
mail to the National Audit Office and they disappeared.

The spin doctors are saying there is no risk but we've already seen reports
popping up on MSN where people have lost substantial sums of money due to
identity theft.

Only in the UK don't you just love it.

Wonder if they'd like a nice foxpro database writing...?

Graham







___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: [OT] Joke

[Graham Brown (CompSYS)]

Probably really really funny after a few beers... did you try that?


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Eurico Chagas Filho
Sent: 17 November 2007 08:55
To: 'ProFox Email List'
Subject: [OT] Joke


Hi

Can someone explain to me the joke below ?

House, Michael (HNI Corp) [4:30 PM]:

here's a joke for you

House, Michael (HNI Corp) [4:30 PM]:

Three guys walk into a bar.

House, Michael (HNI Corp) [4:30 PM]:

the fourth one ducks!

Thanks, Eurico.

No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.503 / Virus Database: 269.15.32/1131 - Release Date: 14-Nov-07
16:54





[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: [NF] any PHP4 gurus out there?

[Graham Brown (CompSYS)]

Hi all

This simple application is for 3 companies I deal with. Signwriter, printer
and architect. The brief was to give them a simple page which will allow
their clients to upload artwork without messing around with ftp.

As you can see there is nothing earth shattering about it, the big thing was
the large file upload. I've tested with just under 90megs and that went
through ok.

I'm going to tart it up some more, probably rejecting scripts, exes, dlls
before giving it the graphics people to make it look pretty.

The pages are hosted on a linux server.


The html form
http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd";>
http://www.w3.org/1999/xhtml";>




function submitme(){
cMess="";
oform=document.forms[0];
if(oform.fldpname.value==""){
   cMess="Please enter your Project Name";
}
if(oform.fldname.value==""){
   cMess="Please enter your Name";
}
if(oform.fldphone.value==""){
   cMess="Please enter your Telephone Number";
}
if(oform.fldemail.value==""){
   cMess="Please enter your Email Address";
}
if(cMess!=""){
  alert(cMess);
  return false;
}
else{
  oform.submit();
}

}










Client Upload Area

Format:
No MAC files!
All files must be sent with CMYK-colour settings.
Use the following formats only: JPEG, PDF.
With vector graphic formats all text must be converted to paths!
Set up pixel images with 300 dpi to avoid loss of quality during
printing.
All text, logos, and important artwork must stay away from all edges by
a minimum of 5mm to avoid being cut off. 



Please enter your details in the spaces below
Some nice adverts can go in
here


Enter Project Name:



Your Name:



Your Company Name:



Your Address:








Your Telephone Number:



Your Fax Number:



Your Email Address:



How can we help?:





Choose a file to upload: 








css

body
{
font-family: "Helvetica Neue", Helvetica, sans-serif;
border: 1px solid #ff;
padding: 0px;
margin: 0px;
}

span.title
{
font-family: "Helvetica Neue", Helvetica, sans-serif;
font-size:40px;
font-weight:bold;
color:blue;
padding: 0px;
margin: 0px;
}

span.smalltitle
{
font-family: "Helvetica Neue", Helvetica, sans-serif;
font-size:20px;
font-weight:bold;
color:blue;
padding: 0px;
margin: 0px;
}
PHP.Ini needs to be in the root of the webspace.


max_execution_time=1200
max_input_time=1200
memory_limit=100M
post_max_size=100M
upload_max_filesize=100M
max_file_size=104857600
post_max_size=104857600
This is the upload file


http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd";>
http://www.w3.org/1999/xhtml";>







Client Upload Area


Upload Status.
Some nice adverts can go in
here




";
   echo "An email confirmation has also been sent to: " .
$_POST['fldemail'];
   if (isset($_POST['fldcname']))
   {
 //check if the email address is invalid
 $mailcheck = spamcheck($_POST['fldemail']);
 if ($mailcheck==false)
 {
$email="[EMAIL PROTECTED]";
$subject="File Uploaded";
$message="File uploaded from the website:\n\n";
$message=$message . "Project Name: ". $_POST['fldpname'] . "\n";
$message=$message . "Contact Name: ". $_POST['fldname'] . "\n";
$message=$message . "Company Name: ". $_POST['fldcname'] . "\n";
$message=$message . "Address:\n". $_POST['fldadd1'] . "\n";
$message=$message . $_POST['fldadd2'] . "\n";
$message=$message . $_POST['fldadd3'] . "\n";
$message=$message . $_POST['fldadd4'] . "\n";
$message=$message . $_POST['fldadd5'] . "\n\n";
$message=$message . "Phone: ". $_POST['fldphone'] . "\n";
$message=$message . "Fax: ". $_POST['fldfax'] . "\n";
$message=$message . "Email: ". $_POST['fldemail'] . "\n\n";
$message=$message . "Comments:\n". $_POST['fldcomments'] . "\n\n";
$message=$message . "The original filename was ". $filename . " and 
has
been saved to ". $newname . "\n";
$email_from="[EMAIL PROTECTED]";

mail($email, $subject,$message, "From: $email_from\r\nCC:
$email_from" );
$conf=$_POST['fldname'] . "\nWe have received your file and will
contact you shortly to discuss. If you have any questions in the meantime
please contact Yvonne on 01332.";
$conf=$conf. "\n\nBest wishes\nGraphics Ltd.";

mail($_POST['fldemail'],"Thankyou for using our upload
service",$conf,"From: $email_from\r\nCC: $email_from" );

 }
   }


}
else
{
  echo "Error: A problem occurred during file upload!";
}
  } else
  {
  echo "Error: File ".$_FILES["uploaded_file"]["name"]." already
exists";
  }
} else
{
  $message="";

  $message=$message . "Project Name: ". $_POST['fldpname'] . "\n";
  $message=$message . "Contact Name: ". $_POST['fldname'] . "\n";
  $message=$message . "Company Name: ". $_POST['fld

RE: [NF] any PHP4 gurus out there?

[Graham Brown (CompSYS)]

Well done Ted

It was the 100M in the form vars. Setting these to 1048... worked and I've
uploaded an 85mb file without problem to the website.
If anybody wants to see the full code please let me know.

Cheers
Graham





-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Ted Roche
Sent: 16 November 2007 19:43
To: profox@leafe.com
Subject: Re: [NF] any PHP4 gurus out there?


On Nov 16, 2007 2:29 PM, Graham Brown (CompSYS) <[EMAIL PROTECTED]> wrote:

> 

What happens if you change this to:



or if you want to be finicky, 104857600?

See the note at:

http://www.php.net/manual/en/faq.using.php#faq.using.shorthandbytes

--
Ted Roche
Ted Roche & Associates, LLC
http://www.tedroche.com


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: [NF] Sage question (mainly for UK guys)

[Graham Brown (CompSYS)]

Hi John

Sage should come with an ODBC driver
This is some simple vfp8 code to rip out the names and addresses.

I used Excel and MSQuery to find out the tables and field names.

nHandle=Sqlstringconnect("dsn=SageLine50v11;uid=manager")
If nHandle>=0
N=SQLEXEC(nHandle,"select * from sales_ledger order by 
address_1","temp")
If Select("temp")>0
oDE=Createobject("decust"+db_platform)
oDE.custsupp.lNoDataOnLoad=.F.
oDE.OpenTables()

Select temp
SCAN
WAIT WINDOW temp.address_1 NOWAIT noclear

SELECT custsupp
LOCATE FOR cs_name=temp.address_1
IF EOF()
APPEND BLANK
REPLACE cs_name WITH temp.address_1
ENDIF
REPLACE cs_add1 WITH temp.address_2,;
cs_add2 WITH temp.address_3,;
cs_add3 WITH temp.address_4,;
cs_postcode WITH temp.address_5,;
cs_telno WITH temp.telephone,;
cs_fax WITH temp.fax,;
cs_email WITH temp.email,;
cs_web WITH temp.web_address,;
cs_accno WITH temp.account_ref
=mtableUpdate()
SELECT temp

Endscan
oDE.CloseTables()
USE IN temp

Else
Wait Window "Unable to open Sage View"
ENDIF
SQLDISCONNECT(nHandle)

Else
Wait Window "Unable to access Sage"
Endif



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of John Weller
Sent: 16 November 2007 20:02
To: profox@leafe.com
Subject: [NF] Sage question (mainly for UK guys)


I am working with a local charity who have a few shops.  They need a simple
stock control system and have asked me to write one.  They are currently
using Sage Line 50 to hold their stock and find it far too complex for their
simple requirements and too inflexible for their situation.  My question
is - does any of the UK brethren know if data can be exported from Sage into
a CSV or similar?  If not I'll have the system produce a printout and direct
it to a text file and manipulate that to get the data but it would be easier
if I could get it directly.  I know Sage used to have that facility but I
hear that now you need an SDK which is not cheap.

TIA

John Weller
01380 723235
07976 393631



[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: [NF] any PHP4 gurus out there?

[Graham Brown (CompSYS)]

Hi


This is the html form which gets submitted, just straight forward html.









Client Upload Area



Format:
No MAC files!
All files must be sent with CMYK-colour settings.
Use the following formats only: JPEG, PDF.
With vector graphic formats all text must be converted to paths!
Set up pixel images with 300 dpi to avoid loss of quality during
printing.
All text, logos, and important artwork must stay away from all edges by
a minimum of 5mm to avoid being cut off. 



Please enter your details in the spaces below
Some nice adverts can go in
here


Enter Project Name:



Your Name:



Your Company Name:



Your Address:








Your Telephone Number:



Your Fax Number:



Your Email Address:



How can we help?:







Choose a file to upload: 





-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Ted Roche
Sent: 16 November 2007 19:25
To: profox@leafe.com
Subject: Re: [NF] any PHP4 gurus out there?


On Nov 16, 2007 2:02 PM, Graham Brown (CompSYS) <[EMAIL PROTECTED]> wrote:
>
> I'm working on some code to upload to a website cms via PHP.
> The script works fine up to 500k but errors on anything over at about 90
> seconds.
>

You don't supply the script, so it's hard to guess what's going wrong.
Are you using a PUT or POST?

The manual http://www.php.net/features.file-upload has some suggestions.


--
Ted Roche
Ted Roche & Associates, LLC
http://www.tedroche.com


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

[NF] any PHP4 gurus out there?

[Graham Brown (CompSYS)]

Hi all

I'm working on some code to upload to a website cms via PHP.
The script works fine up to 500k but errors on anything over at about 90
seconds.


The php.INI file has
max_execution_time=1200
max_input_time=1200
memory_limit=100M
post_max_size=100M
upload_max_filesize=100M
max_file_size=100M
post_max_size=100M

if((!empty($_FILES["uploaded_file"])) &&
$_FILES['uploaded_file']['error']==0 ) {
 The file $_FILES['uploaded_file']['error'] always equals 2
at this point for large files. but is fine for smaller files.

  $filename = basename($_FILES['uploaded_file']['name']);
  $ext = substr($filename, strrpos($filename, '.') + 1);
  //Determine the path to which we want to save this file
  $newname = dirname(__FILE__).'/upload/'.$filename;
  //Check if the file with the same name is already exists on the server
  if (!file_exists($newname)) {
//Attempt to move the uploaded file to it's new place
if ((move_uploaded_file($_FILES['uploaded_file']['tmp_name'],$newname)))
{

   echo "File " . $filename ." has been succcessfully transferred.
";
   echo "An email confirmation has also been sent to: " .
$_POST['fldemail'];
}
else
{
  echo "Error: A problem occurred during file upload!";
}
  } else
  {
  echo "Error: File ".$_FILES["uploaded_file"]["name"]." already
exists";
  }
} else
{

  echo "Error: No file uploaded";
  echo "The error returned was ";
  echo $_FILES['uploaded_file']['error'];

}

Appreciate it if anyone can shed any light because this is driving me nuts.

Regards
Graham



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Explorer at 99% utilisation

[Graham Brown (CompSYS)]

Thanks all

I'm back on site on monday so will see if the pointers sort it.

Regards
Graham

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Michael Madigan
Sent: 08 November 2007 21:39
To: ProFox Email List
Subject: Re: Explorer at 99% utilisation


First thing to do is to remove either Norton or AVG
from their system.  Two anti-virus programs can wreak
havoc.

Second is to shut off network disk scanning on all the
computers.

Third is to disable Windows Defender as it is always
causing problems.

Fourth is to check the system event log to see if
anything goofy is going on there.  Sometimes you get a
bad cluster in a paging file and it brings the system
to its knees.

I've noticed that if you have two opposing programs
that scan files, you're asking for problems.

Having Windows Defender and AVG anti-virus and
Carbonite backup all running on the same machine can
bring everything to a crawl.

Since I've disabled Windows Defender and Carbonite, my
computer flies.




[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Explorer at 99% utilisation

[Graham Brown (CompSYS)]

Hi

I don't know.

The IT chap on site said it wasn't AV but I can't see any other logical
explanation.


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Robert Jennings
Sent: 08 November 2007 17:55
To: profox@leafe.com
Subject: RE: Explorer at 99% utilisation


Graham,

I assume that the AV has been sorted out already?


Robert
Foxpro is will die in 2015, what is the next best language to go to?
Python?



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Graham Brown (CompSYS)
Posted At: 08 November 2007 17:49
Posted To: Profox Archive
Conversation: Explorer at 99% utilisation
Subject: Explorer at 99% utilisation


Hi all

Has anyone come across a problem on WinXP where the taskman reports
explorer at 99%?

My application is running on a small network of about 10-15 users. It is
VFP8 using CA's to a native fox dbc.
Normally the CA generates a cursor of 15000 records in a fraction of a
second.

When one user goes in and runs the query they get the 99% problem and
everybody else slows to a crawl and takes literally minutes to run the
same query. If I get everybody out and keep the problem machine logged
off the system runs normally.
The machine in question appears to have both AVG and Norton AV which
probably isn't good so I've asked them to flatten the pc and reinstall.

The last time I had this it was cabling but not this time.

Has anyone seen the same problem please?

Thanks
Graham




[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Explorer at 99% utilisation

[Graham Brown (CompSYS)]

Hi all

Has anyone come across a problem on WinXP where the taskman reports explorer
at 99%?

My application is running on a small network of about 10-15 users. It is
VFP8 using CA's to a native fox dbc.
Normally the CA generates a cursor of 15000 records in a fraction of a
second.

When one user goes in and runs the query they get the 99% problem and
everybody else slows to a crawl and takes literally minutes to run the same
query. If I get everybody out and keep the problem machine logged off the
system runs normally.
The machine in question appears to have both AVG and Norton AV which
probably isn't good so I've asked them to flatten the pc and reinstall.

The last time I had this it was cabling but not this time.

Has anyone seen the same problem please?

Thanks
Graham




___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

[NF] Outlook Calendar

[Graham Brown (CompSYS)]

Hi all

I've recently had to rebuilt my PS file on Outlook2k. Since I've done this
the calendar doesn't highlight the days properly.

The calendar is day view mode so I have the appointments for today in the
middle of the screen and the calendar display for this month and next month
on the right. Before the right hand calendar view would highlight the days
where I have a meeting in bold text so I can see at glance I'm supposed to
be somewhere.

No idea why this is not working now.

Anybody seen this before please?

Thanks
Graham



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Ideas for trial versions

[Graham Brown (CompSYS)]

Yep neat!

On a networked app I also limit to one user accessing the data. I also use
the limit on the main tables, example only 20 customers, products, jobs etc
As it is one base class that controls all data access really easy to
implement.

but don't do what Winzip used to do, "You are now on day 726 or you 14 day
evaluation"!!

Do you need to watch taking access to a system away completely though, I
used to limit the days so after 60 it just said "Thanks, now buy or go forth
you cheapskate" and log 'em out. One of the solicitors said I couldn't do
this. I had to make the system read only after so many days. Never found out
what the legal precedent was for this though.

Graham


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Michael J. Babcock, MCP
Sent: 25 October 2007 15:16
To: profox@leafe.com
Subject: Re: Ideas for trial versions


On Thu, October 25, 2007 10:01 am, Alan Bourke wrote:
> Yes that's what I meant.
>
>
> How about increasing the transparency of your forms depending on days
> past the trial expiration?  :)
>


LOL!  I love it!  ;-)



[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: [NF] Animated GIFs

[Graham Brown (CompSYS)]

I used gif construction a while back.

http://www.mindworkshop.com/alchemy/gifcon.html

regards


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Michael J. Babcock, MCP
Sent: 23 October 2007 16:54
To: profox@leafe.com
Subject: [NF] Animated GIFs


What's the easiest way to make an animated GIF file (from your experience)?

tia!
--Michael




[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: [NF] Ordnance survey maps x/y coordinates

[Graham Brown (CompSYS)]

PHP code

The hwz_postcodes table contains fields outcode (postcode), longitutde,
latitude, x, y
The outcode is just the first bit of the postcode ie LE1,LE2,LE3 and
contains about 2000 entries. I found a website where these were all listed
and could be copied straight off, will see if I can find it again.

It receives a post field called POSTCODE. The customers table is just a list
of stockists (name, address, phone, fax, postcode etc etc).

I've got to fix a bug with this code whereby if the postcode is not in
hwz_postcodes it shows rubbish.


 4){
   $temp1 = wordwrap($postcodeA, 4, "/", true);
   $temp=strtoupper($temp1);
   list($postcodeA, $rubbishA)  = split('[/.-]',$temp);
}
//x and y of A

$string = sprintf("SELECT * FROM hwz_postcodes WHERE outcode='%s'",
mysql_real_escape_string($postcodeA));
$query = mysql_query($string);
$array = mysql_fetch_row($query);
$xA = $array[2];
$yA = $array[3];
$i = 0;
$main_query = mysql_query("SELECT postcode FROM customers");

while ($main_array = mysql_fetch_array($main_query))
{
   if ($main_array[0])
   {
  $postcodeB = $main_array[0];
  $postcode = $main_array[0];
  $temp2 = wordwrap($postcodeB, 4, "/", true);
  $temp3=strtoupper($temp2);
  list($postcodeB, $rubbishB)  = split('[/.-]',$temp3);
  //x and y of B
  $string = sprintf("SELECT * FROM hwz_postcodes WHERE outcode='%s'",
mysql_real_escape_string($postcodeB));
  $query = mysql_query($string);
  $array = mysql_fetch_row($query);
  $xB = $array[2];
  $yB = $array[3];
  //distance
  $x = $xB - $xA;
  $y = $yB - $yA;
  $distance = sqrt(($x * $x) + ($y * $y)) / 1609.344;
  $distance =sprintf("%10.1f\n", $distance);
  if ($distance < $distance_tmp)
  {
 $distance_tmp = $distance;
 $postcode_tmp = $postcode;
  }
  $i++;
   }
}
$string = sprintf("SELECT * FROM customers WHERE
postcode='%s'",mysql_real_escape_string($postcode_tmp));
$query = mysql_query($string);
$array = mysql_fetch_row($query);
?>
Your nearest
store is ");
if ($array[8]){
echo"http://".$array[8]."\";>";
}
echo nl2br($array[1]."".$array[2]." ".$array[3]." ".$array[4]."
".$array[5]."".$array[6]);
if ($array[7]) {
echo "Telephone: ".$array[7];
}
?>

Regards
Graham


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Dave Crozier
Sent: 16 October 2007 07:56
To: 'ProFox Email List'
Subject: RE: [OT] Ordnance survey maps x/y coordinates


Graham,
Shouldn't really be [OT] as other developers may be interested. I'd make it
[NF]

Dave Crozier


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Graham Brown (CompSYS)
Sent: 15 October 2007 18:58
To: ProFox Email List
Subject: [OT] Ordnance survey maps x/y coordinates

Hi all

Completely off topic this one.

I've inherited some really neat PHP code today which takes a UK postcode
(zipcode!) and looks in a database to find the nearest database record with
that postcode. The php code is basically for entering your postcode and
finding where the nearest stockist is to your location. It does this by
using the Ordnance Survey X/Y coordinates and looking up the first part of
the postcode "LE4" to find the X/Y.
Mainland UK postcodes can be easily looked up with
http://www.streetmap.co.uk/streetmap.dll?GridConvert?name=CV32%204AT&type=Po
stcode

The code works really well but before I port it to VFP I've tested it with
Jersey (little place between the mainland uk and france!) and it fails.
Although I have the JE2 postcode I can't find anywhere which publishes the
OS x/y for the channel islands.

Would anyone happen to know if Ordnance Survey is one of the quirky mainland
uk things or where i can find OS cordinates for outside the mainland uk.

ps if anybody wants the php code let me know!

Cheers
Graham






[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

[OT] Ordnance survey maps x/y coordinates

[Graham Brown (CompSYS)]

Hi all

Completely off topic this one.

I've inherited some really neat PHP code today which takes a UK postcode
(zipcode!) and looks in a database to find the nearest database record with
that postcode. The php code is basically for entering your postcode and
finding where the nearest stockist is to your location. It does this by
using the Ordnance Survey X/Y coordinates and looking up the first part of
the postcode "LE4" to find the X/Y.
Mainland UK postcodes can be easily looked up with
http://www.streetmap.co.uk/streetmap.dll?GridConvert?name=CV32%204AT&type=Po
stcode

The code works really well but before I port it to VFP I've tested it with
Jersey (little place between the mainland uk and france!) and it fails.
Although I have the JE2 postcode I can't find anywhere which publishes the
OS x/y for the channel islands.

Would anyone happen to know if Ordnance Survey is one of the quirky mainland
uk things or where i can find OS cordinates for outside the mainland uk.

ps if anybody wants the php code let me know!

Cheers
Graham






___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Reporting differences on HP Laser

[Graham Brown \(CompSYS\)]

Hi Dave

Hadn't noticed that setting.

Will try that.

Thanks


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Dave Crozier
Sent: 03 October 2007 12:01
To: 'ProFox Email List'
Subject: RE: Reporting differences on HP Laser


Graham,
Have you tried setting the Print area to "Whole Page" as opposed to
Printable Page in the Report Designer File/Page Setup options?

Dave Crozier


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Graham Brown (CompSYS)
Sent: 03 October 2007 11:42
To: ProFox Email List
Subject: Reporting differences on HP Laser

Hi all

I have a landscape report which is printed on a HP Laser (6L from memory)
and it is fine. I then print to the same report having stripped out the tag
and expr fields to a HP (1320 from memory) and the print is 2 inches over to
the right which is not so good. I am thinking margin or something like but
can't see anything special about the 1320 printer.

I always thought windows print drivers removed the issues with printing to
different printers and they have always looked the same whenever I've done
this in the past.

Any idea why a 1320 would look completely different to a 6L.

Regards
Graham



[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Reporting differences on HP Laser

[Graham Brown \(CompSYS\)]

Hi Michael

Both A4.

Regards

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Michael Hawksworth
Sent: 03 October 2007 11:53
To: profox@leafe.com
Subject: RE: Reporting differences on HP Laser


Form size default on printers different?

Regards
Michael Hawksworth


> -Original Message-
> From: [EMAIL PROTECTED] [mailto:profoxtech-
> [EMAIL PROTECTED] On Behalf Of Graham Brown (CompSYS)
> Sent: 03 October 2007 11:42
> To: [EMAIL PROTECTED]
> Subject: Reporting differences on HP Laser
>
> Hi all
>
> I have a landscape report which is printed on a HP Laser (6L from
> memory)
> and it is fine. I then print to the same report having stripped out the
> tag
> and expr fields to a HP (1320 from memory) and the print is 2 inches
> over to
> the right which is not so good. I am thinking margin or something like
> but
> can't see anything special about the 1320 printer.
>
> I always thought windows print drivers removed the issues with printing
> to
> different printers and they have always looked the same whenever I've
> done
> this in the past.
>
> Any idea why a 1320 would look completely different to a 6L.
>
> Regards
> Graham
>
>
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Reporting differences on HP Laser

[Graham Brown \(CompSYS\)]

Hi all

I have a landscape report which is printed on a HP Laser (6L from memory)
and it is fine. I then print to the same report having stripped out the tag
and expr fields to a HP (1320 from memory) and the print is 2 inches over to
the right which is not so good. I am thinking margin or something like but
can't see anything special about the 1320 printer.

I always thought windows print drivers removed the issues with printing to
different printers and they have always looked the same whenever I've done
this in the past.

Any idea why a 1320 would look completely different to a 6L.

Regards
Graham



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

FW: Highlighting item in a treeview

[Graham Brown (CompSYS)]

Hi all

Just had to drop back onto this one again and the darned thing is still
eluding me, am I going crazy or what?!

If anybody could I shed any light on why this isn't playing I'd appreciate
it.

Regards
Graham


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Graham Brown (CompSYS)
Sent: 21 September 2007 14:33
To: ProFox Email List
Subject: Highlighting item in a treeview


Hi all

I'm sure this shouldn't be as difficult as I'm making it! I'm working on a
project which calls for a treeview and grid to be in sync so move one and
the other moves.

I need to highlight the entry in a treeview and for some strange reason I
can't get it to work. The ensurevisible method is firing fine and expands
the nodes of the tree as expected.

I thought it was oTree.nodes.item("J1").selected=.t. but that doesn't want
to play.

I need a sanity check please!

Cheers
Graham





[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: DBFs disappearing when PACKing

[Graham Brown \(CompSYS\)]

Some more questions!

(sorry, couldn't remember if the file created by pack was a tbk,bak or tmp
but tmp makes sense)

I don't know if a pack does a delete dbf, rename tmp to dbf, delete tmp so
it may be an idea to check you can both rename and delete files in explorer
just in case it is a rights issue. I had one "it specialist" remove delete
rights for my application so it crapped out whenever it tried to remove temp
files.
As some temp files are in memory and don't touch the disk the error message
looked sporadic until I worked out what he'd done.

Diskspace? make sure there is definitely enough space for the real file and
its copy. As fox can/does stick files in c:\windows\temp (set("_temp")?)
make sure you have local diskspace also.

Do any of the files show as readonly in explorer/file properties.

Does the account you are running in have local rights to c:\. Ensure the
logged on network user is a local admin to check.

You can also identify if its a rights issue by running as admin on the
domain.
For XP and beyond it may be worth setting the network user up as a local
admin also

I would certainly suggest turning antivirus off for a moment or ensure it is
not scanning dbf,fpt etc etc.

Has Norton AV been on the machines previously, norton is notorious for not
uninstalling properly particularly where script blocking is concerned.

Cheers
Graham#




-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of John J. Mihaljevic
Sent: 27 September 2007 17:40
To: profox@leafe.com
Subject: RE: DBFs disappearing when PACKing


Hi all,

Just did some more testing on this, so here are some answers to the
questions that were asked of me yesterday.

First off, it's apparently not a VFP9 problem, as it's also happening with
VFP6.  That leads me to believe there's some kinda networking issue (Server
2003 on our server) or a Vista issue (on each of our workstations).
Combining this with the fact that we're unable to save files on our server
from Microsoft Office 2007, I'm starting to think it's some kinda rights
issues.  But even so, here are my responses to the emails I got from
everyone yesterday (Thanks much to everyone!!!):

> From: [EMAIL PROTECTED] [mailto:profoxtech-
> [EMAIL PROTECTED] On Behalf Of Graham Brown (CompSYS)
>
> "it's gone.  The CDX is still there, but the DBF is gone."
>
> Sorry didn't make clear, is there a parts.tbk instead of the dbf when
> it vanishes?

There is not, but there's a big TMP file there.  When I USE that TMP file,
it appears to be the original DBF with the deleted records successfully
removed.  Strange that it'd stay in a TMP file and not the correctly-named
DBF.

> From: [EMAIL PROTECTED] [mailto:profoxtech-
> [EMAIL PROTECTED] On Behalf Of John Weller
>
> A WAG - is the index corrupt?

The index file is fine.  I've reindexed and tried this with several files.
Which brings me to your next question...

> Does this happen with other DBFs or just Parts?

It happens with every DBF I try to PACK on the network.  I can successfully
PACK DBFs on my local C-drive, but not on our network's F-drive.

> From: [EMAIL PROTECTED] [mailto:profoxtech-
> [EMAIL PROTECTED] On Behalf Of Peter Cushing
>
> How many records are in the table and how many should be there after
> the pack?

In one example, there are 13,963 records in the original DBF.  I tried
deleting one, and the TMP I mentioned above has 13,962 records, which is
correct.  The only problem is the error message and the fact that it's
leaving me with a TMP file instead of the correctly-named DBF file.

> Have you tried doing the same thing with a version on the C drive to
> see if it makes any difference?

Yes.  Everything is fine on C.

> Is the table free standing or part of a DBC

This is a free-standing DBF.

> From: [EMAIL PROTECTED] [mailto:profoxtech-
> [EMAIL PROTECTED] On Behalf Of Graham Brown (CompSYS)
>
> When a table is packed doesn't it copy to a temp name either a tbk or
> bak or something like delete then copy back the other way.

Apparently so, since I'm getting a TMP with the correct data.

> From: [EMAIL PROTECTED] [mailto:profoxtech-
> [EMAIL PROTECTED] On Behalf Of Tracy Pearson
>
> I recently had several clients running an anti-virus called BitDefender
> which caused this problem.
> I now pack the files manually with zap and append commands.
> XP, Vista, Local, or Network didn't matter. The common factor was
> BitDefender.

I'm using McAfee on this machine.

> From: [EMAIL PROTECTED] [mailto:profoxtech-
> [EMAIL PROTECTED] On Behalf Of Vince Teachout
>
> I don't know the answer, but if you do this:
> Use Parts Order 1 Excl
> Set Deleted OFF
> Copy for .NOT. Deleted() to MyTest
>
> Question: Does Mytest now exist, and 

RE: [NF] How to Open CAB File

[Graham Brown \(CompSYS\)]

Quick google search from annoyances.org!

Using .CAB Files

Intended For
Windows 98
Windows 95

When using a complex operating system with hundreds of support files, like
Windows, every once in a while you'll need to get one of the files off of
the distribution diskettes. These files are often compressed into CAB
(cabinet) files, which are similar to ZIP files.
If you're using Windows Me, 2000, or XP, CAB file support is built-in.

If you're using Windows 95 or 98, you'll need the CabView utility (one of
Microsoft's PowerToys).

Just double-click a CAB file to open it - files can be extracted by dragging
them out of the CAB window.

To create new Cabinet files, obtain the DOS-based CAB Maker utility.


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Charles Hart Enzer, M.D.
Sent: 25 September 2007 17:30
To: profox@leafe.com
Subject: [NF] How to Open CAB File


I want to install WinDiff from the Folder [c:\SWTOOLS]

What are the steps/

Thank you.

--  Charles Hart Enzer, M.D.  --
Past President
Child and Adolescent Psychiatry Council of Cincinnati and Dayton
Mailto:[EMAIL PROTECTED]
Website: http://capccd.org



[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: DBFs disappearing when PACKing

[Graham Brown \(CompSYS\)]

When a table is packed doesn't it copy to a temp name either a tbk or bak or
something like delete then copy back the other way.

I have a dim distant recollection that an IT guy I used to work with created
this problem with a rights problem. Certainly running local should prove
this.

Also when I pack tables I lock the dbc exclusive as well just to be safe.





-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Vince Teachout
Sent: 25 September 2007 17:21
To: ProFox Email List
Subject: Re: DBFs disappearing when PACKing



>> Date: Tue, 25 Sep 2007 11:44:42 -0400
>> From: "John J. Mihaljevic" <[EMAIL PROTECTED]>
>> Subject: DBFs disappearing when PACKing
>>
>> I'm using a DBF in VFP9 on a machine with Vista Business:
>>
>>USE parts ORDER 1 EXCL
>>
>> When I issue the PACK command, I get a window that reads:
>>
>>File f:\prices9\parts.dbf does not exist.
>>
>
I don't know the answer, but if you do this:
Use Parts Order 1 Excl
Set Deleted OFF
Copy for .NOT. Deleted() to MyTest

Question: Does Mytest now exist, and if so, is it the same size?
If not I would guess data corruption.
Continuing:

USE MyTest EXCLU
PACK

Question: Does Mytest still exist, or is it gone, also?



[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: DBFs disappearing when PACKing

[Graham Brown \(CompSYS\)]

"it's gone.  The CDX is still there, but the DBF is gone."

Sorry didn't make clear, is there a parts.tbk instead of the dbf when it
vanishes?


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of John J. Mihaljevic
Sent: 25 September 2007 16:52
To: profox@leafe.com
Subject: RE: DBFs disappearing when PACKing


There is not.  Just a DBF, CDX and BAK (as well as an SCT and SCX for a
form).

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:profoxtech-
> [EMAIL PROTECTED] On Behalf Of Graham Brown (CompSYS)
> Sent: Tuesday, September 25, 2007 1:14 PM
> To: [EMAIL PROTECTED]
> Subject: RE: DBFs disappearing when PACKing
>
> Is there a tbk with the same name?
>
>
>
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Behalf Of John J. Mihaljevic
> Sent: 25 September 2007 16:45
> To: profox@leafe.com
> Subject: DBFs disappearing when PACKing
>
>
> Hi all,
>
> I'm using a DBF in VFP9 on a machine with Vista Business:
>
>   USE parts ORDER 1 EXCL
>
> When I issue the PACK command, I get a window that reads:
>
>   File f:\prices9\parts.dbf does not exist.
>
> And when I go to use the file again (or to simply browse for it in
> Windows),
> it's gone.  The CDX is still there, but the DBF is gone.
>
> Any idea why the DBF could be disappearing?  This has happened several
> times.
>
> Thanks!
>
>
>
>
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: DBFs disappearing when PACKing

[Graham Brown \(CompSYS\)]

Is there a tbk with the same name?




-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of John J. Mihaljevic
Sent: 25 September 2007 16:45
To: profox@leafe.com
Subject: DBFs disappearing when PACKing


Hi all,

I'm using a DBF in VFP9 on a machine with Vista Business:

USE parts ORDER 1 EXCL

When I issue the PACK command, I get a window that reads:

File f:\prices9\parts.dbf does not exist.

And when I go to use the file again (or to simply browse for it in Windows),
it's gone.  The CDX is still there, but the DBF is gone.

Any idea why the DBF could be disappearing?  This has happened several
times.

Thanks!





[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Highlighting item in a treeview

[Graham Brown \(CompSYS\)]

Hi all

I'm sure this shouldn't be as difficult as I'm making it! I'm working on a
project which calls for a treeview and grid to be in sync so move one and
the other moves.

I need to highlight the entry in a treeview and for some strange reason I
can't get it to work. The ensurevisible method is firing fine and expands
the nodes of the tree as expected.

I thought it was oTree.nodes.item("J1").selected=.t. but that doesn't want
to play.

I need a sanity check please!

Cheers
Graham





___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: All Computers on Network Lock up

[Graham Brown (CompSYS)]

I have a dim distant recollection that having the "always suspend" checked
also created this problem? Been a while since I last worked in 2.
This was a setting on the shortcut on the program tab.
may be worth having a look.

Graham



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Michael Madigan
Sent: 23 August 2007 22:33
To: ProFox Email List
Subject: Re: All Computers on Network Lock up


Slow down or lock up?

They may have anti-virus software scanning the network
drive.

Set their antivirus softare to not scan the network
drive.

If that fixes it, remind them that it wasn't you're
fault.


--- Kent Belan <[EMAIL PROTECTED]> wrote:

> Hello,
> I have a client running an old FPW 2.6 app.
> They just got 3 new Dell XP computers.
>
> The computers lockup occassionally and they are
> blaming my app
> because that is what they are using when it locks
> up.
>
> What is strange is that all 3 computers lock up at
> the same time.
>
> I find it hard to believe it is my app that causes
> other computers
> to lock up.
>
> Anyone heard of this or have any ideas ?
>
> Thanks,
> Kent
>
>
>
> ___
> Post Messages to: ProFox@leafe.com
> Subscription Maintenance:
> http://leafe.com/mailman/listinfo/profox
> OT-free version of this list:
> http://leafe.com/mailman/listinfo/profoxtech
> Searchable Archive:
> http://leafe.com/archives/search/profox
> This message:
>
http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
chsi.com
> ** All postings, unless explicitly stated otherwise,
> are the opinions of the author, and do not
> constitute legal or medical advice. This statement
> is added to the messages for those lawyers who are
> too stupid to see the obvious.
>



[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

[OT] From a grateful nation...

[Graham Brown \(CompSYS\)]

To all Americans

On behalf of we Brits could I express our gratitude at your taking Victoria
Beckham AKA Posh Spice AKA the pounty one off our hands !!
Having seen the news last night she seems to be really settled and there is
absolutely no need to send her back. We hope her talent (lack thereof)
brings a ray of sunshine to you all.

btw also saw on the news last night. President Bush appeared to have a go at
running our prime minister over with a golf cart, he seemed to be going
round and round in circles with Gordon clinging on for his life. Could
clearly hear the people in the background laughing. Interesting that this
clip hasn't appear on any further news bulletins since!

10 out of 10 for the idea but must try harder, next time tyre tracks over
his middle please.

Again many thanks

Signed
The Brits



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: VFP9-CRM

[Graham Brown \(CompSYS\)]

Hi

I don't know if this helps

What I have in my systems is an eventlog table basically contains a
datetime, user,table name and memo
The memo has entries like: -
Contact name changed from "Fred" to "Bill"
Phone changed from "0116" to "0117"

I've hooked into the tableupdate so that it scans the table being updated
and generates the event log record. There isn't much of an overhead as the
eventlog table is not keep long and doesn't take too much effort to update.

I only use this to find keying errors, but theoretically I could union join
different event logs and roll back to any given date. Never had to but its
there.

Another alternative which I use on newer systems is also to have datetimes
for when the record was created and when it was last updated.



Cheers
Graham



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of MB Software Solutions
Sent: 26 July 2007 01:35
To: profox@leafe.com
Subject: Re: VFP9-CRM


Sytze de Boer wrote:
> I have a client with an Access database which they refer to as their CRM
system.
> (Developed by an in-house chap who is no longer there)
>
> They also use my accounting system for Receivables, Payables, GL, Payroll,
etc
> They have asked me to convert the CRM system into VFP and to integrate
> it with the rest of the system.
>
> Biggest problem that I see is the synchronizing of this data.
> i.e.
> 1  Client copies the system to his laptop
> 2  Goes overseas and updates contact details, sales discussions, etc
> 3  Comes back and wants to synch it with Head Office data
>
> Does anyone have such a module already or does anyone have ideas about
> the best way to handle synchronization?
>
>

My only suggestion for offline scenarios would be to use GUIDs as your
keys instead of integers to ensure uniqueness.  That should allow you to
see what you have different from another computer's data.

--
Michael J. Babcock, MCP
MB Software Solutions, LLC
http://mbsoftwaresolutions.com
http://fabmate.com
"Work smarter, not harder, with MBSS custom software solutions!"



[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: [NF] Moving files off a laptop for an ex-employee

[Graham Brown \(CompSYS\)]

I don't know if this helps but a quick google search turned this up

"Mozilla Firefox Bookmarks:

For Mozilla Firefox favorites, open the Firefox browser.  Click on
Bookmarks -> Manage Bookmarks.  In the new window, click on File -> Export.
In the new window, use the drop down menu at the top to navigate to the
folder where the bookmarks will be saved.  Click Save to finish."

Cheers
Graham


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of MB Software Solutions
Sent: 24 July 2007 16:43
To: Profox
Subject: [NF] Moving files off a laptop for an ex-employee


I'm laying off a person and would like to take their stuff off of the
company laptop and put it on a CD for them, including their bookmarks.
I looked in the directory tree under Program Files\Mozilla Firefox but
didn't see the obvious file for their bookmarks.  Can someone tell me
where to find it?  (Other stuff is easily moved via the Send To option,
of course.  I just need to locate the bookmarks file.)

tia,
--Michael

--
Michael J. Babcock, MCP
MB Software Solutions, LLC
http://mbsoftwaresolutions.com
http://fabmate.com
"Work smarter, not harder, with MBSS custom software solutions!"



[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: VFP / SQL Performance and Configuration

[Graham Brown \(CompSYS\)]

Yep,
I totally agree I've just had my chaps put in a second server (which is
about the size of a small car!) on one site for just Exchange and a
file/printer share type things, the sql app runs elsewhere

We used to get some big joke type movies emailed or downloaded and before
you knew it every user would forward it to every other user going round and
round which would quite happily cripple the lan.

Exchange needs a minimum of 1gb just for itself? I'm sure we spec'd the
server with far more memory than that. Aside from what MS recommend because
its gonna need more if you'd like to know what we recommend I'll ask the
hardware guys.

Regards




-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of mrgmhale
Sent: 19 July 2007 14:03
To: profox@leafe.com
Subject: RE: VFP / SQL Performance and Configuration


I have always been told to never, ever, ever run anything but Exchange off
an Exchange Server.  Apparently it consumes huge overhead, and can draw a
Server nearly to its knees from time to time.  I do have 2 clients running
Exchange Servers.  They both recently ugraded their Servers (all not just
Exchange).  In both cases they left Exchange on its own server, as opposed
to trying to comingle Server processes from 2 older units to one newer,
faster Server.  I bet it was due to Exchange Server's demand for RAM and
other resources.

Gil

> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Andrew MacNeill
> Sent: Thursday, July 19, 2007 8:35 AM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: VFP / SQL Performance and Configuration
>
>
> Hey all.
>
> I have a client who is running into some sporadic but severe and
> frustrating performance issues on a VFP 9 app connecting to a SQL Server
> box.
>
> The SQL Server box is their primary office server , also running
> Exchange. Lots of disk space but only 1 GB of RAM.
>
> As I mentioned, it IS sporadic - I can't really see anything from the
> Performance tuner - sometimes some queries get suspended but then run
> again..
>
> The application itself has data stored on another server and was working
> fine before switching to the SQL version.
>
> I've increased the size of tempdb. The database is spread into two main
> files but has tons of space free (it's got a size of 1 GB with
> 600 MB free).
>
> Any suggestions on where to look for those items killing performance?
>
> Thanks
> Andrew
>
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Slow load of runtimes

[Graham Brown \(CompSYS\)]

It was only the machines down one side of the building which was the weird
thing.

I had the "network guru" hovering over me asking "why is *your* software not
working?" over and over. It obviously took him a while to agree to down the
networks on a hunch but once he saw what was happening with his boss stood
behind him his attitude completely changed. While not actually apologising
to me it was good fun watching him squirm his way out.

happy days.


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of mrgmhale
Sent: 19 July 2007 14:00
To: profox@leafe.com
Subject: RE: Slow load of runtimes


Wow, I thought only I had run across that kind of loopback on a LAN ...
In the case where I saw it, the entire network went down immediately after
some folks began to migrate cables to a new set of switches.  I got the call
after everything crashed.  I asked what they had changed just before it all
crashed.  "Nothing, we just started moving cables from the old hubs to the
new switches, then it all stopped working.  We think we have a bad switch
out here."  I had then double check to make certain they did not have two or
more cables uplinking to any "child switches".  Sure enough, there was a
duplicate uplink.  They unplugged the offending cable the "new, broken
switch" was suddenly fixed ...

Gil

> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Graham Brown (CompSYS)
> Sent: Thursday, July 19, 2007 5:40 AM
> To: [EMAIL PROTECTED]
> Subject: RE: Slow load of runtimes
>
>
> Hi
>
> I had a site a couple of months back which was doing the same. Exe was
> local, runtimes also local vfp data on network and still running slow.
>
> Switched off every machine and server and still 14 ports lit on the
> switches.
> Turned out to be cabling with the 5 network switches in that they
> had switch
> A connected to switch B which was connected back to switch A and so on (14
> times!)
>
> No I didn't believe anyone could be so stupid either having spent hours
> checking the application over!!
>
> I'd recommend if it is a small network isolating it to the one machine.
>
> Cheers
> Graham
>
>
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Behalf Of Michael Hawksworth
> Sent: 19 July 2007 08:24
> To: profox@leafe.com
> Subject: RE: Slow load of runtimes
>
>
> AV, DNS lookup issues or Your app is causing memory paging when it is open
> with the 42K spreadsheets, word documents and sundry other programs that
> obviously don't effect performance! (early XP desktops only had 256MB
> memory)
>
> If this is using SQL server check that your ODBC does have a reference to
> the server otherwise it has to go find a suitable system
> (30s-2mins delay).
>
> Degrag the drive (run checkdsk first)
>
> It is usually one of the above.
>
> Regards
> Michael Hawksworth
>
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:profoxtech-
> > [EMAIL PROTECTED] On Behalf Of MB Software Solutions
> > Sent: 18 July 2007 20:28
> > To: [EMAIL PROTECTED]
> > Subject: Re: Slow load of runtimes
> >
> > Allen wrote:
> > > I have seen this on sites where the program is loaded from a server.
> > Its
> > > painfull.
> > > Allen
> > >
> >
> > Yes, I've seen what you've seen too.  However, I run my apps
> > local...not
> > from the server location.
> >
> > --
> > Michael J. Babcock, MCP
> > MB Software Solutions, LLC
> > http://mbsoftwaresolutions.com
> > http://fabmate.com
> > "Work smarter, not harder, with MBSS custom software solutions!"
> >
> >
> >
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Slow load of runtimes

[Graham Brown \(CompSYS\)]

Hi

I had a site a couple of months back which was doing the same. Exe was
local, runtimes also local vfp data on network and still running slow.

Switched off every machine and server and still 14 ports lit on the
switches.
Turned out to be cabling with the 5 network switches in that they had switch
A connected to switch B which was connected back to switch A and so on (14
times!)

No I didn't believe anyone could be so stupid either having spent hours
checking the application over!!

I'd recommend if it is a small network isolating it to the one machine.

Cheers
Graham



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Michael Hawksworth
Sent: 19 July 2007 08:24
To: profox@leafe.com
Subject: RE: Slow load of runtimes


AV, DNS lookup issues or Your app is causing memory paging when it is open
with the 42K spreadsheets, word documents and sundry other programs that
obviously don't effect performance! (early XP desktops only had 256MB
memory)

If this is using SQL server check that your ODBC does have a reference to
the server otherwise it has to go find a suitable system (30s-2mins delay).

Degrag the drive (run checkdsk first)

It is usually one of the above.

Regards
Michael Hawksworth

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:profoxtech-
> [EMAIL PROTECTED] On Behalf Of MB Software Solutions
> Sent: 18 July 2007 20:28
> To: [EMAIL PROTECTED]
> Subject: Re: Slow load of runtimes
>
> Allen wrote:
> > I have seen this on sites where the program is loaded from a server.
> Its
> > painfull.
> > Allen
> >
>
> Yes, I've seen what you've seen too.  However, I run my apps
> local...not
> from the server location.
>
> --
> Michael J. Babcock, MCP
> MB Software Solutions, LLC
> http://mbsoftwaresolutions.com
> http://fabmate.com
> "Work smarter, not harder, with MBSS custom software solutions!"
>
>
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Trapping system date change.

[Graham Brown \(CompSYS\)]

If you have the API code could I also have a look please.

info at compsys dot co dot uk


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Dave Crozier
Sent: 03 July 2007 17:19
To: 'ProFox Email List'
Subject: RE: Trapping system date change.


Alan,
Glad to help!

Dave Crozier

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Alan Bourke
Sent: 03 July 2007 16:48
To: profox@leafe.com
Subject: Re: Trapping system date change.

Well I've furtled it just to return the remote date so I can compare it
with the local date, works great, thx!


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Trapping system date change.

[Graham Brown \(CompSYS\)]

Thanks

Hadn't seen it fail before.

My application is a time & fees system so as you can imagine having the
correct time is quite important.
I had the users messing with the system date time so they could start late
and go home early before!

I'm sure they still have at least one win98 machine so will check it for
sync errors.

Cheers


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
Dave Crozier
Sent: 03 July 2007 17:22
To: 'ProFox Email List'
Subject: RE: Trapping system date change.


Graham,
The problem with Net time /Set is that sometimes the call will return an
incorrect Date/Time - especially on Win98 systems (if you still have any).

I got really caught by this one some time ago, hence the need to write an
API call.

Dave Crozier


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Graham Brown (CompSYS)
Sent: 03 July 2007 18:08
To: ProFox Email List
Subject: RE: Trapping system date change.

Hi chaps

I just use a net time /set command to sync the time in one of my bar code
apps.

htu

Graham


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
Dave Crozier
Sent: 03 July 2007 16:16
To: 'ProFox Email List'
Subject: RE: Trapping system date change.


Alan,
I'll email you off line as it’s a bit long to send in a post.

Dave Crozier

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Alan Bourke
Sent: 03 July 2007 16:11
To: profox@leafe.com
Subject: Re: Trapping system date change.

Dave Crozier wrote:
> Alan,
> I have an API call that allows you to sync the time with any other PC on
the
> network. Is that what you mean or do you wish to access a remote Internet
> Time source?
>
No another PC i.e. the server would be perfect. I don't even want to
sync it, just see if someone is playing silly buggers with the system date.



[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Trapping system date change.

[Graham Brown \(CompSYS\)]

Hi chaps

I just use a net time /set command to sync the time in one of my bar code
apps.

htu

Graham


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
Dave Crozier
Sent: 03 July 2007 16:16
To: 'ProFox Email List'
Subject: RE: Trapping system date change.


Alan,
I'll email you off line as it’s a bit long to send in a post.

Dave Crozier

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Alan Bourke
Sent: 03 July 2007 16:11
To: profox@leafe.com
Subject: Re: Trapping system date change.

Dave Crozier wrote:
> Alan,
> I have an API call that allows you to sync the time with any other PC on
the
> network. Is that what you mean or do you wish to access a remote Internet
> Time source?
>
No another PC i.e. the server would be perfect. I don't even want to
sync it, just see if someone is playing silly buggers with the system date.



[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: SQL Server Import Small Date Time

[Graham Brown \(CompSYS\)]

Thanks Andy

Looks like you have to do this for every date field in every table. Just
spent the last 3 hours doing this. Can't see any other way of saying "treat
all foxpro date fields as datetime and not smalldatetime"

At least its saved as a DTS now so I only have to do it once!

Cheers
Graham


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Andy Davies
Sent: 26 June 2007 15:04
To: profox@leafe.com
Subject: Re: SQL Server Import Small Date Time


there's an option in dts ( a tagged page - 'filter' or some such irc) where
you can change the 'to' file spec.

   hth

Andrew Davies  MBCS CITP
  - AndyD    8-)#



**

Manchester City Council supports Smokefree England - 1 July 2007


This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

Please contact [EMAIL PROTECTED] with any queries.

**



[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

SQL Server Import Small Date Time

[Graham Brown \(CompSYS\)]

Hi all

I'm importing a fox database into SQL2k.

Is there any easy way to default all the dates to just datetime, the DTS
wizard always puts these down as smalldatetime. I have to edit the sql
statements each time to put them back to datetime which is a pain.

Thanks
Graham



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: [NF] Need help with website design

[Graham Brown \(CompSYS\)]

Hi

Take a look at w3schools.com. There are millions of these sites out there
but this should give you a fairly good overview.

Cheers
Graham


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Mike Wohlrab
Sent: 18 June 2007 03:50
To: profox@leafe.com
Subject: RE: [NF] Need help with website design


Thanks Ed,

One question though. Where would I put that in my code? I attached my html
code
in case you wanted to look at it and tell me where to put it or put it in
there
if you know where it goes. If you would rather not and have me learn where
it
goes then that would be fine as well.

Ted Roche,

My goals for the site are really to do a combination of advertising my
services
and what I do and how to contact me and etc. It is also going to be used for
an
experience of building and maintaining a website as a learning experience
and
just to have a site and say I made this great website. Also, I am not trying
to
build a website that is going to compete with a very large company or
organization or really compete at all. If I was going to have a website that
would compete with for say Microsoft or google or adobe, best buy, etc, then
I
would hire a professional to do it for me or take high end website design
courses, which I am taking dreamweaver in college, but that's TO. I am a
single
man company just trying to set up a website and I was just wondering how to
make
the page center according to the width of the web browser similar to what
google
does on their homepage or what Microsoft does. Or also what Graham Brown
suggested in the two sites he asked about if they are similar in what they
do to
what I am looking in regards to adjusting the page in accordance to the
width of
the web browser.

Mike Wohlrab
Computer Technology Solutions
585-944-3823
[EMAIL PROTECTED]
www.ComputerTechnologySolutions.org
FTP://MikeWohlrab.com

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Ed Leafe
Sent: Saturday, June 16, 2007 10:31 PM
To: [EMAIL PROTECTED]
Subject: Re: [NF] Need help with website design

On Jun 16, 2007, at 10:13 PM, Mike Wohlrab wrote:

> I need your help with a small problem I have while designing my
> website. The
> problem is that whenever the page is displayed it shows the page
> onto the left
> side of the web browser. Does anyone know how to change it so that
> anytime the
> website is displayed on the users' computer browser it is centered?
> I am using
> Microsoft Publisher from Office 2007. Thanks for any of your help.



How hard is that?

Maybe you need to use something simpler, like a text editor? Or a
simple CSS editor?

-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com




[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: [NF] Need help with feature for my website

[Graham Brown \(CompSYS\)]

Do you mean like www.compsys.co.uk  or www.ecurie25dev.co.uk ?

Cheers



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Mike Wohlrab
Sent: 17 June 2007 03:24
To: profox@leafe.com
Subject: [NF] Need help with feature for my website


Hello all,



I need your help with a small problem I have while designing my website. The
problem is that whenever the page is displayed it shows the page onto the
left
side of the web browser. Does anyone know how to change it so that anytime
the
website is displayed on the users' computer browser it is centered? I am
using
Microsoft Publisher from Office 2007. Thanks for any of your help.



If you visit the website below you will notice that it is hardly anywhere
close
to being finished, but I am slowly working on it.



Mike Wohlrab
Computer Technology Solutions
585-944-3823
[EMAIL PROTECTED]

www.mikewohlrab.com

FTP://MikeWohlrab.com 





--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: [NF] Any .NET SMTP gurus out there?

[Graham Brown \(CompSYS\)]

Hi

>From what I can gather the standard mail uses an SMTP server of "localhost"
if it is not set within code. The example the hosting company sent me back
is using mail.smtpserver="127.0.0.1"

So need to work out if they can give me back "localhost or whether I need to
change the pages to hardwire the "127.." address.

Regards
Graham


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Graham Dobson
Sent: 12 June 2007 17:11
To: ProFox Email List
Subject: RE: [NF] Any .NET SMTP gurus out there?


Could it have to do with not having a mail box set up on the new web server?

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Graham Brown (CompSYS)
Sent: Monday, June 11, 2007 10:16 AM
To: ProFox Email List
Subject: [OT] Any .NET SMTP gurus out there?


Hi all

Totally OT I know and probably a bit of a swear word on this forum!!

I've just inherited an ASP.NET (c#) app. The customer has just moved the
hosting and now it won't send emails. There are no obvious error messages,
it seems to go through but the emails never arrive. The code hasn't changed
and I can't see anywhere the application is sending any sort of
authentication. It just uses the standard built in SMTMail object.

My guess is that the new hosts have their mailserver locked down to prevent
spam but I don't know, and of course the new webhosts have washed their
hands of it!!

Could anyone point me in the general direction of any troubleshooting guides
or give me any sort of pointers?


Cheers
Graham



[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

[OT] Any .NET SMTP gurus out there?

[Graham Brown \(CompSYS\)]

Hi all

Totally OT I know and probably a bit of a swear word on this forum!!

I've just inherited an ASP.NET (c#) app. The customer has just moved the
hosting and now it won't send emails. There are no obvious error messages,
it seems to go through but the emails never arrive. The code hasn't changed
and I can't see anywhere the application is sending any sort of
authentication. It just uses the standard built in SMTMail object.

My guess is that the new hosts have their mailserver locked down to prevent
spam but I don't know, and of course the new webhosts have washed their
hands of it!!

Could anyone point me in the general direction of any troubleshooting guides
or give me any sort of pointers?


Cheers
Graham



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

###### installshield 1606 errors !!

[Graham Brown \(CompSYS\)]

Hi all

I don't know if anyone else gets these but I now have three brand new Dell
machines which are all currently standalone (not on domain yet) running xp
pro.
When I try to install my vfp 8 app on these these machines I get the dreaded
1606 location not found error.

According to KB this means that I have a duff drive letter in the registry
for Shell folders. I've checked these and some aren't set to anything but
all the other ones are pointing to c: which is correct.

In this instance I've manually copied MSVCR70 and the common files/vfp. When
I then ran the app I got a missing language support file (RENU?) which was
there  but never mind. I then ran the install again and it worked.

I don't understand where the problem is but obviously can't be visiting
every site to install my applications as I'd never get any work done.

Has anyone found a reason/fix for this?

Regards
Graham




___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Self referencing joins

[Graham Brown \(CompSYS\)]

Hi
Thanks! Yep. This is effectively what I'm doing with the cursors.
Was trying to work out if I can do this another way due to the speed of the
thing.

Regards

Graham



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Ed Leafe
Sent: 19 April 2007 17:33
To: ProFox Email List
Subject: Re: Self referencing joins


On Apr 19, 2007, at 12:30 PM, Graham Brown ((CompSYS)) wrote:

> With the application I can easily go 15 levels deep due to the way my
> customer sets up how they build things
>
> What I need to do is get this info into a cursor so I can populate a
> treeview with it, I currently create cursor_level1 for the children
> in J1
> and then create another cursor for J4 then another cursor for J12
> which is
> dog slow. I have complication that in my example above if the
> customer needs
> two computers then all qtys underneath must be multiplied by 2.
> However if
> it is one computer with 2 monitors then I'll need 2 monitor cases
> and 8
> buttons. This quantity ripples all the way down 15 levels or
> however many.
>
> Could anyone assist with an SQL statement to show the hierachy in a
> cursor.

I don't believe you can accomplish this in a single SQL statement.
Probably the best approach is to use CREATE CURSOR to create the
structure you want, and then run a query, appending the results to
the cursor. Then iterate through all the records of the results,
using the keys in those records to get all the sub-assemblies, which
are then added to the main cursor, and then these records are queried
for their child records.

Obviously something like this lends itself to recursive calls, as
long as you know that your data is sound (i.e., that it doesn't
contain an assembly that contains parts that contain the original
assembly).

-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com




[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Self referencing joins

[Graham Brown \(CompSYS\)]

Hi all

I have a bit of problem with a system which I can't get my head around and
wonder if anyone can do me a sanity check.
What I have is two tables arranged in header/detail fashion. The key field
between the two is a job number

Header table stru is for the sake of argument

Jobno
Product to be made
Qty required

Detail stru is

Jobno
Item number
Product to be issued
Qty to be issued
Child job


Child job refers to a sub assembly job. So to make a computer (assuming I'm
going to make a monitor!)

I have Job1, product is Computer, Qty 1
The details for this job are
J1, Item 1, Monitor,1 required, Child J4 which shows how to make a monitor
J1, Item 2, Keyboard, 1, No child job
J1, Item 3, Mouse, 1, No child job
J1, Item 4, Tower, 1, Child job J12

J4 Header has Monitor,1,
J4 Details has
J4, Item 1, Monitor Case, 1, no child
J4, Item 2, Buttons, 4, no child
J4, Item 3, TFT Panel, 1, no child

J12 header would then have Tower, 1
J12 details
J12, Item 1, Case, 1, no child
J12,Item 2, MB, 1 Child job J14

J14 would then drill down onto the motherboard and so on

With the application I can easily go 15 levels deep due to the way my
customer sets up how they build things

What I need to do is get this info into a cursor so I can populate a
treeview with it, I currently create cursor_level1 for the children in J1
and then create another cursor for J4 then another cursor for J12 which is
dog slow. I have complication that in my example above if the customer needs
two computers then all qtys underneath must be multiplied by 2. However if
it is one computer with 2 monitors then I'll need 2 monitor cases and 8
buttons. This quantity ripples all the way down 15 levels or however many.

Could anyone assist with an SQL statement to show the hierachy in a cursor.

Cheers
Graham




Graham Brown
CompSYS Software Solutions

Telephone: 0870 753 8480
General fax: 0870 753 8490
Support fax: 0845 009 4480
Mobile: 07973 988939
email: [EMAIL PROTECTED]
web: http://www.compsys.co.uk
CompSYS is a member of the BNI (Business Network International). If you'd
like to know how the BNI could grow your business or would like to visit one
of the weekly meetings held throughout the area, please let me know.



IMPORTANT: This email (including all attachments) is confidential and may be
privileged. It may only be read, copied and used by the intended recipients.
If you are not the intended recipient, you should not disseminate,
distribute or copy this email. Please notify the sender immediately and
delete this email from your system.

The security and reliability of emails is not guaranteed. Verification
should be sought from a mailed or faxed copy. Whilst we operate anti-virus
programmes, emails can become infected after being transmitted. You should
therefore take full responsibility for virus checking.


--- StripMime Report -- processed MIME parts ---
multipart/related
  multipart/alternative
text/plain (text body -- kept)
text/html
  image/jpeg
---


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

[OT] Any C++ programmers out there?

[Graham Brown \(CompSYS\)]

Hi all

I've been asked if I can assist another programmer with some C++ code (which
I can't)
Does anyone fancy doing some consultancy work for the chap?

If so please email me off list and I'll put you in touch.
Cheers


Graham Brown
CompSYS Software Solutions

Telephone: 0870 753 8480
General fax: 0870 753 8490
Support fax: 0845 009 4480
Mobile: 07973 988939
email: [EMAIL PROTECTED]
web: http://www.compsys.co.uk

CompSYS is a member of the BNI (Business Network International). If you'd
like to know how the BNI could grow your business or would like to visit one
of the weekly meetings held throughout the area, please let me know.



IMPORTANT: This email (including all attachments) is confidential and may be
privileged. It may only be read, copied and used by the intended recipients.
If you are not the intended recipient, you should not disseminate,
distribute or copy this email. Please notify the sender immediately and
delete this email from your system.

The security and reliability of emails is not guaranteed. Verification
should be sought from a mailed or faxed copy. Whilst we operate anti-virus
programmes, emails can become infected after being transmitted. You should
therefore take full responsibility for virus checking.


--- StripMime Report -- processed MIME parts ---
multipart/related
  multipart/alternative
text/plain (text body -- kept)
text/html
  image/jpeg
---


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: To flush or not to flush, that is the question

[Graham Brown \(CompSYS\)]

lol

Cheers for that, went down lovely with supper!

G.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Dave Crozier
Sent: 07 February 2007 16:30
To: 'ProFox Email List'
Subject: RE: To flush or not to flush, that is the question


Graham,
In a lighter vein, my mother always used to say on the question to flush or
not to flush:

"If its yellow...let it mellow but if it's brown...then FLUSH it down!!"


Dave Crozier


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Peter Cushing
Sent: 07 February 2007 16:25
To: profox@leafe.com
Subject: Re: To flush or not to flush, that is the question

Graham Brown (CompSYS) wrote:
> btw the scenario I have is exactly as you say, a parameters table holding
> the next available number.
I had a bit of a problem a couple of years ago with the same scenario
but we had two systems accessing the parameter table.  The first was our
old FPD 2.6 system and the other our newer VFP7 system.  It appeared
that VFP was cacheing the table and could not tell that the old system
had updated it, even though we were using RLOCK() then unlock etc.  What
I had to do to make it work was get VFP to close the table after it had
got the number.  It gave me a right headache with duplicate barcode
numbers. :-(

Peter



[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: To flush or not to flush, that is the question

[Graham Brown \(CompSYS\)]

Hi
The code is just use optimistic ie tableupdate(.t.)

The params table is one record so will stick a rlock in for good measure as
well.



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Dave Crozier
Sent: 07 February 2007 17:00
To: 'ProFox Email List'
Subject: RE: To flush or not to flush, that is the question


Ted,
I omitted to add that fact. Well expanded and amplified.

Dave Crozier

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Ted Roche
Sent: 07 February 2007 16:53
To: profox@leafe.com
Subject: Re: To flush or not to flush, that is the question

On 2/7/07, Dave Crozier <[EMAIL PROTECTED]> wrote:

> On the Index table how are you locking the parameter (Next record Id)
table?
> 99% of the time VFP will do this automatically for you but I prefer the
> Rlock()/Flock() manual method, that way I can be SURE of getting no
> duplicates. This is the ONLY time I ever use manual locking however.

I'd amplify your statement a little: You MUST lock a record to ensure
that VFP is reading the most current value from a table. In PK
generation, this is essential and mandatory. In other places in the
application, that's what conflict detection is for.

--
Ted Roche
Ted Roche & Associates, LLC
http://www.tedroche.com


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: To flush or not to flush, that is the question

[Graham Brown \(CompSYS\)]

Hi John

Haven't had chance to look at 9 yet. My libraries are tried and tested on v8
so need to get some spare time to check with 9.

btw the scenario I have is exactly as you say, a parameters table holding
the next available number. Will look at autoincs thanks.

I've put the flush code out there today so will see if this fixes the
problem, like you say it is highly intermittent (twice in a year!) Will also
post back in a little while when I've got some feedback.

Regards


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of John Weller
Sent: 06 February 2007 18:13
To: profox@leafe.com
Subject: RE: To flush or not to flush, that is the question


How are you generating the invoice numbers - from a table holding the next
number?  I had a problem like this generating primary keys using a next
number table on a couple of apps.  It be-devilled us for years, I couldn't
find what was causing it as it seemed to be intermittent - it only went away
when I upgraded and started using auto incrementing fields.

Why upgrade to VFP 8, why not VFP 9?

John Weller
01380 723235
07976 393631

>
>
> I've got a weird problem whereby I get duplicate invoice numbers in a vfp6
> native app. Does a tableupdate issue a flush at the same time? It has just
> duplicated  today for the second time in about a year.
>
>



[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

To flush or not to flush, that is the question

[Graham Brown \(CompSYS\)]

Hi all

I've got a weird problem whereby I get duplicate invoice numbers in a vfp6
native app. Does a tableupdate issue a flush at the same time? It has just
duplicated  today for the second time in about a year.

I'm in the process of upgrading this one to VFP8/CAa & SQLServer so
hopefully not a problem soon (Will post some interesting stuff on this one
when I've got my head round it myself!)

Cheers
Graham Brown
CompSYS Software Solutions

Telephone: 0870 753 8480
General fax: 0870 753 8490
Support fax: 0845 009 4480
Mobile: 07973 988939
email: [EMAIL PROTECTED]
web: http://www.compsys.co.uk

CompSYS is a member of the BNI (Business Network International). If you'd
like to know how the BNI could grow your business or would like to visit one
of the weekly meetings held throughout the area, please let me know.



IMPORTANT: This email (including all attachments) is confidential and may be
privileged. It may only be read, copied and used by the intended recipients.
If you are not the intended recipient, you should not disseminate,
distribute or copy this email. Please notify the sender immediately and
delete this email from your system.

The security and reliability of emails is not guaranteed. Verification
should be sought from a mailed or faxed copy. Whilst we operate anti-virus
programmes, emails can become infected after being transmitted. You should
therefore take full responsibility for virus checking.


--- StripMime Report -- processed MIME parts ---
multipart/related
  multipart/alternative
text/plain (text body -- kept)
text/html
  image/jpeg
---


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: SQLServer Cursor Adapters

[Graham Brown \(CompSYS\)]

Hi

Thanks Stephen

Just thinking about this, isn't the basic design of a foxpro app to assign
the fields to the control source and then issue a tableupdate to commit.

Changing the app to native datetimes means I can't use control source  for
any dates as I'd have to assign the date time to a variable, cast it to a
date then place this in the text.value property.

Does this mean the select statement in the ca is ignoring the cursorschema
property when its fetching data?

VFP not being able to handle dates when talking to SQL server sounds fairly
major?
Sounds nasty! I was looking to have one app with two sets of CAs so it's a
quick swap but that doesn't sound feasible with this?

Cheers


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Stephen the Cook
Sent: 28 January 2007 15:49
To: 'ProFox Email List'
Subject: RE: SQLServer Cursor Adapters


Graham Brown (CompSYS) <> wrote:
> Hi all
>
> I'm still working through the upsize to sqlserver. The first problem
> I've encountered is that SQL upsized my dates to datetimes. I've
> changed the cursoradapter so that everywhere it mentioned a time type
> it now shows a date.
>
> The control source on the both textboxes and grid columns are still
> showing a datetime.
>
> How do I force these to just show a date? Changing the format on both
> to "D"
> makes no difference. I've also looked at DBSetprop but that doesn't
> work for ca's.

Getting just the date from SQL Server =
select CONVERT(VARCHAR(12), your_Column|Or_Var here, 101)

That 101 is an identifier for the look of the output and it's set for a USA
date look and feel.

As a heads up, Fox & Dates is your problem.  If you convert all your fox
based systems to date time columns you will be much farther along in getting
this problem worked out.




Stephen Russell
DBA / .Net Developer

Memphis TN 38115
901.246-0159

"A good way to judge people is by observing how they treat those who
can do them absolutely no good." ---Unknown

http://spaces.msn.com/members/srussell/

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.432 / Virus Database: 268.17.12/654 - Release Date: 1/27/2007
5:02 PM




[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

SQLServer Cursor Adapters

[Graham Brown \(CompSYS\)]

Hi all

I'm still working through the upsize to sqlserver. The first problem I've
encountered is that SQL upsized my dates to datetimes. I've changed the
cursoradapter so that everywhere it mentioned a time type it now shows a
date.

The control source on the both textboxes and grid columns are still showing
a datetime.

How do I force these to just show a date? Changing the format on both to "D"
makes no difference. I've also looked at DBSetprop but that doesn't work for
ca's.

Thanks!

Regards
Graham Brown
CompSYS Software Solutions

Telephone: 0870 753 8480
General fax: 0870 753 8490
Support fax: 0845 009 4480
Mobile: 07973 988939
email: [EMAIL PROTECTED]
web: http://www.compsys.co.uk

CompSYS is a member of the BNI (Business Network International). If you'd
like to know how the BNI could grow your business or would like to visit one
of the weekly meetings held throughout the area, please let me know.



IMPORTANT: This email (including all attachments) is confidential and may be
privileged. It may only be read, copied and used by the intended recipients.
If you are not the intended recipient, you should not disseminate,
distribute or copy this email. Please notify the sender immediately and
delete this email from your system.

The security and reliability of emails is not guaranteed. Verification
should be sought from a mailed or faxed copy. Whilst we operate anti-virus
programmes, emails can become infected after being transmitted. You should
therefore take full responsibility for virus checking.


--- StripMime Report -- processed MIME parts ---
multipart/related
  multipart/alternative
text/plain (text body -- kept)
text/html
  image/jpeg
---


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: New Report Writer?

[Graham Brown \(CompSYS\)]

Hi

Is Cognos still around? I also saw a demo of Synaptris a few years back.

Cheers


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of MB Software Solutions
Sent: 27 January 2007 17:15
To: profox@leafe.com
Subject: Re: New Report Writer?


Stephen the Cook wrote:
> MB Software Solutions <> wrote:
>
>
>> (F*ck your mgmt if they're dissing the Fox for no good/valid reason.
>> I hate politics---that's why I became an independent.)
>>
>
> Could have been a breech of security and all the customer data, and credit
> card details were taken.
>
> There were no details so I present a valid option.
>

But that would be a very valid reason.  I said if they had *no*
good/valid reason!!

--
Michael J. Babcock, MCP
MB Software Solutions, LLC
http://mbsoftwaresolutions.com
http://fabmate.com
"Work smarter, not harder, with MBSS custom software solutions!"



[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.