from:"Sytze de Boer"

Re: Has anyone implemented List & Label?

2017-01-08 Thread Sytze de Boer

Hi Everyone

This is Sytze's son, I am writing because he passed away on Friday (sudden
heart attack while mowing the lawns, very quick, the way he wanted) and I
know he was an avid reader on this forum and often commented to me about
his gleanings he received from it.
I dont think he met any of you in person, but I know he spoke/emailed to
many of you personally and held many of you in high regards.
Would like to pass on this news in case any of you wondered why he went
quiet :)

Jonnie de Boer

On Sat, Jan 7, 2017 at 9:15 AM, Tracy Pearson  wrote:

> Hello Everyone,
>
> I'm currently evaluating List & Label for a replacement of the old Crystal
> Reports we have.
>
> I'm curious if anyone has implemented it, and the designer in to a VFP
> project.
>
> Thank you,
> 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/cag1nny94puyudz7i0x_ofkpc9da0g4iuu8dgep+ylfhlu_p...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Unit quantities

2016-12-20 Thread Sytze de Boer

In my accounting/invoicing system, clients create product items.

Let's say you sell Apples
You can sell
single apples
apples in a carton (e.g. 25 apples per carton)
cartons of apples on a pallet (e.g. 50 cartons per pallets)

I would like to know how YOU handle the Quantity management.
Do you create 3 different stock items or do you force people to enter 2
factors at invoice time. Qty and Factor, where factor can be (say) Single,
Carton or Pallet.

When you *see* your product profile,
do you see 1125 apples, X cartons and Y pallets and Z singles?

I hope I've explained this satisfactorily.
If its NF, please forgive me.

-- 
Kind regards,
Sytze de Boer


--- 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/cag1nny8t_fl0oqeziygdfhx_umwr53mm29vzybnigm1cnya...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Photo capture

2016-12-07 Thread Sytze de Boer

Richard, I appreciate your honesty.
I don't have any idea how to Open the Camera (From within my application)
so I have even less idea how to close it graciously.


On Thu, Dec 8, 2016 at 1:04 PM, Richard Kaye <rk...@invaluable.com> wrote:

> It sounds like the Camera application has the file open for exclusive
> access. I don't know enough to speak intelligently at this point other than
> to suggest you close the Camera application gracefully, as opposed to
> "killing" it.
>
> --
>
> rk
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Sytze
> de Boer
> Sent: Wednesday, December 07, 2016 6:58 PM
> To: profoxt...@leafe.com
> Subject: Re: Photo capture
>
> Hi Richard
> I think you're on to it.
>
> Do you have any ideas how I can try and Close the file?
> (I have tried to Kill the Camera but it seems to make no difference to the
> file)
>
>
> On Thu, Dec 8, 2016 at 12:53 PM, Richard Kaye <rk...@invaluable.com>
> wrote:
>
> > The source file could be open. You can try getting an FLOCK before you
> > attempt your copy. You also might want to look into using the Windows API
> > to copy the file instead of the old xBase COPY FILE command.
> >
> > --
> >
> > rk
> > -Original Message-
> > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
> Sytze
> > de Boer
> > Sent: Wednesday, December 07, 2016 6:43 PM
> > To: profoxt...@leafe.com
> > Subject: Photo capture
> >
> > I'm still totally lost trying to capture a photo via AVICAP32, so now
> > trying alternatives.
> >
> > Using the Windows software Camera to take a photo.
> > All is good. It places the photo into a folder
> > C:\Users\Sytze\Pictures\Camera Roll
> >
> > cdirs=FILETOSTR('picloc.txt')
> > ldirs=cdirs+"*.jpg"
> > lPics=ADIR(picfiles,ldirs)
> >
> > trcask350  =cdirs+picfiles(1,1) &, it now knows the picture
> > trcask351  =Sys(5)+Curdir()+"PICS\"+Alltrim(Str(matties.code))+"_
> > PHOTO.JPG"
> > **all is good at this stage
> >
> > COPY FILE (trcask350) TO (trcask351)
> >
> > Here's the problem
> > The file in the 2nd location is a zero byte file
> >
> > Can anyone suggest why this is so?
> >
> >
> > --
> > 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/CAG1nNy_DtdeWz_f2VexhTqLmNzij=NsRieV3L0q9UCxHi=c...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Photo capture

2016-12-07 Thread Sytze de Boer

Hi Richard
I think you're on to it.

Do you have any ideas how I can try and Close the file?
(I have tried to Kill the Camera but it seems to make no difference to the
file)

On Thu, Dec 8, 2016 at 12:53 PM, Richard Kaye <rk...@invaluable.com> wrote:

> The source file could be open. You can try getting an FLOCK before you
> attempt your copy. You also might want to look into using the Windows API
> to copy the file instead of the old xBase COPY FILE command.
>
> --
>
> rk
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Sytze
> de Boer
> Sent: Wednesday, December 07, 2016 6:43 PM
> To: profoxt...@leafe.com
> Subject: Photo capture
>
> I'm still totally lost trying to capture a photo via AVICAP32, so now
> trying alternatives.
>
> Using the Windows software Camera to take a photo.
> All is good. It places the photo into a folder
> C:\Users\Sytze\Pictures\Camera Roll
>
> cdirs=FILETOSTR('picloc.txt')
> ldirs=cdirs+"*.jpg"
> lPics=ADIR(picfiles,ldirs)
>
> trcask350  =cdirs+picfiles(1,1) &, it now knows the picture
> trcask351  =Sys(5)+Curdir()+"PICS\"+Alltrim(Str(matties.code))+"_
> PHOTO.JPG"
> **all is good at this stage
>
> COPY FILE (trcask350) TO (trcask351)
>
> Here's the problem
> The file in the 2nd location is a zero byte file
>
> Can anyone suggest why this is so?
>
>
> --
> 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/cag1nny_2phnfuaoqfuavw55fa40bcuvqh_dkwtrpqp1qkht...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Photo capture

2016-12-07 Thread Sytze de Boer

I'm still totally lost trying to capture a photo via AVICAP32, so now
trying alternatives.

Using the Windows software Camera to take a photo.
All is good. It places the photo into a folder
C:\Users\Sytze\Pictures\Camera Roll

cdirs=FILETOSTR('picloc.txt')
ldirs=cdirs+"*.jpg"
lPics=ADIR(picfiles,ldirs)

trcask350  =cdirs+picfiles(1,1) &, it now knows the picture
trcask351  =Sys(5)+Curdir()+"PICS\"+Alltrim(Str(matties.code))+"_PHOTO.JPG"
**all is good at this stage

COPY FILE (trcask350) TO (trcask351)

Here's the problem
The file in the 2nd location is a zero byte file

Can anyone suggest why this is so?


-- 
Kind regards,
Sytze de Boer


--- 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/cag1nny-egtusgeixzc5ghmsee3ie9xmzpgunqjvatzujxst...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Cameras

2016-12-04 Thread Sytze de Boer

Some time ago I asked about a new system i was developing.
Its just a small application.
I want a command button that will take a photo.

All is working fine except the photo. Well, not quite.

It's working fine on my Lenovo tablet/laptop, but nowhere else.

Then I spotted a small Lenovo Tablet at a local retail store. I asked if I
could test my software on the tablet. (Lenovo Miix 700)
It worked great.

But the cost was $1600 and I could buy this identical model from my *usual*
supplier for $850, so I got that one.
And my software does not take the photo.!!
The message comes up, "Using Video Capture: failed to connect"

Bernard Bout helped me with the software and I don't want to bother him
again when it is clearly a Windows issue

I'm about to give up on this and use Windows to take the photo, external to
my software.
When I use Windows (10) and type "Camera" all works fine except I can't
figure what the Executable is to activate the camera.

I hope I've explained this sufficiently.
Is there someone who can help me?

-- 
Kind regards,
Sytze de Boer


--- 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/cag1nny9xoo7tzh8yx2rhqjgsqysrq-11b7_qcdyofdi+yem...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: VFP9 runtimes windows 10;

2016-11-23 Thread Sytze de Boer

Man Wai, this is very interesting.
Can you point me to some assistance how to install (say) Wine on an Android
system
(I suspect it will be a bit different from Windows?)

I thought Linux had died a slow death.

On Wed, Nov 23, 2016 at 4:48 PM, Man-wai Chang  wrote:

> Check out:
>
> 1. Wine
> https://www.winehq.org/
>
> 2. CrossOver
> https://www.codeweavers.com/
>
> Worst-case scenario is to use virtualization.
>
> On Tue, Nov 22, 2016 at 8:20 PM,
>  wrote:
> > On 2016-11-19 13:03, Allen wrote:
> >>
> >> I wish VFP9 worked on Linux (legally)
> >> Al
> >
> > I think it could, and I doubt you'd get a legal challenge, but then
> again,
> > IANAL and can't pay your legal bills.  :-)
>
> --
>  .~. 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/cag1nny8ozwrvweth7pppear-xkzaoi6hsvkadfs12yu2s_p...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Word doc on invoice

2016-11-02 Thread Sytze de Boer

By using a program called 2JPG.EXE

On Wed, Nov 2, 2016 at 9:38 PM, Alan Bourke <alanpbou...@fastmail.fm> wrote:

> How are you doing the actual conversion part?
>
> --
>   Alan Bourke
>   alanpbourke (at) fastmail (dot) fm
>
> On Wed, 2 Nov 2016, at 05:36 AM, Sytze de Boer wrote:
> > My client enters invoice details using Word.exe
> > I need to print the word document on a Fox report
> >
> > I know there may be better ways, but this is how it has to run.
> >
> > I can only find 1 way to do this.
> > i.e.  Convert the Doc file to a Jpg file.
> > I have this working except for the fact the conversion is screwing the
> > size/font of the original Doc file.
> >
> > Are there other ways?
> >
> > --
> > 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/cag1nny-wyntciz47xns6hv63toawznkcb+ibyzdp2ulmyxh...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Word doc on invoice

2016-11-01 Thread Sytze de Boer

My client enters invoice details using Word.exe
I need to print the word document on a Fox report

I know there may be better ways, but this is how it has to run.

I can only find 1 way to do this.
i.e.  Convert the Doc file to a Jpg file.
I have this working except for the fact the conversion is screwing the
size/font of the original Doc file.

Are there other ways?

-- 
Kind regards,
Sytze de Boer


--- 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/CAG1nNy9bXT82kXADZSJ2xR=ZZ014g-3970r8eQq41=4ensn...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Excel errors

2016-10-21 Thread Sytze de Boer

I use the following

PARAMETERS whatprg, justchecking

lcProcess=whatprg+".EXE"
lcComputer = "."
loWMIService = GETOBJECT("winmgmts:" +
"{impersonationLevel=impersonate}!\\" + lcComputer + "\root\cimv2")
colProcessList = loWMIService.ExecQuery ("Select * from Win32_Process")

IF TYPE('colProcessList') = "O"
  FOR EACH loProcess IN colProcessList
 IF ALLTRIM(UPPER(loProcess.NAME)) == ALLTRIM(UPPER(lcProcess))
IF justchecking
   iamopen=.t.
   EXIT
endif
trt=MESSAGEBOX("Is it ok to close "+lcProcess+" ?",4+32,'')
IF trt=6
   loProcess.TERMINATE()
   exit
ENDIF
  NEXT
ENDIF  && IF TYPE('colProcessList') = "O"

RELEASE colProcessList, loWMIService

On Sat, Oct 22, 2016 at 9:59 AM, rafael copquin 
wrote:

> I have been using Excel automation for years. However, I could not find a
> way to kill the Excel application when an error occurs.
>
> Here is an example:
>
> I have this cursor with an inventory list that contains 9000 rows and 10
> columns, named curStock.
>
> I save the cursor with:
>
> local cExcel
>
> cExcel = 'c:\temp\stock.xls'
>
> select curStock
>
> copy to (cExcel) type xl5
>
> if upper(vartype(thisform.oExcel)) = "O"
>thisform.oExcel.quit
>thisform.oExcel = .f.
> Else
>thisform.AddProperty('oExcel')
> EndIf
>
> if upper(vartype(thisform.oExcel)) <> "O"
>thisform.oExcel=createobject("Excel.Application")
> else
>thisform.oExcel=getobject(,"Excel.Application")
> endif
>
>
> Try
>
> lOK = .t.
>
> With thisform.oExcel
>.workbooks.open("")
> endwith
>
> Catch to oError
>
>lOK = .f.
>
> MessageBox(oError.message,16,'Excel caused an error',2000)
>
>   thisform.oExcel.quit
>
> EndTry
>
> if not lOK
>
> quit
>
> else
>
> *** show the spreadsheet
>
> endif
>
> The property thisform.oExcel is trying to open the big Excel sheet
> (stock.xls) but fails
>
> Supposedly thisform.Excel.quit should kill the Excel instance.
>
> However it still remains in memory. The task manager shows it is still
> dangling in memory but is invisible.
>
> How can I kill it?
>
> BTW I use this approach instead of filling and formatting the sheet line
> by line, because it takes about half an hour to show, due to the large
> amount of records the cursor contains.
>
> Rafael Copquin
>
>
>
[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/cag1nny95erbknuu+r6hj93knjnmigecytxnef1bvp+z0uyq...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Command button to take a photo

2016-10-20 Thread Sytze de Boer

Hello Chris and Darren

I have not yet had time to check out your responses, but I want to thank
you for the quick responses.

Do you think the process is the same for an in-built camera as it is for a
usb camera?

On Fri, Oct 21, 2016 at 10:52 AM, Darren <fox...@ozemail.com.au> wrote:

> If you have an image on a form similar to the situation in the link below
> then it is a relatively simple matter to use the API to define a rectangle
> and capture that as a bitmap image file. Also relatively easy to convert to
> other image formats using for example the offering in gdiplus. I am sure a
> number of other options exist too. So yes - possible.
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Chris
> Davis
> Sent: Friday, 21 October 2016 8:45 AM
> To: profoxt...@leafe.com
> Subject: Re: Command button to take a photo
>
> http://fox.wikis.com/wc.dll?Wiki~VideoCaptureApi
>
> On 20 Oct 2016, at 22:37, Sytze de Boer
> <sytze.k...@gmail.com<mailto:sytze.k...@gmail.com>> wrote:
>
> In my application, which will be installed on a tablet or laptop, I need a
> command button which will take a photograph.
>
> As I understand it, these photos will always automatically be stored in a
> specific folder.
> Is this possible?
> Is there someone who has done this and willing to share the source?
>
>
>
> --
> 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/cag1nny-kmsw57pvwwign8upng6suqw0dpfse0bwuzggsmhj...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Command button to take a photo

2016-10-20 Thread Sytze de Boer

In my application, which will be installed on a tablet or laptop, I need a
command button which will take a photograph.

As I understand it, these photos will always automatically be stored in a
specific folder.
Is this possible?
Is there someone who has done this and willing to share the source?



-- 
Kind regards,
Sytze de Boer


--- 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/CAG1nNy9qOckBT9RQs7fooPYCXP=fnvnpvssx15qu2mxdbda...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: JPG files refuse to show themselves

2016-08-22 Thread Sytze de Boer

What I can't follow is that when I'm in Windows explorer and double the jpg
file, all goes fine
But, when I use the shellexecute process it does not

So what exactly is shellexecute?



On Tue, Aug 23, 2016 at 9:43 AM, Mike Copeland <m...@ggisoft.com> wrote:

> Great!
>
> Win 10 has some quirks, to say the least.
>
>
> Mike
>
> Sytze de Boer wrote:
>
>> Defaulting the system to use Photo instead of Paint has solved the
>> problem.
>>
>>
>> On Tue, Aug 23, 2016 at 8:06 AM, Mike Copeland <m...@ggisoft.com> wrote:
>>
>> I would try changing the default application for that file type extension
>>> (JPG) in the SETTINGS dialog. Windows 10 seems to handle file
>>> associations
>>> a little different.
>>>
>>> Just a WAG.
>>>
>>> Mike
>>>
>>>
>>> Sytze de Boer wrote:
>>>
>>> Thank you all
>>>>
>>>> EDIT made no difference
>>>> JPEG made no difference
>>>>
>>>> Any other suggestions?
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> On Mon, Aug 22, 2016 at 8:45 PM, Mike Copeland <m...@ggisoft.com>
>>>> wrote:
>>>>
>>>> Just curiousIf you change the file extension to .jpeg if it still
>>>> acts
>>>>
>>>>> the same way (wrong.)
>>>>>
>>>>> I had a client just a week ago who began having trouble with JPG files
>>>>> after their computer was upgraded to Win10 Pro. Changing the file
>>>>> extension
>>>>> to JPEG made their email program begin working again.
>>>>>
>>>>> Again, just curious what might happen in your case.
>>>>>
>>>>> Mike Copeland
>>>>>
>>>>>
>>>>> Sytze de Boer wrote:
>>>>>
>>>>> yes win 10
>>>>>
>>>>>> On 22/08/2016 8:14 PM, "Mike Copeland" <m...@ggisoft.com> wrote:
>>>>>>
>>>>>> Windows 10?
>>>>>>
>>>>>> Mike Copeland
>>>>>>>
>>>>>>>
>>>>>>> Sytze de Boer wrote:
>>>>>>>
>>>>>>> Paint
>>>>>>>
>>>>>>> On 22/08/2016 7:54 PM, "Alan Bourke" <alanpbou...@fastmail.fm>
>>>>>>>> wrote:
>>>>>>>>
>>>>>>>> What opens JPG when you double-click on one?
>>>>>>>>
>>>>>>>>
>>>>>>>> --
>>>>>>>>>   Alan Bourke
>>>>>>>>>   alanpbourke (at) fastmail (dot) fm
>>>>>>>>>
[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/cag1nny_zgnfwpudvjpvoumwt4uhse_wjkvhv8o+jct0d9w6...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: JPG files refuse to show themselves

2016-08-22 Thread Sytze de Boer

Defaulting the system to use Photo instead of Paint has solved the problem.

On Tue, Aug 23, 2016 at 8:06 AM, Mike Copeland <m...@ggisoft.com> wrote:

> I would try changing the default application for that file type extension
> (JPG) in the SETTINGS dialog. Windows 10 seems to handle file associations
> a little different.
>
> Just a WAG.
>
> Mike
>
>
> Sytze de Boer wrote:
>
>> Thank you all
>>
>> EDIT made no difference
>> JPEG made no difference
>>
>> Any other suggestions?
>>
>>
>>
>>
>>
>> On Mon, Aug 22, 2016 at 8:45 PM, Mike Copeland <m...@ggisoft.com> wrote:
>>
>> Just curiousIf you change the file extension to .jpeg if it still acts
>>> the same way (wrong.)
>>>
>>> I had a client just a week ago who began having trouble with JPG files
>>> after their computer was upgraded to Win10 Pro. Changing the file
>>> extension
>>> to JPEG made their email program begin working again.
>>>
>>> Again, just curious what might happen in your case.
>>>
>>> Mike Copeland
>>>
>>>
>>> Sytze de Boer wrote:
>>>
>>> yes win 10
>>>>
>>>> On 22/08/2016 8:14 PM, "Mike Copeland" <m...@ggisoft.com> wrote:
>>>>
>>>> Windows 10?
>>>>
>>>>> Mike Copeland
>>>>>
>>>>>
>>>>> Sytze de Boer wrote:
>>>>>
>>>>> Paint
>>>>>
>>>>>> On 22/08/2016 7:54 PM, "Alan Bourke" <alanpbou...@fastmail.fm> wrote:
>>>>>>
>>>>>> What opens JPG when you double-click on one?
>>>>>>
>>>>>>
>>>>>>> --
>>>>>>>  Alan Bourke
>>>>>>>  alanpbourke (at) fastmail (dot) fm
>>>>>>>
[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/cag1nny9chjytvhf_oazee4fdaw3sf+gzwvkqb0fbbzukwym...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: JPG files refuse to show themselves

2016-08-22 Thread Sytze de Boer

Thank you all

EDIT made no difference
JPEG made no difference

Any other suggestions?

On Mon, Aug 22, 2016 at 8:45 PM, Mike Copeland <m...@ggisoft.com> wrote:

> Just curiousIf you change the file extension to .jpeg if it still acts
> the same way (wrong.)
>
> I had a client just a week ago who began having trouble with JPG files
> after their computer was upgraded to Win10 Pro. Changing the file extension
> to JPEG made their email program begin working again.
>
> Again, just curious what might happen in your case.
>
> Mike Copeland
>
>
> Sytze de Boer wrote:
>
>> yes win 10
>>
>> On 22/08/2016 8:14 PM, "Mike Copeland" <m...@ggisoft.com> wrote:
>>
>> Windows 10?
>>>
>>> Mike Copeland
>>>
>>>
>>> Sytze de Boer wrote:
>>>
>>> Paint
>>>>
>>>> On 22/08/2016 7:54 PM, "Alan Bourke" <alanpbou...@fastmail.fm> wrote:
>>>>
>>>> What opens JPG when you double-click on one?
>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Alan Bourke
>>>>> alanpbourke (at) fastmail (dot) fm
>>>>>
[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/cag1nny8pg1ycosqskgtxodg9rtojd-nmrq2bmckqxyztpjs...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: JPG files refuse to show themselves

2016-08-22 Thread Sytze de Boer

yes win 10

On 22/08/2016 8:14 PM, "Mike Copeland" <m...@ggisoft.com> wrote:

> Windows 10?
>
> Mike Copeland
>
>
> Sytze de Boer wrote:
>
>> Paint
>>
>> On 22/08/2016 7:54 PM, "Alan Bourke" <alanpbou...@fastmail.fm> wrote:
>>
>> What opens JPG when you double-click on one?
>>>
>>>
>>>
>>> --
>>>Alan Bourke
>>>alanpbourke (at) fastmail (dot) fm
>>>
[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/cag1nny_oy93vn5e96ctfyydec77dhgjnv7zolc5wgv1t2dt...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: JPG files refuse to show themselves

2016-08-22 Thread Sytze de Boer

Paint

On 22/08/2016 7:54 PM, "Alan Bourke"  wrote:

> What opens JPG when you double-click on one?
>
>
>
> --
>   Alan Bourke
>   alanpbourke (at) fastmail (dot) fm
>
[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/cag1nny9zpmic7aiqzmgq1-m9ehj+swhegl2hed1yiyfgs8s...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

JPG files refuse to show themselves

2016-08-21 Thread Sytze de Boer

In my system, there are many instances of Opening a file where I do the
following

Do trmatt2 With Sys(5)+Curdir()+"PAYREP3.XLSX",'OPEN'
and trmatt2 looks like this

LPARAMETERS tcFile, tcAction

tcFile  =IIF(type("tcFile")="C",tcFile,sys(5)+curdir()+"README.RTF")
tcAction='OPEN'

if !file(tcFile)
   =messagebox('Sorry, problem finding the file ',0,'')
else
   wait window nowait 'Opening '+tcFile

   DECLARE INTEGER ShellExecute ;
   IN SHELL32.dll ;
   INTEGER nWinHandle,;
   STRING cOperation,;
   STRING cFileName,;
   STRING cParameters,;
   STRING cDirectory,;
   INTEGER nShowWindow

   DECLARE INTEGER FindWindow IN WIN32API STRING cNull,STRING cWinName

   RETURN
ShellExecute(FindWindow(0,_SCREEN.caption),tcAction,tcFile,"",SYS(2023),1)
endif

This is working fine with all manner of files, EXCEPT JPG files
Can anyone help me with this?












-- 
Kind regards,
Sytze de Boer


--- 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/CAG1nNy-XLjpPYLyK6R-MsiwBet1p=0shztbmfk2xa-q+dre...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

iCloud

2016-08-13 Thread Sytze de Boer

I have a client who has now lost their transaction history file for the 2nd
time.
By that I mean, all records between 23rd of March and sometime in August
2016

I've checked the file.
The records are not there with a deleted flag. They're gone, as if deleted
and packed.

It's most bizarre, and of course, my system gets the blame.

About the only thing I've noticed with their system is they run iCloud on
their Windows 10 pc. It pops up about every 15 secs in the right hand
system tray, to say it has synchronised some files.

My system has maybe 75 free standing dbf/fpt/cdx files.
The corrupted history file only has about 10,000 records, where, on 2
occasions, 120 records have disappeared.

Does anyone wish to comment.



-- 
Kind regards,
Sytze de Boer


--- 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/CAG1nNy9U3DroayR6gZotopx4scBq4+XDfcDo8TPpjw1Zs-R=h...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Mobile App

2016-08-01 Thread Sytze de Boer

Dave, once again, THANK you.
Based on your recommendation, I have gone ahead and purchased the
Enterprise version.
I can see some long nights ahead...


On Mon, Aug 1, 2016 at 8:48 PM, Dave Crozier <da...@flexipol.co.uk> wrote:

> Sytze,
> Take a look at Basic4Android. Easy to learn and streets ahead of "basic"
> as you know it with a similar structure to VFP with which it has many
> similarities. Available also on iOS (B4i), Desktop(B4j)  Arduino (B4R) and
> supports Android, Iod, windows, Mac, Linux, Arduino, Raspberry Pi and much
> more.
>
> Free to try with a few restrictions (Cannot use class libraries being one
> of them) but only $59 to fully license on a perpetual basis for the copy
> you register and $119 for the enterprise version which covers you for 2
> years updates. The B4i (iOS) version can be bought with a bundle for $189
> but requires a local Mac computer to run whereas the Hosted Builder bundle
> allows you to use a cloud to do the builds.
>
> Highly recommended, simple to learn, support is excellent and it just
> works.
>
>
> https://www.b4x.com/?gclid=CjwKEAjw5vu8BRC8rIGNrqbPuSESJADG8RV0o1xjL77x7ZV9hkwLWU5M0nEyS-wTBojCfP6GDShKpxoC_b7w_wcB
>
> Dave
>
> -Original Message-
> From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Sytze de Boer
> Sent: 31 July 2016 21:57
> To: profox <profox@leafe.com>
> Subject: Mobile App
>
> With all this talk about platforms and languages, I'll throw this out
> there.
>
> I would like to design something that will work on a mobile phone.
> Apple and.or Android
>
> 1 Your system device name.
>
> Can be a serial number or some other unique 10 character value
>
> 2 Start Date/time
>
> 3 A 10 digit number
>
> 4 Stop date/time
>
>  Email this data to an email address
>
> After emailing, a button to erase the data file.
>
> In VFP terms, a table with columns like
>
> SYSNAME C(10)
>
> STARTTIME  (Date/time)
>
> JOBNUM  N(10)
>
> STOPTIME ( Date/time)
>
> Is this a Xojo job I should attempt or is someone able to do this for me
> (PAID of course)
>
>
> --
> 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/cag1nny8zuuvkh-eygmcgr4zxmannzesuqz9rbwn+v2mxfz7...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Mobile App

2016-07-31 Thread Sytze de Boer

Ted, your comments noted
However, with this App, the client does not always have internet
application.

On Mon, Aug 1, 2016 at 12:38 PM, Ted Roche <tedro...@gmail.com> wrote:

> On Sun, Jul 31, 2016 at 4:56 PM, Sytze de Boer <sytze.k...@gmail.com>
> wrote:
> > With all this talk about platforms and languages, I'll throw this out
> there.
> >
> > I would like to design something that will work on a mobile phone.
> > Apple and.or Android
> >
> > 1 Your system device name.
> >
> > Can be a serial number or some other unique 10 character value
> >
> > 2 Start Date/time
> >
> > 3 A 10 digit number
> >
> > 4 Stop date/time
> >
> >  Email this data to an email address
> >
> > After emailing, a button to erase the data file.
> >
> > In VFP terms, a table with columns like
> >
> > SYSNAME C(10)
> >
> > STARTTIME  (Date/time)
> >
> > JOBNUM  N(10)
> >
> > STOPTIME ( Date/time)
> >
> > Is this a Xojo job I should attempt or is someone able to do this for me
> > (PAID of course)
>
> Why not write it as a web-based app? That would eliminate the email
> component altogether, and allow access from Android, Apple, Zune, Palm
> Pilot, PC, Macintosh, tablets, iPad, kiosks and pretty much anything
> else with a web connection.
>
> Writing custom apps for each proprietary hardware platform is great if
> you need to take advantage of native functionality of the machine
> (GPS, accelerometer, camera, telephony, etc.) but for generic CRUD
> apps, it can be advantageous to just write to a common platform. Kinda
> like "Write Once, Run Anywhere..."
>
>
> --
> 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/cag1nny8cfny72bjk_k6vozcv39_8ri_2szdwrxshmjvtk4d...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Mobile App

2016-07-31 Thread Sytze de Boer

With all this talk about platforms and languages, I'll throw this out there.

I would like to design something that will work on a mobile phone.
Apple and.or Android

1 Your system device name.

Can be a serial number or some other unique 10 character value

2 Start Date/time

3 A 10 digit number

4 Stop date/time

 Email this data to an email address

After emailing, a button to erase the data file.

In VFP terms, a table with columns like

SYSNAME C(10)

STARTTIME  (Date/time)

JOBNUM  N(10)

STOPTIME ( Date/time)

Is this a Xojo job I should attempt or is someone able to do this for me
(PAID of course)


-- 
Kind regards,
Sytze de Boer


--- 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/CAG1nNy-6HzjjmOcKA4zjHikmB7LOOJ4uBnAX8drFrFbty=3...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Windows 10 and Append General

2016-07-27 Thread Sytze de Boer

Update
Thank you all for your comments/opinions or otherwise.

My client has reversed the Win10 update and all is well again.
i.e. same pc, same office, no change to my application.

It simply fails to "append general", as in it skips this line in my code.
So now I have time to apply a work-around.

On Thu, Jul 28, 2016 at 9:05 AM, <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:

> On 2016-07-27 04:59, Alan Bourke wrote:
>
>> I just tested this under Windows 10, VFP9 SP2 and a small table with a
>> general field linked to Word 2016 .docx files. It seems to indeed work
>> fine once I set the properties of the report field to 'Scale Picture -
>> Retain Shape'.
>>
>> So again I would strongly suspect path resolution issues.
>>
>
>
> Ever since folks long ago suggested to NOT embed files into General fields
> (but rather store the LINK to the file instead), I avoided using General
> fields.
>
[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/cag1nny81tm+0lnxyhr5etb0-hftw08njebqxz3iyxpkgfbt...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Windows 10 and Append General

2016-07-26 Thread Sytze de Boer

Yes, I'm trying to print the Doc file embedded in a report. Like you can
with a picture.

On Wed, Jul 27, 2016 at 9:08 AM, Ted Roche <tedro...@gmail.com> wrote:

> On Tue, Jul 26, 2016 at 3:56 PM, Sytze de Boer <sytze.k...@gmail.com>
> wrote:
> >
> > My remaining issue though, is there some way I can print a report with
> the
> > DOC file details.? (In much the same way as printing a report with a JPG
> > file, or otherwise)
> >
>
> I'm sorry for being dense, but what do you mean by that?
>
> Are DOC file details the author's name and number of characters, e.g.,
> the properties, or
>
> Are you trying to print the DOC file, perhaps as an image embedded in
> a FoxPro FRX report?
>
>
> --
> 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/cag1nny-gsinzhjvfurvhmjs_kmefa-2jpusrq2hvj2ml1+e...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Windows 10 and Append General

2016-07-26 Thread Sytze de Boer

Thank you all for your opinions/advice.

I am happy to NOT store data in the General field, since the data is
already saved in DOC format, which is unique to each invoice.
("INV"+alltrim(str(invnum))+".DOC"

My remaining issue though, is there some way I can print a report with the
DOC file details.? (In much the same way as printing a report with a JPG
file, or otherwise)

On Wed, Jul 27, 2016 at 5:29 AM, Gene Wirchenko <ge...@telus.net> wrote:

> [reordered to chronological]
>
> At 02:26 2016-07-26, Dave Crozier <da...@flexipol.co.uk> wrote:
>
> -Original Message-
>> From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Sytze de Boer
>> Sent: 26 July 2016 04:46
>> To: profox <profox@leafe.com>
>> Subject: Windows 10 and Append General
>>
>> So I have used this approach for 20 years and it has always worked My
>> client prepares an invoice using Word The file is
>> "INV"+alltrim(str(invnum))+".DOC"
>> E.g. INV12345.DOC
>>
>
>  Not a solution to your problem, but you might try
>   transform(invnum)
> instead of the alltrim(str()).
>
>
> No, No, No ... General fields are the work of the devil bloated memo
>> files, VFP table size restrictions, links that get mysteriously corrupted,
>> slow as hell  etc.
>>
>
>  One advantage of general fields is that the short form of the keyword
> is my first name.
>
> Sincerely,
>
> Gene Wirchenko
>
>
[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/cag1nny8xaysyzqcpxygh89pcrwv3m6gvcp2a1dchg1bww6d...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Windows 10 and Append General

2016-07-25 Thread Sytze de Boer

So I have used this approach for 20 years and it has always worked
My client prepares an invoice using Word
The file is "INV"+alltrim(str(invnum))+".DOC"
E.g. INV12345.DOC

The system says
append general rtfgen from  LINK

It is then easy to print this on the report

It seems this no longer works with Win10

My thoughts at this time are to no longer store the data in a General
field, and to print the DOC file as part of the report.
BUT, I can't figure how to do that.
I can print pictures, BMP's, Gif's etc, but not a Doc file

Can anyone throw some light on this, or offer some suggestions?

-- 
Kind regards,
Sytze de Boer


--- 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/cag1nny8e-lac7o51shn11ncmajncqcumfqkyyfzhrzjqfgt...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Grid scrollbars

2016-07-17 Thread Sytze de Boer

Well, I have this small package working on a tablet, almost.
(And I shouldn't say this without mentioning the great help from Bernard
Bout)

One aspect is annoying me though. It's almost impossible to scroll my grid.
For the moment I've placed 2 big arrows/Command buttons on the Form

The width of the scroll bar is pathetic and I think I've read somewhere
that *gestures* simply won't work with a VFP application.

Does someone want to comment (or otherwise assist me?)


-- 
Kind regards,
Sytze de Boer


--- 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/CAG1nNy8A40kyGCzJDpWdjBs=mNHD40CA4=bmkuksxpbzs_y...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Menu

2016-07-12 Thread Sytze de Boer

Thank you all for trying to help me.
Recap the problem.
All sub menus of my mainmenu were greyed out, but not any procedures

All problems solved when I noticed my mainform was set to modal
I think I wasted 4 hours on this. The project budget is 176 hours so I
should be ok.

Thank you again.

On Tue, Jul 12, 2016 at 10:53 PM, Laurie Alvey <trukke...@gmail.com> wrote:

> In my apps I don't have a "main" form. I call the menu.mpr in the main prg.
> No problems. Sytze, have you tried regenerating the menu (in case something
> went wrong)?
>
> Laurie
>
> On 12 July 2016 at 09:03, Koen Piller <koen.pil...@gmail.com> wrote:
>
> > Sytze
> > The main menu is usualy called in the init of your mainform and not from
> > your main.prg
> > Regards
> > Koen
> >
> >
> > Op dinsdag 12 juli 2016 heeft Sytze de Boer <sytze.k...@gmail.com> het
> > volgende geschreven:
> >
> > > I think I'm going nuts
> > >
> > > I have created a menu, its called WINB18
> > > I can see the 4 files (mnx,mnt, mpr and mpx)
> > >
> > > If I issue the command, DO WINB18.MPR, all options on the menu work
> just
> > > fine
> > > But, if I load the menu from my MAIN.prg, the menu shows, BUT the only
> > > options that fire are those setup as a Procedure.
> > > All the options listed under the Submenu are greyed out
> > >
> > > I've gone to another application I have developed and all is fine with
> > > those menus
> > > It's only with this one, a new system under development.
> > >
> > > For the life of me, I can't see what's different.
> > > Can anyone help?
> > >
> > > --
> > > 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/CAG1nNy81zbhVBSjHC=er4dts0F1w6TYXw9o=ngmjprq6qr7...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Menu

2016-07-12 Thread Sytze de Boer

Hi Koen, thanks for trying to assist.
My main form does indeed have the DO WINB18.MPR in the Init

On Tue, Jul 12, 2016 at 8:03 PM, Koen Piller <koen.pil...@gmail.com> wrote:

> Sytze
> The main menu is usualy called in the init of your mainform and not from
> your main.prg
> Regards
> Koen
>
>
> Op dinsdag 12 juli 2016 heeft Sytze de Boer <sytze.k...@gmail.com> het
> volgende geschreven:
>
> > I think I'm going nuts
> >
> > I have created a menu, its called WINB18
> > I can see the 4 files (mnx,mnt, mpr and mpx)
> >
> > If I issue the command, DO WINB18.MPR, all options on the menu work just
> > fine
> > But, if I load the menu from my MAIN.prg, the menu shows, BUT the only
> > options that fire are those setup as a Procedure.
> > All the options listed under the Submenu are greyed out
> >
> > I've gone to another application I have developed and all is fine with
> > those menus
> > It's only with this one, a new system under development.
> >
> > For the life of me, I can't see what's different.
> > Can anyone help?
> >
> > --
> > 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/cag1nny_k8w8gc60cy3dsuldemz80xxgrwqgo19bycs5vvms...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

I think I'm going nuts

I have created a menu, its called WINB18
I can see the 4 files (mnx,mnt, mpr and mpx)

If I issue the command, DO WINB18.MPR, all options on the menu work just
fine
But, if I load the menu from my MAIN.prg, the menu shows, BUT the only
options that fire are those setup as a Procedure.
All the options listed under the Submenu are greyed out

I've gone to another application I have developed and all is fine with
those menus
It's only with this one, a new system under development.

For the life of me, I can't see what's different.
Can anyone help?

-- 
Kind regards,
Sytze de Boer


--- 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/CAG1nNy_KDU976=ZP+mA2L983ubK4xMJg-s28ZoejT=wmtks...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: updating 2 forms

2016-07-05 Thread Sytze de Boer

Darren, thanks for your suggestion.
But I'm stuck on how to pass such a reference
Can you suggest?

On Wed, Jul 6, 2016 at 11:12 AM, Darren <fox...@ozemail.com.au> wrote:

> Yes be the answer.
>
> I'd probably attack it by passing a reference to the text box to be updated
> to the 2nd form.  In the control on the 2nd form interactive change event
> have that set the caption of the text box on the first form to the value of
> the control on the 2nd form.
>
>
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Sytze
> de
> Boer
> Sent: Wednesday, 6 July 2016 9:02 AM
> To: profoxt...@leafe.com
> Subject: updating 2 forms
>
> Friends
>
> In a new application I am developing, I have a Form with a Command button
> The Command button opens a 2nd form
>
> When my client enters data into this 2nd form, I need to show what is being
> typed in a Text box on the 1st form.
> Can that be done?
>
>
> --
> 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/cag1nny9tx_d5ndm5yfoadzgvpr0djl4qdu5jytbq9_q+vwn...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

updating 2 forms

2016-07-05 Thread Sytze de Boer

Friends

In a new application I am developing, I have a Form with a Command button
The Command button opens a 2nd form

When my client enters data into this 2nd form, I need to show what is being
typed in a Text box on the 1st form.
Can that be done?


-- 
Kind regards,
Sytze de Boer


--- 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/CAG1nNy_tTRgvUj1b2zH5zVd+Af7Yfusx_=_gad-pcqekje1...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: How to set up a second email address

2016-06-30 Thread Sytze de Boer

I do exactly the same from NY payroll application and use a Gmail account.
On 1/07/2016 4:46 AM, "Kurt Wendt"  wrote:

> How about using a Gmail account as an alternative?
>
> As for the Error - can't you just trap for it - then handle sending to
> alternate email account? Maybe even do a WAIT command - for like 12 seconds
> - then test for the Error??
>
> Regards,
> Kurt Wendt
> Senior Systems Analyst
>
>
> Tel. +1-212-747-9100
> www.GlobeTax.com
>
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
> Andrew Stirling
> Sent: Thursday, June 30, 2016 12:39 PM
> To: profoxt...@leafe.com
> Subject: How to set up a second email address
>
> Hi
>
> I use Fastmail to allow my clients to send wage slips to their employees
> in my payroll program.
> Currently it is down:
> http://www.fastmailstatus.com/
> So I suppose I should set up another email provider to forward these
> emails if/when Fastmail fails.
> So how can I tell if Fastmail is down?
> I do get an error after 10 seconds, 1429 OLE IDespatch exception code 0
> from?
>
> Any thoughts/code much appreciated, who else to use?
>
> --
> Kind regards
>
> Andrew Stirling
> 01250 870397 / 874580
> 07910467915
> supp...@calcpay.co.uk
> http://www.calcpay.co.uk
>
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
>
>
[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/CAG1nNy91fYfvygXNNWhA8Z6nqSruBihYGfKEZQe=c7pbd9q...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: VFP to XLSX file

2016-05-07 Thread Sytze de Boer

Fellow foxers

I have resolved the issue I encountered.
The following works well

sele foxdata
go top

With loExcel
   .Workbooks.Open(lcFile)
   scan
 Mdata =Alltrim(foxdata.sheet2) && EG "J16"
 Msheet=ALLTRIM(sheet1) && EG "Expenses"
 .Application.Worksheets("").Activate  && Select sheet
 .Range("").Select
 .Selection=foxdata.balance
   ETC

In  other words, the problem was not with "" or & and all red herrings
In the end I found the problem that the sheets in the spreadsheet were
protected
Once I re-created the spreadsheet and did not make the sheets Protected,
all problems went away.

On Thu, May 5, 2016 at 11:29 PM, Srikanth Bhandari <
consult...@srikanthbhandari.ind.in> wrote:

> If you want to pass as a variable then it should be without the quotes else
> it passes as a string.
>
> --
> Cheers!!!
>
> *Srikanth Bhandari*
> Mobile: +91 99625 42134 / +91 99001 39393
> Email: consult...@srikanthbhandari.ind.in / srikanth.bhanda...@gmail.com
> Web: srikanthbhandari.ind.in
>
> On Thu, May 5, 2016 at 4:10 PM, Peter Cushing <
> pcush...@whisperingsmith.com>
> wrote:
>
> > On 05/05/2016 08:15, Allen wrote:
> >
> >> I think it will pass  as a string instead of whatever msheet is
> >> Al
> >>
> >> Yes, you don't need to use & when doing automation.
> >
> > E.g.
> >
> >
> > cCell = "B" + ALLTRIM(STR(nRow))&& get some data from a table e.g. B1
> > B2 etc
> > objexcel.Range(cCell).Select
> >
> > cRow = ALLTRIM(STR(nRow)) + ':' + ALLTRIM(STR(nRow)) && could be
> > 45:45   72:74 etc
> > OBJexcel.Rows(cRow).RowHeight = 93
> >
> > Peter
> >
> >
> > This communication is intended for the person or organisation to whom it
> > is addressed. The contents are confidential and may be protected in law.
> > Unauthorised use, copying or disclosure of any of it may be unlawful. If
> > you have received this message in error, please notify us immediately by
> > telephone or email.
> > www.whisperingsmith.com
> >
> > Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3
> 1RR.
> > Tel:0161 831 3700 Fax:0161 831 3715
> > London Office:17-19 Foley Street, London W1W 6DW Tel:0207 299 7960
> >
> >
[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/cag1nny_1thjkws01tzefk-xehnkvbde0k5wkwa5xjj+6hzc...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: VFP to XLSX file

2016-05-05 Thread Sytze de Boer

Because msheet could be msheet1, or msheet2 etc
If I take the "" away, it comes up with   Variable sheet6 is not found

On Thu, May 5, 2016 at 7:02 PM, Allen <pro...@gatwicksoftware.com> wrote:

> why have you got "" as well as & ?
> Al
>
> -Original Message- From: Sytze de Boer
> Sent: Thursday, May 5, 2016 2:09 AM
> To: profoxt...@leafe.com
> Subject: VFP to XLSX file
>
>
> I just can't figure what I'm doing wrong with this code. Can anyone assist
> The spreadsheet I want to place information into has about 15 Sheets
> Foxdata has around 500 entries
>
>
> With loExcel
>   .Workbooks.Open(lcFile)
>   Scan
>  Select foxdata
>  If !balance=0
> Mdata =Alltrim(foxdata.sheet2) && EG "J16"
> *Msheet="SHEET"+ALLTRIM(sheet1) && EG "Expenses"
> Msheet="SHEET"+ALLTRIM(STR(sheetnum)) && If I use the sheet number
> instead
> .Sheet("").Select
> This is where it comes up with error   "invalid index"
>
> .Range("").Select
> I get an occasional error here
>
> .Selection=foxdata.balance
>  Endif
>
>   Endscan
>   .ActiveWindow.Close(xlSaveChanges)
>   .Quit()
> Endwith
>
>
>
> --
> 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/cag1nny8lf4vvco1qi72zuycxbhcnri1h+3cor+wghpzy9_a...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

VFP to XLSX file

2016-05-04 Thread Sytze de Boer

I just can't figure what I'm doing wrong with this code. Can anyone assist
The spreadsheet I want to place information into has about 15 Sheets
Foxdata has around 500 entries


With loExcel
   .Workbooks.Open(lcFile)
   Scan
  Select foxdata
  If !balance=0
 Mdata =Alltrim(foxdata.sheet2) && EG "J16"
 *Msheet="SHEET"+ALLTRIM(sheet1) && EG "Expenses"
 Msheet="SHEET"+ALLTRIM(STR(sheetnum)) && If I use the sheet number
instead
 .Sheet("").Select
This is where it comes up with error   "invalid index"

 .Range("").Select
I get an occasional error here

 .Selection=foxdata.balance
  Endif

   Endscan
   .ActiveWindow.Close(xlSaveChanges)
   .Quit()
Endwith



-- 
Kind regards,
Sytze de Boer


--- 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/cag1nny8wkwzhlg+hm-tw+o0qzfqvygbn8j_p1r8amtsoxru...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Edit CSV file

2016-04-14 Thread Sytze de Boer

I'm glad I posted the question. The feedback has taught me much.
Thank you all.

On Fri, Apr 15, 2016 at 4:31 AM, Tracy Pearson <tr...@powerchurch.com>
wrote:

> Sytze de Boer wrote on 2016-04-13:
> >  My client has asked me to export specified data to a CSV file
> >  That's the easy part.
> >  I have a CSV file with a header and 500 detail lines.
> >
> >  Now he has asked that
> >  Column 1, Row 1, (the header) MUST be called *contactname
> >  Column 7, Row 1, (some details) MUST be called *PAYDUEDATE
> >  and a few others
> >
> >  As you can see, this is more than 10 characters.
> >  I need some help here.
> >  Whats the easiest way to automate this?
>
> Sytze,
>
> If you are lucky enough to be able to use the COPY TO ... TYPE CSV, it may
> be easier than you think:
>
>CREATE CURSOR csvoutput (contname c(30))
>INSERT INTO csvoutput VALUES ("Paul")
>INSERT INTO csvoutput VALUES ("John")
>
>SELECT contname as ContactName FROM csvoutput INTO CURSOR finaloutput
>
>COPY TO sytzetest TYPE CSV
>
>MODIFY FILE sytzetest.csv NOWAIT
>
>
> 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/CAG1nNy_jpGb6+X=KNqXc=wnH=lkkcahefykd3z5yya6uce5...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Edit CSV file

2016-04-13 Thread Sytze de Boer

Matt, thank you for that quick and great guidance.
I think I may have to work out how to make that top line greater than 255
chars, but I'm working on it.
Text to myvar, right?

On Thu, Apr 14, 2016 at 3:32 PM, M Jarvis <brewda...@gmail.com> wrote:

> On Wed, Apr 13, 2016 at 8:28 PM, Sytze de Boer <sytze.k...@gmail.com>
> wrote:
>
> > My client has asked me to export specified data to a CSV file
> > That's the easy part.
> > I have a CSV file with a header and 500 detail lines.
> >
> > Now he has asked that
> > Column 1, Row 1, (the header) MUST be called *contactname
> > Column 7, Row 1, (some details) MUST be called *PAYDUEDATE
> > and a few others
> >
> > As you can see, this is more than 10 characters.
> > I need some help here.
> > Whats the easiest way to automate this?
> >
> >
>
> It's pretty easy actually...
>
> Get your data, build a string with it or send to file then FILETOSTR the
> stuff, create your header line, append the data string, write to CSV file
> with the name you want.
>
> --
> Matt Jarvis
> Eugene, Oregon USA
>
>
> --- 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/CAG1nNy--MOhyDUr=awn_wl14-3nkghr-erlpnsiaai3jaaw...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Edit CSV file

2016-04-13 Thread Sytze de Boer

My client has asked me to export specified data to a CSV file
That's the easy part.
I have a CSV file with a header and 500 detail lines.

Now he has asked that
Column 1, Row 1, (the header) MUST be called *contactname
Column 7, Row 1, (some details) MUST be called *PAYDUEDATE
and a few others

As you can see, this is more than 10 characters.
I need some help here.
Whats the easiest way to automate this?

-- 
Kind regards,
Sytze de Boer


--- 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/cag1nny-9ob+n4opoireatvrnhzaratej0fpz7ok_j+dhedq...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Outlook.com

2016-04-02 Thread Sytze de Boer

Laurie, thanks for your queries.
Yes to both.


On Sat, Apr 2, 2016 at 9:05 PM, Laurie Alvey <trukke...@gmail.com> wrote:

> Is winkiss.usessl = .T.? (This usually works when you can't use TSL.) Also,
> have you tried a timeout setting, say 30 or 60?
>
> Laurie
>
> On 2 April 2016 at 00:05, Sytze de Boer <sytze.k...@gmail.com> wrote:
>
> > Hi
> >
> > I use CDO to send emails via my Gmail address and it works just sweet
> > When I try the same with an email address some...@outlook.com, it fails
> > every time with a message The transport failed to connect to the server
> > (error 1429)
> >
> > With Gmail, the port number is 465. From my research, Outlook.com uses
> 587
> > or 25
> > I think Outlook requires TSL but I don't see that option with CDO
> > I've tried the smtpserver as smtp-mail.outlook.com as well as
> > smtp-mail.live.com
> >
> > This same process (below) works well with an internal Exchange server.
> >
> > (Winkiss is a table)
> > TRY
> >Local lcSchema, loConfig, loMsg, loError, lcErr
> >lcErr = ""
> >lcSchema = "http://schemas.microsoft.com/cdo/configuration/;
> >loConfig = Createobject("CDO.Configuration")
> >
> >With loConfig.Fields
> >   .Item(lcSchema + "smtpserver")  = ALLTRIM(winkiss.opt15)
> >   .Item(lcSchema + "smtpserverport") = winkiss.portnum
> >   .Item(lcSchema + "sendusing")= 2
> >   .Item(lcSchema + "smtpauthenticate")  = .t.
> >   .Item(lcSchema + "smtpusessl")  = winkiss.usessl
> >   .Item(lcSchema + "sendusername")  = ALLTRIM(winkiss.usersig)
> >   .Item(lcSchema + "sendpassword")  = ALLTRIM(winkiss.empw)
> >   .Update
> >Endwith
> >loMsg = Createobject ("CDO.Message")
> >
> >With loMsg
> >   .Configuration = loConfig
> >   .From= ALLTRIM(winkiss.opt17)
> >   .To= ALLTRIM(winkiss.opt17)
> >   .Subject = "Test subject"
> >   .TextBody  = "Testing SMTP emailing, from myself to myself"
> >   .Send()
> >Endwith
> >
> > etc
> >
> > Does anyone have suggestions
> >
> > --
> > 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/CAG1nNy8eA1j=ZOK9Qe-sOmM8Uiik_W517py=6zgCbvj=gti...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Outlook.com

2016-04-01 Thread Sytze de Boer

Hi

I use CDO to send emails via my Gmail address and it works just sweet
When I try the same with an email address some...@outlook.com, it fails
every time with a message The transport failed to connect to the server
(error 1429)

With Gmail, the port number is 465. From my research, Outlook.com uses 587
or 25
I think Outlook requires TSL but I don't see that option with CDO
I've tried the smtpserver as smtp-mail.outlook.com as well as
smtp-mail.live.com

This same process (below) works well with an internal Exchange server.

(Winkiss is a table)
TRY
   Local lcSchema, loConfig, loMsg, loError, lcErr
   lcErr = ""
   lcSchema = "http://schemas.microsoft.com/cdo/configuration/;
   loConfig = Createobject("CDO.Configuration")

   With loConfig.Fields
  .Item(lcSchema + "smtpserver")  = ALLTRIM(winkiss.opt15)
  .Item(lcSchema + "smtpserverport") = winkiss.portnum
  .Item(lcSchema + "sendusing")= 2
  .Item(lcSchema + "smtpauthenticate")  = .t.
  .Item(lcSchema + "smtpusessl")  = winkiss.usessl
  .Item(lcSchema + "sendusername")  = ALLTRIM(winkiss.usersig)
  .Item(lcSchema + "sendpassword")  = ALLTRIM(winkiss.empw)
  .Update
   Endwith
   loMsg = Createobject ("CDO.Message")

   With loMsg
  .Configuration = loConfig
  .From= ALLTRIM(winkiss.opt17)
  .To= ALLTRIM(winkiss.opt17)
  .Subject = "Test subject"
  .TextBody  = "Testing SMTP emailing, from myself to myself"
  .Send()
   Endwith

etc

Does anyone have suggestions

-- 
Kind regards,
Sytze de Boer


--- 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/cag1nny8xvsx1ibxzpgi8pgeb7uthgyh862ha2uajgyflndo...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Outlook and VFP

2016-03-20 Thread Sytze de Boer

When I look at this client's Sent folder in Outlook, I can see (about) 20
emails were sent WITH attachments, followed by (approx) 10 that DIDN'T.

On Mon, Mar 21, 2016 at 11:57 AM, Tracy Pearson <tr...@powerchurch.com>
wrote:

> Is it some but not all on this specific client? I have had a customer send
> a group of emails with PDF attachments, none made it to the destination. I
> found the antivirus program logged it being removed from outgoing email. It
> was simple a report saved as a PDF, though an out of date PDF format.
>
> On March 20, 2016 6:40:21 PM EDT, Sytze de Boer <sytze.k...@gmail.com>
> wrote:
> >Hi Tracey
> >(I always check your posts immediately)
> >
> >.but would it do so randomly?
> >
> >
> >On Mon, Mar 21, 2016 at 11:39 AM, Tracy Pearson <tr...@powerchurch.com>
> >wrote:
> >
> >> Some anti virus program could be removing the attachment.
> >>
> >> On March 20, 2016 6:02:53 PM EDT, Sytze de Boer
> ><sytze.k...@gmail.com>
> >> wrote:
> >> >In my accounting system, clients can email their clients an invoice
> >or
> >> >copy
> >> >of an invoice.
> >> >It places the message and pdf into Outlook.
> >> >Outlook then takes care of it, and you can all such emails in the
> >Sent
> >> >folder
> >> >This has worked for years!
> >> >
> >> >I now have a client who has shown me her Sent folder and I can see
> >> >dozens
> >> >of entries where it has sent the email, but no attachment.
> >> >
> >> >Can anyone suggest how this can happen?
> >> >
> >> >My accounting system also has a "sent" emails dbf and it shows these
> >> >emails
> >> >were placed in to Outlook and the fact there was an attachment (or
> >not)
> >>
> >> --
> >> Sent from my Android device with K-9 Mail. Please excuse my brevity.
> >>
>
> --
> Sent from my Android device with K-9 Mail. Please excuse my brevity.
>
[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/CAG1nNy8svZHTFBNYiNYeCPwpk2ki9x9jdWSCw=ad2is1qvq...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Outlook and VFP

2016-03-20 Thread Sytze de Boer

Hi Tracey
(I always check your posts immediately)

.but would it do so randomly?

On Mon, Mar 21, 2016 at 11:39 AM, Tracy Pearson <tr...@powerchurch.com>
wrote:

> Some anti virus program could be removing the attachment.
>
> On March 20, 2016 6:02:53 PM EDT, Sytze de Boer <sytze.k...@gmail.com>
> wrote:
> >In my accounting system, clients can email their clients an invoice or
> >copy
> >of an invoice.
> >It places the message and pdf into Outlook.
> >Outlook then takes care of it, and you can all such emails in the Sent
> >folder
> >This has worked for years!
> >
> >I now have a client who has shown me her Sent folder and I can see
> >dozens
> >of entries where it has sent the email, but no attachment.
> >
> >Can anyone suggest how this can happen?
> >
> >My accounting system also has a "sent" emails dbf and it shows these
> >emails
> >were placed in to Outlook and the fact there was an attachment (or not)
>
> --
> Sent from my Android device with K-9 Mail. Please excuse my brevity.
>
[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/CAG1nNy_TpoCg+EtM9hB-fJX9vMXt2-XVQZ6mPBCG7c1=y4+...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Outlook and VFP

2016-03-20 Thread Sytze de Boer

In my accounting system, clients can email their clients an invoice or copy
of an invoice.
It places the message and pdf into Outlook.
Outlook then takes care of it, and you can all such emails in the Sent
folder
This has worked for years!

I now have a client who has shown me her Sent folder and I can see dozens
of entries where it has sent the email, but no attachment.

Can anyone suggest how this can happen?

My accounting system also has a "sent" emails dbf and it shows these emails
were placed in to Outlook and the fact there was an attachment (or not)

-- 
Kind regards,
Sytze de Boer


--- 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/CAG1nNy-her7jVzwyRKas3ySMjTDtNHthA3K_Lefrv++=dgx...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Fonts

2016-03-14 Thread Sytze de Boer

Stephen, I appreciate your suggestion.
>From my limited understanding of codepages, it seems though, I need to
specify a different codepage just for this report. Correct?

On Tue, Mar 15, 2016 at 9:39 AM, Stephen Russell <srussell...@gmail.com>
wrote:

> You probably need to change your codepage to the language it can work with.
>
> 1252 Latin 1
> 936 Chinese: Simplified chars--PRC and Singapore
>
>
> On Mon, Mar 14, 2016 at 2:52 PM, Sytze de Boer <sytze.k...@gmail.com>
> wrote:
>
> > A client has asked that I Change the memo details on their invoice to
> > SIMSUN font
> >
> > I logged in via Teamviewer and noted this font is available when in Word
> > But, when I look for it whilst modifying the report, it does not show.
> >
> > Any ideas anyone?
> >
> > --
> > 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/CAG1nNy8rPJi-OGxWs1jStB_0zVrUkXc-eMSXXNQVEmeDS6+M=w...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Fonts

2016-03-14 Thread Sytze de Boer

Yes, I'm modifying it on their system
Since the font is available when in Word, I assume it has been installed.

On Tue, Mar 15, 2016 at 9:20 AM, Michael Oke, II <oke...@gmail.com> wrote:

> Are you modifying it on your system?  Are you sure that you have it
> installed?
>
>
>
> -
> Michael Oke, II
> oke...@gmail.com
> 661-349-6221
> -
>
> On Mon, Mar 14, 2016 at 12:52 PM, Sytze de Boer <sytze.k...@gmail.com>
> wrote:
>
> > A client has asked that I Change the memo details on their invoice to
> > SIMSUN font
> >
> > I logged in via Teamviewer and noted this font is available when in Word
> > But, when I look for it whilst modifying the report, it does not show.
> >
> > Any ideas anyone?
> >
> > --
> > 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/cag1nny-gjww6a6v-ag6ynsraubn21ckoe-rwfy+tf_+pt22...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Fonts

2016-03-14 Thread Sytze de Boer

A client has asked that I Change the memo details on their invoice to
SIMSUN font

I logged in via Teamviewer and noted this font is available when in Word
But, when I look for it whilst modifying the report, it does not show.

Any ideas anyone?

-- 
Kind regards,
Sytze de Boer


--- 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/CAG1nNy9=vMXbwJCASME6o6yUww_dmMf8z0a=d79g375yh4w...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: 64 bit VFP compiler?

2016-03-02 Thread Sytze de Boer

This is all very interesting, but what advantage is there in running 64-bit
VFP?

On Thu, Mar 3, 2016 at 2:47 AM, Thierry Nivelet 
wrote:

> To me, that's theory of a passed age -- and of course, YMMV
>
> Thierry N.
>
> Le 02/03/2016 14:32, Wollenhaupt, Christof a écrit :
>
>> Any lawyer will probably say it infringes EULA or whatever -- it just does
>>> not matter.
>>>
>>> I disagree... What I personally do and what legal risks I'm willing to
>> take
>> is one thing.
>>
>> But it's a different matter altogether if I sell this solution to
>> customers, most of which are substantially larger businesses than my own.
>> These customers have volume licenses and get audited by Microsoft, Oracle,
>> etc. Moreover, many countries distinguish between using and distributing.
>> Should using this software be a violation of intellectual property (which
>> is open at this point), then selling solutions might trigger more serious
>> legal consequences.
>>
>> It's not a matter of whether it's good to have VFP support for 64-bit
>> (which is great), or whether Microsoft has any interest in VFP (they
>> don't). It's a business decision on how much risk you are willing to take
>> on something that is at least a gray area. Sometimes such decisions turn
>> out to be wrong and expensive, as Volkswagen is currently learning.
>>
>>
>
[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/cag1nny8cy4ndzj2m2pckyjwbryeopec0myyedl3oovozx-o...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Import/Export with CSV

2016-02-28 Thread Sytze de Boer

The Supplier code could be letters and number, just letters, or just
numbers.

The supplier code may be 12345.1234567890
It's nothing to do with decimal point. It's a character.
If the code is ABC12345.1234567890 all is fine.

The import routine is append from file IMPFILE type csv

On Mon, Feb 29, 2016 at 1:15 PM, Joe Yoder <j...@wheypower.com> wrote:

> I only dabble with Excel but I suspect that you can get your expected
> results by setting it up to use five decimal places instead of two.  I
> thought you could convert it in Foxpro with str(val( '12345.56'), 10, 5)
> but for some reason that only gives 4 decimal places even with decimals set
> to 6.  I guess that leaves string manipulation where you find the location
> of the dot from the right edge of the trimed string with the RAT function
> and add as many zero as you need.
>
> I'm curious why the extra zeros are important.
>
> Joe
>
> On Sun, Feb 28, 2016 at 6:36 PM, Sytze de Boer <sytze.k...@gmail.com>
> wrote:
>
> > I have a problem and I hope someone can help
> >
> > I export 3 fields to a CSV file
> > Code C(15), price N(10,2) , supcode C(30)
> >
> > The code and the supcode may be pure numbers
> > Example supcode may be 12345.56000
> >
> > I make some changes to the price (using Excel)
> > I now import from this same file and the supcode has changed to 12345.56
> >
> > Whats the best way to overcome this?
> >
> > --
> > 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/CAG1nNy_zuh2APuM1Gwr8LTfVtbY=_=k-uzo6+44s8mudcaf...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Import/Export with CSV

2016-02-28 Thread Sytze de Boer

I have a problem and I hope someone can help

I export 3 fields to a CSV file
Code C(15), price N(10,2) , supcode C(30)

The code and the supcode may be pure numbers
Example supcode may be 12345.56000

I make some changes to the price (using Excel)
I now import from this same file and the supcode has changed to 12345.56

Whats the best way to overcome this?

-- 
Kind regards,
Sytze de Boer


--- 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/CAG1nNy-d=2tws3vpc-u76oan0mk_kfkocoxtvfpcvv9+awl...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Alias()

2016-01-27 Thread Sytze de Boer

Thanks for having a look Gene, but I don't think you've seen my code
correctly.

Clcode is a field in the Windebs table
It is the "currently" selected table (or table which is the controlsource
of the grid)
The error fires on the line that says "lcclient=clcode"





On Thu, Jan 28, 2016 at 11:57 AM, Gene Wirchenko <ge...@telus.net> wrote:

> At 12:22 2016-01-27, Sytze de Boer <sytze.k...@gmail.com> wrote:
>
>> FRIENDS !!
>> Thank you all for your comments. I appreciate it.
>>
>> I decided to post/ask my query because in the past 3 months I've also had
>> some major issues.
>> I cannot identify the cause and I'll briefly describe it here.
>>
>> I have a form with a grid. The controlsource is a free standing table.
>> (Clients table called Windebs)
>> The form has a command group with several buttons.
>> Example, "Show Transactions"
>> The click event has code such as
>> lcclient=clcode
>> select * from winhst where client=lcclient into curs temp
>>
>> I end up with an error "variable clcode not found"
>>
>
>  How do you manage that with no "clcode" in your code?
>
> It is as though the underlying table is no longer Windebs, which is nuts
>> because I did not "select" another table anywhere.
>>
>
>  In the example above, you did a select, and the current alias will be
> that of the cursor.  The cursor will have the structure of winhst, not
> windebs.
>
>  Did you open a table and forget to select 0 before doing so?  I made
> that mistake just this morning, and my code threw an error when I tried to
> close the table that got opened over.
>
> Now, I've seen similar behavior when Anti virus software is locking the
>> tables, or extremely slow network connections, but it just started
>> happening about 3 months ago, and only with "some" customers.
>> At one time I thought it was only on XP pc's but that theory is also
>> disproved.
>>
>> At this stage I'm slowly trawling through my code and changing Click
>> events
>> to
>>
>> sele windebs
>> lcclient=clcode
>> select * from winhst where client=lcclient in to curs temp
>>
>
>  Due to the chaoticness of methods being fired, it can be somewhat
> unclear what code has just executed.  I prefer to be careful and explicitly
> specify tables.  I do not trust that the alias has stayed the same over
> method firing if I have any alias changing.
>
> [snip]
>
>
> Sincerely,
>
> Gene Wirchenko
>
>
[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/CAG1nNy_8K7M3BNksT3zgD7JVJwALDs20ZdC=mOjq=v2bovj...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Alias()

2016-01-27 Thread Sytze de Boer

FRIENDS !!
Thank you all for your comments. I appreciate it.

I decided to post/ask my query because in the past 3 months I've also had
some major issues.
I cannot identify the cause and I'll briefly describe it here.

I have a form with a grid. The controlsource is a free standing table.
(Clients table called Windebs)
The form has a command group with several buttons.
Example, "Show Transactions"
The click event has code such as
lcclient=clcode
select * from winhst where client=lcclient into curs temp

I end up with an error "variable clcode not found"

It is as though the underlying table is no longer Windebs, which is nuts
because I did not "select" another table anywhere.
Now, I've seen similar behavior when Anti virus software is locking the
tables, or extremely slow network connections, but it just started
happening about 3 months ago, and only with "some" customers.
At one time I thought it was only on XP pc's but that theory is also
disproved.

At this stage I'm slowly trawling through my code and changing Click events
to

sele windebs
lcclient=clcode
select * from winhst where client=lcclient in to curs temp

On Thu, Jan 28, 2016 at 7:22 AM, Gene Wirchenko  wrote:

> At 08:54 2016-01-27, Alan Bourke  wrote:
> Someone (attributio lost) wrote:
>
>> > I still use Hungarian notation too, despite Microsoft telling us years
>> > ago that it's no longer acceptable style.  Then again, we Foxers have
>> > always been rebels.  lol
>>
>> For strongly-typed languages in modern development tools why would you
>> use it?
>>
>
>  Because it is much shorter.  Suppose I have an array of client data.
> I might use:
>   sClient   size of clients array
>   cClient   how many clients
>   xClient   index into array
>
> Makes sense for VFP probably.
>>
>
>  I have never used it much in VFP.  I do not have the name collision I
> do in other languages.
>
> Sincerely,
>
> Gene Wirchenko
>
>
[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/cag1nny_x+mlkhq024m+6oqm6dplb6q146+qcuqjsd+kc3qw...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Alias()

2016-01-26 Thread Sytze de Boer

I do the following in one of my modules

sele 909
use (ltable) alias Junk1 Excl

If I issue wait window alias(), it returns Junk1

If I
use (ltable) alias "Junk1" Excl, it returns Junk1 as well

Is this normal?

I ask because I have a client who consistently ends up with an error
variable code not found
when I know for sure the table has a field called Code, and I am trying to
confirm the underlying table is indeed Junk1

-- 
Kind regards,
Sytze de Boer


--- 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/cag1nny84mpnuzgrkzfi99bsj6x97v+fnpsjr6fgcg1kyhmp...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

CSV issues

2015-12-23 Thread Sytze de Boer

In my system, clients can upload/update their inventory by importing from a
CSV file.

Suddenly, a client has reported a problem and I have noticed the following.

1  When he imports from a CSV file, all references to "inch" which is noted
as " in the column, automatically becomes '"'
2  If I import the file as a TXT file instead, it leaves out the "
altogether

I guess there's a workaround but is there something else I should check

-- 
Kind regards,
Sytze de Boer


--- 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/cag1nny-zqvv4sdrk36ep0z5i-oxg41wkr99cyfnk0sdknpp...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: CSV issues

2015-12-23 Thread Sytze de Boer

I think it depends on the version of Excel, and MS getting clever again.

On Thu, Dec 24, 2015 at 8:50 AM, M Jarvis <brewda...@gmail.com> wrote:

> On Wed, Dec 23, 2015 at 11:35 AM, Sytze de Boer <sytze.k...@gmail.com>
> wrote:
>
> > In my system, clients can upload/update their inventory by importing
> from a
> > CSV file.
> >
> > Suddenly, a client has reported a problem and I have noticed the
> following.
> >
> > 1  When he imports from a CSV file, all references to "inch" which is
> noted
> > as " in the column, automatically becomes '"'
> > 2  If I import the file as a TXT file instead, it leaves out the "
> > altogether
> >
> > I guess there's a workaround but is there something else I should check
> >
> > --
> > Kind regards,
> > Sytze de Boer
> >
> >
> Does this happen on ALL computers at the client site? If not, then maybe
> check out settings such as UNICODE (or whatever) and see what's been
> changed
>
> --
> Matt Jarvis
> Eugene, Oregon USA
>
>
> --- 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/cag1nny9er83hghl6b5nbv6ur7zm4sxfoman0k8+r_f3obt4...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Visual Foxpro and Windows 10 problems

2015-11-30 Thread Sytze de Boer

I don't think these are symptoms of a Windows 10 problem.
Yes, I have a client who suffered from this with Norton

On Tue, Dec 1, 2015 at 8:17 AM, Philip Borkholder 
wrote:

> Hello all,
>
> Has anyone experienced any of these problems with Visual Foxpro and
> Windows 10?
> 1) Windows Updates renaming the VFP9.EXE ?
> 2) DBFs and EXE files being removed by Antivirus SOftware and/or
> Anti-Malware protection programs?
>
> One of my colleagues has said they are experiencing this.
> She did not say what version of VFP nor what AV software.
>
> Thank you
> Philip Borkholder
> 
> The 7 Most Amazing Credit Cards If You Have Excellent ...
> http://thirdpartyoffers.netzero.net/TGL3241/565ca0bddc28220bd3e8ast01duc
>
[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/cag1nny8w+afw9vzvhmb4y09cg63lffvhm6jmqwxbiwunmkw...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Sending SMTP emails from VFP using PowerShell.

2015-11-21 Thread Sytze de Boer

Hi Koen

I have tried sending emails with the psdemo.prg and still no luck
But, using this prg, I didn't get any errors. Just no emails were sent.




On Sun, Nov 22, 2015 at 12:05 AM, Koen Piller <koen.pil...@gmail.com> wrote:

> Hi Sytze,
> I have read multiple answers / contributions to your problem, however
> failed to see which one is now the final answer. In other words, have you
> now solved it and if so which was the advise to show you the correct
> result?
> Regards,
> Koen
>
> 2015-11-14 21:12 GMT+01:00 Sytze de Boer <sytze.k...@gmail.com>:
>
> > I must have missed something else altogether.
> > When I try this, I get a message Class definition CLSRECIPIENTCOLLECTION
> is
> > not found
> >
> > When I try to go to
> > https://technet.microsoft.com/en-us/library/hh849925(v=wps.630.aspx
> > the page cannot be found
> >
> > I copied the code from into a prg and called it Test.prg
> > I changed the
> > *loPsServer.cServer = "smtp.mandrillapp.com"
> > *loPsServer.cUser = "mymandrillusername"
> > *loPsServer.cPass = "mymandrillpassword"
> > to my own
> > Addressed a test email to myself with DO TEST, and I get above error
> >
> > What am I doing wrong?
> >
> >
> >
> >
> > On Sun, Nov 15, 2015 at 2:32 AM, Laurie Alvey <trukke...@gmail.com>
> wrote:
> >
> > > I can't get this to work with smtp.mail.yahoo.com. I tried a test
> > message
> > > to myself (trukke...@gmail.com). I get a blue circle for a bit and
> then
> > a
> > > status bar message "File has been deleted." No mail is received. I've
> > > fiddled with ports, SSL and credentials but no success. The current
> way I
> > > send mail from VFP is with CDO which works.
> > >
> > > Laurie
> > >
> > > On 12 November 2015 at 23:06, Ted Roche <tedro...@gmail.com> wrote:
> > >
> > > > "Embrace, Enhance, Extend, Extinguish"
> > > >
> > > >
> > > >
> > > > On Thu, Nov 12, 2015 at 3:41 PM, M Jarvis <brewda...@gmail.com>
> wrote:
> > > > > On Thu, Nov 12, 2015 at 8:01 AM, Ted Roche <tedro...@gmail.com>
> > wrote:
> > > > >
> > > > >> Alan:
> > > > >>
> > > > >> That's great! I've been banging the drum for "SMTP Good, MAPI Bad"
> > for
> > > > >> a long, long time, but not having good/simple tools for handling
> > > > >> SSL.TLS was a big hangup. Now that MS is _finally_ gaining a
> decent
> > > > >> shell with PowerShell, this is a cool tool to add to the arsenal.
> > > > >>
> > > > >>
> > > > > Isn't SMTP a generic standard?
> > > > >
> > > > > We've all seen what M$ does when it starts playing around with
> > generic
> > > > > standards
> > > > >
> > > > > --
> > > > > Matt Jarvis
> > > > > Eugene, Oregon USA
> > > > >
> > > > >
> > > > > --- 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/CAG1nNy_ES+m7QZFqoX79-XogB9NPfjD4L_qr1VRHkA=suee...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Task pane

2015-11-19 Thread Sytze de Boer

I upgraded my pc yesterday.
I installed VFP9, with all the service packs and hot fixes, etc

Totally happy
Except, when I go into VFP, I get this Task Pane Manager popping up and I
can't seem to stop this from popping up.
It has a message about Class defenition MSXML2.domdocument 4.0 is not found

Can someone guide me ?

By the way, system is a Lenovo, I7, 8 Gb Ram and 2 x 250 SSD, and Windows 10
I am in love.

-- 
Kind regards,
Sytze de Boer


--- 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/CAG1nNy-AjWtAdd_AU=srjt_jgcgararrjkd2tnvgdp1t1jp...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Task pane

2015-11-19 Thread Sytze de Boer

Ted thank you
So I did as instructed and installed msxml thingee

Now the TP Manager pops up and greets me with Welcome to Visual Foxpro 9!
I don't want it at all.

On Fri, Nov 20, 2015 at 10:11 AM, Ted Roche <tedro...@gmail.com> wrote:

> On Thu, Nov 19, 2015 at 4:06 PM, Sytze de Boer <sytze.k...@gmail.com>
> wrote:
> > I upgraded my pc yesterday.
> > I installed VFP9, with all the service packs and hot fixes, etc
> >
> > Totally happy
> > Except, when I go into VFP, I get this Task Pane Manager popping up and I
> > can't seem to stop this from popping up.
> > It has a message about Class defenition MSXML2.domdocument 4.0 is not
> found
> >
> > Can someone guide me ?
>
> Craig Bernsten can:
>
>
> https://social.msdn.microsoft.com/Forums/en-US/2eaf774b-40ac-44dd-8d60-8c7427fafc17/vfp-9-and-windows-7
>
> > By the way, system is a Lenovo, I7, 8 Gb Ram and 2 x 250 SSD, and
> Windows 10
> > I am in love.
>
> I wish you two a long, happy and prosperous life!
>
> --
> 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/cag1nny-pujpnosm02zpza+bms-4vxc9rs1dfe2vwhesc429...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Sending SMTP emails from VFP using PowerShell.

2015-11-14 Thread Sytze de Boer

I must have missed something else altogether.
When I try this, I get a message Class definition CLSRECIPIENTCOLLECTION is
not found

When I try to go to
https://technet.microsoft.com/en-us/library/hh849925(v=wps.630.aspx
the page cannot be found

I copied the code from into a prg and called it Test.prg
I changed the
*loPsServer.cServer = "smtp.mandrillapp.com"
*loPsServer.cUser = "mymandrillusername"
*loPsServer.cPass = "mymandrillpassword"
to my own
Addressed a test email to myself with DO TEST, and I get above error

What am I doing wrong?

On Sun, Nov 15, 2015 at 2:32 AM, Laurie Alvey  wrote:

> I can't get this to work with smtp.mail.yahoo.com. I tried a test message
> to myself (trukke...@gmail.com). I get a blue circle for a bit and then a
> status bar message "File has been deleted." No mail is received. I've
> fiddled with ports, SSL and credentials but no success. The current way I
> send mail from VFP is with CDO which works.
>
> Laurie
>
> On 12 November 2015 at 23:06, Ted Roche  wrote:
>
> > "Embrace, Enhance, Extend, Extinguish"
> >
> >
> >
> > On Thu, Nov 12, 2015 at 3:41 PM, M Jarvis  wrote:
> > > On Thu, Nov 12, 2015 at 8:01 AM, Ted Roche  wrote:
> > >
> > >> Alan:
> > >>
> > >> That's great! I've been banging the drum for "SMTP Good, MAPI Bad" for
> > >> a long, long time, but not having good/simple tools for handling
> > >> SSL.TLS was a big hangup. Now that MS is _finally_ gaining a decent
> > >> shell with PowerShell, this is a cool tool to add to the arsenal.
> > >>
> > >>
> > > Isn't SMTP a generic standard?
> > >
> > > We've all seen what M$ does when it starts playing around with generic
> > > standards
> > >
> > > --
> > > Matt Jarvis
> > > Eugene, Oregon USA
> > >
> > >
> > > --- 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/cag1nny-innrx-kkvzgvuhsynrekeudtqqbsphxbuomypopo...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [OT] joke

2015-11-05 Thread Sytze de Boer

It reminds me of the warning to never fart with a straight back.
They travel straight up to the brain so that's where all those shitty ideas
come from.

On Fri, Nov 6, 2015 at 8:46 AM, Stephen Russell 
wrote:

> The family wheeled Grandma out on the lawn, in her wheelchair, where the
> activities for her 100th birthday were taking place.
> Grandma couldn't speak very well, but she would write notes when she
> needed to communicate.
>
> After a short time out on the lawn, Grandma started leaning off to the
> right, so some family members grabbed her, straightened her up and stuffed
> pillows on her right side.
>
> A short time later, she started leaning off to her left, so again the
> family grabbed her and stuffed pillows on her left side. Soon she started
> leaning forward, so the family members again grabbed her, and then tied a
> pillowcase around her waist to hold her up.
>
> A nephew who arrived late came up to Grandma and said 'Hi, Grandma,
> you're looking good! How are they treating you.'?
>
> Grandma took out her little notepad and slowly wrote a note to the
> nephew.
>
> "They won't let me fart."
>
> --
> Stephen Russell
> Sr. Analyst
> Ring Container Technology
> Oakland TN
>
> 901.246-0159 cell
>
>
> --- StripMime Report -- processed MIME parts ---
> multipart/alternative
>   text/plain (text body -- kept)
>   text/html
> ---
>
[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/cag1nny8onvnezay9gvmltdtmagnbs9waarokdp+jpavffhj...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Using Outlook

2015-10-31 Thread Sytze de Boer

Well, I tried to find a way and stop Word from opening but it seems this
not possible

http://answers.microsoft.com/en-us/office/forum/office_2010-outlook/can-i-turn-off-word-as-the-email-editor-in-outlook/d25fb752-4ff4-4aa0-9d6f-b07c3efc09d2?auth=1

On Sat, Oct 31, 2015 at 2:17 AM, Ted Roche  wrote:

> That's likely it. There was a time when Word was the default rich text
> editor for Outlook, and that spawns a copy of Word in the background.
> Have the client disable this option, and it's likely the problem will
> go away.
>
>
> On Fri, Oct 30, 2015 at 5:15 AM, Alan Bourke 
> wrote:
> >
> >> Now that we (think) have found the issue, I can kill Winword after each
> >> email, but is that the best/only solution ?
> >
> > Is this using MAPI to automate the Outlook client? I have to say I've
> > never, ever seen Outlook automation open an instance of MS Word. Is Word
> > set to be the email editor in Outlook?
> >
> > --
> >   Alan Bourke
> >   alanpbourke (at) fastmail (dot) fm
> >
> >
[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/cag1nny_7+kxuzjscj4nx1tjczff2dan4y1688wsep_nnwyr...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Using Outlook

2015-10-29 Thread Sytze de Boer

Thanks Tracey (as always)

Here's a snippet of my code

loUsed=0
lbOpenOutlook  = .F.
On Error lbOpenOutlook =.T.
oOutLook = Getobject(,"Outlook.Application")  & outlook is not open this
will cause an error and thus set lbOpenOutlook to true
On Error
If lbOpenOutlook  && if true Outlook needs to be opened
   oOutLook=Createobject("Outlook.Application")
Endif
Do trmurphy

lcSigContent=''
Do wkoutlook3 & for a signature

#Define olMailItem 0
xouts=.t.
ON ERROR xouts=.f.
oMailItem = oOutLook.CreateItem( olMailItem )

On Fri, Oct 30, 2015 at 2:57 PM, Tracy Pearson <tr...@powerchurch.com>
wrote:

> Look into using getobject().
> https://msdn.microsoft.com/en-us/subscriptions/downloads/zbw8a3a6(v=vs.80).aspx
>
>
>
> On October 29, 2015 9:23:42 PM EDT, Sytze de Boer <sytze.k...@gmail.com>
> wrote:
> >My clients have the choice of sending emails via Gmail or Outlook
> >I have found Gmail to work better in some instances, Outlook in
> >another.
> >
> >With 1 client, where Outlook is the better option, it has been a pain
> >for
> >almost a year now.
> >What happens is that after (say) 200 emails, the system crashes and the
> >only way out is a Restart of the pc.
> >
> >Today we found the cause of the problem (we think)
> >Every time my system creates an email and "sends" it to Outlook, it
> >opens
> >an instance of Winword.exe and does not release it.
> >So, we can end up with dozens and dozens x Winword.exe visible in the
> >task
> >Processes.
> >
> >Now that we (think) have found the issue, I can kill Winword after each
> >email, but is that the best/only solution ?
>
> --
> Sent from my Android device with K-9 Mail. Please excuse my brevity.
>
[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/CAG1nNy87aQT=p=VeY5LLBZYNOw3U6iEHNo9QVK=jrkjqoxn...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Using Outlook

2015-10-29 Thread Sytze de Boer

My clients have the choice of sending emails via Gmail or Outlook
I have found Gmail to work better in some instances, Outlook in another.

With 1 client, where Outlook is the better option, it has been a pain for
almost a year now.
What happens is that after (say) 200 emails, the system crashes and the
only way out is a Restart of the pc.

Today we found the cause of the problem (we think)
Every time my system creates an email and "sends" it to Outlook, it opens
an instance of Winword.exe and does not release it.
So, we can end up with dozens and dozens x Winword.exe visible in the task
Processes.

Now that we (think) have found the issue, I can kill Winword after each
email, but is that the best/only solution ?


-- 
Kind regards,
Sytze de Boer


--- 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/cag1nny9s928xnfcfcwhkxmjy-mejdj42g-qrvswtcbvwtq2...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [OT] Rugby World Cup

2015-10-20 Thread Sytze de Boer

No comments please. I'm a Kiwi

On Wed, Oct 21, 2015 at 12:04 PM, Ricardo Araoz  wrote:

> Should I make any comments on the subject?
>
> :P
>
>
[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/CAG1nNy_BP0aL8_eOWqPkxpVF2WwcRdGm3mNR8aS=dkdzdqg...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: MsOutlook Signature

2015-10-14 Thread Sytze de Boer

Correct, HTML

On Wed, Oct 14, 2015 at 11:45 AM, Mike Copeland <m...@ggisoft.com> wrote:

> Have to ask...you are using HTML for the body source?
>
> Mike Copeland
>
> Sytze de Boer wrote:
>
>> With a number of my clients I configure my accounting software to send
>> invoices via Outlook
>> This is working fine, except, the Outlook signature is not including the
>> picture as part of the signature.
>> Can anyone throw some light on this?
>>
>>
>
[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/CAG1nNy9KdnW+Vo_vCNbGBzN3KTjBVjmsvO8=x2snszs9_ue...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

MsOutlook Signature

2015-10-13 Thread Sytze de Boer

With a number of my clients I configure my accounting software to send
invoices via Outlook
This is working fine, except, the Outlook signature is not including the
picture as part of the signature.
Can anyone throw some light on this?

-- 
Kind regards,
Sytze de Boer


--- 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/CAG1nNy_zL6K3ZsDRhr200dSghwQN7A0g+9hk1DvS9RoZN4uP=a...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Report*.app

2015-08-10 Thread Sytze de Boer

Hi folk

Please can someone throw some light on a subject that I'm sure some of you
are shocked I should ask.

When I distribute my app, I use use Inno to create a distributable file
In the folder are 3 files that I placed there many moons ago.
Reportbuilder.app, reportoutput.app and reportpreviwer.app
The modified date on these files is 3 to 4 years ago

I use either Foxypreviewer or Xfrx to generate my reports.
What relevance are the above 3 files?
I ask because I picked up a Zip file from somewhere where the files are
more recent.


My 2nd question is this.
Sometimes a client asks me to modify 1 or more reports.
So I log in via Teamviewer and modify the report as requested.
When I do so I can't choose to what printer it should print.

Example, I want to print a specific report always to a Dymo printer instead
of the default printer.
The printer option does not appear like it does in my development
environment.
Is this because of the 3 files above?


-- 
Kind regards,
Sytze de Boer


--- 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/CAG1nNy_tiyWJs8Mz-=pu_ivtajnnrbcby2qfx2lsqtx7s8g...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Grid - Header height

2015-07-22 Thread Sytze de Boer

Hi Tracy

No, the background is a simple dbf recordsource
The headers are colored, so themes=.f.



On Thu, Jul 23, 2015 at 8:10 AM, Tracy Pearson tr...@powerchurch.com
wrote:

 Sytze de Boer wrote on 2015-07-22:
   It is set to 40 already, but it ignores it.
 
   On Wed, Jul 22, 2015 at 9:13 PM, Laurie Alvey trukke...@gmail.com
 wrote:
 
  Sounds like it's gone back to the default of 19. Just change the
  Headerheight to what you want.
 
  Laurie
 

 Sytze,

 Are the captions changing as well?
 It reminds me of behavior that happens when the cursor/table behind the
 grid
 is being recreated on the fly.

 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/cag1nny-dykyrpng7emwunz5qazezrmkkzrcyqtye8trobfe...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Grid - Header height

2015-07-22 Thread Sytze de Boer

It is set to 40 already, but it ignores it.


On Wed, Jul 22, 2015 at 9:13 PM, Laurie Alvey trukke...@gmail.com wrote:

 Sounds like it's gone back to the default of 19. Just change the
 Headerheight to what you want.

 Laurie

 On 22 July 2015 at 02:38, Sytze de Boer sytze.k...@gmail.com wrote:

  I have 2 grids on a form and the grid header height for both grids are
 set
  to 40
  This was fine but after some other adjustments, I must have done
 something,
  it is about 20 height
 
  Can anyone suggest why this is so?
 
  --
  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/CAG1nNy_1eZZxeX2M3MXCJdY=8Mb0=1+04mefo8p35hmrg4u...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Grid - Header height

2015-07-21 Thread Sytze de Boer

I have 2 grids on a form and the grid header height for both grids are set
to 40
This was fine but after some other adjustments, I must have done something,
it is about 20 height

Can anyone suggest why this is so?

-- 
Kind regards,
Sytze de Boer


--- 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/cag1nny8rp7rhx-j6pi0t7u4uhdk2mdxuutbaddtg8mogvw0...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Email to Exchange

2015-07-07 Thread Sytze de Boer

Friends

In my system, I push invoice or monthly statements (PDF) into client
Outlook systems by:

oMailItem = oOutLook.CreateItem( olMailItem )
and oMailItem.Send()

One particular client wants the emails to go out via his exchange server.
Can anyone assist with this difference?

I know someone who said to me 'Oh that's easy, just do it via smtp or an ip
address
It may as simple as that but I have no idea how to do this

Can anyone help me out?

-- 
Kind regards,
Sytze de Boer


--- 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/CAG1nNy_GkfTCH3jtPNOmTnYk+akDmpHXtHymcbwqdpEm=yv...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: VFP on a tablet

2015-07-01 Thread Sytze de Boer

It sure does. And sweetly too.



On Thu, Jul 2, 2015 at 7:59 AM, Bryant bry...@medfordsh.com wrote:

 Can someone tell me if VFP runtime can run on a Windows 8 tablet

 Bryant Minard
 Medford Software House

 Sent from my iPad

[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/cag1nny-wwc96d6hxx_f8u86boswm8ttpwxgjwzsn_huzx_r...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Select data

2015-06-30 Thread Sytze de Boer

Tracy, you are spot on of course. Its the missing comma.
Many thanks (AGAIN)



On Tue, Jun 30, 2015 at 5:23 PM, Tracy Pearson tr...@powerchurch.com
wrote:



 On June 30, 2015 12:58:51 AM EDT, Sytze de Boer sytze.k...@gmail.com
 wrote:
 Hi Tracy
 
 The error comes up with Command contains unrecognised phrase/keyword
 .and yes..enginebehavior 70
 
 
 On Tue, Jun 30, 2015 at 4:50 PM, Tracy Pearson tr...@powerchurch.com
 wrote:
 
 
 
  On June 30, 2015 12:18:27 AM EDT, Sytze de Boer
 sytze.k...@gmail.com
  wrote:
  This has worked fine for many years
  
  mcols=XD+ALLTRIM(STR(trcask13))
  SELECT date,pcode,cycle,SUM(gross) as gross, SUM(tax) as tax,
  SUM(ROUND((gross+nontgross)*(mcols/100),2)) as super, mcols as
  mpercent
  FROM palldets ;
  WHERE BETWEEN(cycle,trcask2,trcask3) ORDER BY pcode group BY pcode
 INTO
  TABLE temp
  
  Why does this give me grief
  mcols=XD+ALLTRIM(STR(trcask13))
  mmvu =XD+ALLTRIM(STR(trcask14))
  SELECT date,pcode,cycle,SUM(gross) as gross, SUM(tax) as tax,;
  SUM(ROUND((gross+nontgross)*(mcols/100),2)) as super, mcols as
  mpercent ;
  SUM(ROUND((gross+nontgross)*(mmvu/100),2))  as volsup,mmvu  as
 volp
  FROM
  palldets ;
  WHERE BETWEEN(cycle,trcask2,trcask3) ORDER BY pcode group BY pcode
 INTO
  TABLE temp
  
  in this instance, mcols is XD11 and mmvu is XD39
  Both XD11 and XD39 are fields in a table.
  
  As you can see, I'm simply adding 2 more columns to the temp table
 
  Styze,
 
  I would first say the group by isn't valid. However, you don't have
 date
  or cycle in the grouping. This suggests you are not in VFP 9, or you
 have
  set the engine behavior to be an older version.
 
  You showed us code, you didn't share with us the failure symptoms.
 
  Tracy
 

 Styze,

 It could be the missing comma between mpercent and SUM, or the lack of a
 space between volsup, and mmvu.

 Tracy
 --
 Sent from my Android device with K-9 Mail. Please excuse my brevity.

[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/CAG1nNy-Ui0c=eio4sd2lan+f_tzhmt2d-4c8s+dfm4-vsjz...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Select data

2015-06-29 Thread Sytze de Boer

This has worked fine for many years

mcols=XD+ALLTRIM(STR(trcask13))
SELECT date,pcode,cycle,SUM(gross) as gross, SUM(tax) as tax,
SUM(ROUND((gross+nontgross)*(mcols/100),2)) as super, mcols as mpercent
FROM palldets ;
WHERE BETWEEN(cycle,trcask2,trcask3) ORDER BY pcode group BY pcode INTO
TABLE temp

Why does this give me grief
mcols=XD+ALLTRIM(STR(trcask13))
mmvu =XD+ALLTRIM(STR(trcask14))
SELECT date,pcode,cycle,SUM(gross) as gross, SUM(tax) as tax,;
SUM(ROUND((gross+nontgross)*(mcols/100),2)) as super, mcols as mpercent ;
SUM(ROUND((gross+nontgross)*(mmvu/100),2))  as volsup,mmvu  as volp FROM
palldets ;
WHERE BETWEEN(cycle,trcask2,trcask3) ORDER BY pcode group BY pcode INTO
TABLE temp

in this instance, mcols is XD11 and mmvu is XD39
Both XD11 and XD39 are fields in a table.

As you can see, I'm simply adding 2 more columns to the temp table

-- 
Kind regards,
Sytze de Boer


--- 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/CAG1nNy_RZD1T+j86i2Q5N1YswXs=_tbjhe3fkjtcycqkpga...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Select data

2015-06-29 Thread Sytze de Boer

Hi Tracy

The error comes up with Command contains unrecognised phrase/keyword
.and yes..enginebehavior 70


On Tue, Jun 30, 2015 at 4:50 PM, Tracy Pearson tr...@powerchurch.com
wrote:



 On June 30, 2015 12:18:27 AM EDT, Sytze de Boer sytze.k...@gmail.com
 wrote:
 This has worked fine for many years
 
 mcols=XD+ALLTRIM(STR(trcask13))
 SELECT date,pcode,cycle,SUM(gross) as gross, SUM(tax) as tax,
 SUM(ROUND((gross+nontgross)*(mcols/100),2)) as super, mcols as
 mpercent
 FROM palldets ;
 WHERE BETWEEN(cycle,trcask2,trcask3) ORDER BY pcode group BY pcode INTO
 TABLE temp
 
 Why does this give me grief
 mcols=XD+ALLTRIM(STR(trcask13))
 mmvu =XD+ALLTRIM(STR(trcask14))
 SELECT date,pcode,cycle,SUM(gross) as gross, SUM(tax) as tax,;
 SUM(ROUND((gross+nontgross)*(mcols/100),2)) as super, mcols as
 mpercent ;
 SUM(ROUND((gross+nontgross)*(mmvu/100),2))  as volsup,mmvu  as volp
 FROM
 palldets ;
 WHERE BETWEEN(cycle,trcask2,trcask3) ORDER BY pcode group BY pcode INTO
 TABLE temp
 
 in this instance, mcols is XD11 and mmvu is XD39
 Both XD11 and XD39 are fields in a table.
 
 As you can see, I'm simply adding 2 more columns to the temp table

 Styze,

 I would first say the group by isn't valid. However, you don't have date
 or cycle in the grouping. This suggests you are not in VFP 9, or you have
 set the engine behavior to be an older version.

 You showed us code, you didn't share with us the failure symptoms.

 Tracy

 --
 Sent from my Android device with K-9 Mail. Please excuse my brevity.

[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/cag1nny8phemkkce9dld7mu2-mhavithwh7awat_u6fdw7_a...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

System integration

2015-06-25 Thread Sytze de Boer

I need to develop a system which calls data from a phone system.
They have made available an API and the documentation begins with

Quote
Creating Your Plugin with Microsoft Visual Studio
.

So now I'm stuck
I'm not looking for a freebee, but is there anyone able/willing to have a
look at this with me?


-- 
Kind regards,
Sytze de Boer


--- 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/cag1nny8fzrud6zpvytiqyktqr7ylug65u9dxsafnv2vizub...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: VFP9 and Microsoft Message Que

2015-06-22 Thread Sytze de Boer

And I would love to hear more about this service/process/program


On Tue, Jun 23, 2015 at 1:29 PM, Kent Belan kbe...@bellsouth.net wrote:

 Hello,

 I am working on a project that will talk to the Microsoft Message Que and
 get a message, do some processing and return the answer.

 I have this working about 95% of the time but the other 5% the return
 message gets lost somewhere ???

 Has anyone worked with Microsoft Message Que and VFP9 ?

 If so, I would love to compare notes and see if I am doing something wrong.

 Thanks for your help,
 Kent


[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/CAG1nNy8OnBRzy1mzknxYG1tW2nZ-73HK=1cn7jmw2txwjjo...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: ReportBuilder.app and VFPx

2015-06-18 Thread Sytze de Boer

Hi Tracy

I recently posted a query on another forum and received zero attention
I hope you can shed some light on this

My question was

1 Should one distribute reportbuilder.app to all one's clients?
2 If yes, should one include the reportoutput.app as well
3 If yes, what about ReportPreview.app
4 Perhaps it should only be done if you actually log into the clients pc
and modify a report?
5 I use Foxypreviewer at all client sites. Does that make a difference?







On Fri, Jun 19, 2015 at 6:19 AM, Tracy Pearson tr...@powerchurch.com
wrote:

 Hello,

 It was brought to my attention today when someone
 adds a new field to a report
 uses the Expression Builder to select two fields separated by a +
 symbol
 click OK and OK
 the ReportBuilder throws an error

 This is from the VFP 9 SP 1 ReportBuilder.app
 ---
 Report Builder Error
 ---
 Alias is not found.
 Line 0 in saveexprwidth():
 DO (_REPORTBUILDER) WITH __ReportReturn, 2, __ReportCCObject, 1


 fieldexprhandler.Error()

 Do you want to suspend execution?
 ---
 Yes   No   Cancel
 ---

 I attempted to see if it was on http://vfpx.codeplex.com and the server is
 not responding.

 So I found the xSource for VFP 9 SP 2 on the Microsoft site. Tracked the
 saveexprwidth method in the class panelfieldexpr, in the class library
 frxpanels.

 Adding the following to the end of line 71 corrects the problem:
 and used( m.cAlias )


 Say the expression is alias.firstfield + alias.secondfield
 m.cField contains secondfield
 m.cAlias contains alias.firstfield + alias


 HTH,
 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/CAG1nNy8Bhua=e+e99g9tvoe862dtqenddaavabwpx-unaec...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Printing to a Zebra printer

2015-05-13 Thread Sytze de Boer

Hi Dave
This looks promising
I'll test it and let you know


On Thu, May 14, 2015 at 12:41 AM, Dave Crozier da...@flexipol.co.uk wrote:

 Sytze,
 Firstly get rid of the native Zebra drivers and install the drivers from
 Seagull Scientific. These drivers allow you to drive the printer at full
 speed with all the options available for printer control such as slew rate
 etc.


 http://www.seagullscientific.com/drivers/zebra-windows-printer-drivers.aspx?lang=en

 I don't think you will have any problem from then on in. Check on the
 Seagull page that your Zebra is supported first.

 Dave

 -Original Message-
 From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Sytze de Boer
 Sent: 11 May 2015 03:18
 To: profox
 Subject: Printing to a Zebra printer

 After various attempts, this is where I'm at

 Printer is set up on an Win7 pc
 It is shared.
 It is called Zebraprinter
 The default printer is a HP laserjet
 My application is installed on a Server (V:\)

 On this pc, is a file   C:\TEMP\ZEBRA.INI
 It has 1 line, Zebralabels

 In my application, when you print a label, it checks if this file exists
 If so, it goes
 xprinter=FILETOSTR(C:\TEMP\ZEBRAPRINTER.INI)
 SET PRINTER TO NAME (xprinter)

 All is well at this point

 Now I go to a different pc altogether
 I install the zebra printer and access it via 192.168.1.56 (the 1st pc
 where it is set up as a shared printer)

 No matter what I do, it will not print the label from my application Even
 if I set that printer as my default printer

 The FRX does not have anything in EXPR, TAG1 or TAG2 fields Instead of the
 INI file, I have tried a GETPRINTER() routine immediately before printing
 the label

 I have tried to embed the Zebra printer in the EXPR field and saved the
 printer details.
 All to no avail

 I have tried this on my own system with the INI file routine.
 In my office I have 2 usb printers, a network printer on 192.168.1.25, as
 well as a shared printer on my sons's desktop It prints exactly as I would
 expect per the ini file.

 Sheesh folk. Can anyone help me?

 --
 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/cag1nny8c9xfnbqw20ghrnzctv_zpnb4vvelh8bbmpdekeph...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Printing to a Zebra printer

2015-05-10 Thread Sytze de Boer

Yes


On Mon, May 11, 2015 at 2:21 PM, Richard Quilhot quilh...@gmail.com wrote:

 Did you install the zebra driver on the 2nd pc?

 Thanks
 Rick Quilhot
 On May 10, 2015 10:18 PM, Sytze de Boer sytze.k...@gmail.com wrote:

  After various attempts, this is where I'm at
 
  Printer is set up on an Win7 pc
  It is shared.
  It is called Zebraprinter
  The default printer is a HP laserjet
  My application is installed on a Server (V:\)
 
  On this pc, is a file   C:\TEMP\ZEBRA.INI
  It has 1 line, Zebralabels
 
  In my application, when you print a label, it checks if this file exists
  If so, it goes
  xprinter=FILETOSTR(C:\TEMP\ZEBRAPRINTER.INI)
  SET PRINTER TO NAME (xprinter)
 
  All is well at this point
 
  Now I go to a different pc altogether
  I install the zebra printer and access it via 192.168.1.56 (the 1st pc
  where it is set up as a shared printer)
 
  No matter what I do, it will not print the label from my application
  Even if I set that printer as my default printer
 
  The FRX does not have anything in EXPR, TAG1 or TAG2 fields
  Instead of the INI file, I have tried a GETPRINTER() routine immediately
  before printing the label
 
  I have tried to embed the Zebra printer in the EXPR field and saved the
  printer details.
  All to no avail
 
  I have tried this on my own system with the INI file routine.
  In my office I have 2 usb printers, a network printer on 192.168.1.25, as
  well as a shared printer on my sons's desktop
  It prints exactly as I would expect per the ini file.
 
  Sheesh folk. Can anyone help me?
 
  --
  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/cag1nny-dvh-hfdhemvbatu8q_biiwnzcgcv5_grxvwravqy...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Printing to a Zebra printer

2015-05-10 Thread Sytze de Boer

After various attempts, this is where I'm at

Printer is set up on an Win7 pc
It is shared.
It is called Zebraprinter
The default printer is a HP laserjet
My application is installed on a Server (V:\)

On this pc, is a file   C:\TEMP\ZEBRA.INI
It has 1 line, Zebralabels

In my application, when you print a label, it checks if this file exists
If so, it goes
xprinter=FILETOSTR(C:\TEMP\ZEBRAPRINTER.INI)
SET PRINTER TO NAME (xprinter)

All is well at this point

Now I go to a different pc altogether
I install the zebra printer and access it via 192.168.1.56 (the 1st pc
where it is set up as a shared printer)

No matter what I do, it will not print the label from my application
Even if I set that printer as my default printer

The FRX does not have anything in EXPR, TAG1 or TAG2 fields
Instead of the INI file, I have tried a GETPRINTER() routine immediately
before printing the label

I have tried to embed the Zebra printer in the EXPR field and saved the
printer details.
All to no avail

I have tried this on my own system with the INI file routine.
In my office I have 2 usb printers, a network printer on 192.168.1.25, as
well as a shared printer on my sons's desktop
It prints exactly as I would expect per the ini file.

Sheesh folk. Can anyone help me?

-- 
Kind regards,
Sytze de Boer


--- 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/CAG1nNy_cJ_WK4XXnZ7O8iZET9BFPCBK2SgdJL=gr4ijxjpk...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Performance measure

2015-04-23 Thread Sytze de Boer

Tracy, I can only log into the *server*


On Fri, Apr 24, 2015 at 10:50 AM, Tracy Pearson tr...@powerchurch.com
wrote:



 On April 23, 2015 6:36:39 PM EDT, Sytze de Boer sytze.k...@gmail.com
 wrote:
 I have a client who runs my invoicing/job centre system
 He has about 6,000 clients, 15,000 stock items and 500,000 history
 transactions
 My client is complaining about performance.
 
 I have other clients who have many more clients, stock items and 1.5
 million history transactions where performance is not an issue.
 
 I have asked him to upgrade his network switch, cabling, and to make
 sure
 his AV software excludes *my* folder on the Server
 (The server is a simple Win 7 pc with an SSD hdd, accessed by 5 users)
 
 He has done so, but still thinks performance is slow
 I've logged into his system via Teamviewer and all is quick and snappy
 
 Is there a tool I can run on the workstations to see network
 performance?
 Is there something else I can do to measure/compare the software
 performance versus the hardware performance?

 Have you logged in to a workstation when others were also using the system
 to see the performance?

 Tracy
 --
 Sent from my Android device with K-9 Mail. Please excuse my brevity.

[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/cag1nny_nuatmpnfkszcfxafvetsxvn3pyrc8vhxjhybn6e9...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Performance measure

2015-04-23 Thread Sytze de Boer

I have a client who runs my invoicing/job centre system
He has about 6,000 clients, 15,000 stock items and 500,000 history
transactions
My client is complaining about performance.

I have other clients who have many more clients, stock items and 1.5
million history transactions where performance is not an issue.

I have asked him to upgrade his network switch, cabling, and to make sure
his AV software excludes *my* folder on the Server
(The server is a simple Win 7 pc with an SSD hdd, accessed by 5 users)

He has done so, but still thinks performance is slow
I've logged into his system via Teamviewer and all is quick and snappy

Is there a tool I can run on the workstations to see network performance?
Is there something else I can do to measure/compare the software
performance versus the hardware performance?

-- 
Kind regards,
Sytze de Boer


--- 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/CAG1nNy84YqDhRKvDwD_SQBgZU=ncfetvqudydpojqprt6rd...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Disk space

2015-04-01 Thread Sytze de Boer

A client sent me an error message today that said
There is not enough disk space for c:\winkiss\winjr.dbf.

It occurred in a module, line number 151
On that line the module ZAPs a table called winjr.dbf
(The file is exclusive)

When I logged in, the hard drive has 809 gig free space (1 terabyte)

Does anyone have any ideas what may be happening ?

-- 
Kind regards,
Sytze de Boer


--- 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/CAG1nNy90ms0mN=KJZAp7RmYBu7JLqVf7SLxmSHMVSDKQ3=3...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Disk space

2015-04-01 Thread Sytze de Boer

Richard, you may be right, but why did it crop up today when this same pc
has run this software for years
The pc is used by the administrator and it has just the 1 profile.


On Thu, Apr 2, 2015 at 1:29 PM, Richard Quilhot quilh...@gmail.com wrote:

 it's a rights issue


 Rick Q
 quilh...@gmail.com


 On Wed, Apr 1, 2015 at 8:28 PM, Sytze de Boer sytze.k...@gmail.com
 wrote:

  A client sent me an error message today that said
  There is not enough disk space for c:\winkiss\winjr.dbf.
 
  It occurred in a module, line number 151
  On that line the module ZAPs a table called winjr.dbf
  (The file is exclusive)
 
  When I logged in, the hard drive has 809 gig free space (1 terabyte)
 
  Does anyone have any ideas what may be happening ?
 
  --
  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/CAG1nNy8PKWXTbYf635n3Dfa=hjsspnlkksqqbhbhq3x3oft...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Mwresize

2015-03-06 Thread Sytze de Boer

William, I use a different resize but probably follows the same principle

I declare 2 public variables in my main.prg
PUBLIC trheight
PUBLIC trwidth

If the system leaves the main screen I set the trheight and trwidth
variables

On any screen/form where I want to scale the screen, I INIT
heightratio=trheight/(thisform.height+25)
widthratio =trwidth /thisform.Width

thisform.Height=thisform.height*heightratio
thisform.width =(thisform.width*widthratio)+2
thisform.Top=0
thisform.Left=0
thisform.Resize

This has worked really well for me
(All my forms are Modal)

On Sat, Mar 7, 2015 at 11:20 AM, William Pew b...@msn.com wrote:

Hi Tracy!

Thanks for the quick reply. Actually what I'm trying to do is 'automate' a
feature that's already built into mwresize. If you right click the resizer
tab in the bottom right hand corner of the form mwresize pops up a small
menu of choices (75%, 85%, 95%, etc) which, when you make a selection,
resizes the form and all of its controls to the requested percentage of the
forms original size. What I would like to do, in the absence of
auto-resizing to match the current screen resolution, is to set up a public
variable which would contain a number to be used as a fixed choice without
having to use the menu when the form opens. This way I can get the
resolution fairly close to what looks best. Thus, if the form is so large
because of a lower resolution that you can't get at the resizer controls,
you can set this (maybe during the initial system configuration at install
time) to get the form resized automatically.

Kind of a 'back door' approach but a viable solution if I can get it to
work.

Bill

On 2015-03-06 4:25 PM, Tracy Pearson wrote:

William Pew wrote on 2015-03-06:

Hello, again!
Here we go with yet another resizer question.
I have not been able to find a drop in automatic resizer to handle
screen resolution differences among computers. If anyone knows of one
I'd be very interested - problem solved.
Failing that, I've been using mwresize for interactive screen
resizing.
It works beautifully. I thought if I could find a way to pass the vcx a
parameter to have it resize the form to a particular percentage of the
original size when the form is called this would be close enough. I
have
no idea how to manage this.
Can anyone give me an idea how this might be achieved? Or, does
anyone
have contact information for Markus Winhard (mwresize author) so I
might
ask him?
Thanks,
Bill Pew

Bill,

When you say a percentage of the original size. Are you basing this off
the
original size of the top level form this form is opening in?
I can think of two ways to get information to a form when it is
instantiating. You can pass parameters to the Init method. The other one
is
having some public like variable. I like to put things on _Screen with
AddProperty() during runtime. In another program, I use a public settings
object to maintain those type of settings.

HTH,
Tracy

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/cag1nny9oxjdn8b7vkohteaetb+p2to3yyx1h3ihz4ecf9cq...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.

Re: Resizing

2015-03-04 Thread Sytze de Boer

No, a smallish vcx only


On Thu, Mar 5, 2015 at 6:35 AM, mbsoftwaresoluti...@mbsoftwaresolutions.com
 wrote:

 On 2015-02-25 14:01, Sytze de Boer wrote:

 I use
 *CodeMine Stretchy-Resize Control
 *Copyright 1999, Soft Classics, Ltd. All Rights Reserved.

 I've tried other resizers but I found this one met all my criteria,
 especially once I figured out how to auto resize subsequent forms.
 i.e. if the user resizes the master form, subsequent forms auto re-adjust.



 Hi Sytze,

 Do you have to be using the CodeMine framework to take advantage of this?

 tia,
 --Mike


[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/CAG1nNy8qdwr3pskP1v8WcQMht2FxK5LGaf4aA3oPqN=j2hv...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Resizing

2015-02-25 Thread Sytze de Boer

I've tried other resizers but I found this one met all my criteria,
especially once I figured out how to auto resize subsequent forms.
i.e. if the user resizes the master form, subsequent forms auto re-adjust.

On Thu, Feb 26, 2015 at 2:42 AM, Koen Piller koen.pil...@gmail.com wrote:

Hi,
anchors for resizing objects.
than use Greg Reichert's Style class to change Fontsize, -Name, -Colour,
-Attribute all over your form, particulary handy when you make a
poss-application for a bigger-screen than originaly coded.
You can find Greg's class at: Changing Colors and Styles of controls at
run-time http://www.glrsoftware.com/download/download.asp?file=Styles.zip

Regards,
Koen

2015-02-25 14:21 GMT+01:00 Richard Kaye rk...@invaluable.com:

Anchors work well once you get your head wrapped around absolute vs.
relative. The native VFP builder for anchors can also help you figure out
the right value.

mwresize also has the ability to scale fonts which is why I started using
it.

rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
Chris
Davis
Sent: Wednesday, February 25, 2015 8:15 AM
To: profoxt...@leafe.com
Subject: RE: Resizing

Thanks Richard the anchor thing seems to be working a treat for me but I
will keep it in mind.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
Richard Kaye
Sent: 25 February 2015 13:08
To: profoxt...@leafe.com
Subject: RE: Resizing

You might want to look into Markus Winhard's mwresize class.

http://leafe.com/download/mwresize51.zip

rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
Chris
Davis
Sent: Wednesday, February 25, 2015 7:10 AM
To: profoxt...@leafe.com
Subject: Resizing

What's the best resize out there which will keep all controls in their
oringal positions etc just making everything bigger ... would need to
support containers ...

Thanks

Chris.

[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/CAG1nNy_73uDTr5xXNHR84uzwYE8hQDf5ga=e17uhyvr5+zl...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.

Text box formatting

2015-02-12 Thread Sytze de Boer

I have a 200 char field
When data is input, I want to force maximum 4 char input, but there may be
40 such sets

I have tried input mask space space space space dash, 40 times
I have tried =replicate(-,40)(4 spaces and a dash)
Neither seems to work

Can anyone help me?

-- 
Kind regards,
Sytze de Boer


--- 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/CAG1nNy9n3V8L58CgdewBBBY=mmjj+cftlbjp2mg6ywyscur...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Google calendar integration

2015-01-23 Thread Sytze de Boer

I'm still struggling with Google calendar integration and in my
frustrations, am now looking at ActiveX process.
However, they only offer samples via dotnet, VB and the like, so it will
probably just double my level of frustration.

Has anyone else made any progress with this ?

-- 
Kind regards,
Sytze de Boer


--- 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/CAG1nNy_rdrN_SU9gu2rYEbKOU=oyqqakbnzbk+-wrgpezpr...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Help with update

2015-01-09 Thread Sytze de Boer

Friends
I know this code stinks and I'm sure there's a much better way with UPDATE,
but I can't figure it out.

sele stocks
repla all timesheets with 0

sele tsheets
go top
scan
   sele stocks
   seek tsheets.stcode
   replace timesheets with timesheets+tsheets.qty
   sele tsheets
endscan

Can anyone help with this ?


-- 
Kind regards,
Sytze de Boer


--- 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/CAG1nNy83-Gn14Ck6eA0AHS5dX7P6S1Sde=ggtgkod0wxcft...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Help with update

2015-01-09 Thread Sytze de Boer

Tracey, you're correct.
I was trying to avoid the dreaded LOCK situation

This works beuatifully/quick

UPDATE winstoks SET on_order=0

SELECT SUM(qty) as qty, stockcode FROM winsords WHERE !EMPTY(stockcode)
GROUP BY stockcode INTO CURSOR tmp readwrite
UPDATE winstoks ;
SET winstoks.on_order=tmp.qty;
from tmp ;
WHERE winstoks.code=tmp.stockcode

Is there a way to avoid the file locks?
UPDATE winstoks SET on_order=0 if !locked
(Yes, I know, its a silly question)




On Sat, Jan 10, 2015 at 11:14 AM, Tracy Pearson tr...@powerchurch.com
wrote:

 Darren wrote on 2015-01-09:
   UPDATE stocks SET timesheets = 0
   UPDATE stocks SET timesheets = tsheets.qty FROM tsheets WHERE
 stocks.stCode
   = tsheets.stCode
 
   -Original Message- From: ProfoxTech
   [mailto:profoxtech-boun...@leafe.com] On Behalf Of Sytze de Boer Sent:
   Saturday, 10 January 2015 8:43 AM To: profoxt...@leafe.com Subject:
   Help with update
 
   Friends
   I know this code stinks and I'm sure there's a much better way with
 UPDATE,
   but I can't figure it out.
 
   sele stocks
   repla all timesheets with 0
 
   sele tsheets
   go top
   scan
  sele stocks
  seek tsheets.stcode
  replace timesheets with timesheets+tsheets.qty
  sele tsheets
   endscan
 
   Can anyone help with this ?
 
   --
   Kind regards,
   Sytze de Boer
 

 Darren,

 If Memory serves, the Update command can lock the table header during the
 process.
 If there are multiple tsheets.stcode and your are combining (summing them)
 you may need to use a subquery instead of the table directly in the
 suggested Update command.

 Untested:

 UPDATE stocks SET timesheets = tsheetsum.qty ;
 FROM (select stcode, sum(qty) as qty from tsheets group by 1) as
 tsheetsum ;
 WHERE stocks.stCode  = tsheetsum.stCode

 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/cag1nny_bqymfvrft5uxgj6sh8luju1wgg3oxrtw1rkvdj_p...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Help with update

2015-01-09 Thread Sytze de Boer

Actually, as you can see, there are 3 steps to my solution, which I
suspect is not necessary, but I haven't yet found a way to set on_order
to zero if there's (now) nothing in winsords



On Sat, Jan 10, 2015 at 11:26 AM, Sytze de Boer sytze.k...@gmail.com
wrote:

 Tracey, you're correct.
 I was trying to avoid the dreaded LOCK situation

 This works beuatifully/quick

 UPDATE winstoks SET on_order=0

 SELECT SUM(qty) as qty, stockcode FROM winsords WHERE !EMPTY(stockcode)
 GROUP BY stockcode INTO CURSOR tmp readwrite
 UPDATE winstoks ;
 SET winstoks.on_order=tmp.qty;
 from tmp ;
 WHERE winstoks.code=tmp.stockcode

 Is there a way to avoid the file locks?
 UPDATE winstoks SET on_order=0 if !locked
 (Yes, I know, its a silly question)




 On Sat, Jan 10, 2015 at 11:14 AM, Tracy Pearson tr...@powerchurch.com
 wrote:

 Darren wrote on 2015-01-09:
   UPDATE stocks SET timesheets = 0
   UPDATE stocks SET timesheets = tsheets.qty FROM tsheets WHERE
 stocks.stCode
   = tsheets.stCode
 
   -Original Message- From: ProfoxTech
   [mailto:profoxtech-boun...@leafe.com] On Behalf Of Sytze de Boer Sent:
   Saturday, 10 January 2015 8:43 AM To: profoxt...@leafe.com Subject:
   Help with update
 
   Friends
   I know this code stinks and I'm sure there's a much better way with
 UPDATE,
   but I can't figure it out.
 
   sele stocks
   repla all timesheets with 0
 
   sele tsheets
   go top
   scan
  sele stocks
  seek tsheets.stcode
  replace timesheets with timesheets+tsheets.qty
  sele tsheets
   endscan
 
   Can anyone help with this ?
 
   --
   Kind regards,
   Sytze de Boer
 

 Darren,

 If Memory serves, the Update command can lock the table header during the
 process.
 If there are multiple tsheets.stcode and your are combining (summing them)
 you may need to use a subquery instead of the table directly in the
 suggested Update command.

 Untested:

 UPDATE stocks SET timesheets = tsheetsum.qty ;
 FROM (select stcode, sum(qty) as qty from tsheets group by 1) as
 tsheetsum ;
 WHERE stocks.stCode  = tsheetsum.stCode

 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/CAG1nNy8a3bt78KKbEopy2sSaqffFkArv7R+sMRL+bQU=f_+...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Dropdowns that function like Google search

2015-01-02 Thread Sytze de Boer

Check out Xbox by Jun Tangunan on Foxite
I think he did exactly what you're asking, or so close it would be easy to
adapt to your requirements





On Sat, Jan 3, 2015 at 8:04 AM, Rick Borup rbo...@ita-software.com wrote:

 Mike,

 If you're still looking for a solution, check out SrchCombo.vcx from Anil
 Dharampal. I've used it with a long list (thousands) of choices and have
 been happy with its performance. It's available for download on the
 Universal Thread.

 -Rick


 -Original Message-
 From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
 mbsoftwaresoluti...@mbsoftwaresolutions.com
 Sent: Thursday, July 17, 2014 9:34 PM
 To: profoxt...@leafe.com
 Subject: Dropdowns that function like Google search

 VFP9SP2

 Existing:  Customer combobox with style set to 0 - Dropdown combo.  If
 user enters customer not found in list, program asks if they want to add
 this name as a new customer.

 Preferred: user wants Customer dropdown to be like Google search where
 as he types, he sees a dropdown of possible choices matching what he's
 typed so far.

 Suggestions?

 Thanks,
 --Mike


[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/CAG1nNy_xuSLQVnFGqn7kBjwTwY6Y=lxpjvhct2a7v12gdai...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Network Slow Query

2014-12-18 Thread Sytze de Boer

I will follow this subject with keen interest

On Fri, Dec 19, 2014 at 12:15 PM, Dan Covill dan.cov...@outlook.com wrote:

Tracy,

How about Reprocess and/or Multilocks? The system with the two tables
related might be doing temporary locks when moving between records. ??

Dan

From: tr...@powerchurch.com
To: profoxt...@leafe.com
Subject: Network Slow Query
Date: Thu, 18 Dec 2014 18:02:27 -0500

From a workstation, when no other workstation has the two tables in
question
the query takes 2.5 seconds
After another workstation opens the tables and relates them to display
the
information in form, the query takes 45 to 60 seconds.

Locally the query takes 0.7 seconds.

Table1.dbf - 33,232 KB
Table1.cdx - 16,438 KB

Table2.dbf - 10,808 KB
Table2.fpt - 205,424 KB
Table2.cdx - 3,284 KB

---

In testing this, I have setup in VM's 2 Windows 7 workstations, and 1
Windows 8. Win7-2 is hosting on a shared drive. Win7-1 is doing the
query.
Win8 is just opening and relating the tables.

The time to get the results in the VM's is
SMB2 - ON
Single User - 1.937
Multi user - 13.454
SMB2 - OFF
Single user - 1.422
Multi user - 11.813

Using the Resource Monitor I see 63 Mbps when multi users have the
table. I
see 300 Mbps when single user.

Does anyone have thoughts on what options I need to look at to help the
query speed up?

[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/cag1nny_qez0fsdb6--zfqqr7gskjnki5f_jazytx934chgq...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.

Re: (NF) Note storage, access, what do you use?

2014-12-11 Thread Sytze de Boer

How about a spreadsheet in your Dropbox

On Fri, Dec 12, 2014 at 9:14 AM, Mike Copeland m...@ggisoft.com wrote:

All,

I need a way to store business-related notes and have them accessible from
anywhere, including from my Andriod phone. I'm currently using an
application I wrote in VFP, which works great, but if I'm out of the
office, I have to have remote access back to my computer. So, I'm looking
for a cloud (oh, buzzword warning!) solution.

Obviously, there's Evernote. Any platform, free for limited use, popular,
established. I've downloaded and installed it and played with it, and it
doesn't overwhelm me.

Anyone got any other suggestions? What do you use? Do you like it?

I just need to be able to store names, phone, email, random notes, URLs,
maybe even pix or video. Something with very flexible search...no good to
HAVE the info if you can't FIND the info.

Thanks in advance for any suggestions or advice.

Mike Copeland

[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/CAG1nNy_Faj2g8Fwpa9Tw5bTqPG_89BzFSMHcCmKCjBc=urn...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.

Re: (NF) Note storage, access, what do you use?

2014-12-11 Thread Sytze de Boer

I once downloaded and tried PocketCloud
It's actually still working from my Phone

(It's a bit like Teamviewer, back to your own desktop)


On Fri, Dec 12, 2014 at 12:56 PM, Ed Leafe e...@leafe.com wrote:

 -BEGIN PGP SIGNED MESSAGE-
 Hash: SHA1

 On 12/11/2014 02:14 PM, Mike Copeland wrote:
  I need a way to store business-related notes and have them accessible
  from anywhere, including from my Andriod phone. I'm currently using an
  application I wrote in VFP, which works great, but if I'm out of the
  office, I have to have remote access back to my computer. So, I'm
  looking for a cloud (oh, buzzword warning!) solution.
 
  Obviously, there's Evernote. Any platform, free for limited use,
  popular, established. I've downloaded and installed it and played with
  it, and it doesn't overwhelm me.

 I've been using Evernote for a few years now, and it's great. I scan
 business cards, drop the images into Evernote, and it uses OCR to index
 them by words on the image! Pretty cool, and very useful. I run Evernote
 on my Mac, on my phone, and as a web app. Can't get much more convenient
 than that.


 - -- Ed Leafe
 -BEGIN PGP SIGNATURE-
 Version: GnuPG v2.0.14 (GNU/Linux)

 iQIcBAEBAgAGBQJUii8yAAoJEKMgtcocwZqLkNIP/15VP/G8qbLOL6r8Jml0V4Nt
 nyanj8WxS618AVtTlUq0ldLliTagxTAudCHRWFj51Hy6a6ZgpSsNJZHeV0Ovjcmz
 jtmZDMjz2bfq6Y97dGjSlDV7yssptTgOhY8dOpMJCUeJxKkPe7KxDpsSolIInRqX
 Rxf+zj5cFGg9wSkG38l1fyiRC9FnpfKrbcRZzLM3sfT7o2OeqQLEqc8uaXuySTXX
 9jDpM56sK65y6c9U1w/cAqFWqO4cEvANYsIR7EtEASjnMCaMino+BgCDrrbzfzrz
 h4l5sJSlwTSbNQHW1sGbQs11IkUSCqY2c7nsebMP9NSsY/Mq2RknvXOq3Mu+U7kz
 B6Ur5+DfK2rByePM158T5k5N1WDUy0pqb9EzQbUpQFrrgmW0Qq8wDXAzvCG/gzGC
 ISf8sAnqXHe+vwFCOsYKQTccwAP8Bu59VbYADC0aT3nY1PaY6/WyVv6T6Iiimfx5
 ejJSYdzhkPq+iQKV9L5WrZX45idB9iguoe6K5NnZMhRAblHiVrldHF1jGzlulTf2
 aTybL33MVhY9uUlFieE+KdAQSTuqSja9vBWbQcBKux55AURf2QWBEXmWQ8GtGUv4
 MKc2TL8QPAN6ONZQGeRNQCaTS8SjvBSULzHuAAAUOZYa5JXvhPRuzFk4//adrxnf
 +WZ9Z+dgRHFbX6sQcq6W
 =rYWF
 -END PGP SIGNATURE-

[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/cag1nny_h6bvnnjneoa9ir_fzgwosbvcfdxr19x6b3bvop1s...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [NF] Cloud Servers

2014-12-10 Thread Sytze de Boer

Would you put AZURE in this category?

On Thu, Dec 11, 2014 at 10:43 AM, Jeff Johnson j...@san-dc.com wrote:

On 12/10/2014 1:30 PM, Kevin Cully wrote:

Hello Jeff,

I'm currently interested and/or using in 3 cloud hosting companies:
http://Hosting.com, http://DigitalOcean.com, and http://Vultr.com.

HOSTING.COM
I'm currently using them for a client with a West-Wind customized store
on a Windows 2008 server. To get acceptable HD space and performance, the
cost is $300 per month. This seems to be very expensive to me with current
offerings. However, when you need support, a person answers the phone in a
very short time frame and most of the times that person can resolve the
issue.

DIGITALOCEAN
Allows for hourly or monthly hosting of Linux and BSD servers. It's
amazing to spin up a Linux server in about 40 seconds! I'm using this for
testing of Xojo web applications.

VULTR
I'm not currently using this company yet. They seem to have more server
locations, especially in the states. They have hourly and monthly pricing.
They have Linux and BSD hosting *AND* they allow for customized ISO
installations, which is how you get a Windows server installation.

I hope this helps.

-Kevin

On 12/10/2014 02:19 PM, Jeff Johnson wrote:

I have a couple of companies that provide Windows Virtual Servers for
their customers. There seems to be a lot of companies providing this type
of service. The prices are all over the board and the customer service,
support, and up time can only be found by talking to customers. Does
anyone have a clue how to find a decent company in a particular area, say
Colorado? (I understand the hosting company doesn't have to be local)

TIA

Kevin: The VULTR has great prices. Like I said, all over the board.
Companies I have looked at provide per user prices.

-- Jeff Jeff Johnson j...@san-dc.com SanDC, Inc. (623) 582-0323 SMS
(602) 717-5476 Fax 623-869-0675 www.san-dc.com www.cremationtracker.com
www.agentrelationshipmanager.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/CAG1nNy8cqH-1Nt59mmYrTRE9jCDKp1h2CRBQ-iUi9g4HEwi=6...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.

Re: [NF] Supporting remote clients

2014-12-01 Thread Sytze de Boer

Teamviewer will monitor how often you use the free version, and suddenly
deny access.
They keep updating their system and if your client has a different version
to yours, it will not allow access.
And the professional version is pricy.
I have used it to assist clients in different parts of the world.

Dave Crozier recently mentioned Splashtop.
It has a certain number of limitations and I found the only real good point
was the price.

I would have to say that you get what you paid for and Teamviewer is
unbeatable.
They also have a small host (V 7) which I distribute with my software
Then, when they call for help, I check if they have Teamviewer installed.
If so, I kill it
Then my system calls this small host and I'm in !

On Tue, Dec 2, 2014 at 9:11 AM, Paul McNett p...@mcnettware.com wrote:

If the client has an existing VPN, ask to get access. If not, offer to set
up VPN for them.

If the client has existing DNS for their LAN machines, assigning a DNS
name for every machine in the LAN, find out the names of the machines you
are interested in remote controlling. If not, offer to set up DNS for them.

Then, install TightVNC Service on all the machines you want to remote
control, and connect over the VPN from your laptop wherever you may be.

After the initial setup, it's free forever.

Alternatively, the client needs to pay for LogMeIn Pro or equivalent.

Of course, convincing them of the value will require some selling.
Usually, charging your full rate for travel time suffices.

No, I don't convince a high percentage of leads to contract with me, which
turns out to be a good thing for everyone. They don't pay for
products/services they don't feel they need, and I don't waste time trying
to support them.

Paul

[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/cag1nny-vl-4zfq5tz1afpj7y0wbuqe7pptrfnm3h2p-yshw...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.

1 2 3 4 5 6 7 8 9 10 >

1 - 100 of 1009 matches

Mail list logo