RE: Splitting PDF Files with Ghostscript

[Graham Brown]

Hi 

Alternative approach is to use the free PDFTK utility. This is command line
and from memory you give it a command line argument  of "CAT".

Regards]
Graham


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Paul H. Tarver
Sent: 27 March 2024 21:25
To: ProFox@leafe.com
Subject: Splitting PDF Files with Ghostscript

Ok, does anyone have some sample VFP code they are willing to share to help
me split a PDF file with 50 pages or so into separate PDF files with one
page in each file? I've tried to convert several things I've seen on
multiple sites with various languages, but I've had no luck converting those
to run using the WScript.Shell. 

 

Any help would be appreciated! Thanks!

 

Paul H. Tarver 
Tarver Program Consultants, Inc. 



 



--- 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: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/001b01da80f1$b7b33660$2719a320$@compsys.co.uk
** 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[ Other languages

[Graham Brown]

Thanks Ed.



-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ed Leafe
Sent: 01 December 2023 15:27
To: ProFox Mailing List
Subject: Re: [OT[ Other languages

On Dec 1, 2023, at 07:48, Graham Brown  wrote:
> 
> Has there been any thought to creating lists for other languages like Web,
> mobile, VB.Net and C#? Is there a requirement for this within the group?

Years ago (2003!) we started the ProPython list, as there were more and more
people interested in moving to Python (for good reason!). However, in the
past few years that traffic has died down to nothing.

I would propose that instead of a new list to label your subjects with
"[NF]" for "not fox", and then add "[my_language]" after that so that others
interested in that language can quickly see the message, and those who don't
care can either delete it or add a filter to their email.


-- Ed Leafe


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/005501da246f$7ae3f320$70abd960$@compsys.co.uk
** 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[ Other languages

[Graham Brown]

Hi 

 

Dumb question time.

 

Vis Fox has been a huge part of my career since the late 90s, I still
support my VFP apps  but I now find my new developments are either PHP or
VS.NET. 

 

Has there been any thought to creating lists for other languages like Web,
mobile, VB.Net and C#? Is there a requirement for this within the group?

 

Just wondering about our brave new world!

 

Regards

Graham

 



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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/003801da245d$003bd2d0$00b37870$@compsys.co.uk
** 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 Upsize

[Graham Brown]

Hi 

Don't know if this upsize code will help anybody else but will share it.
This has been run with SQL express 2008r2
Run the upsizing wizard to send the structure with no data. Run this on a 
backup of the fox data.

This uses Pauls CABuilder to generate CursorAdapters for the SQL database
It then scans a given folder for all DBFs, opens the CA and sends the records 
to the ca.
If the autoIdent is important then update the records one at a time with 
TableUpdate(.f.) and call the DBCC function to change the ID.

This code updates every 1000 rows with tableupdate(.t.)

Released as is with no warranties...use at your own riskblah blah

Takes about 90 minutes to run on one of my bigger databases approx. 1m records


**
***
*** Instructions
***
*** Sometimes the upsizing wizard is not sending data, just the structure
***
*** Run this and set the nulls
*** Copy the compdata to the upsize folder
*** Run upsize wizard, if it doesn't error fine
*** If it doesn't send the data come back here, run the copy upsize data
*** It takes hours to do this manually so do it late at night.
***
*** May need to regenerate the CAClassesSQL and DESQL in the project
***


Clear
Set Status Bar On

Set TABLEVALIDATE To 0

Set Multilocks On
Set Exclusive On
Set Deleted On
Close Databases
For i =1 To 255
Select (i)
Use
Next

Wait Window "Copy files to SQL Server Database" Nowait Noclear

Set Default To d:\app\Source

Set Multilocks On
If Type("gcConnString")="U"
gcConnString="Driver=SQL 
Server;server=sql;database=test;uid=admin;pwd=password;trusted_connection=no;"
Set Classlib To d:\app\source\desql Additive  && Data environment class with 
all the CAs
Set Classlib To d:\app\Source\caclassessql Additive   && CAs for SQL
Endif


nHandle=Sqlstringconnect(gcConnString)
odata=Createobject("deallfilessql")
odata.OpenTables()

starttime=Time()

If Messagebox("Read file fox",36,"Confirm")=6

oldPath=Justpath(Locfile("*.dbc","DBC","Please locate original database"))
Set Deleted On
Set Default To &oldPath
nNum=Adir(aFiles,"*.dbf")
For N=1 To nNum
DoEvents
DoEvents
DoEvents

cFile=aFiles[n,1]

cFile=Left(cFile,Len(cFile)-4)
cSQL="delete from "+cFile
nStat=EXECSQL(nHandle,cSQL)
ca=cFile

? "Converting " +cFile+" to " + ca+"start time "+Left(Time(),5)

If PEMSTATUS(odata,ca,5)
If Select(cFile)>0
Use In &cFile
Endif
Select 0

** SET STEP ON
Use &cFile Alias old
Go Top
odata.&ca..lNoDataOnLoad=.F.
odata.&ca..cSelectCMDFilter="f_rn=0"
odata.&ca..cselectorderby="f_rn"
odata.&ca..CursorFill()


If Select("qte_d")>0
Select &ca


Select old
SCAN


Scatter Memvar Memo
Select 0
* odata.&ca..cSelectCMDFilter="f_rn=0"
* odata.&ca..CursorFill()
Select old
If Recno()/25=Int(Recno()/25) OR .t.
Wait Clear
Wait Window "Processing "+cFile+" "+Str(Recno())+" of "+Str(Reccount()) Nowait 
Noclear
** ?"Processing "+cFile+" "+Str(Recno())+" of "+Str(Reccount())
DoEvents Force
DoEvents
DoEvents
Endif

Select &ca
Append Blank
Gather Memvar Fields Except f_rn Memo
* EXECSQL(nHandle,"DBCC CHECKIDENT 
('"+cFile+"',reseed,"+Alltrim(Str(m.f_rn-1))+")")
* Tableupdate(.f.)

IF Recno()/1000=Int(Recno()/1000)
=TABLEUPDATE(.t.)
odata.&ca..cSelectCMDFilter="f_rn=0"
odata.&ca..CursorFill()
ENDIF


Select old
Endscan
Select &ca
Tableupdate(.t.)


Use In old

Else
Wait Window "Unable to open table "+ca
ENDIF
? "End time "+TIME()

Else
Wait Window "No CA for "+cFile Nowait Noclear

Endif
If Select("old")>0
Use In old
Endif

Next
Endif
?

?? "Conversion started "
?? starttime
?? " ended at "
?? Time()
?


Endif


Function EXECSQL
Lparameters nHandle,cSQL

nTimes=1
Do While .T.
DoEvents Force

nStat=SQLEXEC(nHandle,cSQL)
If nStat<>0
Exit
Endif
If nTimes>5
Wait Window cSQL+"("+Alltrim(Str(nTimes))+")" Nowait Noclear
DoEvents Force
Endif

If nTimes=100
Exit
Endif
nTimes=nTimes+1
DoEvents Force
DoEvents Force

Enddo

Return .T.


Function setnull()

cPath=oldPath
Set Default To &cPath
numfiles=Adir(a,"*.dbf")


lPack=Messagebox("Pack the local tables first",36,"Confirm")=6
For N=1 To numfiles
cDBF=a[n,1]
Wait Window cDBF Nowait Noclear

If File(cDBF)
cDBF=Strtran(cDBF,".DBF","",1,999,1)

Use &cDBF
If lPack
Wait Window cDBF+Chr(13)+Chr(10)+"Pack" Nowait Noclear
Pack
Endif
numfields=Afields(b)
Use
For F=1 To numfields
cfield=b[f,1]
If Upper(cfield)="F_RN"
Loop
Endif

Wait Window cDBF+Chr(13)+Chr(10)+cfield+Chr(13)+Chr(10)+"Set Null" Nowait 
Noclear
Alter Table &cDBF Alter &cfield Null
Next
Endif
Next



Return


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/003001d9f9e2$445c6010$cd152030$@compsys.co.uk
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. Thi

RE: FW: SQL Upsize

[Graham Brown]

Thanks. I'll take a look.


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Virgil Bierschwale
Sent: 06 October 2023 11:42
To: ProFox Email List
Subject: Re: FW: SQL Upsize

https://navicat.com/en/


On Fri, Oct 6, 2023 at 3:11 AM Graham Brown  wrote:

> Thanks
>
> What is Navicat?
>
> -Original Message-
> From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Virgil
> Bierschwale
> Sent: 05 October 2023 20:04
> To: ProFox Email List
> Subject: Re: FW: SQL Upsize
>
> I use navicat.
> copy the dbf to csv or txt.
> use navicat to connect to sql server.
> and then do a import.
>
> I've added about 10GB data to mysql that way and it works pretty good.
> they have a version for sql server as well.
>
>
> On Thu, Oct 5, 2023 at 11:36 AM Graham Brown  wrote:
>
> > Hi
> > Thanks
> >
> > Yes, the database and tables all get created via the upsizing wizard so
> > definitely something to do with the data itself
> > The upsizing wizard has worked in the past probably 2000 to 2005 but
> won't
> > work in 2008r2. Havent done one of these in a long time.
> >
> > In the upsizing wizard I uncheck indices, integrity etc etc but made no
> > difference
> >
> > I have created a simple prg to create a cursor adapter on the local data
> > and another on the server data. This does scatter and gather between the
> > two but on a table with 500k records it takes two days to run so too
> slow.
> >
> > The next thing I am going to try is manually creating the insert sql
> > commands and run these in EM, just a pita if I am missing something
> obvious.
> >
> > Interesting one.
> >
> > Graham
> >
> >
> >
> > -Original Message-
> > From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Kurt Wendt
> > Sent: 05 October 2023 17:21
> > To: ProFox Email List
> > Subject: Re: FW: SQL Upsize
> >
> > Hey there Graham,
> >
> > Now, I know this is going to be more of a WAG or a total
> Shot-in-the-Dark,
> > Butt...
> >
> > Also, I will admit - I am not familiar with the exact process you're
> > attempting to do. I did try something similar MANY Years ago, admittedly
> -
> > back in like 2012. Anyway...
> >
> > So, my question is this - did your Process at least create the Database
> > files in SQL - and SOME of the records did make it into the Database? If
> > so, why not push the records into SQL Databases from FoxPro after the SQL
> > databases were already created?
> >
> > Now, I know - it's Not Addressing your original problem. But, I figured I
> > would throw some suggestions out there...
> >
> > -Kurt
> >
> >
> > On Thu, Oct 5, 2023 at 8:44 AM Graham Brown 
> wrote:
> >
> > > Hi all
> > >
> > >
> > >
> > > I am upsizing a Foxpro DBC to SQL 2008 r2. This worked fine with
> earlier
> > > versions of SQL but gives errors to newer versions of SQL. I am using
> > ODBC
> > > rather than Native client although it doesn't make any difference to
> the
> > > errors.
> > >
> > >
> > >
> > > For one specific table the upsize says 988 rows failed. Only a few
> > records
> > > show an error in the report (6) and this is connectivity error failed
> to
> > > convert numeric to float. The destination fields do not show float so
> not
> > > sure what it is complaining about.
> > >
> > >
> > >
> > > Has anyone seen the same please.
> > >
> > >
> > >
> > > Regards
> > >
> > > Graham
> > >
> > >
> > >
> > > Ps Sent the last one to owner@, sorry Ed.
> > >
> > >
> > >
> > >
> > >
> > > --- 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: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/004301d9f860$85d9e9a0$918dbce0$@compsys.co.uk
** 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: FW: SQL Upsize

[Graham Brown]

Thanks

What is Navicat?

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Virgil Bierschwale
Sent: 05 October 2023 20:04
To: ProFox Email List
Subject: Re: FW: SQL Upsize

I use navicat.
copy the dbf to csv or txt.
use navicat to connect to sql server.
and then do a import.

I've added about 10GB data to mysql that way and it works pretty good.
they have a version for sql server as well.


On Thu, Oct 5, 2023 at 11:36 AM Graham Brown  wrote:

> Hi
> Thanks
>
> Yes, the database and tables all get created via the upsizing wizard so
> definitely something to do with the data itself
> The upsizing wizard has worked in the past probably 2000 to 2005 but won't
> work in 2008r2. Havent done one of these in a long time.
>
> In the upsizing wizard I uncheck indices, integrity etc etc but made no
> difference
>
> I have created a simple prg to create a cursor adapter on the local data
> and another on the server data. This does scatter and gather between the
> two but on a table with 500k records it takes two days to run so too slow.
>
> The next thing I am going to try is manually creating the insert sql
> commands and run these in EM, just a pita if I am missing something obvious.
>
> Interesting one.
>
> Graham
>
>
>
> -Original Message-
> From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Kurt Wendt
> Sent: 05 October 2023 17:21
> To: ProFox Email List
> Subject: Re: FW: SQL Upsize
>
> Hey there Graham,
>
> Now, I know this is going to be more of a WAG or a total Shot-in-the-Dark,
> Butt...
>
> Also, I will admit - I am not familiar with the exact process you're
> attempting to do. I did try something similar MANY Years ago, admittedly -
> back in like 2012. Anyway...
>
> So, my question is this - did your Process at least create the Database
> files in SQL - and SOME of the records did make it into the Database? If
> so, why not push the records into SQL Databases from FoxPro after the SQL
> databases were already created?
>
> Now, I know - it's Not Addressing your original problem. But, I figured I
> would throw some suggestions out there...
>
> -Kurt
>
>
> On Thu, Oct 5, 2023 at 8:44 AM Graham Brown  wrote:
>
> > Hi all
> >
> >
> >
> > I am upsizing a Foxpro DBC to SQL 2008 r2. This worked fine with earlier
> > versions of SQL but gives errors to newer versions of SQL. I am using
> ODBC
> > rather than Native client although it doesn't make any difference to the
> > errors.
> >
> >
> >
> > For one specific table the upsize says 988 rows failed. Only a few
> records
> > show an error in the report (6) and this is connectivity error failed to
> > convert numeric to float. The destination fields do not show float so not
> > sure what it is complaining about.
> >
> >
> >
> > Has anyone seen the same please.
> >
> >
> >
> > Regards
> >
> > Graham
> >
> >
> >
> > Ps Sent the last one to owner@, sorry Ed.
> >
> >
> >
> >
> >
> > --- 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: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/002d01d9f82c$ade44cd0$09ace670$@compsys.co.uk
** 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: FW: SQL Upsize

[Graham Brown]

Hi
Thanks

Yes, the database and tables all get created via the upsizing wizard so 
definitely something to do with the data itself
The upsizing wizard has worked in the past probably 2000 to 2005 but won't work 
in 2008r2. Havent done one of these in a long time.

In the upsizing wizard I uncheck indices, integrity etc etc but made no 
difference

I have created a simple prg to create a cursor adapter on the local data and 
another on the server data. This does scatter and gather between the two but on 
a table with 500k records it takes two days to run so too slow.

The next thing I am going to try is manually creating the insert sql commands 
and run these in EM, just a pita if I am missing something obvious.

Interesting one.

Graham



-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Kurt Wendt
Sent: 05 October 2023 17:21
To: ProFox Email List
Subject: Re: FW: SQL Upsize

Hey there Graham,

Now, I know this is going to be more of a WAG or a total Shot-in-the-Dark,
Butt...

Also, I will admit - I am not familiar with the exact process you're
attempting to do. I did try something similar MANY Years ago, admittedly -
back in like 2012. Anyway...

So, my question is this - did your Process at least create the Database
files in SQL - and SOME of the records did make it into the Database? If
so, why not push the records into SQL Databases from FoxPro after the SQL
databases were already created?

Now, I know - it's Not Addressing your original problem. But, I figured I
would throw some suggestions out there...

-Kurt


On Thu, Oct 5, 2023 at 8:44 AM Graham Brown  wrote:

> Hi all
>
>
>
> I am upsizing a Foxpro DBC to SQL 2008 r2. This worked fine with earlier
> versions of SQL but gives errors to newer versions of SQL. I am using ODBC
> rather than Native client although it doesn't make any difference to the
> errors.
>
>
>
> For one specific table the upsize says 988 rows failed. Only a few records
> show an error in the report (6) and this is connectivity error failed to
> convert numeric to float. The destination fields do not show float so not
> sure what it is complaining about.
>
>
>
> Has anyone seen the same please.
>
>
>
> Regards
>
> Graham
>
>
>
> Ps Sent the last one to owner@, sorry Ed.
>
>
>
>
>
> --- 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: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/001401d9f7a9$ef439e20$cdcada60$@compsys.co.uk
** 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: SQL Upsize

[Graham Brown]

Hi all

 

I am upsizing a Foxpro DBC to SQL 2008 r2. This worked fine with earlier
versions of SQL but gives errors to newer versions of SQL. I am using ODBC
rather than Native client although it doesn't make any difference to the
errors.

 

For one specific table the upsize says 988 rows failed. Only a few records
show an error in the report (6) and this is connectivity error failed to
convert numeric to float. The destination fields do not show float so not
sure what it is complaining about.

 

Has anyone seen the same please.

 

Regards

Graham

 

Ps Sent the last one to owner@, sorry Ed.

 



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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/000c01d9f7a2$c1121290$433637b0$@compsys.co.uk
** 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: Fox.wikis.com

[Graham Brown]

WellReading the message on the wiki I think Mike just needs a big hug from 
all of us...!

And Steven, the block button is there for a reason, just kick 'em off and don't 
even try to reason with some people so don't deal with people who p you off

Bring back our Wiki please !

Have a really great day everyone 

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Eric Selje
Sent: 18 July 2023 15:03
To: ProFox Email List
Subject: Re: Fox.wikis.com

It really is. I wish they could work something out. Mike Y., if you're out
there reading this can you make nice with Stephen for the benefit of the
community? We've communicated many times in the past and it's always been
pleasant and professional.

Eric


On Mon, Jul 17, 2023 at 4:02 PM MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:

> That's a real shame that it's still down.  http://fox.wikis.com/
>
>
> --
> Michael J. Babcock, MCP
> Fox/VFP dev since 1997
> Developer of FabNet estimating software - mbsoftwaresolutions.com
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/001501d9baee$b0ebb380$12c31a80$@compsys.co.uk
** 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: Passing parameters to an external program run from fox

[Graham Brown]

Just had the same problem

I have ps2pdf.prg. this has a function called "runme"

I don’t know who the author is...sorry

*:**
*:
*: Procedure File PS2PDF.PRG
*:
*: Documented using Visual FoxPro Formatting wizard version  .05
*:**
*:   PS2PDF
*:   clnpsfiles
*:   runme
*:   long2str
*:   str2long
*:   getStartupInfo
*:   num2dword
*:   num2word
*:   buf2dword
*:   Decl
Parameters m_ifilename   && checking this has to be a ps file.
If m_ifilename =="" Or Not File(m_ifilename)
Return
Endif
**Do clnpsfiles
m_safety  = Set("safety")
Set Safety Off
If Not Directory(m.cHomeDir+"psfiles")
Mkdir &(m.cHomeDir+"psfiles")
Endif
If Not Directory(m.cHomeDir+"pdffiles")
Mkdir &(m.cHomeDir+"pdffiles")
Endif
m_psfile= m.cHomeDir+"psfiles\"+Juststem(m_ifilename)+".ps"
If File(m_psfile)
**Erase (m_psfile)
Endif
If Justext(m_ifilename) == ""
m_ifilename = Juststem(m_ifilename)+".TXT"
m_psfile=Juststem(m_ifilename)+".ps"
If File(m_psfile)
Erase (m_psfile)
Endif
Rename (m_ifilename) To 
m.cHomeDir+"psfiles\"+Juststem(m_ifilename)+".ps"
m_ifilename = m.cHomeDir+"psfiles\"+Juststem(m_ifilename)+".ps"
Endif
If Justext(m_ifilename)="TXT"
Rename (m_ifilename) To 
m.cHomeDir+"psfiles\"+Juststem(m_ifilename)+".ps"
m_ifilename = m.cHomeDir+"psfiles\"+Juststem(m_ifilename)+".ps"
Endif
If Justext(m_ifilename)="ps" Or Justext(m_ifilename)="PS"
*Rename (m_ifilename) To "psfiles\"+Juststem(m_ifilename)+".ps"
*m_ifilename = "psfiles\"+Juststem(m_ifilename)+".ps"
Endif
gs = Filetostr(m.cHomeDir+"LocationOfgs.ini")
m_outfile = m.cHomeDir+"pdffiles\"+Juststem(m_ifilename) +".pdf"
m_cmd = [ -q -dSAFER -dNOPAUSE -dBATCH -sDEVICE#pdfwrite 
-sOutputFile#]+m_outfile +[ -dnodisplay -dCompatibilityLevel#1.2 -c 
.setpdfwrite -f ] +;
m_ifilename
m_cmd = (gs)+ m_cmd +Chr(0)
** this is the actual ps2pdf command sent to ghostscript
M_HANDLE=FCREATE("C:\GSME.BAT")
FWRITE(M_HANDLE,M_CMD,LEN(M_CMD))
FCLOSE(M_HANDLE)


Do runme With m_cmd
Set Safety &m_safety

*!**
*!
*! Procedure CLNPSFILES
*!
*!  Calls
*!  clnpsfiles
*!  runme
*!
*!**
Procedure clnpsfiles
** proceedure for clearing out the last ps file to be converted.
** general housekeeping
m_num = Adir(m_files,m.cHomeDir+"psfiles\*.ps")
If m_num  > 0
m_dir = "psfiles\"
For i=1 To m_num
m_filetoerase =(m_dir)+m_files[i,1]
Erase (m_filetoerase)
Next i
Endif
Endproc



*!**
*!
*! Procedure RUNME
*!
*!  Calls
*!  clnpsfiles
*!  runme
*!
*!**
Proc runme
Para m_cmd
#Define NORMAL_PRIORITY_CLASS 32
#Define IDLE_PRIORITY_CLASS 64
#Define HIGH_PRIORITY_CLASS 128
#Define REALTIME_PRIORITY_CLASS 1600

* Return code from WaitForSingleObject() if
* it timed out.
#Define WAIT_TIMEOUT 0x0102

* This controls how long, in milli secconds, WaitForSingleObject()
* waits before it times out. Change this to suit your preferences.
#Define WAIT_INTERVAL 200

Declare Integer CreateProcess In kernel32.Dll ;
INTEGER lpApplicationName, ;
STRING lpCommandLine, ;
INTEGER lpProcessAttributes, ;
INTEGER lpThreadAttributes, ;
INTEGER bInheritHandles, ;
INTEGER dwCreationFlags, ;
INTEGER lpEnvironment, ;
INTEGER lpCurrentDirectory, ;
STRING @lpStartupInfo, ;
STRING @lpProcessInformation

Declare Integer WaitForSingleObject In kernel32.Dll ;
INTEGER hHandle, Integer dwMilliseconds

Declare Integer CloseHandle In kernel32.Dll ;
INTEGER hObject

Declare Integer GetLastError In kernel32.Dll

* STARTUPINFO is 68 bytes, of which we need to
* initially populate the 'cb' or Count of Bytes member
* with the overall length of the structure.
* The remainder should be 0-filled
Start = long2str(68) + Replicate(Chr(0), 64)

* PROCESS_INFORMATION structure is 4 longs,
* or 4*4 bytes = 16 bytes, which we'll fill with nulls.
process_info = Replicate(Chr(0), 16)
* Start a copy of gs (EXE name must be null-terminated)
File2Run = m_cmd 

* Call CreateProcess, obtain a process handle. Treat the
* application to run as 

Dymo Twin Turbo

[Graham Brown]

Hi all

 

Probably a long shot but has anyone managed to get labels printing to a Dymo
450 Twin Turbo. 

I am trying to get it to choose the correct spool (printer has two) . It
always defaults to the last one printed to.

 

There is sample code for VB but nothing for Fox. Would've expected if I have
the driver installed I can just put the info into the frx memo field but
doesn't seem to want to play.

 

Thanks

Graham

 

 



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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/00f601d8f783$22610630$67231290$@compsys.co.uk
** 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.

CABuilder Revisited

[Graham Brown]

Hi

 

I posted before about the CABuilder tool asking for the original disk then
failing to find anything.

 

I traced the code and found the last line "Do (_browser) with (lcClassList)"
was causing the error and commenting this line allowed the code to complete
correctly. I have no idea what dependencies this needs and why it would
fail.

 

I hope this helps someone.

 

Graham

 



-- 
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/006001d80a2d$0b30c020$21924060$@compsys.co.uk
** 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] Microsoft wrongly blocking lots of emails

[Graham Brown]

I am not an expert but would a SPF record in the DNS help?
Does it need any other DNS changes to validate the email ?


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of MB Software 
Solutions, LLC
Sent: 05 January 2022 22:53
To: profox@leafe.com
Subject: Re: [NF] Microsoft wrongly blocking lots of emails

But here's what's oddmy IT guy says that his IP range is NOT on the 
blocked list.  Nor does M$ support find any problem (yet it doesn't work).

 From the M$ tech he worked with on this:

Hello,

My name is Farheen and I work with the Outlook.com Sender Support Team.

I do not see anything offhand with IP: (172.104.208.100) that would
be preventing your mail from reaching our customers.

You may be able to find additional information on common delivery
questions at the Outlook.com Postmaster Site found at
https://mail.live.com/mail/postmaster.aspx I would like to highlight
some key areas that I believe are appropriate to your company.

  * Outlook.com has created the *Smart Network Data Services
(SNDS)*program. This is a service that helps legitimate email
senders work with their customers and partners to reduce spam
originating from their IP. To register, please go to
http://postmaster.msn.com/snds/ This program allows a sender to
monitor the 'health' of their IPs.
  * Monitor user complaints. Outlook.com also has a sender complaint
feedback loop program called the *Junk Email Reporting Program
(JMRP)*. Enrolment in this free program will benefit you as a
sender as it will keep your email lists updated and populated
with interested Outlook.com customers. This program will help
you to remove those Outlook.com customers who do not want to
receive emails from your company. If you are interested in
joining this program, please visit
https://postmaster.live.com/snds/JMRP.aspx?wa=wsignin1.0.

While using the SNDS tool and enrolment in the JMRP will not allow
emails from your mail servers to bypass our filters, these are in
place to help legitimate companies deliver their emails to
Outlook.com customers.

*_ Apply for IP Certification by Return Path, a Validity Product?_*_
_If you are doing all the above and you continue to have
deliverability issues, you may wish to consider joining Return
Path's IP Certified Mail Program, *a third-party program
administered by Return Path*, *a Validity Product*. Many legitimate
mailers and marketers have qualified and joined this program to
improve mail deliverability and decrease email from being filtered
to the Junk E-mail Folder. *Return Path's IP Certification
(*https://www.validity.com/products/returnpath/certification/

*)*
*is the only service to which we subscribe*

The troubleshooting steps in this email are recommendations only.
Microsoft makes no guarantees that following these steps will
guarantee deliverability to MSN, Outlook.com, or Live.com customers.

For more detailed information about best sending practices to
Outlook.com users, please review the following white paper:

http://download.microsoft.com/download/e/3/3/e3397e7c-17a6-497d-9693-78f80be272fb/enhance_deliver.pdf
"


...So now he's going to look into this IP Certification by Return Path 
product.


On 1/5/2022 3:35 PM, Ed Leafe wrote:
> On Jan 5, 2022, at 14:21, MB Software Solutions, 
> LLC  wrote:
>> Anybody else experiencing errors like this trying to email folks who use 
>> Office 365 as their email provider?
>>
>> Access denied, banned sender[172.104.208.100]. To request removal from this
>> list please forward this messagetodel...@messaging.microsoft.com. For
>> more information please go to
>> http://go.microsoft.com/fwlink/?LinkId=526653. AS(1410)
>> [BN1NAM02FT015.eop-nam02.prod.protection.outlook.com] (in reply to RCPT 
>> TO
>> command)
> I've had to deal with a lot of email providers that block this list because 
> it's hosted on a VPS from Digital Ocean. It has nothing to do with the 
> content, just that the IP address is in a banned range.
>
> -- Ed Leafe
>
>
>
>
>
>
>
> ___
> Post Messages to:ProFox@leafe.com
> Subscription Maintenance:https://mail.leafe.com/mailman/listinfo/profox
> OT-free version of this 
> list:https://mail.leafe.com/mailman/listinfo/profoxtech
> Searchable Archive:https://leafe.com/archives
> This 
> message:https://leafe.co

RE: CABuilder

[Graham Brown]

Thanks

I have to support the vfp8 stuff so don't want to make big changes to the code 
base. Customer has asked for a link into Sage Online Accounting which is simple 
enough but it needs additional fields.

Will have to trace the CA Builder and see if I can see what it is complaining 
about. Unfortunately the Acer I always used for Fox dev breathed its last so I 
am a bit scuppered.


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of MB Software 
Solutions, LLC
Sent: 16 December 2021 22:08
To: profox@leafe.com
Subject: Re: CABuilder

Ever since Ed Leafe and some others posted that failings of CAs, I never 
spent another minute on them.  I've used Paul McNett's MakeUpdatable.prg 
for years although I morphed it into something else I think eventually 
in my framework which uses SPT exclusively.  I will admit that the Fox 
team did fix some of those errors apparently but I never looked back.


On 12/16/2021 4:25 PM, Graham Brown wrote:
> Hi all
>
>   
>
> I use Paul's CABuilder tool under vfp8 to create Cursor Adapters. Just
> lately it has started failing under Windows 8.
>
> Database is SQL so I'm ticking the convert date/time to date option,
> selecting SQL and ODBC. It runs through all the tables then says I don't
> have something installed and asks for the setup.
>
> Doesn't say what it is missing and putting the original disc in tells me it
> can't find the setup files.
>
>   
>
> Will trace the code to see if I can find any clues but has anyone seen this
> before?
>
>   
>
> Regards
>
> Graham
>
>   
>
>
>
-- 
Michael J. Babcock, MCP
Fox/VFP dev since 1997
Developer of FabNet estimating software - mbsoftwaresolutions.com


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/011e01d7f772$68b20ab0$3a162010$@compsys.co.uk
** 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.

CABuilder

[Graham Brown]

Hi all

 

I use Paul's CABuilder tool under vfp8 to create Cursor Adapters. Just
lately it has started failing under Windows 8.

Database is SQL so I'm ticking the convert date/time to date option,
selecting SQL and ODBC. It runs through all the tables then says I don't
have something installed and asks for the setup.

Doesn't say what it is missing and putting the original disc in tells me it
can't find the setup files.

 

Will trace the code to see if I can find any clues but has anyone seen this
before?

 

Regards

Graham

 



-- 
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/010501d7f2c3$6ec07490$4c415db0$@compsys.co.uk
** 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] Winforms

[Graham Brown]

Hi all

Thanks for all your replies. Don't understand why Microsoft haven't sorted
visual inheritance properly.
WPF (sigh) another technology to study.



-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Alan Bourke
Sent: 20 August 2021 14:54
To: profoxt...@leafe.com
Subject: Re: [NF] Winforms

Graham

I'd definitely consider Windows Presentation Foundation over Winforms if
this inheritance thing is a problem for you, because WPF *does* support that
sort of visual inheritance, and i will set you up for WinUI going forward.

-- 
  Alan Bourke
  alanpbourke (at) fastmail (dot) fm

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/003901d795eb$6c26e320$4474a960$@compsys.co.uk
** 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] Winforms

[Graham Brown]

Hi all

Are there any VB.NET Winforms gurus around.

I am struggling with custom controls in Winforms. So when I start a new
project in Visfox I create custom VCXs for the different forms and form
controls. I then use these custom controls throughout the project.

I can create an inherited form with the layout I need but when I use this
form in the project all the base controls are locked  which I think is
something to do with "Friend" but I don't understand.

In Visfox I create a VCX for controls (e.g. textbox, label, combobox etc )
and inherit from the windows controls. Customisation of these controls is
visual so click on the properties and change the font size etc.
In Winforms there doesn't seem to be any visual element to this I have to
write all the code for it.

Am I missing something?

Cheers Graham




-- 
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/00c801d79389$8e374b30$aaa5e190$@compsys.co.uk
** 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] Winforms

[Graham Brown]

Hi Alan

"Programmatically add designer support"? 

Hmm how does that work, do you know of any resources to read up on?

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Alan Bourke
Sent: 18 August 2021 13:04
To: profox@leafe.com; profoxt...@leafe.com
Subject: Re: [NF] Winforms

It's been many years since I used WinForms but if I remember visual
inheritance and WinForms designer support in Visual Studio don't work the
same as you would be used to from VFP or VB6. Basically you have to
programmatically add designer support, or as you say programmatically update
any control properties you want to change.

WPF and its successors are much better in this regard.


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/013601d79450$d96d6a40$8c483ec0$@compsys.co.uk
** 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] Winforms

[Graham Brown]

Hiya
That's the problem.

I can't figure out how to create a subclassed version of a textbox for
instance in the first place.

If I want to set every textbox in the system to 10pt I don't want to edit
every control on every form to change the font size. I  would just want to
change it in the textbox base and compile.

The only way I can find in the help docs is to create a new usercontrol and
put the textbox inside a usercontrol. Every form then has the new
usercontrol and not a direct textbox.
This seems like a right pitb

What am I missing?


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Stephen Russell
Sent: 18 August 2021 17:12
To: ProFox Email List
Subject: Re: [NF] Winforms

You could create a project where you subclassed any form widget in your way.

Then in every new solution, you include that project and use those classes
at the top instead of:
using  System.Windows.Forms.Form

you would use :
using  MyUberCoolSystem.Windows.Forms.Form

Just like you had to do in VFP as I remember.

I would never do that again, personally.  If I need to override something
I'd do it in just this application, and not everything I did.  Extending
the functionality of classes is easy as needed.  In all of my data objects,
I override the ToString() to output a serialized json string of the data.



On Wed, Aug 18, 2021 at 7:04 AM Alan Bourke  wrote:

> It's been many years since I used WinForms but if I remember visual
> inheritance and WinForms designer support in Visual Studio don't work the
> same as you would be used to from VFP or VB6. Basically you have to
> programmatically add designer support, or as you say programmatically
> update any control properties you want to change.
>
> WPF and its successors are much better in this regard.
>
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/013501d7944e$ec691ab0$c53b5010$@compsys.co.uk
** 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] Winforms

[Graham Brown]

Hi all

Are there any VB.NET Winforms gurus around.

I am struggling with custom controls in Winforms. So when I start a new
project in Visfox I create custom VCXs for the different forms and form
controls. I then use these custom controls throughout the project.

I can create an inherited form with the layout I need but when I use this
form in the project all the base controls are locked  which I think is
something to do with "Friend" but I don't understand.

In Visfox I create a VCX for controls (e.g. textbox, label, combobox etc )
and inherit from the windows controls. Customisation of these controls is
visual so click on the properties and change the font size etc.
In Winforms there doesn't seem to be any visual element to this I have to
write all the code for it.

Am I missing something?

Cheers Graham




-- 
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/00dd01d7938f$53a779d0$faf66d70$@compsys.co.uk
** 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: MyODBC

[Graham Brown]

Thanks

The ConnectString just shows the DSN name.

I did create a file dsn, located the file in the common folder and it has an
"OPTION=524298". Still not showing me the MyODBC.SQL file though.

Nothing else in the DSN so not sure what else it needs.

Graham


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ted Roche
Sent: 29 November 2018 18:55
To: profox@leafe.com
Subject: Re: MyODBC

I don't know, but here's how I would go about figuring it out:

1. Start up the ODBC Administrator (make sure it's the 32-bit version!) 2.
Create a new System DSN using the MyODBC driver. Search through the
Options/Properties dialogs for the logging function and turn it on.
3. In VFP, using SQLConnect() to connect to a database.
4. Using the connection number you got in #3, query the connection like:

MyString = SQLGetProp(cnMyConnectionNumber, "StringConnect")

and that should get you the connection string settings.



On Thu, Nov 29, 2018 at 1:30 PM Graham Brown  wrote:

> Hi
>
>
>
> Does anyone know how to switch on the logging function in the ODBC 
> driver please.
>
> MyODBC says use "option=4" in the sqlstringconnect but this doesn't 
> appear to do anything.
>
> Graham
>
>
>
>
>
>
>
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
>
>
> --- 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://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/000e01d48831$69055840$3b1008c0$@compsys.co.uk
** 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.

MyODBC

[Graham Brown]

Hi

 

Does anyone know how to switch on the logging function in the ODBC driver
please.

MyODBC says use "option=4" in the sqlstringconnect but this doesn't appear
to do anything.

Graham

 

 



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/014201d48811$8ab1d9c0$a0158d40$@compsys.co.uk
** 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: MyODBC not updating tables

[Graham Brown]

Thanks for the pointers 

The app runs local on Windows 7 and uploads a lot of Excel data to an
external online portal on shared hosting.

The hosting has a remote SQL option to unlock the port for my IP. If the
port is locked it won't even connect. 
Also I get a connection and I can fire off select and delete commands but
not update and insert commands.
I've checked the size of the MySQL DB and it isn't over quota.

I don't know anything about the set up as it is shared hosting with
www.20i.co.uk. As the domain is managed by another company I can't even talk
to 20i myself.
I don't know where MySQL is in relation to PHPMyAdmin. They just say use the
mysql.abc.com in the hostname and they resolve this to the correct box.

The domain was originally hosted by HeartInternet.co.uk and the update
always worked.

One thing the 20i have said in the last hour is that there are a number of
"discarded" commands in the event log. I haven't found out why they are
discarded but there doesn't appear to be any problems with the SQL as I can
run the same sql in PHPMyAdmin.

I don't get any error so don't know how to check what the ODBC or MySQL is
doing or why commands are being discarded if they are mine.

Regards 
Graham





-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ted Roche
Sent: 28 November 2018 14:01
To: profox@leafe.com
Subject: Re: MyODBC not updating tables

On Wed, Nov 28, 2018 at 6:38 AM Graham Brown  wrote:

>
> nMySQL=Sqlstringconnect("Driver=MySQL ODBC 5.1 
> Driver;SERVER=mysql.abc.com
> ;UID={aw};PWD={test};DATABASE={aw16};port=52905")
>
> and sqlexec(nMySQL,cSQL)
>

Do you capture the results of these functions and test that they are not
returning an error?


> It has worked for years but the client recently moved to a new hosting 
> company. No errors at runtime, no data arrives in the table but I can 
> run these commands in PHPMyAdmin so the SQL commands are fine.
>

PHPMyAdmin is running on the same machine as the MySQL, or a different one?

The VFP is surely running on a Windows box. The PHP and MySQL, well, you
didn't say.

Offhand, I'd confirm that port 52905 is open in any firewall in place.

--
Ted Roche
Ted Roche & Associates, LLC
http://www.tedroche.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://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/062901d48768$6d6cea70$4846bf50$@compsys.co.uk
** 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.

MyODBC not updating tables

[Graham Brown]

Hello 

 

I've just had to revisit a foxpro app I wrote about 10 years ago.

 

This just reads an excel spreadsheet, generates an SQL statement and fires
it at a MySQL database.

I'm using MyODBC 5.1 and Foxpro 8.

 

This is a sample of the SQL. 

insert into aw_due
(f_mem_rn,f_supplier_rn,f_mem_name,f_supp_name,f_date,f_value,f_mem_code,f_x
ls_ref) values (544,0,

'AB ','An','1990/01/01',3735.49,'117 ','');

 

The code opens a connection with 

nMySQL=Sqlstringconnect("Driver=MySQL ODBC 5.1
Driver;SERVER=mysql.abc.com;UID={aw};PWD={test};DATABASE={aw16};port=52905")

and sqlexec(nMySQL,cSQL)

 

It has worked for years but the client recently moved to a new hosting
company. No errors at runtime, no data arrives in the table but I can run
these commands in PHPMyAdmin so the SQL commands are fine.

 

Has anybody seen anything like this please?

 

Graham

 



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/05c301d4870f$01b31600$05194200$@compsys.co.uk
** 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.

VFP6 / Codemine7 kill switch

[Graham Brown]

Hi

 

 

I have a legacy app written in VFP6 with Codemine7. The customer has just
asked for some new reports but I'm finding it will not compile on Windows 7,
8 or 10.

It throws messages which may be Codemine related saying Session not
initialised. It also complains about not being able to write to the
registry.

 

SP5 will not install because MDAC is not installed, MDAC install just
freezes or quits the install with no error.

 

Is anybody aware of any reasons or whether there are any kill switches in
either product.

 

I've got a Windows XP (yes I know) computer on the way to try it on that.

 

 

Regards

 

Graham Brown



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/00f701d28777$0f2a3cd0$2d7eb670$@compsys.co.uk
** 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.

Registry errors in Windows 10

[Graham Brown]

Hi all

I have several apps written in VFP8 with the Codemine8 framework, when the 
application runs it comes up with the initial registration screen normally not 
a problem just complete the screen fill in the path to local data and click 
finish.

Windows 10 now throws up a message saying it can't find file appreg02.  I've 
attempted to trace this through but cannot find anything.

Has anyone come across the same error message please?

Regards
Graham



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/085701d1d062$454b4bf0$cfe1e3d0$@compsys.co.uk
** 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] Two DHCP servers on a network - Changed to [NF]

[Graham Brown]

Hi 

No reason why Server 2012 DHCP can't be turned off, just trying to
understand the implications of doing so.
It is one of the things I've never found "best practice", if there is such a
thing, just different opinions. Even the MCSEs I know tend to look blank at
me on this one...!

Bigger networks will have wired and wireless devices so I wouldn't think I'm
doing anything out the ordinary.
Not even sure if I should care if it is the first responder giving the IP
address, this never seems to be the server in any case as it is always the
higher range.

Different subnets sounds interesting though, I'll have a read on that one.




-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ted Roche
Sent: 23 February 2016 11:39
To: profox@leafe.com
Subject: Re: [NF] Two DHCP servers on a network - Changed to [NF]

On Tue, Feb 23, 2016 at 3:42 AM, Graham Brown  wrote:
>
> My thinking was if anything logs into the domain it will take the 
> server DHCP IP address range and wifi devices from the router DHCP IP
range.
>

I think this is wishful thinking. On startup, the ethernet devices
essentially broadcast a plea over the network, "Who can give me an IP
address?" and pick one of the responders. IIRC, the first to answer, but no
guarantee who.

> It appears it is a bad idea to have 2 DHCP servers but not sure if 
> this will stop the tablets and smartphones getting a connection.

It sounds like a bad idea to me.

Is there a reason why you can't just turn off the DHCP server on the Win
2012 box?

https://technet.microsoft.com/en-us/library/cc778064(v=ws.10).aspx

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

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/0b4e01d16e3a$3b5ec480$b21c4d80$@compsys.co.uk
** 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] Two DHCP servers on a network - Changed to [NF]

[Graham Brown]

Hi 

I have test platform network running server 2012, the PCs are cat cabled
back to the network switch.
All the PCs connect to the domain.

I also have several wifi devices (laptops/tablets/smartphones) which connect
the internet but not the server or domain. The Virgin Media router also has
DHCP.

The router is fixed to 192.168.1.1
The server is fixed to 192.168.1.2

I've also set the ranges for DHCP so the server has 192.168.1.10 to
192.168.1.230 The router has the range 192.168.1.239 and above.

My thinking was if anything logs into the domain it will take the server
DHCP IP address range and wifi devices from the router DHCP IP range.

Having checked all the connected devices they all seem to be 239 and above.

It appears it is a bad idea to have 2 DHCP servers but not sure if this will
stop the tablets and smartphones getting a connection.

Could anyone point me towards best practices please. Not sure if I can turn
off DHCP on the server altogether.

Regards
Graham






---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/0b2301d16e16$1da2cf00$58e86d00$@compsys.co.uk
** 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] Two DHCP servers on a network

[Graham Brown]

Hi 

I have test platform network running server 2012, the PCs are cat cabled
back to the network switch.
All the PCs connect to the domain.

I also have several wifi devices (laptops/tablets/smartphones) which connect
the internet but not the server or domain. The Virgin Media router also has
DHCP.

The router is fixed to 192.168.1.1
The server is fixed to 192.168.1.2

I've also set the ranges for DHCP so the server has 192.168.1.10 to
192.168.1.230
The router has the range 192.168.1.239 and above.

My thinking was if anything logs into the domain it will take the server
DHCP IP address range and wifi devices from the router DHCP IP range.

Having checked all the connected devices they all seem to be 239 and above.

It appears it is a bad idea to have 2 DHCP servers but not sure if this will
stop the tablets and smartphones getting a connection.

Could anyone point me towards best practices please. Not sure if I can turn
off DHCP on the server altogether.

Regards
Graham






---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/096601d16bf8$d1fd60c0$75f82240$@compsys.co.uk
** 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] Two DHCP servers on a network

[Graham Brown]

Hi 

I have test platform network running server 2012, the PCs are cat cabled
back to the network switch.
All the PCs connect to the domain.

I also have several wifi devices (laptops/tablets/smartphones) which connect
the internet but not the server or domain. The Virgin Media router also has
DHCP.

The router is fixed to 192.168.1.1
The server is fixed to 192.168.1.2

I've also set the ranges for DHCP so the server has 192.168.1.10 to
192.168.1.230 The router has the range 192.168.1.239 and above.

My thinking was if anything logs into the domain it will take the server
DHCP IP address range and wifi devices from the router DHCP IP range.

Having checked all the connected devices they all seem to be 239 and above.

It appears it is a bad idea to have 2 DHCP servers but not sure if this will
stop the tablets and smartphones getting a connection.

Could anyone point me towards best practices please. Not sure if I can turn
off DHCP on the server altogether.

Regards
Graham






---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/096a01d16bfa$905e9a10$b11bce30$@compsys.co.uk
** 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] Reporting in .NET

[Graham Brown]

Hi 

 

I'm evaluating Visual Studio  and have got as far the built in RDLC
report writer  which isn't anywhere near as good as fox.

 

One of my reports is a standard invoice layout, in fox I'd just draw the
lines from the page header to the page footer and all works fine.

In RDLC this doesn't work.

 

It has this thing called a Tablix which I can put a border round but
this box border is only as big as the number of lines in the table.

So with one line item on the invoice I get a small box with a load of
white space which looks rubbish.

 

Does anyone know how to get the Tablix border  to fill the space between
page header and page footer please?

 

The only answer  I can find on the web is adding blank records to the
report datasource which sounds even worse, that or using Crystal.

 

Regards

Graham

 



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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/A7F53C603656FA4CBE6CE969E85A11911C0782@compsrv.compsys.local
** 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: Excel 2013 slow automation

[Graham Brown]

Thanks

Excel is not visible until the function completes but will give that a go.

Regards
Graham


-Original Message-
From: ProFox on behalf of Man-wai Chang
Sent: Sat 23/05/2015 14:45
To: ProFox Email List
Subject: Re: Excel 2013 slow automation
 
Did you use ApplicationUpdating to lock screen changes until the end
of processing?

On Sat, May 23, 2015 at 5:02 PM, Graham Brown  wrote:
> Has anyone seen any problems with Excel automation?
> My code creates an excel spreadsheet, writing out various info from the 
> tables, in 2010 and earlier it takes about 1 minute to write out 1500 lines 
> but in 2013 it is more like 45 minutes.
> Checked with AV on and off, closed all other apps etc etc so it definitely 
> seems to be 2013.

-- 
 .~. Might, Courage, Vision. SINCERITY!
/ v \ 64-bit Ubuntu 9.10 (Linux kernel 2.6.39.3)
/( _ )\ http://sites.google.com/site/changmw
^ ^ May the Force and farces be with you!

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/A7F53C603656FA4CBE6CE969E85A119108C130@compsrv.compsys.local
** 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.

Excel 2013 slow automation

[Graham Brown]

Hello 

Has anyone seen any problems with Excel automation?

My code creates an excel spreadsheet, writing out various info from the tables, 
in 2010 and earlier it takes about 1 minute to write out 1500 lines but in 2013 
it is more like 45 minutes.
Checked with AV on and off, closed all other apps etc etc so it definitely 
seems to be 2013.

Regards
Graham


--- StripMime Report -- processed MIME parts ---
multipart/mixed
  text/plain (text body -- kept)
  application/ms-tnef
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/A7F53C603656FA4CBE6CE969E85A119108C12F@compsrv.compsys.local
** 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: Shield icon and "Allow this program to make changes"

[Graham Brown]

Hi 

The app runs from a mapped network drive. The UAC message comes up
before it launches anything.
Not sure about whether the project properties have fixed it though, sent
a revised exe to the client to check.


Regards

Graham Brown








-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Chris Davis
Sent: 11 March 2015 13:15
To: profox@leafe.com
Subject: RE: Shield icon and "Allow this program to make changes"

Where is it running from? Program Files? If it is then is it trying to
do "STUFF" in Program Files which without UAC turned off is not allowed
without responding to that prompt.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
Graham Brown
Sent: 11 March 2015 12:18
To: profoxt...@leafe.com
Subject: Shield icon and "Allow this program to make changes"

Hi 

 

Has anyone seen this before please?

 

I have just replaced my aging Windows XP development pc with a Windows 7
pc. 

 

Every VFP8 app I now compile on Windows 7 now shows a blue/yellow shield
icon and when the application is run it shows a User Account Control
message asking if it is ok for this program to make changes to the local
settings.

 

The app runs on a network so disabling security controls is a no-no.

 

Not worried about the shield icon but the UAC message is going to annoy
the customers.

 

Appreciate any pointers.

 

Regards

Graham

 



--- 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://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/A7F53C603656FA4CBE6CE969E85A11911C068D@compsrv.compsys.local
** 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: Shield icon and "Allow this program to make changes"

[Graham Brown]

Hi

Thanks, it is definitely an odd problem.  From what I can see there is
no whitelist option and it only appeared after a build with Windows 7.

Not sure if it is a fluke but I've just filled in the project properties
author etc, built the exe as a different name and the shield icon has
disappeared.
It also isn't asking for UAC.



Regards

Graham Brown







___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/A7F53C603656FA4CBE6CE969E85A11911C068C@compsrv.compsys.local
** 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.

Shield icon and "Allow this program to make changes"

[Graham Brown]

Hi 

 

Has anyone seen this before please?

 

I have just replaced my aging Windows XP development pc with a Windows 7
pc. 

 

Every VFP8 app I now compile on Windows 7 now shows a blue/yellow shield
icon and when the application is run it shows a User Account Control
message asking if it is ok for this program to make changes to the local
settings.

 

The app runs on a network so disabling security controls is a no-no.

 

Not worried about the shield icon but the UAC message is going to annoy
the customers.

 

Appreciate any pointers.

 

Regards

Graham

 



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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/A7F53C603656FA4CBE6CE969E85A11911C068B@compsrv.compsys.local
** 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] Garbaged folder structure

[Graham Brown]

Hi 


The workstation is Windows 7, server is an old SBS server.
I RDP'd to the server and the folders appeared corrupted on the server
as well.

The original folders were still there as well but hidden.

Does sound like some malware got in but scans were clean like your
problem.

Definitely something weird.




Regards
Graham




What's the workstation OS? Is this a desktop shortcut that's going all
cattywampus?

I'm chasing down a problem that *might* be related: a Windows 7 Pro
workstation has problems with desktop shortcuts that just turn to mush -
sometimes links to non-existent registry entries, or broken links to
existing exe's. Machine has layers upon layers of anti-malware
(firewall, active scanner, MSE, etc.) so I don't *think* it's a malware
more than a misfire.

Here's a website (don't know of the accuracy) claiming it's a desktop
maintenance task:

http://www.ghacks.net/2010/03/30/fix-windows-7-desktop-shortcuts-disappe
aring/



On Thu, Jan 29, 2015 at 3:13 AM, Graham Brown 
wrote:

>
>
> Hi
>
>
>
> I have a Foxpro 6 app running on an SBS server from a mapped network 
> drive (O:)
>
> In the O: root  I should have a gage_tup folder but if I right click 
> properties on this folder I actually see a shortcut instead with this 
> command line.
>
>
>
> C:\windows\system32\cmd.exe /C start cmd.exe /C if exist 
> "\\SBS\cbs\FDP5\CLIPART\cJVssV.AYl
>  " start ""
> "\\SBS\cbs\FDP5\CLIPART\cJVssV.AYl
>  " && start ""
> "\\SBS\cbs\GAGE_TUP  "
>
>
>
> All the folders have been replaced with the same weird shortcuts. I 
> have scanned workstations and servers for problems and all reports
clean.
>
> This has happened once before on a different network and a vfp8 
> application.
>
>
>
> I've fixed by restoring a clean backup and reimporting the tables but 
> would be interested to know if anybody else has seen the problem.
>
>
>
> Cheers
>
> Graham
>
>
>
>
>
> --- 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://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/A7F53C603656FA4CBE6CE969E85A11911C05D9@compsrv.compsys.local
** 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] Garbaged folder structure

[Graham Brown]

 

Hi 

 

I have a Foxpro 6 app running on an SBS server from a mapped network
drive (O:) 

In the O: root  I should have a gage_tup folder but if I right click
properties on this folder I actually see a shortcut instead with this
command line.

 

C:\windows\system32\cmd.exe /C start cmd.exe /C if exist
"\\SBS\cbs\FDP5\CLIPART\cJVssV.AYl
 " start ""
"\\SBS\cbs\FDP5\CLIPART\cJVssV.AYl
 " && start ""
"\\SBS\cbs\GAGE_TUP  "

 

All the folders have been replaced with the same weird shortcuts. I have
scanned workstations and servers for problems and all reports clean.

This has happened once before on a different network and a vfp8
application.

 

I've fixed by restoring a clean backup and reimporting the tables but
would be interested to know if anybody else has seen the problem.

 

Cheers

Graham

 



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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/A7F53C603656FA4CBE6CE969E85A11911C05CA@compsrv.compsys.local
** 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] Telerik

[Graham Brown]

Hi 

 

Has anyone used the Telerik Rad controls for Winforms.

 

Just wondering if they are any good.

 

Cheers

Graham

 



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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/A7F53C603656FA4CBE6CE969E85A11910BDA8C@compsrv.compsys.local
** 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 Codemine 8 gurus out there?

[Graham Brown]

Just heard back from Dave at Tech Soft Classics/Codemine tech support.
The source to this is in the template folder in the .SQL file.

If that helps anyone else.

Regards

Graham Brown







-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Graham Brown
Sent: 02 September 2014 12:15
To: ProFox Email List
Subject: Any Codemine 8 gurus out there?

Hi all

 

Just messing with some old VFP8/CM8 apps trying to upsize the eventlog
and registry keys to SQL Server.

It is saying it can't find sproc sp_cm_incrementcounter.

 

Does anyone still have CM8 around and can let me have the source to
whatever sprocs it is trying to create please.

 

Cheers

Graham

 



--- 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://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/A7F53C603656FA4CBE6CE969E85A11910BDA69@compsrv.compsys.local
** 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 Codemine 8 gurus out there?

[Graham Brown]

Hi all

 

Just messing with some old VFP8/CM8 apps trying to upsize the eventlog
and registry keys to SQL Server.

It is saying it can't find sproc sp_cm_incrementcounter.

 

Does anyone still have CM8 around and can let me have the source to
whatever sprocs it is trying to create please.

 

Cheers

Graham

 



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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/A7F53C603656FA4CBE6CE969E85A11910BDA64@compsrv.compsys.local
** 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: Opening PDFs

[Graham Brown]

Thanks but not clear how to use this.

I've opened object browser for Adobe reader, the interfaces show
IAcroAXDocShim and _IAcroAXDocShimEvents.
Dragging either of these to a prg does show all the methods but
attempting to run says it can't find "AcroPDFLib.AcroPDF" 

Not sure what installs this as I've only got the viewer not full
distiller.

Regards

Graham Brown







-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Tracy
Pearson
Sent: 06 June 2014 16:46
To: profox@leafe.com
Subject: RE: Opening PDFs 

Graham Brown wrote on 2014-06-06: 
>  Hi all
> 
> 
>  One of my clients wants to be able to show a pdf document but disable

> Save/Email/Print/Copy.
>  
>  I've embedded the activex into a fox form but there doesn't seem to 
> be  any way to hide the autohide menu in the view (called a heads up 
> display  or HUD)
>  
>  Doesn't seem to be any way to bindevents to the methods either.
> 
> 
>  Has anyone come across a simple way to achieve this please?
> 
> 
>  Regards
>  
>  Graham
> 
> 
> 
> 

Graham,

It might be simplest to set a password on to the PDF files that prevent
those functions from working.

But going with your VFP solution...

I have, in the past, with VFP, needed to work with an Interface class,
then use EventHandler() to connect the ActiveX/COM object and the
Interface object together.

If you open the ActiveX in Object Browser, you can drag an Interface
(one that is bolded) to a new prg. It will create the interface
structure for you. There might be an event that is fired when attempting
to do one of these things which you can block the action from happening.

For instance, the CodeStone SMTP control (http://www.codestone.co.uk/)
has an ILogHandler interface. It allowed me to capture more details when
I was having troubles with a particular server. This is how they get
connected:
  This.oLog = CREATEOBJECT("csmail.loghandler")
  This.oLogHandler = NEWOBJECT("csmailloghandler",
"csmailloghandler.fxp")
  EVENTHANDLER(This.oLog, This.oLogHandler)

Tracy Pearson
PowerChurch Software


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/A7F53C603656FA4CBE6CE969E85A11910BD88A@compsrv.compsys.local
** 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.

Opening PDFs

[Graham Brown]

Hi all

 

One of my clients wants to be able to show a pdf document but disable
Save/Email/Print/Copy. 

I've embedded the activex into a fox form but there doesn't seem to be
any way to hide the autohide menu in the view (called a heads up display
or HUD)

Doesn't seem to be any way to bindevents to the methods either.

 

Has anyone come across a simple way to achieve this please?

 

Regards

Graham

 



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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/A7F53C603656FA4CBE6CE969E85A11910BD889@compsrv.compsys.local
** 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: Recreate VCX,SCX from SCC

[Graham Brown]

Thanks, I'll check that 

The laptop I use is getting a bit old, it freezes periodically and
whatever project I'm working on garbages either the scx or vcx files. 
I'm using the SCC files as a secondary backup so I can cut and paste
code back in.





___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/A7F53C603656FA4CBE6CE969E85A11910BD81C@compsrv.compsys.local
** 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.

Recreate VCX,SCX from SCC

[Graham Brown]

Hi 

 

I'm using the SCC utility to create source backups of VCX, FRX and SCX
files.

Has anyone come across  a way to recreate the original files from the
VCA, SCA and FRA files SCC creates?

 

Regards

 

Graham

 



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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/A7F53C603656FA4CBE6CE969E85A11910BD7EB@compsrv.compsys.local
** 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: Convert HTML from image link to embedded image

[Graham Brown]

Hi Paul

Don't know if helps but I used a product called html2exe a long time
ago. This creates a single file with all the images embedded
I think I used this for some ebook type thing years ago.

Regards

Graham Brown








-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Paul Newton
Sent: 02 May 2014 10:01
To: profox@leafe.com
Subject: Convert HTML from image link to embedded image

Hi all

I have some HTML files containing text and images (which when I examine
the HTML contains references/links to JPG files).  I need to convert
these links to embedded images, using VFP, so that the HTML does not
rely on the presence of the JPGs.  Any suggestions?  Is this even
possible?

Many thanks

Paul Newton 



[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/A7F53C603656FA4CBE6CE969E85A11910BD7CD@compsrv.compsys.local
** 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 CSV or Excel

[Graham Brown]

Hi 

I had a project which took emailed pdfs from outlook. I grabbed the text
from these and created jobs in the MySQL database.
I looked for ages for an easy way to do this, pdflib seemed to be the
only real contender but it cost more than the customer would pay.


My project opened the attachment with Adobe Reader then used an API call
to find the opened instance.
Once it had a handle it stuffed a CTRL A  and CTRL C 

I then used _cliptext to read and process the info.

Not elegant but it worked. 

Happy to dig out some code if you'd like to have a look see.

Regards

Graham Brown








-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Jeff Johnson
Sent: 14 February 2014 16:16
To: profox@leafe.com
Subject: [NF] PDF to CSV or Excel

Greetings:  I have used a number of tools to convert a PDF to CSV with
no success.  Has anyone found a Windows application that can do PDF to
CSV conversions reliably?  Paid application does not matter at this
point.

Thanks,

--
Jeff

Jeff Johnson
j...@san-dc.com
SanDC, Inc.
623-582-0323
Fax 623-869-0675

http://www.san-dc.com
  


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/A7F53C603656FA4CBE6CE969E85A11910BD651@compsrv.compsys.local
** 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: Invalid seek offset

[Graham Brown]

Less than 24 hours after speaking to the server guys, the server failed
with hard drive errors.
At this point they said the monitoring software on the network had been
warning of impending doom for some time but they'd done nothing about it
except blaming the software.

Thought I'd share that just in case anybody else gets the same.






-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Graham Brown
Sent: 14 January 2014 11:45
To: ProFox Email List
Subject: RE: Invalid seek offset

Thanks. Very interesting, I've asked the network techs to check this
out.
I'll report back later.



Graham,
I think this link was posted on here recently. If not then I apologise
but M$ seem to have found a resolution for network shares dropping out
intermittently, which as Christof says is one cause of the error:

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

Dave

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Graham Brown
Sent: 14 January 2014 10:50
To: ProFox Email List
Subject: RE: Invalid seek offset

Thanks Dave

I'll grab the codemine data folder later and rebuild it.

Have you found any way to monitor the network for timeouts?

I think this network has issues because I know when I try to copy new
exes on it will tell me the file is in use, the server open files shows
the exe as being open several times on each pc  (single instance exe so
isn't possible) and when I check these pcs they are switched off. 

The hardware guys don't understand or don't want to understand so don't
bother investigating.

Only this one site reporting reporting problems.

All very strange.



Graham,
Usually index corruption or a corruption of the DBF header. Normally
copying the data to a new table then zapping and appending back cures
the problem. The cause of the corruption I most often found was network
timeouts caused by cheap network cards or switches.

Dave

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Graham Brown
Sent: 14 January 2014 10:05
To: ProFox Email List
Subject: Invalid seek offset

Hi all

 

One of my clients has just started getting invalid seek offset errors.
The app is vfp8/codemine8 with a SQL 2005 database.

I'm just trying to pin it down to see if it is antivirus or power saving
etc. Also asked the hardware guys to see if anything appears in any of
the log files.

 

Has anyone come across a definitive reason for this error?

 

Regards

Graham

 



--- 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://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/A7F53C603656FA4CBE6CE969E85A11910BD5E6@compsrv.compsys.local
** 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: Invalid seek offset

[Graham Brown]

Thanks. Very interesting, I've asked the network techs to check this
out.
I'll report back later.



Graham,
I think this link was posted on here recently. If not then I apologise
but M$ seem to have found a resolution for network shares dropping out
intermittently, which as Christof says is one cause of the error:

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

Dave

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Graham Brown
Sent: 14 January 2014 10:50
To: ProFox Email List
Subject: RE: Invalid seek offset

Thanks Dave

I'll grab the codemine data folder later and rebuild it.

Have you found any way to monitor the network for timeouts?

I think this network has issues because I know when I try to copy new
exes on it will tell me the file is in use, the server open files shows
the exe as being open several times on each pc  (single instance exe so
isn't possible) and when I check these pcs they are switched off. 

The hardware guys don't understand or don't want to understand so don't
bother investigating.

Only this one site reporting reporting problems.

All very strange.



Graham,
Usually index corruption or a corruption of the DBF header. Normally
copying the data to a new table then zapping and appending back cures
the problem. The cause of the corruption I most often found was network
timeouts caused by cheap network cards or switches.

Dave

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Graham Brown
Sent: 14 January 2014 10:05
To: ProFox Email List
Subject: Invalid seek offset

Hi all

 

One of my clients has just started getting invalid seek offset errors.
The app is vfp8/codemine8 with a SQL 2005 database.

I'm just trying to pin it down to see if it is antivirus or power saving
etc. Also asked the hardware guys to see if anything appears in any of
the log files.

 

Has anyone come across a definitive reason for this error?

 

Regards

Graham

 



--- 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://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/A7F53C603656FA4CBE6CE969E85A11910BD5DC@compsrv.compsys.local
** 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: Invalid seek offset

[Graham Brown]

Thanks Dave

I'll grab the codemine data folder later and rebuild it.

Have you found any way to monitor the network for timeouts?

I think this network has issues because I know when I try to copy new
exes on it will tell me the file is in use, the server open files shows
the exe as being open several times on each pc  (single instance exe so
isn't possible) and when I check these pcs they are switched off. 

The hardware guys don't understand or don't want to understand so don't
bother investigating.

Only this one site reporting reporting problems.

All very strange.



Graham,
Usually index corruption or a corruption of the DBF header. Normally
copying the data to a new table then zapping and appending back cures
the problem. The cause of the corruption I most often found was network
timeouts caused by cheap network cards or switches.

Dave

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Graham Brown
Sent: 14 January 2014 10:05
To: ProFox Email List
Subject: Invalid seek offset

Hi all

 

One of my clients has just started getting invalid seek offset errors.
The app is vfp8/codemine8 with a SQL 2005 database.

I'm just trying to pin it down to see if it is antivirus or power saving
etc. Also asked the hardware guys to see if anything appears in any of
the log files.

 

Has anyone come across a definitive reason for this error?

 

Regards

Graham

 



--- 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://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/A7F53C603656FA4CBE6CE969E85A11910BD5D9@compsrv.compsys.local
** 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.

Invalid seek offset

[Graham Brown]

Hi all

 

One of my clients has just started getting invalid seek offset errors.
The app is vfp8/codemine8 with a SQL 2005 database.

I'm just trying to pin it down to see if it is antivirus or power saving
etc. Also asked the hardware guys to see if anything appears in any of
the log files.

 

Has anyone come across a definitive reason for this error?

 

Regards

Graham

 



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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/A7F53C603656FA4CBE6CE969E85A11910BD5D6@compsrv.compsys.local
** 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] Website hacks.

[Graham Brown]

Hi all

 

I've had one of my websites attacked over the weekend, ended up with
loads of random text in the various fields.

The common theme seems to be a string featuring "2rand[0,1,1]" 

 

Anybody seen this before please? 

 

 



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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/A7F53C603656FA4CBE6CE969E85A11910BD51D@compsrv.compsys.local
** 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.

texbox in grid header (VFP8)

[Graham Brown]

Hi 

 

Is it possible to replace the header of a grid cell with a textbox.

 

The form is something like this

 

ProductRedYellow   Blue

Product 1 Yes No  Yes

Product2  No  Yes No

 

So product1 is available in red and blue

Product 2 is just available in yellow

 

The customer asked if he can change the colours headings on the fly so I
pop up a modal window that allows him to do that but he wants to enter
this directly in into the grid header.

 

Is possible to add a textbox directly to a grid header? Can't find
anything to suggest it is.

 

Regards

Graham

 

 

 

 



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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/A7F53C603656FA4CBE6CE969E85A119106ECC9@compsrv.compsys.local
** 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.

Overwrite autoinc field

[Graham Brown]

Hi 

 

I need to fix a dbf that has some missing records. The system has a good
audit trail so I can find the missing data.

 

The problem is that I want to use the same autoinc fields in the
database

The only way I can think is to issue alter table  alter
 I AUTOINC  first then run the insert sql.

 

Is there a better way to do this?

 

Cheers

Graham

 

 

 

 

 



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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/A7F53C603656FA4CBE6CE969E85A119106EC5F@compsrv.compsys.local
** 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] Selling software intellectual property.

[Graham Brown]

Hi all

 

One of my customers has asked to buy out the rights to one of my products. 
Currently there is only the one company using this.

 

Normally my projects do not include the source because previously another 
client took the source, developed his own application with my libraries and set 
up in competition with me. Cost me about £30k in lost business.

 

Previously when this happened I had one customer try to enforce "no writing 
software for 8 years after the sale" and another wanting 20% royalty on all 
derivative works which is basically everything and everybody. I told both of 
them where to go.

 

This new chap wants ownership of just the one product. The chap has said he 
will pay for this but I've no idea what to charge or what terms I should impose 
or accept.

 

Just wondering how to deal with this

 

Regards

Graham

 



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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/A7F53C603656FA4CBE6CE969E85A119106EBCC@compsrv.compsys.local
** 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] Anyone used Mobiforms smartphone rad ?

[Graham Brown]

Thanks

Is it normal for the emulator to take 25 mins to start up?
Is there any minimum memory or processor specs for this?

PC spec is 2.4ghz with 2gb of ram.

Regards
Graham



-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Stephen Russell
Sent: 22 August 2013 14:45
To: ProFox Email List
Subject: Re: [OT] Anyone used Mobiforms smartphone rad ?

I am starting to work with https://www.syncfusion.com/products/aspnet-mvc

Bought in at a much cheaper amount.  :)  Also have to work with barcodes and 
camera for this app.  Has local data and can hook up as soon as wifi is 
available which is a big issue for my environments.




On Thu, Aug 22, 2013 at 5:43 AM, Graham Brown  wrote:

> Hi Dave
>
> Thanks.
> B4A looks really cool.
>
> I've been trying to get Eclipse working without success. The emulator 
> refuses to load, Wasted days on this which is real disappointment. Not 
> sure if the processor or ram is enough for Eclipse. Have you had any 
> similar problems with B4A?
>
> The initial request from the client is an android only application for 
> their field service engineers. The FSE will fill in a form, take some 
> pictures and get the customer to sign on screen. Signatures will store 
> this against the job either by emailing or later downloading. 
> Everything from the Android app will be sent back to the office for 
> processing in the VFP app, I'll need to print the signature at some 
> point so would need to be image file rather than points.
>
> Does B4A allow you to manage the camera e.g. take pictures, save or 
> email them?
> Also capture a signature?
>
>
> I often work with an IT chap who is looking for business apps on all 
> three platforms. Mobiforms infers you write once and can deploy to 
> Android, IPhone and Windows mobile. Just thinking as a solution that 
> asks a dozen or so questions, fill in some notes, take a few pictures 
> and collect a signature possibly Mobiforms may be able to do that across 
> platforms?
>
> In your opinion does Mobiforms do what it says on the tin just not in 
> a feature rich  way?
>
> I'd be interested to see some screenshots of things you've created if 
> you are ok to share.
> Graham at compsys dot co dot uk or info at
>
> Cheers
> Graham
>
>
>
>
>
> -Original Message-
> From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Dave 
> Crozier
> Sent: 22 August 2013 10:16
> To: ProFox Email List
> Subject: RE: [OT] Anyone used Mobiforms smartphone rad ?
>
> Graham,
> Forget it, it is completely crap. I spent a few days evaluating it and 
> it is just not flexible enough. If you are looking at Android 
> development then instead look at Basic4Android. Absolutely excellent 
> and the full dev system is only £40 UK money.
>
> I rewrote our old Microsoft PDA complete stock take system on it in 3 
> days from scratch, linked it into our wifi system for data transfer 
> and then interfaced it into VFP. All on £80 tablets and I have run the 
> app unchanged on a complete range from smartphones to 10" tabs.
>
> I have nothing but praise for it, forget that it is called basic as it 
> has all the oops bits in there with classes, etc. and a really strong 
> user group and once over the initial strangeness of writing Android 
> apps with all the "screen states" you need to understand about it's an 
> easy learn from VFP.
>
> If you want any more details then drop me an email as I can also get 
> it for you at a reduced price.
>
> Dave
>
>
> -Original Message-
> From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Graham 
> Brown
> Sent: 22 August 2013 09:27
> To: ProFox Email List
> Subject: [OT] Anyone used Mobiforms smartphone rad ?
>
> Hi
>
>
>
> Has anyone come across Mobiforms?
>
>
>
> I have a vfp8 project, the customer wants an Android based front end 
> on a smartphone.
>
> The Eclipse/ADT route looks like a complete nightmare, mobiforms says 
> it is a RAD environment for Android, Windows Phone and Iphone.
>
>
>
> Sounds too good to be true...
>
>
>
> If anybody has come across this product I'd appreciate any comments.
>
>
>
> Cheers
>
> Graham
>
>
>
>
>
> --- 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://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/A7F53C603656FA4CBE6CE969E85A119106EB98@compsrv.compsys.local
** 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] Anyone used Mobiforms smartphone rad ?

[Graham Brown]

Hi Dave

Thanks.
B4A looks really cool. 

I've been trying to get Eclipse working without success. The emulator refuses 
to load, Wasted days on this which is real disappointment. Not sure if the 
processor or ram is enough for Eclipse. Have you had any similar problems with 
B4A?

The initial request from the client is an android only application for their 
field service engineers. The FSE will fill in a form, take some pictures and 
get the customer to sign on screen. Signatures will store this against the job 
either by emailing or later downloading. Everything from the Android app will 
be sent back to the office for processing in the VFP app, I'll need to print 
the signature at some point so would need to be image file rather than points.

Does B4A allow you to manage the camera e.g. take pictures, save or email them?
Also capture a signature?


I often work with an IT chap who is looking for business apps on all three 
platforms. Mobiforms infers you write once and can deploy to Android, IPhone 
and Windows mobile. Just thinking as a solution that asks a dozen or so 
questions, fill in some notes, take a few pictures and collect a signature 
possibly Mobiforms may be able to do that across platforms?

In your opinion does Mobiforms do what it says on the tin just not in a feature 
rich  way?

I'd be interested to see some screenshots of things you've created if you are 
ok to share.
Graham at compsys dot co dot uk or info at

Cheers 
Graham





-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Dave Crozier
Sent: 22 August 2013 10:16
To: ProFox Email List
Subject: RE: [OT] Anyone used Mobiforms smartphone rad ?

Graham,
Forget it, it is completely crap. I spent a few days evaluating it and it is 
just not flexible enough. If you are looking at Android development then 
instead look at Basic4Android. Absolutely excellent and the full dev system is 
only £40 UK money.

I rewrote our old Microsoft PDA complete stock take system on it in 3 days from 
scratch, linked it into our wifi system for data transfer and then interfaced 
it into VFP. All on £80 tablets and I have run the app unchanged on a complete 
range from smartphones to 10" tabs.

I have nothing but praise for it, forget that it is called basic as it has all 
the oops bits in there with classes, etc. and a really strong user group and 
once over the initial strangeness of writing Android apps with all the "screen 
states" you need to understand about it's an easy learn from VFP.

If you want any more details then drop me an email as I can also get it for you 
at a reduced price.

Dave


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Graham Brown
Sent: 22 August 2013 09:27
To: ProFox Email List
Subject: [OT] Anyone used Mobiforms smartphone rad ?

Hi 

 

Has anyone come across Mobiforms?

 

I have a vfp8 project, the customer wants an Android based front end on a 
smartphone.

The Eclipse/ADT route looks like a complete nightmare, mobiforms says it is a 
RAD environment for Android, Windows Phone and Iphone.

 

Sounds too good to be true...

 

If anybody has come across this product I'd appreciate any comments.

 

Cheers

Graham

 



--- 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://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/A7F53C603656FA4CBE6CE969E85A119106EB90@compsrv.compsys.local
** 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] Anyone used Mobiforms smartphone rad ?

[Graham Brown]

Hi 

 

Has anyone come across Mobiforms?

 

I have a vfp8 project, the customer wants an Android based front end on
a smartphone.

The Eclipse/ADT route looks like a complete nightmare, mobiforms says it
is a RAD environment for Android, Windows Phone and Iphone.

 

Sounds too good to be true...

 

If anybody has come across this product I'd appreciate any comments.

 

Cheers

Graham

 



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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/A7F53C603656FA4CBE6CE969E85A119106EB8E@compsrv.compsys.local
** 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: Fee tables from DBC

[Graham Brown]

Hi 
 
I stopped using free tables and went to DBC quite a few years back. (think when 
I moved from CA-Clipper to Fox)
Anything that needs to be more resilient I convert to SQL Server and use Cursor 
Adapters or SQLExec.
 
Certainly when I've had to free a table the long field names are the biggest 
headache because it means so many code and report changes and then serious 
testing. Hence the reason I avoid doing this.
 
May I ask what issues do you get with DBC or is it a preference thing.
 
Depending how many tables/fields I would probably write a convert proc to do 
this so something like
for each table
  for each record in table
 append record from old to new with scatter/gather shortening any fields 
long than 10.
 
Possibly echoing out each variable long than 10. I suppose it would then be 
feasible to open each scx, frx, and vcx looking for these fields and replacing 
them with the new names.
 
Just a thought.
 
 



From: ProFox on behalf of James Harvey
Sent: Mon 08/07/2013 13:45
To: 'ProFox Email List'
Subject: Fee tables from DBC 



I think I've finally decided to stop using a DBC, and would like to revert
back to a "Free" table scenario.

One issue is that there are about a dozen field names in several tables
longer than 10 char that will need to be changed in the structure and code.

After that I will open the DBC and then "remove" each table.

Once that's done I suppose I could just open Windows Explore and delete the
dbc from the folder?

A complete backup will be made prior to any changes being made.

Does anyone who has done this before have any advice?

TIA

Jim

James E Harvey
M.I.S.
Hanover Shoe Farms, Inc.
www.hanoverpa.com
office: 717-637-8931
cell: 717-887-2565
fax: 717-637-6766



[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/A7F53C603656FA4CBE6CE969E85A11913AB0@compsrv.compsys.local
** 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: CDO email error

[Graham Brown]

Thanks

I've just posted your comments to my ISP (Heart Internet) and got this
back.
Would be useful if they actually told us this stuff wouldn't it ...!

Cheers
G



Hi Graham,

 Thanks for your reply.

 This would definitely be a possible cause of the problem. We have
sending limits in place to prevent our mail servers from getting
blacklisted due to blacklist criteria classing lots of emails being sent
at once as spam. 

 Below are the usage details for the various methods of using our
systems to send email:- 

 Webmail: 50 emails per day. 

 PC Software (such as Outlook): 1000 messages per hour and 100
recipients per message. 

 Mailing List: This can be used as many times as you like, although it
is limited to 2500 users per list. 

 Web Servers: Scripts running on the web servers are limited to 1000
emails per 12 hours.




-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Tracy
Pearson
Sent: 12 June 2013 12:45
To: ProFox Email List
Subject: Re: CDO email error

Graham Brown  wrote:

>
> Oops: sorry meant to ask if anybody has seen this error before!
>
>
>Cheers
>
>Graham

Yes.

I've seen this from providers when sending too fast. I have started
putting a 500 millisecond pause between each send request.
-- 
Tracy

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/A7F53C603656FA4CBE6CE969E85A119106EAA1@compsrv.compsys.local
** 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.

CDO email error

[Graham Brown]

Hi all

 

I've got some simple code that scans a table for email addresses and
uses cdo to send bulk emails from Fox.

 

Yesterday and today it has started throwing "The server rejected one or
more recipient addresses. The server response was: 550 time so please
try again later. Err code 7" part way through the table. I've checked
the recipient email addresses and they appear ok.

 

The mailserver appears to be blacklisted by CASA-CBL, just in the
process of getting this delisted but I'd expect it to not send anything
rather than get a third of the way through then error on every following
record.

 

Not an error I've seen before. The hosting company say it is not a
problem at their end.

 Oops: sorry meant to ask if anybody has seen this error before!


Cheers

Graham

 

 

 



--- 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://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/A7F53C603656FA4CBE6CE969E85A119106EAA0@compsrv.compsys.local
** 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.

CDO email error

[Graham Brown]

Hi all

 

I've got some simple code that scans a table for email addresses and
uses cdo to send bulk emails from Fox.

 

Yesterday and today it has started throwing "The server rejected one or
more recipient addresses. The server response was: 550 time so please
try again later. Err code 7" part way through the table. I've checked
the recipient email addresses and they appear ok.

 

The mailserver appears to be blacklisted by CASA-CBL, just in the
process of getting this delisted but I'd expect it to not send anything
rather than get a third of the way through then error on every following
record.

 

Not an error I've seen before. The hosting company say it is not a
problem at their end.

 

Cheers

Graham

 

 

 



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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/A7F53C603656FA4CBE6CE969E85A119106EA9E@compsrv.compsys.local
** 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] Sourcesafe - how to roll back to previous build

[Graham Brown]

Okay okay

Looks like we need some bad taste jokes, it is Monday after all.

"What do you do if you see a ginger person drowningthrow another in quick."

"Daddy, daddy why do I have to keep walking in circles?  Be quiet or I'll 
nail your other foot to the floor too"

Need a laugh today so keep 'em coming.


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Pete Theisen
Sent: 03 June 2013 11:01
To: ProFox Email List
Subject: Re: [OT] Sourcesafe - how to roll back to previous build

On 06/03/2013 03:47 AM, Adam Buckland wrote:

Another win for the wrong kind of PC (political correctness)

> Not even that anymoreŠ [OT] - [RIP]
>
> On 02/06/2013 23:39, "Pete Theisen"  wrote:
>
>> On 06/02/2013 05:21 PM, Graham Brown wrote:
>>
>> Hi Graham,
>>
>> Hmm, good question for the [NF] folks. We are all about politics, 
>> religion, sex, terrible jokes and sheep over here on [OT].
>>
>>> I recently had a big problem which involved rolling a development 
>>> back to a previous build.  Ended up having to restore backups which 
>>> was a complete nightmare.
>> --
>> Regards,
>>
>> Pete
>> http://pete-theisen.com/
>> http://elect-pete-theisen.com/
>>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/A7F53C603656FA4CBE6CE969E85A119106EA7B@compsrv.compsys.local
** 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.

Sourcesafe - how to roll back to previous build

[Graham Brown]

Hi all

I recently had a big problem which involved rolling a development back
to a previous build.  Ended up having to restore backups which was a
complete nightmare.

At the moment every project I've written uses the incremental build
option. So I normally set these so YYY.M.x so 2013.6.1 would be the
first build in June 2013.
I may also build  more than one release in a day depending what the
client asks for.

I've just set up VSS with three umbrella projects containing all
codemine6, codemine7 and codemine8 applications. Each application is  a
folder in one of these projects. Not sure if this is the right way to
set the thing up.

So I've just sent an update for the $/codemine8/courtson to the client,
this is version 2013.6.1.
Does Sourcesafe allow me to label the check-in to the courtson folder on
the 2/6/2013 so it says 2013.6.1?  Also would Sourcesafe allow me to get
this exact version in a few weeks (or months) time if I need to?

Not sure if the best bet is to not bother with sourcesafe and just zip
the files into separate folders e.g.
c:\releases\courtson\build2013.6.1.zip when I release an exe to the
client.

Not sure if any of this makes any sense !

 

Would appreciate your thoughts.

 

Regards

 

 

Graham Brown



--- 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://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/A7F53C603656FA4CBE6CE969E85A119106EA78@compsrv.compsys.local
** 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] Sourcesafe - how to roll back to previous build

[Graham Brown]

Hi all

 

I recently had a big problem which involved rolling a development back
to a previous build.  Ended up having to restore backups which was a
complete nightmare.

 

At the moment every project I've written uses the incremental build
option. So I normally set these so YYY.M.x so 2013.6.1 would be the
first build in June 2013.

I may also build  more than one release in a day depending what the
client asks for.

 

 

I've just set up VSS with three umbrella projects containing all
codemine6, codemine7 and codemine8 applications. Each application is  a
folder in one of these projects. Not sure if this is the right way to
set the thing up.

 

So I've just sent an update for the $/codemine8/courtson to the client,
this is version 2013.6.1.

 

Does Sourcesafe allow me to label the check-in to the courtson folder on
the 2/6/2013 so it says 2013.6.1?  Also would Sourcesafe allow me to get
this exact version in a few weeks (or months) time if I need to?

 

Not sure if the best bet is to not bother with sourcesafe and just zip
the files into separate folders e.g.
c:\releases\courtson\build2013.6.1.zip when I release an exe to the
client.

 

 

Not sure if any of this makes any sense !

 

Would appreciate your thoughts.

 

Regards

 

 

Graham Brown



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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/A7F53C603656FA4CBE6CE969E85A119106EA76@compsrv.compsys.local
** 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-Wait

[Graham Brown]

Wait clear ?



-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Sytze de
Boer
Sent: 29 May 2013 02:16
To: profox
Subject: VFP-Wait

I think I'm having a bad year today.

I process something in a do while loop
Before I do so, I issue Wait window nowait "Processing, hold yer horses
please"
After the Enddo, I say Wait window "" nowait but it doesn't clear the
horses So I've tried Wait window clear That causes an error Variable
clear not found

--
Kind regards
Sytze de Boer


--- 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://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/A7F53C603656FA4CBE6CE969E85A119106EA56@compsrv.compsys.local
** 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] Browser redirect virus (quibids.com)

[Graham Brown]

Had one of these drive bys a while back. Mine redirected to
Javacreachures.com (?) 

Kapersky TDSSKiller repaired it from memory although it may have been
housecall.trendmicro.
MSE and AVG did not clear the problem.

I blocked the javacreachures website on the router while I was cleaning
the pc.



-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Lew Schwartz
Sent: 28 May 2013 17:31
To: ProFox Email List
Subject: [NF] Browser redirect virus (quibids.com)

Centers on quibids.com, but throws up a few other sites randomly. So far
chrome and firefox are infected. None of the removal schemes on line
seem to work (eg: I can't find quibids.com anywhere n the machine or
registry).

-Lew Schwartz


--- 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://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/A7F53C603656FA4CBE6CE969E85A119106EA53@compsrv.compsys.local
** 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: A Form & a Strange Date Problem

[Graham Brown]

I've never trusted empty!
 
I always use len(trim(var))=0 or dDatehttp://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/A7F53C603656FA4CBE6CE969E85A11913A23@compsrv.compsys.local
** 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] Facebook chaos

[Graham Brown]

Hi David
 
Thanks for the advice, 
I've used similar registrations in the past but they've continued to take 
payments despite cancelling the service. Had to cancel my card in the end to 
get them to stop and wait ages for the credit card company to sort it.
 
Wouldn't want to get burned like that again!
 
G



From: ProFox on behalf of David Almada
Sent: Tue 19/02/2013 16:00
To: 'ProFox Email List'
Subject: RE: [OT] Facebook chaos



Hi Graham,

You can go to www.lynda.com and they have a free 7 day trial of free video
training on how to use facebook.  You have to sign up with a credit card and
remember to cancel before the 7 days but they have all the functions of
facebook coverered.  They also have about every other type of software.
They charge $25 a month normally.


David Almada Consulting
Email: davidalm...@sbcglobal.net   Phone:  619-295-5535
San Diego, California  -  Databases:  FoxPro/SQL/MS-Access
Data Translation - Information Extraction - Migrating Applications

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Graham Brown
Sent: Tuesday, February 19, 2013 4:29 AM
To: ProFox Email List
Subject: [OT] Facebook chaos

Hi all

I don't use Facebook but my youngster does. We have some bullying issues.

I've gone through all the privacy settings and made her profile private to
invited friends only which appears to be ok.

The problem is she is getting bullied by other children using the message
function. I think the bullies are looking for people my youngster is
connected to who aren't private and instead of using the "Add as friend"
they click the message function.

I had a quick look but can't see how to block people messaging from unknown
contacts.
Any Facebook gurus out there who know if this is possible please?

Cheers

Graham




[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/A7F53C603656FA4CBE6CE969E85A119139FB@compsrv.compsys.local
** 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] Facebook chaos

[Graham Brown]

Hi all

I don't use Facebook but my youngster does. We have some bullying issues.

I've gone through all the privacy settings and made her profile private to 
invited friends only which appears to be ok.

The problem is she is getting bullied by other children using the message 
function. I think the bullies are looking for people my youngster is connected 
to who aren't private and instead of using the "Add as friend" they click the 
message function.

I had a quick look but can't see how to block people messaging from unknown 
contacts.
Any Facebook gurus out there who know if this is possible please?

Cheers

Graham

 

 



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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/A7F53C603656FA4CBE6CE969E85A119139FA@compsrv.compsys.local
** 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] Facebook chaos

[Graham Brown]

Hi all

I don't use Facebook but my youngster does. We have some bullying issues.

I've gone through all the privacy settings and made her profile private to 
invited friends only which appears to be ok.

The problem is she is getting bullied by other children using the message 
function. I think the bullies are looking for people my youngster is connected 
to who aren't private and instead of using the "Add as friend" they click the 
message function.

I had a quick look but can't see how to block people messaging from unknown 
contacts.
Any Facebook gurus out there who know if this is possible please?

Cheers

Graham

 

 



--- StripMime Report -- processed MIME parts ---
multipart/mixed
  text/plain (text body -- kept)
  application/ms-tnef
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/A7F53C603656FA4CBE6CE969E85A119139F6@compsrv.compsys.local
** 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: Import From Excel

[Graham Brown]

This is some simple code from one of my projects for importing XL.
 
The aNVL function is just a wrapper to NVL to check for null values.
 
oXL=Createobject("Excel.Application")
oWB=oXL.Workbooks.Open(cfilename)
oWB.Sheets("Sheet1").Select()
oWS=oWB.ActiveSheet
nMax=0
nrow=0
For Each oRow In oWS.Rows

 If Len(Trim(aNVL(oRow.cells[1,1].Value,"")))=0 And 
Len(Trim(aNVL(oRow.cells[1,2].Value,"")))=0 And 
Len(Trim(aNVL(oRow.cells[1,3].Value,"")))=0
  Exit
 Endif
 If lAction
 Else
  m.pr_code=aNVL(oRow.cells[1,25].Value,"")
*   m.rn=aNVL(oRow.cells[1,26].Value,"0")
*   If Type("m.rn")="C"
*m.rn=Val(m.rn)
*   Endif
  If Len(Trim(m.pr_code))>0
   Thisform.odataenvironment.Product.cSelectCMDFilter="pr_code='"+m.pr_code+"'"
   Thisform.odataenvironment.Product.CursorFill()
  Else
   Thisform.odataenvironment.Product.cSelectCMDFilter="f_rn=-1"
   Thisform.odataenvironment.Product.CursorFill()
  Endif
  If Eof()
   
Thisform.odataenvironment.Product.cSelectCMDFilter="upper(pr_manu)='"+Upper(Alltrim(aNVL(oRow.cells[1,1].Value,"")))+"'
 and UPPER(pr_model)='"+Upper(Alltrim(aNVL(oRow.cells[1,2].Value,"")))+"'"
   Thisform.odataenvironment.Product.CursorFill()
   Locate For ;
UPPER(Alltrim(pr_manu))==Upper(aNVL(oRow.cells[1,1].Value,"")) And ;
UPPER(Alltrim(pr_model))==Upper(Alltrim(aNVL(oRow.cells[1,2].Value,""))) 
And ;
ALLTRIM(pr_engine)==Alltrim(aNVL(oRow.cells[1,3].Value,"")) And ;
ALLTRIM(pr_enginespec)==Alltrim(aNVL(oRow.cells[1,4].Value,"")) And ;
ALLTRIM(pr_engine_code)==Alltrim(aNVL(oRow.cells[1,5].Value,"")) And ;
ALLTRIM(pr_year_from) == Alltrim(aNVL(oRow.cells[1,6].Value,"")) And ;
ALLTRIM(pr_year_to) == Alltrim(aNVL(oRow.cells[1,7].Value,"")) And ;
ALLTRIM(pr_veh_part) == Alltrim(aNVL(oRow.cells[1,8].Value,"")) And ;
ALLTRIM(pr_orig_manu) == Alltrim(aNVL(oRow.cells[1,9].Value,"")) And ;
ALLTRIM(pr_category)==Alltrim(aNVL(oRow.cells[1,10].Value,"")) And ;
ALLTRIM(pr_system_type)==Alltrim(aNVL(oRow.cells[1,11].Value,"")) And ;
ALLTRIM(pr_manu_part) == Alltrim(aNVL(oRow.cells[1,12].Value,"")) And ;
ALLTRIM(pr_make) == Alltrim(aNVL(oRow.cells[1,14].Value,"")) And ;
ALLTRIM(pr_comPloc)== Alltrim(aNVL(oRow.cells[1,23].Value,""))
  Endif
  If Eof()
   Append Blank
  Endif
  Replace pr_code With aNVL(oRow.cells[1,25].Value,"")
  Replace pr_manu With aNVL(oRow.cells[1,1].Value,"")
  Replace pr_model With aNVL(oRow.cells[1,2].Value,"")
  Replace pr_engine With aNVL(oRow.cells[1,3].Text,"")
  Replace pr_enginespec With aNVL(oRow.cells[1,4].Value,"")
  Replace pr_engine_code With aNVL(oRow.cells[1,5].Value,"")
  Replace pr_year_from With aNVL(oRow.cells[1,6].Text,"")
  Replace pr_year_to With aNVL(oRow.cells[1,7].Text,"")
  Replace pr_veh_part With aNVL(oRow.cells[1,8].Value,"")
  Replace pr_orig_manu With aNVL(oRow.cells[1,9].Value,"")
  Replace pr_category With aNVL(oRow.cells[1,10].Value,"")
  Replace pr_system_type With aNVL(oRow.cells[1,11].Value,"")
  Replace pr_manu_part With aNVL(oRow.cells[1,12].Value,"")
  Replace pr_locn With aNVL(oRow.cells[1,13].Value,"")
  Replace pr_make With aNVL(oRow.cells[1,14].Value,"")
** Replace pr_action With aNVL(oRow.cells[1,14].Value,"")
  Replace pr_dead With "S"
  cUrl=""
  Try
   If "=HYPERLINK" $ Upper(oRow.cells[1,11].formula)
cUrl=oRow.cells[1,11].formula
cUrl=Left(cUrl,At(",",cUrl)-1)
cUrl=Strtran(cUrl,"=hyperlink(","",1,999,1)
cUrl=Strtran(cUrl,["],"",1,999,1)

   Else
cUrl=oRow.cells[1,11].hyperlinks(1).address
   Endif
  Catch
  Finally
  Endtry
  cUrl1=""
  Try
   cUrl1=oRow.hyperlinks(1).address
  Catch
  Finally
  Endtry
  cUrl=aNVL(oRow.cells[1,24].Value,"")
  If Type("cUrl1")="C"
   If Len(Trim(cUrl1))>0
cUrl=cUrl1
   Endif
  Endif

  Wait Window Alltrim(Str(Recno()))+Chr(13)+Chr(10)+" 
"+Left(Alltrim(pr_veh_part)+Alltrim(pr_manu),50) Nowait Noclear

  cPrice=aNVL(oRow.cells[1,15].Value,"")
  If cPrice>="A" And cPrice<="Z"
   cPrice="0"
  Endif
  cPrice=Val(cPrice)
  Replace pr_cprice With cPrice
  sPrice=aNVL(oRow.cells[1,16].Value,"")
  If sPrice>="A" And sPrice<="Z"
   sPrice="0"
  Endif
  sPrice=Val(sPrice)
  Replace pr_sprice With sPrice
  Replace pr_invcnt With Val(aNVL(oRow.cells[1,17].Value,0))
  Replace pr_oncomm With Val(aNVL(oRow.cells[1,18].Value,0))
  cDesc=aNVL(oRow.cells[1,19].Value,"")
  If Isnull(cDesc)
   cDesc=""
  Endif
  Replace pr_desc With cDesc
  Replace pr_action With aNVL(oRow.cells[1,20].Value,"")
  Replace pr_comment With aNVL(oRow.cells[1,21].Value,"")
  Replace pr_fault With aNVL(oRow.cells[1,22].Value,"")
  Replace pr_comPloc With aNVL(oRow.cells[1,23].Value,"")
  If Alltrim(pr_category)==Alltrim(pr_system_type)
**  SET STEP ON
  Endif
 Endif
 If !Eof()
  =mTableupdate()
 Endif
Next




From: ProFox on behalf of John Weller
Sent: Tue 12/02/2013 10:45
To: profox@leafe.com
Subject: Import From Excel



I have some data in the form of an Excel spread sheet which I want to import
into a table.  The problem is that one colu

RE: SQL Server optimisation

[Graham Brown]

I've tried various combinations 
e.g. where (len(ltrim(custname))>0 and custname like '%abc%' ) or 
(len(ltrim(address))>0 and address like '%abc%')
 
Makes no real difference.
 



From: ProFox on behalf of Fred Taylor
Sent: Sun 10/02/2013 17:30
To: ProFox Email List
Subject: Re: SQL Server optimisation



SInce you're building up the SQL statement, are you only including fields
they entered a value for in your WHERE clause?

Fred


On Sun, Feb 10, 2013 at 8:39 AM, Graham Brown  wrote:

> Hi all
>
> I'm trying to work out whether it is possible to optimise a query on
> approx. 70,000 records.
> The problem is that the customer wants to do an "All fields" search so I
> have something like: -
>
> nH=sqlstringconnect(gcConnString)
> cSQL="select f_rn from tablename where field1 like '%ABC%' or field2
> like '%ABC%' or field3 like '%ABC%' "
> sqlexec(nH,cSQL,"curs")
>
> The sql select statement contains about 20 fields. One of these fields
> is also a text/memo column.
>
> I also had the query as select f_rn from tablename where
> (field1+field2+field3...) like '%ABC%' but that was always over a minute
> to run
>
>
> I built indices on  most of the fields but sometimes it takes 2-3
> seconds whereas other times it can take over a minute to run exactly the
> same query. Doesn't matter if use pass-thru or directly into the query
> analyser, result is either 2-3 seconds or over a minute.
>
> If I limit this search to less than 5 fields the result is always
> returned quickly 2-3 seconds as far as I can see.
>
> Not sure whether the 2-3 seconds on the full query is just SQL caching
> the results.
>
> Does anyone know of any possible solutions to this one please?
>
> Also looking at full text search to see if that provides the answer.
> I'm just thinking I should just tell the customer "fast and all fields"
> is just not possible.
>
>
> Regards
> Graham
>
>
>
>
>
>
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/A7F53C603656FA4CBE6CE969E85A119139D6@compsrv.compsys.local
** 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 optimisation

[Graham Brown]

Hi 

The data structure looks like fine to me. The table I am querying
contains 70,000 records and the fields because that is what the customer
needs.
It is basically vehicle information going back to 2006, customer needs
this info because they offer lifetime warranty on the parts. The
searches are basically to find out the history of given customer and/or
part.

I already  give the customer the option to limit the search to either
the vehicle registration or part number or client name and this is
always quick. 
I reckon they are just being a little lazy so instead of choosing the
search from a combobox they just leave it set at any field.

I have to deliver what the customer wants otherwise I am not going to be
in business very long..!


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of AndyHC
Sent: 10 February 2013 15:46
To: profox@leafe.com
Subject: Re: SQL Server optimisation

On 10/02/2013 21:09, Graham Brown wrote:

looks like you need to do a major redesign of your data structure!

   AndyD
> Hi all
>
> I'm trying to work out whether it is possible to optimise a query on 
> approx. 70,000 records.
> The problem is that the customer wants to do an "All fields" search so

> I have something like: -
>
> nH=sqlstringconnect(gcConnString)
> cSQL="select f_rn from tablename where field1 like '%ABC%' or field2 
> like '%ABC%' or field3 like '%ABC%' "
> sqlexec(nH,cSQL,"curs")
> ...
>
> Does anyone know of any possible solutions to this one please?
>
> 
>
>
> Regards
> Graham
>
>
>
>
>
>
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/A7F53C603656FA4CBE6CE969E85A11914A16@compsrv.compsys.local
** 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 optimisation

[Graham Brown]

Hi all

I'm trying to work out whether it is possible to optimise a query on
approx. 70,000 records. 
The problem is that the customer wants to do an "All fields" search so I
have something like: -

nH=sqlstringconnect(gcConnString)
cSQL="select f_rn from tablename where field1 like '%ABC%' or field2
like '%ABC%' or field3 like '%ABC%' "
sqlexec(nH,cSQL,"curs")

The sql select statement contains about 20 fields. One of these fields
is also a text/memo column.

I also had the query as select f_rn from tablename where
(field1+field2+field3...) like '%ABC%' but that was always over a minute
to run


I built indices on  most of the fields but sometimes it takes 2-3
seconds whereas other times it can take over a minute to run exactly the
same query. Doesn't matter if use pass-thru or directly into the query
analyser, result is either 2-3 seconds or over a minute.

If I limit this search to less than 5 fields the result is always
returned quickly 2-3 seconds as far as I can see.

Not sure whether the 2-3 seconds on the full query is just SQL caching
the results.

Does anyone know of any possible solutions to this one please?

Also looking at full text search to see if that provides the answer. 
I'm just thinking I should just tell the customer "fast and all fields"
is just not possible. 


Regards
Graham







___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/A7F53C603656FA4CBE6CE969E85A11914A15@compsrv.compsys.local
** 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: Math whizzes required...!

[Graham Brown]

Yep maths wise it is working out the management charge on 0.992% not 1%

The website consistently undervalues the management charge, just trying
to work out if it is always 0.008%
And whether 0.008 has a significance just like 42.



-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On
Behalf Of Allen
Sent: 20 July 2012 14:01
To: GrahamB
Subject: RE: Math whizzes required...!

A quick guess it's to do with decimal places Al

-Original Message-

Hi all

 

I've written a simple calculator for a mate of mine.



[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/0AF51B84D903A144B9EE71AEAFE7E81C0EC706@compsys1.CompySys.local
** 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: Repair vcx

[Graham Brown]

VCT is missing or invalid

Have tried tablevalidate 0 and that doesn't work.


-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On
Behalf Of Richard Kaye
Sent: 27 June 2012 14:16
To: GrahamB
Subject: RE: Repair vcx 

It depends on the type of corruption. Can you open the VCX as a table? 

--
rk

-Original Message-
From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com]
On Behalf Of Graham Brown
Sent: Wednesday, June 27, 2012 8:59 AM
To: profoxt...@leafe.com
Subject: Repair vcx 

Hi all

Just had a power cut and one of my vcx files is now corrupted.

Is there a simple way to recover the vcx without restoring backups.

Regards

Graham Brown


[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/0AF51B84D903A144B9EE71AEAFE7E81C0EC63A@compsys1.CompySys.local
** 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 set filter to

[Graham Brown]

Thought I'd share this one because it has driven me nuts for a while
now.

 

My customer reports a sporadic problem with things like "Variable
cu_name not found in read events"

Cu_name is a valid field in the customer table, the form it is contained
in ("customer") is also present although not the active form.

 

Once the error has appeared the read events has stopped and I'm at the
source line immediately after the read events in the main.prg file.

 

I have two forms open before the error (customer and product), The
customer screen also has a  set filter to for speed.

Both forms are vcx based with cursoradapters to SQL server.

 

All I'm doing is swapping between the two forms with
ofrmcustomer.show() or ofrmproduct.show() from a toolbar.

 

What I've found is calling oFrmProduct.show method from when a form with
cursoradapter and filter will consistently crash fox.

 

If I remove the set filter and replace it with a requery of the database
(caProduct.cSelectCMDFilter='cu_status='O' or whatever and
caProduct.cursorfill() ) I do not get any problems.

 

I have no idea why moving focus from a frm with cursoradapters and a
filter will crash an application but hope this helps somebody.

 

Regards

Graham

 



--- 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/0AF51B84D903A144B9EE71AEAFE7E81C0EC4EB@compsys1.CompySys.local
** 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: PDF printing from Foxpro

[Graham Brown]

Hi 

Also check out GSPrint and PDFTK

I wrote an QA application for a train manufacturer a couple of years
back, I use these to control watermarking and printing of existing pdfs.

Cheers
G




___
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/0AF51B84D903A144B9EE71AEAFE7E81C0EC2E9@compsys1.CompySys.local
** 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.

Reading emails from Exchange

[Graham Brown]

Hi all

 

I've previously written a simple utility to scan Outlook mail items and
store information in a fox table. 

I've just been asked if it can read emails directly from Exchange.

 

I have a dim distant recollection this was either Webdav or LDAP but
can't remember.

 

Anybody know if this is possible in fox please.

 

Cheers

Graham Brown



--- 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/0AF51B84D903A144B9EE71AEAFE7E81C0EC29B@compsys1.CompySys.local
** 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: In-bedded Audio Files

[Graham Brown]

I would also store the link.
Not tried but there is also quite a good article on using MCI to play
audio files at
http://www.dbmonster.com/Uwe/Forum.aspx/foxpro/209/Play-mp3-from-VFP

-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On
Behalf Of Dave Crozier
Sent: 25 August 2011 16:16
To: GrahamB
Subject: RE: In-bedded Audio Files

George,
You have 4 options. 

1. Add the audio file into an OLE field in which case they will be
played automatically by whichever application is tied to the file
extension by the PC

2. Convert the audio file into an ascii string and save it to a memo
field then piece it back together to a temporary file and play it using
ShellExecute()

3. Save to a Blob data type field

4. Hold the audio file in its original format in a preset folder and
simply store a link to it.

Personally I would go the (4) route as you may soon break the 2Gb limit
in VFP with large files and apart from that the chances of data
corruption are small. If the database gets too large then you could
always use SQLExpress to hold the binary data which will go up to 10Gb
and is free.

The problem with memo fields is that the replaced data space never gets
reused unless the database is packed (pack memo) so if the file is
constantly updated then replaced records still take up space

Dave


-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On
Behalf Of G Gambill
Sent: 25 August 2011 14:21
To: profoxt...@leafe.com
Subject: In-bedded Audio Files

I am looking for hints as to how (if possible) to inbed audio files
within a
dbf (dbc) and play the via a VFP exe.

Any suggestion?

Thanks

George


--- 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/0AF51B84D903A144B9EE71AEAFE7E81C0EC263@compsys1.CompySys.local
** 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: Sending E-mail from VFP

[Graham Brown]

You can also  CDOSys to send email. I use this all the time as it is
built in to Windows.
http://leafe.com/archives/full_thread/442226


-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On
Behalf Of Brant E. Layton
Sent: 19 August 2011 19:01
To: GrahamB
Subject: Sending E-mail from VFP

Hi Folks,

I'm seeking some insight into sending E-mail from VFP programs.

In the past, I've seen this done by dropping .BAT files containing MAPI
commands 
into a system folder, with the .BAT file sending another .txt file.
There 
wasn't a good way to track the success of the sending.  It also doesn't
seem to 
work if you can't get access to MAPI processes (like, you don't have a
server, 
don't have Exchange, etc.).  At least this is my understanding of the
mechanism.

Today, I need to be able to generate a nifty, nicely-formatted HTML
Email (with 
logos, etc.), and send it, done by a VFP program.  I'm not worried about
the 
generating, just the sending part.

I'm assuming that the old way would still work, and have heard of some
virtual 
printers that will do this.

Comments and/or experience on the best way to do this?

Thanks in advance,

Brant Layton
480.964.1316


[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/0AF51B84D903A144B9EE71AEAFE7E81C0EC230@compsys1.CompySys.local
** 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: PDF Output

[Graham Brown]

CutePDF?

You can automate this with a set printer to, I normally just have a
timer looking for the save window which stuffs the filename.


-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On
Behalf Of John Weller
Sent: 22 August 2011 11:30
To: GrahamB
Subject: PDF Output

I am writing a membership system for a local charity.  The system is to
be operated by a member who may not be particularly computer literate so
I am looking for a FREE utility that I can call from VFP to print a
report as a PDF.  I know that XFRX will do it but at a price which I
can't justify.  Any suggestions gratefully received.

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/0AF51B84D903A144B9EE71AEAFE7E81C0EC22F@compsys1.CompySys.local
** 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: visual foxpro 6 to mysql

[Graham Brown]

Hi Gary

First of all download MyODBC from the MySQL website if not done already.

This will give you a new odbc driver in control panel.

The variables below for ipaddress, dbname, userid and password should all be on 
PHPMyAdmin which is the way most hosting companies allow you to manage MySQL. 
You may need to ask for the IP because it isn't always just an IP . On one of 
my sites it is "cluster.mysqlinstance.domainname.com".
This fox code downloads from one of my databases.

nMySQL1=Sqlstringconnect("Driver={MySQL ODBC 5.1 Driver}; Server=; 
Database=; UID=; PWD=; Option=3")
If nMySQL1>=0
SQLEXEC(nMySQL1,"select * from tblagents","crs")
Select crs
Endif
SQLDISCONNECT(nMySQL1)

Once you have a handle to the database via Stringconnect you can fire any SQL 
commands at it.
I sometimes have weird issues where commands do not complete. AsyncMode in the 
properties usually fixes this.
SQLSETPROP(nMySQL, 'asynchronous', .F.)

UDL files are a good way to get at a connection string. If you haven't used 
them before right click on your desktop/new/text doc. Rename this to .UDL and 
run it.
You'll get the standard windows wizard. Fill in the blanks and test connection. 
Rename back to .txt open it and there's your connstring.

If you can't connect remotely to the MySQL database another way is to FTP the 
file and run a php webpage both via fox.
Google has lots of resources for parsing a csv in php. This is the page at the 
top of the list
http://php.net/manual/en/function.fgetcsv.php


Cheers
Graham



-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of 
Gary Jeurink
Sent: 10 August 2011 04:31
To: GrahamB
Subject: RE: visual foxpro 6 to mysql

I'm not great at PHP but I'm learning. Tables are cTeams, cGames, cTmstats.
The cTmstats gets updated each week along with cGames that have been played.
I don't know how to update the MySQL cTmStats with the foxpro cTmstats.dbf each 
Tuesday morning. I need to update the MySQL tables at godaddy with my foxpro 
data and I don't know how. PHP gives me access to MySQL but how do I connect 
foxpro? ... I tried delimited text but they usually crash at 1/2 to 2/3rds 
using MyAdmin... whatever its called.

Gary Jeurink

-Original Message-
From: Stephen Russell [mailto:srussell...@gmail.com]
Sent: Tuesday, August 09, 2011 6:07 PM
To: ProFox Email List
Subject: Re: visual foxpro 6 to mysql

On Tue, Aug 9, 2011 at 5:26 PM, Gary Jeurink  wrote:
> I have developed a football statistics database that I update each 
> week
for
> the 120 d1a college football teams and the 32 pro teams. Included is 
> the schedule so you can pick a game and the various yds and points are
predicted
> for upcoming games. Its fun  and I do well on college pickem and 
> pigskin pickem on espn. I update from web pages to excel sheets and 
> then merge to
my
> database with a view each week. What is the easiest way  to reload a 
> MySQL table on a server [godaddy] from my foxpro data table?
>
-

I would do update statements as well as insert statements.

You can crunch many togther via a union and pass a long string as a script

So how do you set up to accomplish this?  I would make two passes to identify 
updates to existing rows and then add in new rows.  Create a script per table 
for both types of statements.

Just a guess but you have a row for each team in a game ?  You also put in some 
rows to support players accomplishments in that game?

Inserts are pretty simple :
INSERT INTO table1 (field1, field2)
VALUES ('foo', 'bar');

UPDATE table1 SET field1 = 'foobar', field2' = 'new value' where ID=???


--
Stephen Russell

Unified Health Services
60 Germantown Court
Suite 220
Cordova, TN 38018

Telephone: 888.510.2667

901.246-0159 cell





[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/0AF51B84D903A144B9EE71AEAFE7E81C0EC1E5@compsys1.CompySys.local
** 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: Video capture (AVICap32)

[Graham Brown]

I didn't get anywhere with AVICap but have had some success with Window
Image Acquisition (WIA) so thought I'd share. This code is from articles
from Bernard Bout on Foxite.

I've also been testing it with scanners for a document
management/billing system I'm working on at the moment.

This code grabs an image from a webcam without any preview screen
 
cdg=Createobject("wia.commondialog")
 img = cdg.ShowAcquireImage
 try
 img.savefile(PUTFILE("Save as","MyPhoto.jpg","JPG"))
CATCH
FINALLY 
ENDTRY

This shows the standard Microsoft screens.

aLocal cdg As Object,dev As Object, IP As Object
SET STEP ON 
 * create the dialog object
 cdg=Createobject("wia.commondialog")
 * show it
 dev=cdg.ShowSelectDevice
 * get the path to temp photos buffered. The WIA buffers ALL old photos
in the Documents & Settings directory. We dont need them so we delete
them.
 cPath = dev.properties(24).Value
 * and erase the old ones
 Erase (cPath+"\*.jpg")
 *
 * get a photo - WIA has its own GUI
 img = cdg.ShowAcquireImage
 If Isnull(img)
 Wait Window Timeout 1 "User Cancelled"
 Return
 Endif
 
* I use TerminalServices so that only 256 colors are available. WIA
outputs by defa in JPG. So By converting to GIF and then BMP I get a 256
colour BMP.!!
 * used for processing the image
 IP = Createobject("WIA.ImageProcess")
 * sets up a conversion filter
 IP.Filters.Add (IP.FilterInfos("Convert").FilterID)

 IP.Filters(1).properties("FormatID").Value =
"{B96B3CB0-0728-11D3-9D7B-F81EF32E}" && GIF

 * make it a GIF - 256 colors
 img = IP.Apply(img)
 
IP.Filters(1).properties("FormatID").Value =
"{B96B3CAB-0728-11D3-9D7B-F81EF32E}" && BMP
 * convert the GIP to BMP (256 colors)
 img = IP.Apply(img)
 
* if the previous file is there then WIA complains with an error do we
delete it. Name is stored in Form var cFilename
 Erase ("\xphoto.bmp")
 * And finally - SAVE IT
 img.savefile("\xphoto.bmp")


 

___
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/0AF51B84D903A144B9EE71AEAFE7E81C0EC1C1@compsys1.CompySys.local
** 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: Video capture (AVICap32)

[Graham Brown]

Hi all

The code switches the camera on or at least the green light comes on but
no preview.
I've also tried with an external USB webcam with no success.

Can't see what else could be causing it to fail.

Rgds
Graham



-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On
Behalf Of Tracy Pearson
Sent: 29 July 2011 23:00
To: GrahamB
Subject: RE: Video capture (AVICap32)

Graham Brown wrote on 2011-07-29: 
>  Hi John
>  
>  Can't see what else could be holding it open. I noticed you can't
open
>  this together with the USB Preview.
>  I also uninstalled skype just to be sure.
>  
>  Regards
>  Graham
> 

Graham,

The ArcSoft software has a private mode. But I can't test it with this
method since I can't get a connection to the camera when ArcSoft has the
connection. 

The video window does not match the 640x480 capture area.  When you do
see
the video in the other applications, is it dark in the upper left?
grabbing at straws

Tracy Pearson
PowerChurch Software


[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/0AF51B84D903A144B9EE71AEAFE7E81C0EC199@compsys1.CompySys.local
** 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: Video capture (AVICap32)

[Graham Brown]

Hi John

Can't see what else could be holding it open. I noticed you can't open
this together with the USB Preview. 
I also uninstalled skype just to be sure.

Regards
Graham


-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On
Behalf Of John Harvey
Sent: 29 July 2011 21:15
To: GrahamB
Subject: RE: Video capture (AVICap32)

It sounds like you have something else locking the port. Check your
processes to see if there is anything there.

John

-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On
Behalf Of Graham Brown
Sent: Friday, July 29, 2011 12:44 PM
To: ProFox Email List
Subject: RE: Video capture (AVICap32)

Hi 

Form opens with black preview window caption is "Using Video Capture:
connected 640x480". 
Buttons for Get Frame, Preview and Close are visible.

Clicking preview makes no difference still get a black preview area

Does this code run for you? I've not seen anything running so possibly
the code didn't run in the first place?

Regards
Graham



So you get the form on the screen, click "Preview Video", which results
in a black screen, and are still able to get the video in other
software?

Or is the caption of the form showing "Using Video Capture: failed to
connect"?

Tracy Pearson
PowerChurch Software


[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/0AF51B84D903A144B9EE71AEAFE7E81C0EC196@compsys1.CompySys.local
** 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: Video capture (AVICap32)

[Graham Brown]

Hi Tracy.

The camera is built into the laptop which is an XP Acer Travelmate 7510.
The other laptop is a Win 7 ZooStorm Fizzbook Spin. The only software I
can see is from MyComputer for USB Video Device but no option to
disconnect

I disabled the camera in Device Manager just to make sure and the
caption changed to unable to connect so definitely using the right
drivers.

Thanks for running the software, it's got to be a setup thing then. I'll
borrow a webcam tomorrow just to check that and report back.

Regards
Graham






-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On
Behalf Of Tracy Pearson
Sent: 29 July 2011 22:01
To: GrahamB
Subject: RE: Video capture (AVICap32)

Graham,

Tinkering with what I have on my VAIO, I have discovered there is an
application on the laptop by ArcSoft. There is a service running that
determines when the ArcSoft monitor software closes another ArcSoft
product will regain the capture of the webcam. I started the Monitor,
selected to Disconnect from the webcam. Now I'm getting a preview in VFP
again.

Do you have multiple webcam devices appearing in the device manager?

Tracy Pearson
PowerChurch Software


[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/0AF51B84D903A144B9EE71AEAFE7E81C0EC195@compsys1.CompySys.local
** 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: Video capture (AVICap32)

[Graham Brown]

Hi 

Form opens with black preview window caption is "Using Video Capture:
connected 640x480". 
Buttons for Get Frame, Preview and Close are visible.

Clicking preview makes no difference still get a black preview area

Does this code run for you? I've not seen anything running so possibly
the code didn't run in the first place?

Regards
Graham



So you get the form on the screen, click "Preview Video", which results
in a black screen, and are still able to get the video in other
software?

Or is the caption of the form showing "Using Video Capture: failed to
connect"?

Tracy Pearson
PowerChurch Software


[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/0AF51B84D903A144B9EE71AEAFE7E81C0EC193@compsys1.CompySys.local
** 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: Video capture (AVICap32)

[Graham Brown]

Hi 
Yes

The XP laptop has an icon in MyComputer which says "USB Video Device". I
click on this and get video.
I've recently uninstalled Skype from this laptop as it was blue
screening from time to time.

The other laptop has Facebook Skype working.

Regards
Graham


-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On
Behalf Of Tracy Pearson
Sent: 29 July 2011 17:31
To: GrahamB
Subject: RE: Video capture (AVICap32)

Graham Brown wrote on 2011-07-29: 
>  Hi all
> 
> 
>  I'm using this code to attempt to capture video from my laptops
> 
> 
>  The screen appears but all I get is black screen where the video  
> playback should be. Has any seen this before and know how to fix it  
> please.
> 
> 
>  Regards
>  
>  Graham
> 
> 

Graham,

With the black screen visible; Are you able to bring up another software
and get connected to the camera? You shouldn't be able to. 


Tracy Pearson
PowerChurch Software


[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/0AF51B84D903A144B9EE71AEAFE7E81C0EC191@compsys1.CompySys.local
** 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.

Video capture (AVICap32)

[Graham Brown]

Hi all

 

I'm using this code to attempt to capture video from my laptops

 

The screen appears but all I get is black screen where the video
playback should be. Has any seen this before and know how to fix it
please.

 

Regards

Graham

 

 

Oform=createobject("tform")

Oform.show(1)

 

DEFINE CLASS Tform As Form

#DEFINE WM_CAP_START  0x0400

#DEFINE WM_CAP_DRIVER_CONNECT(WM_CAP_START+10)

#DEFINE WM_CAP_DRIVER_DISCONNECT (WM_CAP_START+11)

#DEFINE WM_CAP_DRIVER_GET_CAPS   (WM_CAP_START+14)

#DEFINE WM_CAP_SET_PREVIEW   (WM_CAP_START+50)

#DEFINE WM_CAP_SET_OVERLAY   (WM_CAP_START+51)

#DEFINE WM_CAP_SET_PREVIEWRATE   (WM_CAP_START+52)

#DEFINE WM_CAP_GET_STATUS(WM_CAP_START+54)

#DEFINE WM_CAP_GRAB_FRAME(WM_CAP_START+60)

 

Width=340

Height=310

Autocenter=.T.

Caption="Using Video Capture"

MinButton=.F.

MaxButton=.F.

hWindow=0

hCapture=0

capWidth=0

capHeight=0

capOverlay=0



ADD OBJECT cmdGetFrame As CommandButton WITH
Default=.T.,;

Left=15, Top=264, Height=27, Width=90, Caption="Get
Frame",;

Enabled=.F.

 

ADD OBJECT cmdPreview As CommandButton WITH
Default=.T.,;

Left=106, Top=264, Height=27, Width=100,
Caption="Preview Video",;

Enabled=.F.

 

ADD OBJECT cmdClose As CommandButton WITH Cancel=.T.,;

Left=250, Top=264, Height=27, Width=70, Caption="Close"

 

PROCEDURE Activate

IF THIS.hWindow = 0

DECLARE INTEGER GetFocus IN user32

THIS.hWindow = GetFocus()

THIS.CreateCaptureWindow

THIS.DriverConnect

ENDIF

 

PROCEDURE Destroy

THIS.ReleaseCaptureWindow

 

PROCEDURE cmdClose.Click

ThisForm.Release

 

PROCEDURE cmdGetFrame.Click

ThisForm.GetFrame

 

PROCEDURE cmdPreview.Click

ThisForm.StartPreview

 

PROCEDURE GetFrame

THIS.msg(WM_CAP_GRAB_FRAME, 0,0)

#DEFINE WM_CAP_FILE_SAVEDIB (WM_CAP_START + 25)

LOCAL lcFile

lcFile = "" && File name to create

lcFile = "c:\temp\sample.bmp"

THIS.msg(WM_CAP_GRAB_FRAME, 0,0)

THIS.msg(WM_CAP_FILE_SAVEDIB, 0, lcFile,1)

 

PROCEDURE CreateCaptureWindow

#DEFINE WS_CHILD   0x4000

#DEFINE WS_VISIBLE 0x1000

 

DECLARE INTEGER capCreateCaptureWindow IN avicap32;

STRING lpszWindowName, LONG dwStyle,;

INTEGER x, INTEGER y,;

INTEGER nWidth, INTEGER nHeight,;

INTEGER hParent, INTEGER nID

 

THIS.hCapture = capCreateCaptureWindow("",;

WS_CHILD+WS_VISIBLE,;

10,8,320,240, THIS.hWindow, 1)

 

PROCEDURE DriverConnect

THIS.msg(WM_CAP_DRIVER_CONNECT, 0,0)

IF THIS.IsCaptureConnected()

THIS.GetCaptureDimensions

STORE .T. TO THIS.cmdGetFrame.Enabled,;

THIS.cmdPreview.Enabled

THIS.Caption = THIS.Caption + ":
connected, " +;

 
LTRIM(STR(THIS.capWidth)) + "x" +;

 
LTRIM(STR(THIS.capHeight))

ELSE

THIS.Caption = THIS.Caption + ": failed
to connect"

ENDIF

 

PROCEDURE DriverDisconnect

THIS.msg(WM_CAP_DRIVER_DISCONNECT, 0,0)



PROCEDURE ReleaseCaptureWindow

IF THIS.hCapture <> 0

THIS.DriverDisconnect

DECLARE INTEGER DestroyWindow IN user32
INTEGER hWnd

= DestroyWindow(THIS.hCapture)

THIS.hCapture = 0

ENDIF

 

PROCEDURE msg(msg, wParam, lParam, nMode)

IF THIS.hCapture = 0

RETURN

ENDIF

 

IF VARTYPE(nMode) <> "N" Or nMode=0

DECLARE INTEGER SendMessage IN user32;

INTEGER hWnd, INTEGER
Msg,;

INTEGER wParam, INTEGER
lParam

= SendMessage(THIS.hCapture, msg,
wParam, lParam)

ELSE

DECLARE INTEGER SendMessage IN user32;

INTEGER hWnd, INTEGER
Msg,;

INTEGER wParam, STRING
@lParam

= SendMess

RE: [NF] SPAM down 82% from last year

[Graham Brown]

Yep but they've just found a new one just to p*** me off.

Had yet more calls from some call centre in india to say I have a virus on my 
computer, could I just give them remote access and they will fix it for me...
What nice people...

Wonder if anyone ever falls for this?


-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of 
Michael Madigan
Sent: 26 July 2011 06:30
To: GrahamB
Subject: [NF] SPAM down 82% from last year

This is good news 

http://www.theblaze.com/stories/email-spam-down-82-percent-since-july-2010/


[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/0AF51B84D903A144B9EE71AEAFE7E81C0EC176@compsys1.CompySys.local
** 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] - Shit happens....

[Graham Brown]

Thanks, made me smile anyway.
Have a nice day.


-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On
Behalf Of Adam Buckland
Sent: 13 July 2011 11:46
To: GrahamB
Subject: [OT] - Shit happens

 

 

TAOISM - "if you understand shit, it isn't shit"
HINDUISM - "this shit happened before"
CONFUCIANISM - "Confucious say 'shit happens'"
BUDDHISM - "shit will happen to you again"
ZEN - "what is the sound of shit happening?"
ISLAM - "if shit happens, it is the will of Allah"
SIKHISM - "leave our shit alone"
JEHOVA'S WITNESS - "knock. knock. shit happens"
ATHEISM - "i don't believe this shit"
AGNOSTICISM - "can you prove that shit happpens?"
CATHOLICISM - "if shit happens, you deserve it"
PROTESTANTISM - "shit happens, amen to that"
JUDAISM - "why does shit always happen to us?"
ORTHODOX JUDAISM - "so shit happens, already"
TELEVANGELISM - "send money or shit will happen to you"
RASTAFARIANISM - "let's smoke this shit"
HARE KRISHNA - "shit happens rama rama"
NATION OF ISLAM - "don't take no shit"
NEW AGE - "visualize shit happening"
SHINTOISM - "you inherit shit of your ancestors"
HEDONISM - "i love it when shit happens"
SATANISM - "sneppah tihs"
CAPITALISM - "this is MY shit"
FEMINISM - "men are shit"
EXISTENTIALISM - "what is shit, anyway?"
SCIENTOLOGY - "if shit happens, see Dianetics p.137"
MORMONISM - "excrement happens" (don't say shit)
BAPTISM - "we'll wash the shit right off you"
MYSTICISM - "this is really weird shit"
VOODOO - "shit doesn't just happen - we made it happen"
DISNEYISM - "bad shit doesn't happen here"
COMMUNISM - "let's share the shit"
MARXISM - "you have nothing to lose but your shit"
CONSPIRACY THEORISM - "THEY shit on us!"
PSYCHO-ANALYSIS - "tell me about your shit"
DARWINISM - "survival of the shittiest"
AMISH - "modern shit is useless"
SUICIDAL - "i've had enough of this shit"
OPTIMISM - "shit won't happen to me"
TREKISM - "to boldly shit where no-one has shat before"
SHAKESPEAREAN - "to shit or not to shit, that is the question"
DESCARTES - "i shit, therefore i am"
FREUD - "shit is a phallic symbol"
LAWYERS - "for enough money, I can get you out of shit"
ACUPUNCTURIST - "hold still or this shit's gonna hurt"
DOG - "i just shit in your shoe"
CAT - "dogs are shit"
MOUSE - "oh shit! a cat!"
POLITICALLY CORRECT - "internally processed,
nutritionally drained, biological output happens"
EINSTEIN - "shit is relative"
FAMILY GATHERING - "relatives are shit"
MATERIALISM - "whoever dies with the most shit, wins"
VEGETARIANISM - "if it shits, don't eat it"
FATALISM - "oh shit, it's going to happen"
ENVIRONMENTALISM - "shit is biodegradable"
AMERICANISM - "who gives a shit?"
STATISTICIAN - "shit is 84.7% likely to happen"
HIP-HOP - "motherfuck this shiznit, beeatch!"
TANTRISM - "fuck this shit"
CYNICISM - "we are all full of shit"
SURREALISM - "fish happens"
WICCA - "you can make shit happen but shit will happen to you three
times"

[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/0AF51B84D903A144B9EE71AEAFE7E81C0EC14E@compsys1.CompySys.local
** 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: Variable not found in read events

[Graham Brown]

I've had a report back from the customer's IT people. I've asked them to
send me copies of the actual errors reported but thought I'd share this.


"Looked at Karens PC tonight, many errors in the event logs, indicating
network errors.
Installed latest updated network card drivers, and errors stopped.
Tested for 30 minuted between two machines using Realtek diagnostics
with no errors.

Hopefully this will sort it out, but it most likely was a network card
driver issue on Karens PC.
If it fixes it, I will update the rest of them."


-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On
Behalf Of Graham Brown
Sent: 22 June 2011 15:30
To: GrahamB
Subject: RE: Variable not found in read events

Thanks Tracy, I'll get the techies on site to run through these.

-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On
Behalf Of Tracy Pearson
Sent: 22 June 2011 15:01
To: GrahamB
Subject: RE: Variable not found in read events

Graham Brown wrote on 2011-06-22: 
>  Hi
> 
> 
>  I have a fox 8 app running codemine. Periodically it throws an error

> like
> 
> 
>  Line# 123 of Start
>  "Variable 'PR_CATEGORY' is not found."
>  2 Appapplication.Start (..\common\cmapp.vct)
>  1 o:\ecuwms\ecuwmsv2.exe
>  Generated by Build 2.1.295
> 
> 
>  Line 123 is the codemine call to read events. The variable name is
not
>  always the same, in this instance it is the category field on the  
> product screen (vcx)
> 
> 
>  The error doesn't appear all the time, seems to be when they either  
> leave the computer for a period of time or are hammering it.
> 
> 
>  I've looked at Spector recordings of the session and there is nothing

> wrong there, no other errors are thrown just before.
>  
>  They also periodically get error reading file on network drives
within
>  my system ( .frx files) so not sure if I'm looking at a network
issue.
> 
> 
>  Has any seen read events fail with errors before please.
> 
> 
> 
> 
>  Regards
>  
>  Graham
> 

Graham,

I occasionally see this reported from end users. Usually it is our VFP 8
or VFP 9 executable running from the mapped server drive. We also see
Invalid Seek Offset errors. Every time the problem has gone away when:
1) Anti-virus on workstations are set to NOT scan network drives
2) Anti-virus on the host/server machine is set to exclude the directory
where the executable exists
3) Anti-virus site wide is set to exclude DBF, FPT, and CDX files

There has been additional culprits at some sites. These include desktop
search tools such as the Google Desktop Search, always on offsite backup
programs, and a chatty network card or bad Ethernet cable.

HTH, happy hunting,
Tracy


Tracy Pearson
PowerChurch Software


[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/0AF51B84D903A144B9EE71AEAFE7E81C0EC0E7@compsys1.CompySys.local
** 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: Variable not found in read events

[Graham Brown]

Thanks Tracy, I'll get the techies on site to run through these.

-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On
Behalf Of Tracy Pearson
Sent: 22 June 2011 15:01
To: GrahamB
Subject: RE: Variable not found in read events

Graham Brown wrote on 2011-06-22: 
>  Hi
> 
> 
>  I have a fox 8 app running codemine. Periodically it throws an error
>  like
> 
> 
>  Line# 123 of Start
>  "Variable 'PR_CATEGORY' is not found."
>  2 Appapplication.Start (..\common\cmapp.vct)
>  1 o:\ecuwms\ecuwmsv2.exe
>  Generated by Build 2.1.295
> 
> 
>  Line 123 is the codemine call to read events. The variable name is
not
>  always the same, in this instance it is the category field on the
>  product screen (vcx)
> 
> 
>  The error doesn't appear all the time, seems to be when they either
>  leave the computer for a period of time or are hammering it.
> 
> 
>  I've looked at Spector recordings of the session and there is nothing
>  wrong there, no other errors are thrown just before.
>  
>  They also periodically get error reading file on network drives
within
>  my system ( .frx files) so not sure if I'm looking at a network
issue.
> 
> 
>  Has any seen read events fail with errors before please.
> 
> 
> 
> 
>  Regards
>  
>  Graham
> 

Graham,

I occasionally see this reported from end users. Usually it is our VFP 8
or
VFP 9 executable running from the mapped server drive. We also see
Invalid
Seek Offset errors. Every time the problem has gone away when:
1) Anti-virus on workstations are set to NOT scan network drives
2) Anti-virus on the host/server machine is set to exclude the directory
where the executable exists
3) Anti-virus site wide is set to exclude DBF, FPT, and CDX files

There has been additional culprits at some sites. These include desktop
search tools such as the Google Desktop Search, always on offsite backup
programs, and a chatty network card or bad Ethernet cable.

HTH, happy hunting,
Tracy


Tracy Pearson
PowerChurch Software


[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/0AF51B84D903A144B9EE71AEAFE7E81C0EC0E0@compsys1.CompySys.local
** 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: Automate Internet Explorer 9 with fox 8

[Graham Brown]

Thanks everyone

I've released a version with calls to WinInet based on Anatoliy's code
from the Fox Wiki 
http://fox.wikis.com/wc.dll?Wiki~ReadUrl

Initial feedback is that It works on all the computers and is
significantly faster than automating IE which I was surprised to hear.

Regards
Graham




-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On
Behalf Of Stephen Russell
Sent: 17 June 2011 15:30
To: GrahamB
Subject: Re: Automate Internet Explorer 9 with fox 8

On Fri, Jun 17, 2011 at 4:18 AM, Graham Brown 
wrote:
> Thanks John, I'll set up some tests over the weekend.
> I've also been doing some tests with API calls to Wininet
--

As a heads up jQuery content may not be touchable from your app in
this case.  In that what you see is generated localy via javascript
and not in html shot from the server.

-- 
Stephen Russell

Unified Health Services
60 Germantown Court
Suite 220
Cordova, TN 38018

Telephone: 888.510.2667

901.246-0159 cell

[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/0AF51B84D903A144B9EE71AEAFE7E81C0EC0D8@compsys1.CompySys.local
** 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.

Variable not found in read events

[Graham Brown]

Hi 

 

I have a fox 8 app running codemine. Periodically it throws an error
like 

 

Line# 123 of Start 
"Variable 'PR_CATEGORY' is not found." 
2 Appapplication.Start (..\common\cmapp.vct) 
1 o:\ecuwms\ecuwmsv2.exe 
Generated by Build 2.1.295 

 

Line 123 is the codemine call to read events. The variable name is not
always the same, in this instance it is the category field on the
product screen (vcx)

 

The error doesn't appear all the time, seems to be when they either
leave the computer for a period of time or are hammering it.

 

I've looked at Spector recordings of the session and there is nothing
wrong there, no other errors are thrown just before.

They also periodically get error reading file on network drives within
my system ( .frx files) so not sure if I'm looking at a network issue.

 

Has any seen read events fail with errors before please.

 

 

Regards

Graham

 



--- 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/0AF51B84D903A144B9EE71AEAFE7E81C0EC0D7@compsys1.CompySys.local
** 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: Automate Internet Explorer 9 with fox 8

[Graham Brown]

Thanks John, I'll set up some tests over the weekend. 
I've also been doing some tests with API calls to Wininet

Graham

-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On
Behalf Of John Harvey
Sent: 16 June 2011 17:16
To: GrahamB
Subject: RE: Automate Internet Explorer 9 with fox 8

I have found this to work when the body object doesn't appear in the dom
of
IE9 and you are trying to get to innertext or innerhtml.

lctext=oie.Document.body
IF ISNULL(lctext)
lctext=OIE.Application.Document.firstChild
ENDIF

John Harvey

-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On
Behalf Of Graham Brown
Sent: Wednesday, June 15, 2011 2:33 PM
To: profox@leafe.com
Subject: Automate Internet Explorer 9 with fox 8

Hi all

 

I've got some simple code to automate IE, navigate to a URL and download
the page as text. 

This code works fine in IE8 

 

oIE=createobject("InternetExplorer.Application")

oIE.Navigate("http://www.microsoft.com";)

do while oIE.ReadyState<>4

  Inkey(1)

Enddo

? oIE.Document.Body.InnerText

 

The compiled application fails with "Body is not an object" on Windows 7
and IE9.

 

If I run this line by in the command window Intellisense tells me there
is no body although I can just ignore Intellisense and ask for the body.
I can then see its InnerText.

Intellisense also fails in IE8/WinXP but the compiled application works
fine.

 

Has any come across this one please because it is driving me nuts.

 

Cheers

Graham

 



--- 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/0AF51B84D903A144B9EE71AEAFE7E81C0EC0C1@compsys1.CompySys.local
** 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.

Automate Internet Explorer 9 with fox 8

[Graham Brown]

Hi all

 

I've got some simple code to automate IE, navigate to a URL and download
the page as text. 

This code works fine in IE8 

 

oIE=createobject("InternetExplorer.Application")

oIE.Navigate("http://www.microsoft.com";)

do while oIE.ReadyState<>4

  Inkey(1)

Enddo

? oIE.Document.Body.InnerText

 

The compiled application fails with "Body is not an object" on Windows 7
and IE9.

 

If I run this line by in the command window Intellisense tells me there
is no body although I can just ignore Intellisense and ask for the body.
I can then see its InnerText.

Intellisense also fails in IE8/WinXP but the compiled application works
fine.

 

Has any come across this one please because it is driving me nuts.

 

Cheers

Graham

 



--- 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/0AF51B84D903A144B9EE71AEAFE7E81C0EC0B8@compsys1.CompySys.local
** 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: Windows 7 grid highlight

[Graham Brown]

Great !

Looks like I'll have to use dynamicBackColor then.

In another part of the project I change all dynamicbackcolor to red
where a condition is true and windows 7 understands that.

Cheers
G






-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On
Behalf Of Mike Copeland
Sent: 10 May 2011 21:16
To: GrahamB
Subject: Re: Windows 7 grid highlight



Welcome to the wonderfully frustrating world of Windows 7!



I think Windows 7 sucks.

Mike

> Hi
>
> AllowCellSelection is .f. and columns[n].readonly=.t.
> Doesn't make any difference to the row highlight though?
>
> All very strange.
>
>
>
> -Original Message-
> From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On
> Behalf Of Tracy Pearson
> Sent: 10 May 2011 18:45
> To: GrahamB
> Subject: RE: Windows 7 grid highlight
>
> Graham Brown wrote on 2011-05-10:
>>   Hi
>>
>>
>>   Sanity check required please!
>>
>>
>>   In Windows XP this correctly shows a grid with a black highlight
bar
>> with white writing
> 
>
>>   But in Windows 7 I get a pale blue highlight background with white
>> writing. This is the standard theme as this is the same colours used
>> in  other applications title bar.
>>
>>
>>   Looks like Windows 7 is ignoring the themes setting but I can't see
> why.
>>
>>   Am I going nuts?
>>
>>
>>   Regards
>>
> Graham,
>
> The currently selected field displays white on blue. The rest of the
row
> displays white on black.
>
> If the user doesn't need to edit the row:
> .AllowCellSelection = .F.
>
>
> Tracy Pearson
> PowerChurch Software
>
>
[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/0AF51B84D903A144B9EE71AEAFE7E81C0EC011@compsys1.CompySys.local
** 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.