MYSQL connection

[Rafael Copquin]

I have been using SQL Server Express for years, both on local PC's and the
cloud.

I am now considering using MYSQL for a new cloud app.

I downloaded and installed the MySQL Workbench and can connect to the cloud
MYSQL database, directly from the WorkBench.

However, I was not successful in connecting to the cloud (or the local host
for that matter) from VFP

Do I need to download and install an ODBC driver for this? If so,which
driver?

A code snippet would be of great help

Thank you all in advance

Rafael Copquin


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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/CAHM-jJ16t21qF-c_2JHHzqsbkoW7etBzv=cwxx5fwpsohtl...@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: sql server connection

[Rafael Copquin]

Hi Eric, I was afraid they would need to install the driver. I'll try
innosetup as you suggest

In any case, thank you both, Eric and Vince

Best regards
Rafael


El jue, 11 feb 2021 a las 11:17, Eric Selje ()
escribió:

> Rafael,
>
> They'll have to have the driver installed in order to talk to SQL Server.
> The best way is to provide them with an Installer program (use InnoSetup -
> free and easy) that installs your app as well as the driver. It can add a
> DSN too, although you may want to consider hardcoding that connection
> string into your EXE so the password isn't visible. Hopefully they're using
> a SQL account with the minimal privileges needed.
>
> I hope this helps,
>
> Eric
>
>
> On Thu, Feb 11, 2021 at 6:50 AM Rafael Copquin 
> wrote:
>
> > I have a VFP) app that uses MS sqlserver as backend. The SQL Server is
> > located in a web provider
> >
> > The connection is achieved by creating a DSN throught the ODBC driver in
> my
> > PC
> >
> > I need to deploy this app to several clients. But none of them should use
> > their ODBC driver to create the connection, or install the applicable SQL
> > Server Native Client in their PC.
> >
> > The idea is that I would send them my VFP application exe and they would
> > simply connect to the cloud SQL Server and run the app without any
> further
> > operations to install the exe.
> >
> > I tried SQLConnect and SQLStringConnect, but they always refer to an
> > existing DSN
> >
> > Is there a way to accomplish this without my clients intervention other
> > than lodging the exe in the applicable directory in their PC's ??
> >
> > Please advise and if possible, provide an example on how to do this
> >
> > TIA
> >
> > Rafael Copquin
> >
> >
> > --- StripMime Report -- processed MIME parts ---
> > multipart/alternative
> >   text/plain (text body -- kept)
> >   text/html
> > ---
> >
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/CAHM-jJ3yPRjCB6nyhxq55Ki9mn7KF8oNYs+k1=1tfqqdczh...@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.

sql server connection

[Rafael Copquin]

I have a VFP) app that uses MS sqlserver as backend. The SQL Server is
located in a web provider

The connection is achieved by creating a DSN throught the ODBC driver in my
PC

I need to deploy this app to several clients. But none of them should use
their ODBC driver to create the connection, or install the applicable SQL
Server Native Client in their PC.

The idea is that I would send them my VFP application exe and they would
simply connect to the cloud SQL Server and run the app without any further
operations to install the exe.

I tried SQLConnect and SQLStringConnect, but they always refer to an
existing DSN

Is there a way to accomplish this without my clients intervention other
than lodging the exe in the applicable directory in their PC's ??

Please advise and if possible, provide an example on how to do this

TIA

Rafael Copquin


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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/cahm-jj1v2ukm7asgkbqgq7tubnvmbq0bge3l9r1vzhhoxev...@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: now it is cxi files

[Rafael Copquin]

Hi Tracy
It is an FLL named cpaxvfp5.fll
When I try to run the code I get the message that COMPAXION is FoxPro
version reliant.
BTW, the code used in the old app is

SET TALK OFF
SET LIBRARY TO CPAXVFP5.FLL
SET TALK ON


nRetVal=CPAX_Move('datos.cxi','bases.*')
SET TALK OFF
SET LIBRARY TO
Rafael

El lun., 26 oct. 2020 a las 17:23, Tracy Pearson ()
escribió:

> It's a DLL right? How is it failing?
>
> If it is an FLL, I'm still not sure why it wouldn't work between versions
> of
> VFP runtimes.
>
> Are you missing a dependency of the DLL?
>
> Tracy
>
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Rafael
> Copquin
> Sent: Monday, October 26, 2020 3:52 PM
> To: profoxt...@leafe.com
> Subject: now it is cxi files
>
> Last week I wrote about this old VFP5 app that I inherited which had some
> files with the phd extension. I never had heard or encountered that kind of
> files but Dave Crozier helped me with them.
> However, digging more deeply into this old app (which BTW I need to upgrade
> to VFP9 and add some perks to it), I found that some of the DBF's are
> wrapped into a file with the CXI extension.
> Fortunately the old source code has the original program that wraps the
> dbfs into a CXI file. I thought all I had to do was recomplile in VFP9, but
> to my surprise, the dll available only works with VFP5
>
> So my questions are:
>
> 1) how can I get the dll that works with VFP9 (I am not sure that there is
> an update for VFP9)
> 2) if there is not an update, then how can I get a VFP5 so I can compile my
> new code and make the CXI routines work.
>
> I'll appreciate some help on this
>
> Rafael Copquin
>
>
> --- StripMime Report -- processed MIME parts ---
> multipart/alternative
>   text/plain (text body -- kept)
>   text/html
> ---
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/CAHM-jJ1hOOOtRYavOL=rskycr1o+vdxbubeu+oze8zyxm90...@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.

now it is cxi files

[Rafael Copquin]

Last week I wrote about this old VFP5 app that I inherited which had some
files with the phd extension. I never had heard or encountered that kind of
files but Dave Crozier helped me with them.
However, digging more deeply into this old app (which BTW I need to upgrade
to VFP9 and add some perks to it), I found that some of the DBF's are
wrapped into a file with the CXI extension.
Fortunately the old source code has the original program that wraps the
dbfs into a CXI file. I thought all I had to do was recomplile in VFP9, but
to my surprise, the dll available only works with VFP5

So my questions are:

1) how can I get the dll that works with VFP9 (I am not sure that there is
an update for VFP9)
2) if there is not an update, then how can I get a VFP5 so I can compile my
new code and make the CXI routines work.

I'll appreciate some help on this

Rafael Copquin


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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/CAHM-jJ3aGkgsHZxMntPbOh=s-=7_begg_cx7bu+kctqcusc...@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: phdbase

[Rafael Copquin]

Hi Woody
Thanks for the info. I did as you suggested, but also deleted the cdx and
phd files and could open the dbf with no problem.
Thanks again
Best regards
Rafael

El mar., 13 oct. 2020 a las 14:57, Rafael Copquin ()
escribió:

> Hi guys, it's been e long time!
>
> I just inherited an old vfp5 program that needs to be updated to VFP9,
> adding new routines to enhance performance and migrate the dbf's to sql
> server.
>
> I encountered some dbfs that have an additional file with a phd extension
> which I believe is generated by a program that facilitates text searches in
> memo files.
>
> I try to open the dbf but vfp9 says that it can't find the phd file, even
> though the dbf, its cdx and phd files are in the same folder.
>
> I tried to set tablevalidate to 0, set exclusive on but to no avail
>
> How can I open those dbf's?
>
> TIA
>
> Rafael Copquin
>
>


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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/cahm-jj1dsxvktk3bjkvnsag9bpns5mzzuwmhxjbb6-bvuxo...@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.

phdbase

[Rafael Copquin]

Hi guys, it's been e long time!

I just inherited an old vfp5 program that needs to be updated to VFP9,
adding new routines to enhance performance and migrate the dbf's to sql
server.

I encountered some dbfs that have an additional file with a phd extension
which I believe is generated by a program that facilitates text searches in
memo files.

I try to open the dbf but vfp9 says that it can't find the phd file, even
though the dbf, its cdx and phd files are in the same folder.

I tried to set tablevalidate to 0, set exclusive on but to no avail

How can I open those dbf's?

TIA

Rafael Copquin


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

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/CAHM-jJ1rnNgQXOiYFy104DxdJU3+HVX=5yowzuaqa6nc+04...@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.

AZURE and VFP

[Rafael Copquin]

I just started a trial instance of SQL Server on Azure.

My question is whether it is possible to upload a VFP exe into a Storage 
account on Azure and have it run from a local browser.


I have this app that produces payroll receipts. I can generate the 
payroll receipts for each employee in a pdf format and would like to 
lodge them somewhere on Azure. The SQL Server on Azure contains all the 
data to generate the receipts on demand. So any employee, with hi/her 
applicable password could access the VFP exe and visualize their monthly 
payment receipt from his/her home just using a browser.


I know it should be possible to do it with a VM, lodging a SQL Server 
instance on it and my app's exe, but my client does not want to pay for 
the VM, just use the above option.


Is it at all possible? if so,how? Any leads?

TIA

Rafael Copquin



--
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/fd65824d-e57c-fdad-529e-fa730ccfe...@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: TSQL equivalent of strtran function

[Rafael Copquin]

It is numeric and I have to transform it to a char (fixed length) type and
do need to show the decimal point.
I use cast to change it to char(15) and then the replace function, which
did the job of removing the decimal point

select replace(cast sales as char(15),'.','') as sales from ..

thanks
Rafael


El vie., 3 may. 2019 a las 10:33, Stephen Russell ()
escribió:

> What is the data type for that column?  Char, VarChar, NVarchar?  Or is it
> numeric and you are pulling the data in a select and you do not want the
> decimal point to show?
>
> On Thu, May 2, 2019 at 5:41 PM Rafael Copquin 
> wrote:
>
> > Please tell what function in TSQL can I use in the same way as STRTRAN in
> > VFP
> >
> > I ned to remove the point from a character expression such as
> >
> > 12345.67 to leave as 1234567 in TSQL
> >
> > TIA
> > Rafael Copquin
> >
> >
> > --- 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: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/cahm-jj2khnorkxesardmjyzxewt8modfo1lp1sofk5vvsez...@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.

TSQL equivalent of strtran function

[Rafael Copquin]

Please tell what function in TSQL can I use in the same way as STRTRAN in
VFP

I ned to remove the point from a character expression such as

12345.67 to leave as 1234567 in TSQL

TIA
Rafael Copquin


--- 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: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/cahm-jj22dij_snxb0hlcu2tp7f9hfhih0crqx+ckawlgqmp...@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 Grid record focus

[Rafael Copquin]

I have a similar problem, this time with a checbox in a column of the grid.
When  the user clicks on the checkbox, it performs some code in its click
event and then, instead of staying on that record, the pointer goes up to
the top of the grid. This is annoying.

Finally I solved it with this code in the click event of the checkbox:
local nRec
nRec = recno('mycursor')

** perform some code here

select mycursor
locate for recno() = nRec
this.parent.parent,refresh

In my case, the pointer stays on the record it is supposed to be.

Hope it helps

Rafael Copquin







El vie., 16 nov. 2018 a las 13:49, Kent Belan () escribió:

> Hello,
> I have a weird problem with a grid on a locate screen that I have never
> noticed before.
>
> I have a maintenance screen with a locate button, that opens a modal search
> form with a grid to select a record.
>
> When I load the grid with several hundred records the first time it loads
> fine at the top of the file.
>
> The user selects a record and I return to the maintenance form and show the
> record details.
>
> If the user clicks the locate button again, I load the search form with the
> grid and position the cursor to the record that was previous selected and
> the grid shows the correct record.
>
> The problem is when the user clicks on the grid, it repositions itself to
> the first page of the grid and now we are on the wrong record.
>
> Very weird ...  Has anyone seen this behavior and possible solution ?
>
> Thanks,
> 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/cahm-jj0jqr0d6lxvp_dr1fre0mvrxvv99-knena1amfmkoq...@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: Print salary receipts to a pdf image

[Rafael Copquin]

noted, thanks


El vie., 14 sept. 2018 a las 16:25, Charlie-gm ()
escribió:

>
> The doc mgmt systems I was referring to were ones we built (I was part
> of the dev team). They were custom solutions.
>
> -Charlie
>
> On 9/14/2018 2:42 PM, Rafael Copquin wrote:
> > Thnk you for your offer Charlie.
> >
> > However, I would not want you to loose any time on this, since I came up
> > with a very simple solution, as described in a previous post.
> >
> > I am curious though as to what document management systems you used in
> the
> > past.
> >
> > have a nice weekend
> > Rafael
> >
> >
> > El vie., 14 sept. 2018 a las 14:21, Charlie-gm ()
> > escribió:
> >
> >> The opinions are flying, so...
> >>
> >>> In Document Management systems this is given.  You set the shell that
> >> holds
> >>> the text objects in place on top of the pdf file.  You then pass the
> data
> >> ...
> >> This is a false statement. Document management systems do not use the
> >> "print on top of PDF" design as "a given." The 2 document management
> >> applications that I have worked on threw out this approach mostly
> >> because of what Ted has pointed out. I've done other applications where
> >> "document management" was a component and we also did not use it there.
> >> One thing I have implemented regarding PDFs is an "archiving" function
> >> (aka, exactly what was sent to the customer, user). Those components
> >> simply printed output twice (once for the users, once to the logging
> >> PDFs when then got placed back into the DB).
> >>>> Like Alan suggested I think the easiest solution is to just create it
> >>>> using the VFP report writer.  Put all the words, lines, boxes etc
> using
> >>>> the normal report writer tools and anything graphics like that you
> can't
> >> ...
> >> I'll second the "write-in-VFP" option for a couple reasons:
> >> 1) the output quality will be superb, and when generating paper for
> >> users/customers, the quality of the finished product leaves lasting
> >> impressions (don't forget about color! )
> >> 2) there will be a huge payoff for future maintainability and
> >> flexibility (got change in form, new form, more data? no problem!).
> >>
> >> In fact, if your company would allow you, go ahead and send me
> >> (colem...@acm.org) a scan or picture of the form and I'll get it
> started
> >> for you (I generally use VFP9, but if you have earlier versions let me
> >> know). The thing is, there are some features of the VFP Report Writer
> >> that are hard to explain, but if you see them in action the lightbulb
> >> comes on (for example, to put a box around the whole content, just
> >> stretch a box from header to footer bands). So, while I may not have
> >> time to do a complete form, I can probably set up the initial layout
> >> which you could easily expand from there.
> >>
> >> -Charlie
> >>
> >>
[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/cahm-jj3yabk280lektzwz2ff45kt6fepoofvotukrup75if...@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: Print salary receipts to a pdf image

[Rafael Copquin]

Thnk you for your offer Charlie.

However, I would not want you to loose any time on this, since I came up
with a very simple solution, as described in a previous post.

I am curious though as to what document management systems you used in the
past.

have a nice weekend
Rafael


El vie., 14 sept. 2018 a las 14:21, Charlie-gm ()
escribió:

>
> The opinions are flying, so...
>
> > In Document Management systems this is given.  You set the shell that
> holds
> > the text objects in place on top of the pdf file.  You then pass the data
> ...
> This is a false statement. Document management systems do not use the
> "print on top of PDF" design as "a given." The 2 document management
> applications that I have worked on threw out this approach mostly
> because of what Ted has pointed out. I've done other applications where
> "document management" was a component and we also did not use it there.
> One thing I have implemented regarding PDFs is an "archiving" function
> (aka, exactly what was sent to the customer, user). Those components
> simply printed output twice (once for the users, once to the logging
> PDFs when then got placed back into the DB).
> >> Like Alan suggested I think the easiest solution is to just create it
> >> using the VFP report writer.  Put all the words, lines, boxes etc using
> >> the normal report writer tools and anything graphics like that you can't
> ...
> I'll second the "write-in-VFP" option for a couple reasons:
> 1) the output quality will be superb, and when generating paper for
> users/customers, the quality of the finished product leaves lasting
> impressions (don't forget about color! )
> 2) there will be a huge payoff for future maintainability and
> flexibility (got change in form, new form, more data? no problem!).
>
> In fact, if your company would allow you, go ahead and send me
> (colem...@acm.org) a scan or picture of the form and I'll get it started
> for you (I generally use VFP9, but if you have earlier versions let me
> know). The thing is, there are some features of the VFP Report Writer
> that are hard to explain, but if you see them in action the lightbulb
> comes on (for example, to put a box around the whole content, just
> stretch a box from header to footer bands). So, while I may not have
> time to do a complete form, I can probably set up the initial layout
> which you could easily expand from there.
>
> -Charlie
>
>
[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/CAHM-jJ1PsOpMuzRWo7nibGHukJnYFVo8T7rNN=k+j4r1uf1...@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: Print salary receipts to a pdf image

[Rafael Copquin]

Thank you guys

I just scanned the empty form and embedded it in a VFP report

Then, by painstaking trial and error I managed to make the report textboxes
coincide with the right place on the form.

I printed it and it looks well enough

The textboxes have to be set as "bring to front" and the scanned image have
to cover the header, details and footer areas of the report.

It also has to be a JPG image. The VFP control will not accept a PDF file,
unless I am missing something very obvious

Thanks again for your suggestions

Rafael

El vie., 14 sept. 2018 a las 14:15, Frank Cazabon ()
escribió:

> Koen,
>
> it's not me asking for help, it's Rafael. I suggested PDFtk as I use it
> in some systems. Dead simple to implement, maybe 30 minutes tops if you
> program slowly.
>
> Frank.
>
> Frank Cazabon
>
> On 14/09/2018 12:57 PM, Koen Piller wrote:
> > Frank,
> >
> > Ted is completely correct.
> > Just use VFP:
> > 1) scan your given PDF form  and extract the different images from that
> > file into separate .jpg files
> > 2) create a dbf/cursor with all the fields you are required to fill in
> the
> > given PDF
> > 3) search internet for the font used for that PDF
> > 4) create a VFP Report, where you put the images you have colleted at
> their
> > place like on the given PDF
> > 5) set all the captions as on the given PDF to the text as in the font as
> > 6) set all the textboxes font as on the given PDF
> > 7) save report, print and compare
> > A job which can be done in less than 1 hour.  (maybe 1st time  a little
> bit
> > longer, however when you know how-to certainly < 1 hour)
> > If you find problems with this approach, feel free to contact me.
> >
> > Koen
> >
> >
> >
> >
> > Op vr 14 sep. 2018 om 17:10 schreef Frank Cazabon <
> frank.caza...@gmail.com>:
> >
> >> If you can get the PDF as a fillable PDF form you can then use PDFtk to
> >> fill the form from VFP.
> >>
> >> Frank.
> >>
> >> Frank Cazabon
> >>
> >> On 14/09/2018 10:53 AM, Rafael Copquin wrote:
> >>> Perhaps I was not very clear.
> >>>
> >>> I have scanned the empty receipt as a pdf image.
> >>> I want to fill it with the applicable data and then print it on a laser
> >>> printer
> >>>
> >>> I can't use the vfp report writer because it will not take a pdf file
> as
> >> an
> >>> image. And if I use a jpg file instead, it will not allow me to make it
> >> fit
> >>> in the page with the right shape.
> >>>
> >>> Rafael
> >>>
> >>>
> >>> El vie., 14 sept. 2018 a las 6:01, Alan Bourke (<
> alanpbou...@fastmail.fm
> >>> )
> >>> escribió:
> >>>
> >>>> Maybe I'm missing something but would you not just design a normal VFP
> >>>> report with the logo graphic and whatever boxes and lines are
> required,
> >>>> reproducing the pre-printed stationery, and print that to PDF via XFRX
> >> or
> >>>> whatever?
> >>>>
> >>>> --
> >>>> 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/CAHM-jJ344DS1yAWta8bdV8mLTcRUEUwBhrYp6Ra=c-b5tt2...@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: Print salary receipts to a pdf image

[Rafael Copquin]

Perhaps I was not very clear.

I have scanned the empty receipt as a pdf image.
I want to fill it with the applicable data and then print it on a laser
printer

I can't use the vfp report writer because it will not take a pdf file as an
image. And if I use a jpg file instead, it will not allow me to make it fit
in the page with the right shape.

Rafael


El vie., 14 sept. 2018 a las 6:01, Alan Bourke ()
escribió:

> Maybe I'm missing something but would you not just design a normal VFP
> report with the logo graphic and whatever boxes and lines are required,
> reproducing the pre-printed stationery, and print that to PDF via XFRX or
> whatever?
>
> --
>   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/cahm-jj2n+y3da6fii2_yuzyyyeho9ju+xyqpyg1f1u8awz1...@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.

Print salary receipts to a pdf image

[Rafael Copquin]

I have the following requirement:

Print a salary receipt to a company form, previously generated as a pdf file

The application calculates the monthly salaries of the company's personel
and issues a salary receipt for each employee.
Now they print the receipt to a preprinted form with te company logo and
the Treasurer's signature
But they want to have the blank form, with the logo and static text,
including the officer's signature on the form, to be filled with the salary
data, employee name, deductions, etc and print the whole on a blank sheet
by a laser printer.
In this way the company will save the cost of having preprinted forms. They
will simply use a letter size sheet to print each receipt

What do you suggest, please?
What about FoxyPreviewer, or any other software?

Perhaps ask the printing company to scan a blank form and produce a pdf
file, or another image file?

Please advise

Thank you

Rafael Copquin


--- 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/cahm-jj1qmloechkjkesd_uu6yitcoi0_1x0x9k4aubt4ehx...@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: Backup in SQL Server

[Rafael Copquin]

SQL Server 2012 Express

Rafael


El 11/09/2018 a las 10:18, Stephen Russell escribió:

What type of SQL Server version are you using?


sql server backup maintenance plan scheduled backup part-1

https://www.youtube.com/watch?v=K_0LDFsvQyQ



On Mon, Sep 10, 2018 at 3:34 PM Rafael Copquin 
wrote:


I am using the free tool (SQL Back Up Master) to perform backups of the
different SQL Server databases.

I installed it in my clients's computers, admonishing them to back up their
work every day, so I would not be responsible if any data loss occurs.

Most of my clients use it with no problems, but sometimes, they "forget" to
do their daily backup. (they are just too lazy or too much in a hurry to go
home after work, to spend the few minutes it takes to do the back up)

So I was thinking of embedding a back up routine in my app that would fire
when they shut down the app.

My idea is to call a stored procedure to do the backup.
However I do not know how to write such a procedure.
Could you help me on this, please?

Basically I want the database to be zipped (as SBM does) and send it to any
cloud repository, such as dropbox, google drive, one drive or an ftp site

Thanks
Rafael Copquin


--- 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/202bfc19-0604-90a0-24d1-fa2a0df7e...@yahoo.com.ar
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Backup in SQL Server

[Rafael Copquin]

I am using the free tool (SQL Back Up Master) to perform backups of the
different SQL Server databases.

I installed it in my clients's computers, admonishing them to back up their
work every day, so I would not be responsible if any data loss occurs.

Most of my clients use it with no problems, but sometimes, they "forget" to
do their daily backup. (they are just too lazy or too much in a hurry to go
home after work, to spend the few minutes it takes to do the back up)

So I was thinking of embedding a back up routine in my app that would fire
when they shut down the app.

My idea is to call a stored procedure to do the backup.
However I do not know how to write such a procedure.
Could you help me on this, please?

Basically I want the database to be zipped (as SBM does) and send it to any
cloud repository, such as dropbox, google drive, one drive or an ftp site

Thanks
Rafael Copquin


--- 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/CAHM-jJ2Ho+UoNeGDR_OEo5C3ycaX9ViUn22c2g=10616wwu...@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: alter column in sql server

[Rafael Copquin]

Thank you Kevin
Rafael

El jue., 6 sept. 2018 a las 12:03, Kevin J Cully ()
escribió:

> Take a look in the Downloads area for the Stru2PostgreSQL and Stru2MySQL_2
> program.  It should be pretty easy to modify those to get the structures
> generated.
>
> http://leafe.com/download/stru2postgreSQL.PRG
> http://leafe.com/download/stru2mysql_2.prg
>
> -Kevin
>
>
> -Original Message-
> From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ted Roche
> Sent: Thursday, September 06, 2018 10:34 AM
> To: profox@leafe.com
> Subject: Re: alter column in sql server
>
> Why not write the script in VFP and then cut-and-paste it into the SQL
> Server? Use AFIELDS to get the fieldlist, TEXTMERGE to write the script.
> Easy, peasy.
>
> On Thu, Sep 6, 2018 at 10:28 AM Rafael Copquin 
> wrote:
>
> > I need to import a DBF table into SQL Server However, all the fields
> > in the DBF table begin with the suffix ST (a previous programmer built
> > the table in 1992, with the notion that all fields should have a
> > specific suffix related to the table's purpose)
> >
> > But I just want the sql server table to have all its fields without
> > that suffix, ie: STACCT should become ACCT, STNAME should become NAME
> > and so on,
> >
> > The DBF table has 60 fields.
> >
> > I would like to issue an ALTER TABLE statement directly in the SQL
> > Server Management Studio to remove the ST suffix from all its fields.
> >
> > But I have no idea on how to build a stored procedure with something
> > similar to a DO WHILE loop in SQL Server, such that it would read a
> > field name, remove the ST suffix and alter the name as desired. And
> > then pass to the next field and do the same
> >
> > In fact, I must do the same with all the DBF tables from the old DOS
> > system, because I am converting it to a VFP9 app with a SQL Server
> > back end.
> >
> > Please show me a code snippet that would do that
> >
> > Thank you in advance
> >
> > Rafael Copquin
> >
> >
> > --- 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/cahm-jj0ezush43qhqutfh9nuyuepukqvhr-bcwjbmdwbhyj...@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.

alter column in sql server

[Rafael Copquin]

I need to import a DBF table into SQL Server
However, all the fields in the DBF table begin with the suffix ST (a
previous programmer built the table in 1992, with the notion that all
fields should have a specific suffix related to the table's purpose)

But I just want the sql server table to have all its fields without that
suffix, ie: STACCT should become ACCT, STNAME should become NAME and so on,

The DBF table has 60 fields.

I would like to issue an ALTER TABLE statement directly in the SQL Server
Management Studio to remove the ST suffix from all its fields.

But I have no idea on how to build a stored procedure with something
similar to a DO WHILE loop in SQL Server, such that it would read a field
name, remove the ST suffix and alter the name as desired. And then pass to
the next field and do the same

In fact, I must do the same with all the DBF tables from the old DOS
system, because I am converting it to a VFP9 app with a SQL Server back end.

Please show me a code snippet that would do that

Thank you in advance

Rafael Copquin


--- 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/CAHM-jJ2=YiH4U9okG8kR=ccyymgkeerxhftmc6ezzrej+vm...@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.

between clause in TSQL (from VFP9)

[Rafael Copquin]

I have a SQL Server table with client names. I need to select a range of
names from this list, but the between clause does not work well

Example; select all names begininng with A up to M

sql statement

select name from mydatabase.dbo.customers
where name between 'A%' and 'M%'
order by name

The result is a list of names beginning with A and up to L

To get the names beginning with M I need to write the where clause as
follows

where name between 'A%' and 'N%'

I also tried :

where name >= 'A%' and name <= 'M%'

The resultant list goes from A to L, it does not show the names beginning
with 'M'

What is the solution, please?

BTW, is there a range function in T-SQL, similar to Excel (A:M)?



Rafael Copquin




<http://www.avg.com/email-signature?utm_medium=email_source=link_campaign=sig-email_content=webmail>
Libre
de virus. www.avg.com
<http://www.avg.com/email-signature?utm_medium=email_source=link_campaign=sig-email_content=webmail>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>


--- 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/CAHM-jJ15fUs9AJo5tsdwvEbMfjnYN2-+F=y12j1jhcu2asy...@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: recno() function in t-sql

[Rafael Copquin]

I searched the internet and found an alternative answer that works

DECLARE @id INT
SET @id = 0
UPDATE mybase.dbo.invoices
SET @id = recnbr = @id + 1
GO

The above filled the recnbr column with a sequence of numbers starting 
with 1 incrementing by 1, which was my purpose


Thnaks again

Rafael



El 05/07/2018 a las 9:13, Rafael Copquin escribió:

Thank you

El mié., 4 de jul. de 2018 17:29, Darren <mailto:fox...@ozemail.com.au>> escribió:


Have a look at   SELECT ROW_NUMBER()  OVER(.) AS Recnbr,x,y,z

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com
<mailto:profoxtech-boun...@leafe.com>] On Behalf Of Rafael
Copquin
Sent: Thursday, 5 July 2018 5:30 AM
To: profoxt...@leafe.com <mailto:profoxt...@leafe.com>
Subject: recno() function in t-sql

What is the equivalent of therecno() function in t-sql

I need to fill a column called recnbr with the record number of
each line

In VFP it would be:

update mytable set recnbr = recno()

But since there is no recno() function in t-sql, what would be a
replacement?

TIA

Rafael Copquin


--- 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/508c75b2-c349-a1a2-39b9-28017426f...@yahoo.com.ar
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do 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: recno() function in t-sql

[Rafael Copquin]

Thank you

El mié., 4 de jul. de 2018 17:29, Darren  escribió:

> Have a look at   SELECT ROW_NUMBER()  OVER(.) AS Recnbr,x,y,z
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Rafael
> Copquin
> Sent: Thursday, 5 July 2018 5:30 AM
> To: profoxt...@leafe.com
> Subject: recno() function in t-sql
>
> What is the equivalent of therecno() function in t-sql
>
> I need to fill a column called recnbr with the record number of each line
>
> In VFP it would be:
>
> update mytable set recnbr = recno()
>
> But since there is no recno() function in t-sql, what would be a
> replacement?
>
> TIA
>
> Rafael Copquin
>
>
> --- 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/CAHM-jJ0fwHbppm024OaujmUiV_AVOjy3k0WL5Xt2WZjJmauB=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.

recno() function in t-sql

[Rafael Copquin]

What is the equivalent of therecno() function in t-sql

I need to fill a column called recnbr with the record number of each line

In VFP it would be:

update mytable set recnbr = recno()

But since there is no recno() function in t-sql, what would be a
replacement?

TIA

Rafael Copquin


--- 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/cahm-jj0pdw_sbfuedhvz4x5ojeumurow1vh3bboub7shbqt...@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 and sqlsever

[Rafael Copquin]

I need to update a sql server table with the number of each record in a 
field called recnbr


In vfp it would be

select mytable

update reccnbr with recno()

What would be the t-sql equivalent of recno() ?

IOW, knowing that _there is no_ recno() function in t-sql, what would be 
the update statement like?


TIA

Rafael Copquin






--- 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/2d6730c4-0f3d-96f4-14f2-b673b005e...@yahoo.com.ar
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do 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, SqlServer and NULL values

[Rafael Copquin]

Thank you Stephen
Very clear and exact

Rafael

2018-06-13 11:50 GMT-03:00 Stephen Russell :

> In SSMS run this script
> CREATE PROCEDURE newEmployee
> -- Add the parameters for the stored procedure here
> @name varchar(75)
> , @dob datetime = null
> AS
> BEGIN
> -- SET NOCOUNT ON added to prevent extra result sets from
> -- interfering with SELECT statements.
> SET NOCOUNT ON;
>
> Insert into Employees values(@name, @dob)
>
> END
> GO
>
> In your VP app:
>
> cCmd =  [exec newEmployee 'john Doe'  ]
>
> sqlexec(nHandle,cCmd)
>
> >From wherever you can do this
> select * from Employees
>
> You should see this:
>
> name dob
> john Doe NULL
>
> To get the date in use this statement:
> exec newEmployee 'Tommy Doe', '1997-01-05'
>
> You will now see  this:
> name dob
> john Doe NULL
> Tommy Doe 1997-01-05 00:00:00.000
>
> Let SQL do the work for you and just call that code for all your necessary
> functionality in the future.
>
>
>
>
> On Wed, Jun 13, 2018 at 9:30 AM Rafael Copquin 
> wrote:
>
> > I have a SQL Server 2012 Express table with a field called DOB of type
> DATE
> >
> > The field accepts NULL values and does not have a default value..
> >
> > To insert the DOB from VFP I transform it to the form '-MM-DD' and
> send
> > it as a character string.
> >
> > However, if the DOB is empty, the only way VFP inserts the record is if
> the
> > empty value is sent as ''
> > and the DOB field displays '1900-01-01' which is the value inserted.
> >
> > I want to insert NULL in the field, not '1900-01-01'
> >
> > If I use the SQL Server Management Studio, I can insert the NULL value
> > directly with this expression:
> >
> > insert into mydatabase.dbo.employees(name,dob) values( 'John Doe',NULL)
> >
> > However, this command, from VFP, does not insert the record:
> >
> > cCmd =  [insert into mydatabase.dbo.employees(name,dob) values( 'John
> > Doe',NULL) ]
> >
> > sqlexec(nHandle,cCmd)
> >
> >
> > How can I get the field to get the NULL value?
> >
> > TIA
> > Rafael Copquin
> >
> >
> > --- 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/cahm-jj3-f3_e_fqmh1e6jw+uqus-ogqog7ooxrjhadpkmom...@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, SqlServer and NULL values

[Rafael Copquin]

Thank you. It works well as you suggested but:

cName = 'RAFAEL'
vDOB = NULL

cCmd = 'insert into mydatabase.dbo.employees(name,dob) values
(?cName,?vDOB)'
sqlexec(nHandle,cCmd)

the above works, the below construct does not:


Text to cCmd textmerge noshow flags 2 pretext 15

insert into mydatabase.dbo.employees(name,dob) values ('<>',<>)

endtext

sqlexec(nHandle,cCmd)


Why?

I use text.. endtext most of the time, especially when the statements are
very long and occupy several lines.

Character strings are surrounded with '<<>>', numbers are <<>> and dates
are '<>'  (dates are converted to the form YYY-MM-DD)

Rafael



2018-06-13 11:49 GMT-03:00 Frank Cazabon :

> Don't pass the dates as strings, use parameters and set the blank date
> parameter to null prior to sending it:
>
> PRIVATE myDate AS Date
>
> myDate = DATE()
>
> IF EMPTY(m.myDate)
>
> m.myDate = NULL
>
> ENDIF
>
> m.lcSQL = "INSERT INTO myTable (myDateField) VALUES (?m.myDate)"
>
>
> Frank.
>
> Frank Cazabon
>
>
> On 13/06/2018 10:30 AM, Rafael Copquin wrote:
>
>> I have a SQL Server 2012 Express table with a field called DOB of type
>> DATE
>>
>> The field accepts NULL values and does not have a default value..
>>
>> To insert the DOB from VFP I transform it to the form '-MM-DD' and
>> send
>> it as a character string.
>>
>> However, if the DOB is empty, the only way VFP inserts the record is if
>> the
>> empty value is sent as ''
>> and the DOB field displays '1900-01-01' which is the value inserted.
>>
>> I want to insert NULL in the field, not '1900-01-01'
>>
>> If I use the SQL Server Management Studio, I can insert the NULL value
>> directly with this expression:
>>
>> insert into mydatabase.dbo.employees(name,dob) values( 'John Doe',NULL)
>>
>> However, this command, from VFP, does not insert the record:
>>
>> cCmd =  [insert into mydatabase.dbo.employees(name,dob) values( 'John
>> Doe',NULL) ]
>>
>> sqlexec(nHandle,cCmd)
>>
>>
>> How can I get the field to get the NULL value?
>>
>> TIA
>> Rafael Copquin
>>
>>
>> --- 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/cahm-jj3t+sedtmb531cix2yl5vofnj2h0vb8qjjfntigerq...@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.

VFP9, SqlServer and NULL values

[Rafael Copquin]

I have a SQL Server 2012 Express table with a field called DOB of type DATE

The field accepts NULL values and does not have a default value..

To insert the DOB from VFP I transform it to the form '-MM-DD' and send
it as a character string.

However, if the DOB is empty, the only way VFP inserts the record is if the
empty value is sent as ''
and the DOB field displays '1900-01-01' which is the value inserted.

I want to insert NULL in the field, not '1900-01-01'

If I use the SQL Server Management Studio, I can insert the NULL value
directly with this expression:

insert into mydatabase.dbo.employees(name,dob) values( 'John Doe',NULL)

However, this command, from VFP, does not insert the record:

cCmd =  [insert into mydatabase.dbo.employees(name,dob) values( 'John
Doe',NULL) ]

sqlexec(nHandle,cCmd)


How can I get the field to get the NULL value?

TIA
Rafael Copquin


--- 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/cahm-jj0klxpunmwftqlkntrcggfbj0sff4kj7fzrc8e+ik0...@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: Resetting VFP

[Rafael Copquin]

I use this:

DECLARE ExitProcess IN kernel32 INTEGER uExitCode
ExitProcess(0)

Put this code in your personal menu (that you attach to VFP), and/or as a
procedure in your app to exit the program.

This calls a Windows API that kills the VFP instance and closes all files.
It never fails.
In my personal menu I have an option called EMERGENCY EXIT.

When I click on it the VFP instance just dies and memory is clean

Rafael Copquin


<http://www.avg.com/email-signature?utm_medium=email_source=link_campaign=sig-email_content=webmail>
Libre
de virus. www.avg.com
<http://www.avg.com/email-signature?utm_medium=email_source=link_campaign=sig-email_content=webmail>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

2018-04-27 14:42 GMT-03:00 Fred Taylor <fbtay...@gmail.com>:

> CANCEL
> CLOSE ALL
> CLEAR ALL
>
> usually works for me.
>
>
> Fred
>
> On Fri, Apr 27, 2018 at 10:21 AM, Gene Wirchenko <ge...@telus.net> wrote:
>
> > Hello:
> >
> >  Sometimes, the coding is a breeze, and sometimes, it is not.
> >
> >  Suppose, because of bugs, incomplete functionality, etc., you have
> > just hung up VFP.
> >
> >  Is there a way to reset VFP?  Something that always works?
> >
> >  I know I can abort it and then restart it, but I have had to do so
> > dozens of times.  The thrill palls.
> >
> > 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/cahm-jj3y7z0uf1cewkuxm0hupjxtopryvzbfrpu60s_hfph...@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: Appending from a Cursor

[Rafael Copquin]

Append from dbf('yourcursor')

Rafael Copquin


El mié., 11 de abr. de 2018 15:02, Gene Wirchenko <ge...@telus.net>
escribió:

> Hello:
>
>   I have some code where I am importing transactions.  I have a
> cursor for these transactions where I validate them.  After doing
> this, I want to add them to the transaction table.  I select the
> transaction alias and then do
>append from (alimport)
>
>   alimport is an alias variable.  It works for creating the cursor:
>SQLSEL * from cwkt;
>where .f.;
>into cursor (alimport) readwrite nofilter
> It works to select the cursor:
>   select (alimport)
>
>   So why does the append not work?  I get error 1 with the text
> "File 'c:\cbs2dev\cutlblas_import.dbf' does not exist."
>
>   I figured out how to do this using SQL, but I would still like
> to know why the append does not work.
>
> 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/cahm-jj3akdth5ni-wfsa8w2lyuux8364kqib7nuhktzapc_...@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: persistence of sql server database in memory

[Rafael Copquin]

Thanks Stephen

That does not answer my question though. But it is illustrative of how
other companies want to hide sensitive data from snooping eyes (government,
nosy employees, competitors, etc)
In my client's case, it is about not sharing confidential sales data,
building plans and management salaries with the local staff
Some of their employees can steal this information and sell it to outsiders

And yes, the databases are on a desk PC

My problem is to determine why the data persists in memory and how to
prevent it

Rafael


<http://www.avg.com/email-signature?utm_medium=email_source=link_campaign=sig-email_content=webmail>
Libre
de virus. www.avg.com
<http://www.avg.com/email-signature?utm_medium=email_source=link_campaign=sig-email_content=webmail>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

2017-11-10 16:33 GMT-03:00 Rafael Copquin <rafael.copq...@gmail.com>:

> One of my clients uses a VFP9 app with MSSQL SERVER databases
>
> Two databases
>
>  database A  stored in the hard disk  (C:)
>
>  databaseB (with confidential data) stored in an external hard disk
> (E:)
>
> The Sql Server Management Studio correctly shows, in each database
> properties windows, in the files option, that the A database resides in
> disk C and the B database resides in disk E
>
> However, if I physically remove the hard disk (E:), the management studio
> still shows all tables of database B and select statements show data from
> the applicable tables.
>
> I thought that the data resides in memory in the cache. So I disconnected
> the SSMS from the engine, even turned off the SSMS. Then, when the SSMS was
> up again, it would still show the database B (even if its lodging HD was
> disconnected and put away in a drawer) and queries would still show data
> from any of the tables.
>
> What is going on?
>
> How can I prevent this "ghost" behaviour?
>
> It is very important that, when the external hard disk is removed, no
> confidential data can be read at all.
>
> Rafael Copquin
>
>
>
>
> ---
> Este correo electrónico ha sido comprobado en busca de virus por AVG.
> http://www.avg.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/CAHM-jJ3y9ubiqo0JtKCWUi4yFO_DwsbSxjXpP4Pxnai=r9g...@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.

persistence of sql server data in memory

[Rafael Copquin]

One of my clients uses a VFP9 app with MSSQL SERVER databases

Two databases

 database A  stored in the hard disk  (C:)

 databaseB (with confidential data) stored in an external hard disk 
(E:)


The Sql Server Management Studio correctly shows, in each database 
properties windows, in the files option, that the A database resides in 
disk C and the B database resides in disk E


However, if I physically remove the hard disk (E:), the management 
studio still shows all tables of database B and select statements show 
data from the applicable tables.


I thought that the data resides in memory in the cache. So I 
disconnected the SSMS from the engine, even turned off the SSMS. Then, 
when the SSMS was up again, it would still show the database B (even if 
its lodging HD was disconnected and put away in a drawer) and queries 
would still show data from any of the tables.


What is going on?

How can I prevent this "ghost" behaviour?

It is very important that, when the external hard disk is removed, no 
confidential data can be read at all.


Rafael Copquin



---
Este correo electrónico ha sido comprobado en busca de virus por AVG.
http://www.avg.com


___
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/5d2b6f20-7dfd-7e6e-d40f-b333adba9...@yahoo.com.ar
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

persistence of sql server database in memory

[Rafael Copquin]

One of my clients uses a VFP9 app with MSSQL SERVER databases

Two databases

 database A  stored in the hard disk  (C:)

 databaseB (with confidential data) stored in an external hard disk 
(E:)


The Sql Server Management Studio correctly shows, in each database 
properties windows, in the files option, that the A database resides in 
disk C and the B database resides in disk E


However, if I physically remove the hard disk (E:), the management 
studio still shows all tables of database B and select statements show 
data from the applicable tables.


I thought that the data resides in memory in the cache. So I 
disconnected the SSMS from the engine, even turned off the SSMS. Then, 
when the SSMS was up again, it would still show the database B (even if 
its lodging HD was disconnected and put away in a drawer) and queries 
would still show data from any of the tables.


What is going on?

How can I prevent this "ghost" behaviour?

It is very important that, when the external hard disk is removed, no 
confidential data can be read at all.


Rafael Copquin




---
Este correo electrónico ha sido comprobado en busca de virus por AVG.
http://www.avg.com


___
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/595118b3-8fef-4f9a-bcbf-03a4832f4...@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: WG: recno() function in tsql

[Rafael Copquin]

That works for dbf tables, but not for SQL Server tables

Thanks

Rafael Copquin



El 27/10/2017 a las 14:40, AndyHC escribió:

fwiw this works -
(use dbc, remote view, cursor adaptor, w.h.y for line 1  :-

SELECT * FROM somewhere WHERE type = "myType" INTO CURSOR tmp
SELECT RECNO() as id, * FROM tmp


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

recno() function in tsql

[Rafael Copquin]

Is there an equivalent to the VFP recno() function in T-SQL?

I'd like to create the following select statement in T-SQL:

select recno(),otherfields. from database.dbo.table

If there is not, what would be a substitute?

Rafael Copquin




---
Este correo electrónico ha sido comprobado en busca de virus por AVG.
http://www.avg.com


___
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/e97e84c8-0757-2ade-1110-3bbef9854...@yahoo.com.ar
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do 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 AWS from a VFP app

[Rafael Copquin]

You're absolutely right Stephen. I will not contest that.

Amazon does have a complete security scheme, but as I said before, my  
clients are not that fuzzy. They are small and very glad that they can 
be "on line" all the time, checking availability of products in any of 
their branches, etc., etc. And the HO staff being able to update prices, 
see how sales are developing, etc, etc.


If comes to security issues I would probably contract a AWS VPN or 
whatever is needed, but for now, I'm OK with what I've got.


Rafael


El 24/10/2017 a las 11:49, Stephen Russell escribió:

>From a security POV placing your database in the DMZ is not as secure as it
is behind that firewall.  When you place your systems in the Cloud that is
a benefit you define for yourself.

http://docs.aws.amazon.com/AmazonVPC/latest/UserGuide/VPC_Security.html

It is your customer's data and you should make it as secure as possible,
right?  Have you ever hired white hat hackers to test your vulnerability?
Some of our customers demand this before they sign trading partner
contracts with us.



On Tue, Oct 24, 2017 at 9:35 AM, <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:


On 2017-10-24 07:59, Rafael Copquin wrote:


Hi Michael

Yes you can! I don't know which of your presidents said that, but it
applies here I guess.

As I said in that post, I am an old programmer with very little
patience to read an enormous amount of information. But my son,
currently working for a US company as a software engineer enlightened
me and helped me set it up.

I opened an account in AWS, and for a year I shall be able to use
their services for free. In AWS you have something they call RDS,
which is basically what I was looking for: a SQL Server as a service,
meaning all I need is to instance a SQL Server and work from anywhere
accessing all of the databases. And I will just pay for what I use and
for the time I use it. it has to do with hours per month, or number of
clicks or whatever, but it will amount to no more that 50 bucks, for
what I gather.

They have MySQL also as a service I believe, but since I only deal
with SQL Server, I would not know how good that is.

But the important thing here is you do not need to get a VM with a SQL
engine inside, which is the case with Google Cloud Computing. You can
get one though, through a different service they call EC2 and EC3, but
that is too much for my limited purposes. (I have small clients, with
few stores to operate, so I do not need too much complexity)

In my case, I simply create a ODBC connection string and use it in my
VFP app, accessing the AWS SQL Server with as much ease as I can
access the LAN server.

BTW, because in my country sometimes we have problems with the
internet service, I implemented a special routine that will access a
local server as well. In case there is a connection failure, the
stores work locally and then, when the service is restored, the
routine updates the cloud server with all the transactions missed. No
big deal there.

I know I could set up a replication paradigm, but then it costs more
money and my stingy clients do not like to pay too much.

I hope it helps

Regards

Rafael Copquin




Thanks, Rafael!  This sounds exactly like what I was talking about.
Currently, my ISP hosts my MySQL (MariaDB) databases and I just use a
simple SQLSTRINGCONNECT handle to work with it, as though it were on the
local LAN.  Costwise I think he's great for what I'm doing, but you know
how the buzzwords sell magazines so to speak and if I could use a database
on AWS that would allow me to market "using the AWS Cloud" as well.  That
brings credibility.

Glad it's this easy.  It should be!



[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/7fe2d6dc-5130-787b-17ab-67b479b2d...@yahoo.com.ar
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do 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 AWS from a VFP app

[Rafael Copquin]

Hi Michael

Yes you can! I don't know which of your presidents said that, but it 
applies here I guess.


As I said in that post, I am an old programmer with very little patience 
to read an enormous amount of information. But my son, currently working 
for a US company as a software engineer enlightened me and helped me set 
it up.


I opened an account in AWS, and for a year I shall be able to use their 
services for free. In AWS you have something they call RDS, which is 
basically what I was looking for: a SQL Server as a service, meaning all 
I need is to instance a SQL Server and work from anywhere accessing all 
of the databases. And I will just pay for what I use and for the time I 
use it. it has to do with hours per month, or number of clicks or 
whatever, but it will amount to no more that 50 bucks, for what I gather.


They have MySQL also as a service I believe, but since I only deal with 
SQL Server, I would not know how good that is.


But the important thing here is you do not need to get a VM with a SQL 
engine inside, which is the case with Google Cloud Computing. You can 
get one though, through a different service they call EC2 and EC3, but 
that is too much for my limited purposes. (I have small clients, with 
few stores to operate, so I do not need too much complexity)


In my case, I simply create a ODBC connection string and use it in my 
VFP app, accessing the AWS SQL Server with as much ease as I can access 
the LAN server.


BTW, because in my country sometimes we have problems with the internet 
service, I implemented a special routine that will access a local server 
as well. In case there is a connection failure, the stores work locally 
and then, when the service is restored, the routine updates the cloud 
server with all the transactions missed. No big deal there.


I know I could set up a replication paradigm, but then it costs more 
money and my stingy clients do not like to pay too much.


I hope it helps

Regards

Rafael Copquin


El 23/10/2017 a las 20:28, mbsoftwaresoluti...@mbsoftwaresolutions.com 
escribió:

On 2017-10-23 16:49, Stephen Russell wrote:
I don't think that you can just stand up your data there in AWS.  I 
believe
that you must expose it via an API.  You pass in params to your 
method and

it spits out data in XML or json.



Now to be very clear, I'm not talking about using DBFs -- I'm talking 
about backends like SQL Server, MySQL, Oracle, etc.from a VFP app.



[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/9ab8448d-a531-4542-133c-21c61a92c...@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: Email with CDO error

[Rafael Copquin]

I used a similar code.  Actually what I had to do was put the original code
(the one quoted in my first email on this) in a prg, called from the form

I had this code within a loop (that iterated some 400 times) in my
send_email form. But it would not work. When I took the code out of the
form and placed it into a prg, it worked!

A pseudocode of my form calling the prg is:

select curInvoices

scan all

   cTo = alltrim(curInvoices.email)&& get the email from each
customer

  cAttach = alltrim(curInvoices.invoice)   && contains path to the pdf
and its individual name

  do sendemail with cTo,cAttach
endscan

I also put a counter to iterate 10 times, then wait 15 seconds and then
pick another ten emails and so on. This is to avoid gmail rejecting a big
load of emails sent at once.

Of course I had to turn on the 'less secure apps' setting on the Gmail
account first, and then it worked perfectly.

I wonder why it would not work with the cdo code directly on the form. BTW,
my client runs this app from a Windows 7 prof computer, for what its worth.

Thank you all for your suggestions

Rafael Copquin



El 26/09/2017 a las 7:54, Alan Bourke escribió:

I've just tested this code and it sent successfully, but not until I
turned on the 'less secure apps' setting on the Gmail account.
https://gist.github.com/anonymous/ddb479e315bcc45efb0d4703fc05b836




<http://www.avg.com/email-signature?utm_medium=email_source=link_campaign=sig-email_content=webmail>
Libre
de virus. www.avg.com
<http://www.avg.com/email-signature?utm_medium=email_source=link_campaign=sig-email_content=webmail>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>


--- 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/CAHM-jJ1eJ98OdeFcErf4pMZsXySj4HUM06JN=06qd2w_hth...@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: email with CDO error

[Rafael Copquin]

I used a similar code. Actually what I had to do was put the original 
code (the one quoted in my first email on this) in a prg, called from 
the form


I had this code within a loop (that iterated some 400 times) in my 
send_email form. But it would not work. When I took the code out of the 
form and placed it into a prg, it worked!


A pseudocode of my form calling the prg is:

select curInvoices

scan all

   cTo = alltrim(curInvoices.email)    && get the email from each 
customer


  cAttach = alltrim(curInvoices.invoice)   && contains path to the 
pdf and its individual name


  do sendemail with cTo,cAttach

endscan

I also put a counter to iterate 10 times, then wait 15 seconds and then 
pick another ten emails and so on. This is to avoid gmail rejecting a 
big load of emails sent at once.


Of course I had to turn on the 'less secure apps' setting on the Gmail 
account first, and then it worked perfectly.


I wonder why it would not work with the cdo code directly on the form. 
BTW, my client runs this app from a Windows 7 prof computer, for what 
its worth.


Thank you all for your suggestions

Rafael Copquin


El 26/09/2017 a las 7:54, Alan Bourke escribió:

I've just tested this code and it sent successfully, but not until I
turned on the 'less secure apps' setting on the Gmail account.

https://gist.github.com/anonymous/ddb479e315bcc45efb0d4703fc05b836 
<https://gist.github.com/anonymous/ddb479e315bcc45efb0d4703fc05b836>






---
Este correo electrónico ha sido comprobado en busca de virus por AVG.
http://www.avg.com


--- 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/50572783-d5d7-08b2-2142-97648b639...@yahoo.com.ar
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do 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: Email with CDO error

[Rafael Copquin]

I used a similar code.  Actually what I had to do was put the original 
code (the one quoted in my first email on this) in a prg, called from 
the form


I had this code within a loop (that iterated some 400 times) in my 
send_email form. But it would not work. When I took the code out of the 
form and placed it into a prg, it worked!


A pseudocode of my form calling the prg is:

select curInvoices

scan all

   cTo = alltrim(curInvoices.email)    && get the email from each 
customer


  cAttach = alltrim(curInvoices.invoice)   && contains path to the 
pdf and its individual name


  do sendemail with cTo,cAttach

endscan

I also put a counter to iterate 10 times, then wait 15 seconds and then 
pick another ten emails and so on. This is to avoid gmail rejecting a 
big load of emails sent at once.


Of course I had to turn on the 'less secure apps' setting on the Gmail 
account first, and then it worked perfectly.


I wonder why it would not work with the cdo code directly on the form. 
BTW, my client runs this app from a Windows 7 prof computer, for what 
its worth.


Thank you all for your suggestions

Rafael Copquin



El 26/09/2017 a las 7:54, Alan Bourke escribió:

I've just tested this code and it sent successfully, but not until I
turned on the 'less secure apps' setting on the Gmail account.

https://gist.github.com/anonymous/ddb479e315bcc45efb0d4703fc05b836






---
Este correo electrónico ha sido comprobado en busca de virus por AVG.
http://www.avg.com


___
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/814435b7-ff39-12f2-430b-a943c24fd...@yahoo.com.ar
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do 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: Email with CDO error

[Rafael Copquin]

I did that and it still does not work. I get the same error message
Rafael

Enviado desde Correo para Windows 10

De: Koen Piller
Enviado: lunes, 25 de septiembre de 2017 12:33
Para: profoxt...@leafe.com
Asunto: Re: Email with CDO error

Hi,
Please check and compare your code against the working procedure by Sergey
:

https://www.berezniker.com/content/pages/visual-foxpro/send-email-gmail-account

Regards,

Koen

2017-09-25 17:30 GMT+02:00 Fred Taylor <fbtay...@gmail.com>:

> Is your smtpconnectiontimeout setting of 10, too small?  I've never changed
> that setting from whatever it's default is and send 100's of emails a day
> using similar code.
>
>
> Fred
>
> On Mon, Sep 25, 2017 at 8:21 AM, Rafael Copquin <rafael.copq...@gmail.com>
> wrote:
>
> > I am trying to send emails from VFP using CDO. This is a system that
> needs
> > to send pdf images of invoices to 400+ customers.
> >
> > I opened accounts in gmail, yahoo and hotmail and always get the same
> > error message:
> >
> > error 1429 Ole dispatch exception code 0 from CDO.Messsage.1:Transport
> > error connecting to server
> >
> > This is my code:
> >
> > loCfg=CREATEOBJECT("CDO.Configuration")
> > WITH loCfg.Fields
> > ..Item("http://schemas.microsoft.com/cdo/configuration/smtpserver;) = "
> > smtp.gmail.com"
> > ..Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport;)
> =
> > 465
> > ..Item("http://schemas.microsoft.com/cdo/configuration/sendusing;) = 2
> > ..Item("http://schemas.microsoft.com/cdo/configuration/smtpc
> > onnectiontimeout") = 10
> > ..Item("http://schemas.microsoft.com/cdo/configuration/sendusername;) =
> "
> > myacco...@gmail.com"
> > ..Item("http://schemas.microsoft.com/cdo/configuration/sendpassword;) =
> > "mypassword"
> > ..Item("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate
> ")
> > = .t.
> > ..Item("http://schemas.microsoft.com/cdo/configuration/smtpusessl;) =
> .t.
> > .Update
> > ENDWITH
> >
> > loMsg = CREATEOBJECT ("CDO.Message")
> >
> > WITH loMsg
> > ..Configuration = loCfg
> > ..From = "myacco...@gmail.com"
> > ..To = 'myotheracco...@hotmail.com'
> > ..Subject = 'Enviamos factura electrónica'
> > ..TextBody = 'Please find attached your invoice for the month of October
> > 2017'
> > ..AddAttachment('c:\invoices\fe_261_092017_1.pdf')
> > ..Send()
> > endwith
> >
> >
> > loCfg = NULL
> > loMsg = NULL
> >
> > Either with an attachment or without one, I get the same error.
> > I configured gmail to accept sending from "unsafe" apps (is VFP an unsafe
> > app?). Did the same in yahoo and in hotmail.
> > But I always get the same error
> >
> > What I am doing wrong?
> > What is the workaround?
> >
> > NOTE: this happens even if I try to send just one message, let alone 400+
> > TIA
> > Rafael Copquin
> >
> >
> >
> >
> >
> >
> > ---
> > Este correo electrónico ha sido comprobado en busca de virus por AVG.
> > http://www.avg.com
> >
> >
> > --- StripMime Report -- processed MIME parts ---
> > multipart/alternative
> >  text/plain (text body -- kept)
> >  text/html
> > ---
> >
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/160559.75285...@smtp203.mail.gq1.yahoo.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 with CDO error

[Rafael Copquin]

I am trying to send emails from VFP using CDO. This is a system that 
needs to send pdf images of invoices to 400+ customers.


I opened accounts in gmail, yahoo and hotmail and always get the same 
error message:


error 1429 Ole dispatch exception code 0 from CDO.Messsage.1:Transport 
error connecting to server


This is my code:

loCfg=CREATEOBJECT("CDO.Configuration")
WITH loCfg.Fields
..Item("http://schemas.microsoft.com/cdo/configuration/smtpserver;) = 
"smtp.gmail.com"
..Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport;) = 
465

..Item("http://schemas.microsoft.com/cdo/configuration/sendusing;) = 2
..Item("http://schemas.microsoft.com/cdo/configuration/smtpconnectiontimeout;) 
= 10
..Item("http://schemas.microsoft.com/cdo/configuration/sendusername;) = 
"myacco...@gmail.com"
..Item("http://schemas.microsoft.com/cdo/configuration/sendpassword;) = 
"mypassword"
..Item("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate;) 
= .t.

..Item("http://schemas.microsoft.com/cdo/configuration/smtpusessl;) = .t.
    .Update
ENDWITH

loMsg = CREATEOBJECT ("CDO.Message")

WITH loMsg
..Configuration = loCfg
..From = "myacco...@gmail.com"
..To = 'myotheracco...@hotmail.com'
..Subject = 'Enviamos factura electrónica'
..TextBody = 'Please find attached your invoice for the month of October 
2017'

..AddAttachment('c:\invoices\fe_261_092017_1.pdf')
..Send()
endwith


loCfg = NULL
loMsg = NULL

Either with an attachment or without one, I get the same error.
I configured gmail to accept sending from "unsafe" apps (is VFP an 
unsafe app?). Did the same in yahoo and in hotmail.

But I always get the same error

What I am doing wrong?
What is the workaround?

NOTE: this happens even if I try to send just one message, let alone 400+
TIA
Rafael Copquin






---
Este correo electrónico ha sido comprobado en busca de virus por AVG.
http://www.avg.com


--- 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/7a37518f-6760-0bf3-6560-de6475e81...@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 and CDO banging my head against the wall

[Rafael Copquin]

Hi Mike

I do not understand your message :-)

See below how I got it

BTW folks. I found the reason.

It is the way the security is configured in Yahoo.

In the security section I allowed receiving messages for "unsafe" apps 
and it worked flawlessly


Thanks anyways

Rafael



El 04/09/2017 a las 18:24, Mike escribió:

RmlyZXdhbGwgYmxvY2tpbmcgdGhlIHBvcnQocykgeW91IG5lZWQgb24gdGhlIG1hY2hpbmUgdGhh
dCBpcyBmYWlsaW5nP8KgCk1pa2XCoAoKClNlbnQgZnJvbSBteSBTcHJpbnQgU2Ftc3VuZyBHYWxh
eHkgUzcgZWRnZS4KLS0tLS0tLS0gT3JpZ2luYWwgbWVzc2FnZSAtLS0tLS0tLUZyb206IFJhZmFl
bCBDb3BxdWluIDxyYWZhZWwuY29wcXVpbkBnbWFpbC5jb20+IERhdGU6IDkvNC8xNyAgMzo0MyBQ
TSAgKEdNVC0wNjowMCkgVG86IHByb2ZveHRlY2hAbGVhZmUuY29tIFN1YmplY3Q6IFZGUCBhbmQg
Q0RPIGJhbmdpbmcgbXkgaGVhZCBhZ2FpbnN0IHRoZSB3YWxsIApJZiBJIHVzZSBteSBvd24geWFo
b28gcGVyc29uYWwgYWNjb3VudCB0byBzZW5kIHRoaXMgZW1haWwsIF9pdCB3b3JrcyAKYmVhdXRp
ZnVsbHkuXwoKSG93ZXZlciwgSSBoYWQgbXkgY2xpZW50IG9wZW4gYSB5YWhvbyBhY2NvdW50IHNv
IHRoZXkgY2FuIHNlbmQgdGhlaXIgb3duIAplbWFpbHMgZnJvbSBWRlAgYW5kIEkgZ2V0IHRoZSBt
ZXNzYWdlOiBzZXJ2ZXIgdW5hdmFpbGFibGUgb3IgZmFpbGVkIHRvIApjb25uZWN0IHRvIHNlcnZl
ci4KCkkgdHJpZWQgdGhpcyBmcm9tIHRocmVlIGRpZmZlcmVudCBtYWNoaW5lcyB3aXRoIHRoZSBz
YW1lIHJlc3VsdC4KCkFuZCB0aGUgc2FtZSBoYXBwZW5zIHdpdGggZ21haWwuIFRyeWluZyB0byBz
ZW5kIHRoZSBlbWFpbCBmcm9tIGdtYWlsLCAKdXNpbmfCoCBzbXRwLmdtYWlsLmNvbSBmb3IgdGhl
IG91dGdvaW5nIHNlcnZlciwgSSBnZXQgdGhlIHNhbWUgcmVzdWx0LgoKQlRXLCBpdCBiYXJmcyBp
biB0aGUgc2VuZCgpIGxpbmUKCgrCoMKgwqDCoCBsb0NmZyA9IENSRUFURU9CSkVDVCgiQ0RPLkNv
bmZpZ3VyYXRpb24iKQrCoMKgwqDCoCBXSVRIIGxvQ2ZnLkZpZWxkcwouSXRlbSgiaHR0cDovL3Nj
aGVtYXMubWljcm9zb2Z0LmNvbS9jZG8vY29uZmlndXJhdGlvbi9zbXRwc2VydmVyIikgPSAKInNt
dHAubWFpbC55YWhvby5jb20iCi5JdGVtKCJodHRwOi8vc2NoZW1hcy5taWNyb3NvZnQuY29tL2Nk
by9jb25maWd1cmF0aW9uL3NtdHBzZXJ2ZXJwb3J0IikgPSA0NjUKLkl0ZW0oImh0dHA6Ly9zY2hl
bWFzLm1pY3Jvc29mdC5jb20vY2RvL2NvbmZpZ3VyYXRpb24vc2VuZHVzaW5nIikgPSAyCi5JdGVt
KCJodHRwOi8vc2NoZW1hcy5taWNyb3NvZnQuY29tL2Nkby9jb25maWd1cmF0aW9uL3NlbmR1c2Vy
bmFtZSIpID0gCiJteWNsaWVudGFjY291bnRAeWFob28uY29tIgouSXRlbSgiaHR0cDovL3NjaGVt
YXMubWljcm9zb2Z0LmNvbS9jZG8vY29uZmlndXJhdGlvbi9zZW5kcGFzc3dvcmQiKSA9IAoiaGlz
cGFzc3dvcmQiCi5JdGVtKCJodHRwOi8vc2NoZW1hcy5taWNyb3NvZnQuY29tL2Nkby9jb25maWd1
cmF0aW9uL3NtdHBhdXRoZW50aWNhdGUiKSAKPSAudC4KLkl0ZW0oImh0dHA6Ly9zY2hlbWFzLm1p
Y3Jvc29mdC5jb20vY2RvL2NvbmZpZ3VyYXRpb24vc210cHVzZXNzbCIpID0gLnQuCsKgwqDCoMKg
wqDCoCAuVXBkYXRlCsKgwqDCoMKgIEVORFdJVEgKCsKgwqDCoMKgIGxvTXNnID0gQ1JFQVRFT0JK
RUNUICgiQ0RPLk1lc3NhZ2UiKQrCoMKgwqDCoCBXSVRIIGxvTXNnCsKgwqDCoMKgwqDCoCAuQ29u
ZmlndXJhdGlvbiA9IGxvQ2ZnCsKgwqDCoMKgwqDCoCAuRnJvbSA9ICJteWNsaWVudGFjY291bnRA
eWFob28uY29tIgoKwqDCoMKgwqDCoMKgIC5UbyA9ICdyYWZhZWwuY29wcXVpbkBnbWFpbC5jb20n
CgoKwqDCoMKgwqDCoMKgIC5TdWJqZWN0ID0gIlRlc3QiCsKgwqDCoMKgwqDCoCAuVGV4dEJvZHkg
PSAiSGVsbG8gIgoKwqDCoMKgwqDCoMKgIC5TZW5kKCkKwqDCoMKgwqAgRU5EV0lUSAoKCkkgZ29v
Z2xlZCBmb3IgYSBzb2x1dGlvbiBhbmQgdGhleSBzYXkgdG8gdHJ5IHRvIGNoYW5nZSB0aGUgb3V0
Z29pbmcgcG9ydCAKdG8gNTg3LCB0byBubyBhdmFpbAoKV2hhdCB0aGUgaGVjayBpcyBnb2luZyBv
bj8/CgpTb3JyeSwgbXkgYmFkIHRlbXBlciBjb250cm9sbGVkIG1lCgpSYWZhZWwgQ29wcXVpbgoK
CgoKLS0tCkVzdGUgY29ycmVvIGVsZWN0csODwrNuaWNvIGhhIHNpZG8gY29tcHJvYmFkbyBlbiBi
dXNjYSBkZSB2aXJ1cyBwb3IgQVZHLgpodHRwOi8vd3d3LmF2Zy5jb20KCgotLS0gU3RyaXBNaW1l
IFJlcG9ydCAtLSBwcm9jZXNzZWQgTUlNRSBwYXJ0cyAtLS0KbXVsdGlwYXJ0L2FsdGVybmF0aXZl
CsKgIHRleHQvcGxhaW4gKHRleHQgYm9keSAtLSBrZXB0KQrCoCB0ZXh0L2h0bWwKLS0tCgpfX19f
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fXwpQb3N0IE1lc3NhZ2Vz
IHRvOiBQcm9Gb3hAbGVhZmUuY29tClN1YnNjcmlwdGlvbiBNYWludGVuYW5jZTogaHR0cDovL21h
aWwubGVhZmUuY29tL21haWxtYW4vbGlzdGluZm8vcHJvZm94Ck9ULWZyZWUgdmVyc2lvbiBvZiB0
aGlzIGxpc3Q6IGh0dHA6Ly9tYWlsLmxlYWZlLmNvbS9tYWlsbWFuL2xpc3RpbmZvL3Byb2ZveHRl
Y2gKU2VhcmNoYWJsZSBBcmNoaXZlOiBodHRwOi8vbGVhZmUuY29tL2FyY2hpdmVzL3NlYXJjaC9w
cm9mb3gKVGhpcyBtZXNzYWdlOiBodHRwOi8vbGVhZmUuY29tL2FyY2hpdmVzL2J5TUlEL3Byb2Zv
eC9hZGEzNDA0ZC1lYTI3LTE2NjQtOWI5Yy0zMGEwNDRiNTQ5YzNAZ21haWwuY29tCioqIEFsbCBw
b3N0aW5ncywgdW5sZXNzIGV4cGxpY2l0bHkgc3RhdGVkIG90aGVyd2lzZSwgYXJlIHRoZSBvcGlu
aW9ucyBvZiB0aGUgYXV0aG9yLCBhbmQgZG8gbm90IGNvbnN0aXR1dGUgbGVnYWwgb3IgbWVkaWNh
bCBhZHZpY2UuIFRoaXMgc3RhdGVtZW50IGlzIGFkZGVkIHRvIHRoZSBtZXNzYWdlcyBmb3IgdGhv
c2UgbGF3eWVycyB3aG8gYXJlIHRvbyBzdHVwaWQgdG8gc2VlIHRoZSBvYnZpb3VzLgpSZXBvcnQg
W09UXSBBYnVzZTogaHR0cDovL2xlYWZlLmNvbS9yZXBvcnRBYnVzZS9hZGEzNDA0ZC1lYTI3LTE2
NjQtOWI5Yy0zMGEwNDRiNTQ5YzNAZ21haWwuY29t


--- 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/e1ce95d5-d72d-ce6b-2b16-a853d22d1...@gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This 

VFP and CDO banging my head against the wall

[Rafael Copquin]

If I use my own yahoo personal account to send this email, _it works 
beautifully._


However, I had my client open a yahoo account so they can send their own 
emails from VFP and I get the message: server unavailable or failed to 
connect to server.


I tried this from three different machines with the same result.

And the same happens with gmail. Trying to send the email from gmail, 
using  smtp.gmail.com for the outgoing server, I get the same result.


BTW, it barfs in the send() line


loCfg = CREATEOBJECT("CDO.Configuration")
WITH loCfg.Fields
.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver;) = 
"smtp.mail.yahoo.com"

.Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport;) = 465
.Item("http://schemas.microsoft.com/cdo/configuration/sendusing;) = 2
.Item("http://schemas.microsoft.com/cdo/configuration/sendusername;) = 
"myclientacco...@yahoo.com"
.Item("http://schemas.microsoft.com/cdo/configuration/sendpassword;) = 
"hispassword"
.Item("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate;) 
= .t.

.Item("http://schemas.microsoft.com/cdo/configuration/smtpusessl;) = .t.
  .Update
ENDWITH

loMsg = CREATEOBJECT ("CDO.Message")
WITH loMsg
  .Configuration = loCfg
  .From = "myclientacco...@yahoo.com"

  .To = 'rafael.copq...@gmail.com'


  .Subject = "Test"
  .TextBody = "Hello "

  .Send()
ENDWITH


I googled for a solution and they say to try to change the outgoing port 
to 587, to no avail


What the heck is going on??

Sorry, my bad temper controlled me

Rafael Copquin




---
Este correo electrónico ha sido comprobado en busca de virus por AVG.
http://www.avg.com


--- 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/ada3404d-ea27-1664-9b9c-30a044b54...@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] Amazon Web Services/Azure/Google Cloud Computing

[Rafael Copquin]

thank you all for your replies

Rafael Copquin



---
Este correo electrónico ha sido comprobado en busca de virus por AVG.
http://www.avg.com


___
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/5c475c5f-7214-ea17-0ef2-6c2c0f680...@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.

[NF] Amazon Web Services/Azure/Google Cloud Computing

[Rafael Copquin]

I am experimenting with cloud computing.

A client of mine who is currently using a Microsoft SQL Server based 
application, wishes to have the SQL Server database in the cloud so it 
can be accessible by all his company's branches.


I would like to know if Amazon is offering SQL Server as a service. I am 
aware that if you contract a Virtual Machine with SQL Server inside you 
would have the problem solved, but I wonder if it is possible to use SQL 
Server without the need to have a VM as well


In the case of Google Cloud Computing, you must have a virtual machine 
and SQL Server inside


I have tried Azure and I've seen that they offer SQL Server as a 
service, but if you want to get in a single select statement data from 
two different databases, that is not possible, unless you try a 
convoluted solution that I got from the web and that would involve 
modifying my application code a lot. This I will not do (the client 
won't pay for the time involved in  reprogramming)


OTOH, the information provided in any of those sites is so huge and 
confusing, that I do not know what to choose, where to look and..too 
much for this old programmer.


Can anybody enlighten me, please?

Remember, I am looking for a simple SQL Server as a service solution, 
without the need to get a VM as well. Is this possible?


Rafael Copquin


---
Este correo electrónico ha sido comprobado en busca de virus por AVG.
http://www.avg.com


___
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/8e7cd088-3acc-c85c-e4b0-c99bbb06d...@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: numeric overflow

[Rafael Copquin]

Thank you
Rafael Copquin


El 07/07/2017 a las 15:57, Paul H. Tarver escribió:

I sometimes run into this with variables and/or fields. In either case, you
can pre-test a value and/or format using the transform() function as well.

If TRANSFORM(a,"@L 999.99") = "***.**"
Endif

The nice thing about this method is you can control exactly the format of
the value you are testing.

Alternate test:

If occurs('*',TRANSFORM(a,"@L 999.99") ) > 0
Endif

Paul H. Tarver
Tarver Program Consultants, Inc.
Email: p...@tpcqpc.com



-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Rafael
Copquin
Sent: Friday, July 07, 2017 12:22 PM
To: profoxt...@leafe.com
Subject: numeric overflow

I wonder if there is a way to detect that a numeric field in a record is
filled with  as a result of a numeric overflow in a calculation

Please enlighten me

Rafael Copquin


---
Este correo electrónico ha sido comprobado en busca de virus por AVG.
http://www.avg.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/59634d5f@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: numeric overflow

[Rafael Copquin]

Pretty smart!
Thank you
Rafael

El 07/07/2017 a las 14:44, Fred Taylor escribió:

IsOverflow(tnVal)
>LOCAL cVal, lStat
>m.cVal = STR(m.tnVal)
>IF m.cVal="*"
>   m.lStat = .t.
>ENDIF
>RETURN m.lStat



---
Este correo electrónico ha sido comprobado en busca de virus por AVG.
http://www.avg.com


___
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/595fcf9d.50...@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.

numeric overflow

[Rafael Copquin]

I wonder if there is a way to detect that a numeric field in a record is 
filled with  as a result of a numeric overflow in a calculation


Please enlighten me

Rafael Copquin


---
Este correo electrónico ha sido comprobado en busca de virus por AVG.
http://www.avg.com


___
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/595fc352.1030...@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 and Gmail

[rafael copquin]

So what you're saying is to send the emails in batches of no more than 
15, wait about 30 seconds and go on?


Rafael



On 06/06/2017 10:57, Tracy Pearson wrote:

rafael copquin wrote on 2017-06-06:

  I just delivered a new system which includes a mailing function.
  
  The client needs to send 500 to 700 invoices per month to its customers,

  in PDF format.
  
  They use gmail
  
  Question:
  
  How many emails does Gmail accept to be mailed in a single shot?
  
  I was told that they have a limit which, when surpassed, blocks Gmail
  
  Anybody?
  
  Thank you
  
  Rafael Copquin




Rafael,

When sending through Google mail servers, I have found the following
prevents issues with the servers shutting the account down for the day.
 sending 15 emails during a single connection
 pause 200 milliseconds between each email in the connection
 wait 5 seconds before reconnecting

Different providers require finessing, so these are something the user can
adjust in my software.

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/78cff6ef-5aab-8947-edfa-da5e6afb4...@yahoo.com.ar
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do 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 and Gmail

[rafael copquin]

I just delivered a new system which includes a mailing function.

The client needs to send 500 to 700 invoices per month to its customers, 
in PDF format.


They use gmail

Question:

How many emails does Gmail accept to be mailed in a single shot?

I was told that they have a limit which, when surpassed, blocks Gmail

Anybody?

Thank you

Rafael Copquin



___
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/afc0f606-f32a-3abb-4548-50192cf4c...@fibertel.com.ar
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do 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: generate pdf files by batch and send them by email

[rafael copquin]

thank you

Rafael



On 16/05/2017 17:48, Ted Roche wrote:

I've done this all with paid solutions, but FoxyPreviewer is supposed
to be able to do it all:

https://foxypreviewer.codeplex.com/

On Tue, May 16, 2017 at 4:37 PM,  <rafael.copq...@gmail.com> wrote:

I need to generate a batch of invoices in PDF format and then send them 
automatically by email
I’ve been exploring the web for some meaningful code but most examples are in VB
1. I have a cursor with N invoices and all pertinent header data
2. I want to generate N PDF files with all the invoice data and sabe them to a 
designated folder
3. I need to email them, one by one, to the respective customers
I know this has been done zillions of times but in my case I never did it for 
batches and would appreciate an example on:
1. How to generate the PDF files
2. How to save them in a particular folder
3. How to email them
Needles to add that the solutions have to be in VFP and FREE
TIA
Rafael Copquin





--- 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/9a2869d3-79c1-a94c-3147-bd9291700...@yahoo.com.ar
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do 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] Anti-Virus Programs

[rafael copquin]

Ditto here. Kaspersky rocks!

Rafael Copquin

On 20/02/2017 18:59, Stephen Russell wrote:

Kaspersky has been my go to for the past 8 years or more.  You can get a 3
pack license with rebate, for under 15 USD and it used to be free in the
old days.

I like how it hooks into chrome and will give you a heads up on a site not
being safe to continue to but letting you still make a dumb mistake on your
own if you so wanted to.

On Mon, Feb 20, 2017 at 3:32 PM, John Weller <j...@johnweller.co.uk> wrote:


I have been asked to give a talk to a local pensioner's organisation on
internet security.  One of the points I will make is that you need a good
anti-virus.  I have used M$ Security Essentials and now Windows Defender on
Win 10 for some years without any problems, largely as a result of
recommendations here.  In a recent magazine article in UK they were saying
that Defender is not very good only picking up 75% of viruses in a test.
They were advocating Kaspersky; the fact that they were offering it at a
discount but were undoubtedly getting a cut may have influenced their
decision.  What anti-virus are you using?  Do you still recommend Defender?
Any thoughts or comments?  I will be recommending one to the pensioners so
will be going for one of the free ones.

Thanks

John

John Weller
01380 723235
07976 393631




[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/73489f40-adce-f501-44cf-2c0bfefcd...@fibertel.com.ar
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: SQL Backend Question - Part Deux

[rafael copquin]

Not necessarily. It depends on a natural predisposition to learn and 
assimilate a language. For instance my grandfather was Ucrainian. He 
lived in Argentina for over 50 years and could never speak Spanish 
fluently. He spoke in Russian to my grannie and she, who was a very 
competent speaker (and cook) would translate for us kids what the old 
man wanted to say. Though vodka was easy to understand and no 
translation was needed there.:-)


Rafael



On 10/02/2017 5:30, Thierry Nivelet wrote:

A secret you may not be aware of: it takes a non-native writer far more than 
twice as much time to write the same idea.

Thierry Nivelet
http://foxincloud.com/
Give your VFP app a second life in the cloud


Le 10 févr. 2017 à 09:16, John Weller  a écrit :

+1

John Weller
01380 723235
079763 93631
Sent from my iPad


On 10 Feb 2017, at 06:38, Jerry Wolper  wrote:

Rafael (and everyone else),


Sometimes I doubt myself on the correct use of some English expressions.
After all, they don’t teach all of them at school.

I'm always impressed by how well the non-native English speakers express
themselves here. (Certainly better than most of us can do in other
languages.) So, don't apologize, and feel free to ask if you have a
question.

-Jerry





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

Re: SQL Backend Question - Part Deux

[rafael copquin]

I have two canadian sons married to american girls and living in 
Manhattan. Just came back from NY, visiting them and my grandchildren.


I am glad to learn that the kids are becoming bilingual, because my sons 
speak to them in Spanish at home. Of course, English is the main 
language, both at school and at the playground.


So maybe, in a few years when they are old enough _they_ will be my 
English mentors. But I have to confess that while living in Canada I 
learned a lot of idioms, especially those beginning with f:-)


Regards

Rafael



On 10/02/2017 3:38, Jerry Wolper wrote:

Rafael (and everyone else),


Sometimes I doubt myself on the correct use of some English expressions.
After all, they don’t teach all of them at school.

I'm always impressed by how well the non-native English speakers express
themselves here. (Certainly better than most of us can do in other
languages.) So, don't apologize, and feel free to ask if you have a
question.

-Jerry


--- 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/c4f083ae-74e2-2f43-3b2f-bea59a634...@fibertel.com.ar
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: SQL Backend Question - Part Deux

[rafael copquin]

To Gene and Michael


Sometimes I doubt myself on the correct use of some English expressions. 
After all, they don’t teach all of them at school. In my case, I was 
first exposed to the language when I was a child and my first teacher 
was a british lady. It was when I emigrated to Canada in the 70’s that I 
learned most of what I use today.  However, after a long time back in 
Argentina, some of it goes away, even though I try to keep it up by 
reading English books .


Thanks for the clarification anyway

Regards

Rafael


On 08/02/2017 20:13, Gene Wirchenko wrote:

At 14:40 2017-02-08, rafael copquin <rafael.copq...@gmail.com> wrote:
Hi Thierry You know English is a second language to me. Perhaps I 
should have said "I came across" or "just read this". Having just 
returned from holidays I may have made a mistake in the way I 
expressed myself. Maybe careless in the way I wrote it. I was not at 
all surprised or shocked. Just used the wrong expression. Sorry Rafael


 Your usage was just fine if you intended that you came across 
something and were not specifically searching for it.  Example 
sentence about an experience of mine: I was playing games at 
armorgames.com and stumbled upon an ad for an HVAC (heating, 
ventilation, and air conditioning) company in town which I applied to.


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/2e60045b-094a-d7cc-e11f-bcd2ecbbb...@fibertel.com.ar
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: SQL Backend Question - Part Deux

[rafael copquin]

Hi Thierry

You know English is a second language to me. Perhaps I should have said 
"I came across" or "just read this". Having just returned from holidays 
I may have made a mistake in the way I expressed myself. Maybe careless 
in the way I wrote it.


I was not at all surprised or shocked. Just used the wrong expression.

Sorry

Rafael



On 08/02/2017 14:38, Thierry Nivelet wrote:

Le 8 févr. 2017 à 14:48, rafael copquin <rafael.copq...@gmail.com> a écrit :

I stumbled upon the below reply by Thierry.

Hi Rafael,

Just curious, what do you mean by ’stumbled'? surprised? shocked?
Thks

Thierry Nivelet



--- 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/69f1540f-ecfa-f7dc-422f-3b4303263...@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: SQL Backend Question - Part Deux

[rafael copquin]

I just got back from my summer holidays (it is summer now in the 
southern hemisphere) and after a few hours of reading emails accumulated 
during my absence, I stumbled upon the below reply by Thierry.


Years ago I wrote an article on the UniversalThread dealing with the 
issue of bringing a set of records from a remote source which could be 
of help.


https://www.universalthread.com/ShowHeaderArticleOneItem.aspx?ID=39291

Regards

Rafael Copquin




On 03/02/2017 17:12, Thierry Nivelet wrote:

> forget grids showing ALL the data to the user

FWIW, FoxInCloud comes with a paged grid with sorting & filtering 
capability: just drop an existing grid at design time into the 
container class supplied by FoxInCloud and it'll get paged in Web 
mode. User can set the number of items per page and it'll persist 
across sessions.


> Thierry's FoxInCloud could be a good idea

could also be a real opportunity; doesn't the video I recently posted 
showing a responsive Web App from a 'regular' VFP app look terrific? ;)


Thierry Nivelet
FoxInCloud
Give your VFP app a second life in the cloud
http://foxincloud.com/




___
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/b7f622b5-4354-0278-2d6b-288d06b8a...@fibertel.com.ar
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

cursor adapter class

[rafael copquin]

Hi folks!

The UniversalThread just published my article describing a class that 
builds a complex cursor adapter that works with SQL Server databases.


It is an enhancement to a previous one published in April 2006. That one 
could only work with a single table in the select statement and then 
only with DBF's


The one published now can contain a complex select statement, involving 
two or more tables and pulling records from a SQL Server database. You 
can modify it slightly to make it work with DBF's, as explained in the 
notes at the end of the article.


Here's the link

https://www.universalthread.com/ShowHeaderArticleOneItem.aspx?ID=40122

Regards

Rafael Copquin



___
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/729babd4-29a5-cf30-43f6-d4cd6a9d9...@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: Problem with VFP IDE (VFP9SP2, fully patched)

[rafael copquin]

It is and in most cases it works. However, because the file I was trying 
to show was so big, Excel somehow burped and setting it to visible 
before opening the file made the problem disappear.


Thanks to all of you for your comments

Rafael Copquin



On 23/10/2016 16:15, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:

On 2016-10-22 07:30, Man-wai Chang wrote:
Check ownership and permission of all files in the program 
installation folder?



My wonder is why anything changed?!?

I'm going to uninstall VFP and reinstall it.



[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/7de97934-0a1b-fef0-5ad3-c2552bda9...@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

[rafael copquin]

I solved it!

What I did was make the oExcel object _visible_ just after instantiation 
and before trying to open the file.


if upper(vartype(thisform.oExcel)) <> "O"
thisform.oExcel=createobject("Excel.Application")
else
thisform.oExcel=getobject(,"Excel.Application")
endif

thisform.oExcel.visible = .T.

Try

 lOK = .t.

 With thisform.oExcel
.workbooks.open("")
 endwith

etc

Thank you all anyways

Rafael



On 21/10/2016 18:09, Richard Kaye wrote:

You've probably got some hidden dialog waiting for an answer asking you if you 
want to save your changes. Try adding something like this to your exception 
handling before you call Quit.

m.oExcel.ActiveWorkbook.Saved= .T.  && this prevents Excel prompt when we 
destroy the Excel object

--

rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of rafael 
copquin
Sent: Friday, October 21, 2016 4:59 PM
To: profoxt...@leafe.com
Subject: Excel errors

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/dd19fc77-3321-c578-6346-164e73724...@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.

Excel errors

[rafael copquin]

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



___
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/7b206292-d9f3-10ce-bfa6-a73eb5a15...@fibertel.com.ar
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do 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: Report label caption expression

[rafael copquin]

I'm sorry, I read his post quickly and did not notice

My bad

The best solution then is to use a textbox

Rafael



On 25/08/2016 10:18, Laurie Alvey wrote:

Rafael, that would be fine on a form, but Joe is talking about a REPORT
label!

Laurie

On 25 August 2016 at 13:22, rafael copquin <rafael.copq...@gmail.com> wrote:


If you want to use a label do this:

local cText,cYear

cYear = alltrim( str( year() ) )  && if you want the current year

cText = cYear+' Auto mileage report'

thisform.lblYear.caption = cText

Rafael Copquin



On 24/08/2016 22:14, Joe Yoder wrote:


I want the header on a report to display the year from a variable along
with some text.  When I set the value to "str(m.Year) + 'Auto Mileage
Report'" that string is displayed rather than "2015 Auto Mileage Report."

I think I solved this years ago with the use of a special character or
syntax but I can't remember what it was.

Thanks in advance for any help,

Joe


--- 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/67c1f463-e971-87fd-3f41-d7ec9c6ea...@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: Report label caption expression

[rafael copquin]

If you want to use a label do this:

local cText,cYear

cYear = alltrim( str( year() ) )  && if you want the current year

cText = cYear+' Auto mileage report'

thisform.lblYear.caption = cText

Rafael Copquin



On 24/08/2016 22:14, Joe Yoder wrote:

I want the header on a report to display the year from a variable along
with some text.  When I set the value to "str(m.Year) + 'Auto Mileage
Report'" that string is displayed rather than "2015 Auto Mileage Report."

I think I solved this years ago with the use of a special character or
syntax but I can't remember what it was.

Thanks in advance for any help,

Joe


--- 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/9e68d83d-afee-fba5-474e-4ce1bba19...@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: Too simple report?

[rafael copquin]

A simpler way to do that, without using any variables is thus:

Copy the control you use to display each record in the summary band, but 
set the calculation type to sum


At the end of the report this control will show the sum of the records, 
as requested


Rafael Copquin



On 23/08/2016 11:46, Tracy Pearson wrote:

Joe Yoder wrote on 2016-08-23:

  I have a report that amounts to simply printing each record from a table.
  There is no subgrouping of the data.  All that is needed is a grand total
  at the bottom. How does one setup the report writer to get and print the
  total?
  
  TIA - Joe



Joe,

Under the Reports, menu, select Optional Bands.
In the Report Properties window on the Optional Bands tab you'll want to
check Report has summary band.
Then click over to Variables, I create variables with the m. notation. So I
add m.summary
Value to store is the field you want to sum.
Initial value is 0
Reset value based on is report
Calculation type is Sum

Then you add a textbox to the Summary band (the names are at the bottom of
the band) and put in m.summary. (or the variable name you used)


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/736b57ab-e112-f5b8-ebf6-de5dc734c...@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: GETFILE and SET DEFAULT

[rafael copquin]

Try this:

m.SaveDef = set('DEFAULT')

set default to ...

do your thing

then get back with

set default to 

or

set default to (m.SaveDef)

Rafael Copquin

On 20/07/2016 16:50, Joe Yoder wrote:

I need to have a user choose a file with a specific extension from a
specific folder.  I assumed I could simply pass a file skeleton to GETFILE
like one does to ADIR.  When I try that FoxPro seems to navigate to the
proper folder but does not show any contents in the folder.

I looked up the docs on GETFILE and it appears that specifying the path to
a specific folder is not a valid use.  One needs to "SET DEFAULT TO" the
desired path in a separate operation and then call GETFILE with the desired
extension.  This appears to work but when I tried to save and restore the
setting of DEFAULT before and after this use I discovered that no matter
what I do,
?SET('DEFAULT') always returns 'C:'.  Since "SET DEFAULT TO" (invalid path)
gives an error  and GETFILE respects the setting - apparently the default
value is being set but just not reported.  My conclusion is that the
recommended "m.SaveDef = SET('DEFAULT')" before and
"SET DEFAULT TO m.SaveDef) after really do nothing.

Am I missing something?

Thanks in advance,

Joe


--- 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/a6e5673a-51c4-6b8c-14d7-d88967301...@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.

more on PDF and VFP

[rafael copquin]

I was just fooling around and did the following:

(I have the free version of FoxitReader installed in my computer)

I created a form and inserted the FoxitReader control which was now 
available in my PC and named it pdfreader


In the click event of a button I put this code:

thisform.pdfreader.openFile ('c:\donna\columbia.pdf')

It opened the pdf file in the form as expected.

Caveat: the FoxitReader menu was also inside the control.

This is not ideal, but at least should give some idea on how to deal 
with the insertable activex controls.


Rafael Copquin



___
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/526d43b1-e3ba-1f1f-8ec3-312a2cdd8...@fibertel.com.ar
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do 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 Display a PDF

[rafael copquin]

:-):-)
Rafael

On 12/07/2016 20:38, Ted Roche wrote:

On Tue, Jul 12, 2016 at 6:39 PM, rafael copquin <rcopq...@yahoo.com.ar> wrote:

In addition to all the answers you've got so far, I use this method:

Add the _shellexecute class from the _environ.vcx class library that ships
with VFP 9 to a form

Name it 'launcher'

and run this code from the click event of a button:

Local cDocName

cDocName = GetFile('doc,xls,pdf,txt','File','Open',0,'Choose file')
thisform.launcher.shellexecute (cDocName)


That's the best answer, the actual code. I was trolling around the
archives, but couldn't locate it.





___
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/e8896591-46c3-2e5b-1c8a-e5818069c...@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 Display a PDF

[rafael copquin]

In addition to all the answers you've got so far, I use this method:

Add the _shellexecute class from the _environ.vcx class library that 
ships with VFP 9 to a form


Name it 'launcher'

and run this code from the click event of a button:

Local cDocName

cDocName = GetFile('doc,xls,pdf,txt','File','Open',0,'Choose file')
thisform.launcher.shellexecute (cDocName)

You can launch any file with the above extensions that you select with 
the getfile function


That's all there is to it

Rafael Copquin


On 12/07/2016 18:04, Desmond Lloyd wrote:

Good afternoon,

Does anyone have a quick and dirty way to display a PDF from VFP either in
a form,  or natively using Adobe Reader?

Any assistance would be GREATLY appreciated...

Regards,
Desmond


--- 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/33edca74-3f5c-3298-5e9e-65e4fc89b...@yahoo.com.ar
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do 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

[rafael copquin]

I would do it this way:

On your first form, put a button to call the second form. In the 
button's click event do this:


do form secondform with thisform

On the second form init event:

lparameters toForm

thisform.oForm = toForm (you created a property called oForm in the 
second form and attach the parameter to it)


the second form should be modal. Then you make whatever changes you need.

When you completed your changes, I assume you typed something in a 
textbox (named txtWhatIType in this example)


thisform.oForm.text1.value = thisform.txtWhatIType.value
thisform.oForm.text1.refresh

release thisform

What you have done here is send a reference to the first form to the 
second form (thisform). It gets into the second from in its init event 
and is captured in the second form oForm property


When you finish your changes, you pass the value of those changes from 
the txtWhatIType textbox into text1 (or whatever you named it) in form 
1. Just in case, but perhaps not necessary, you  refresh the first 
form's text1.value


You release the second form and you should have the value you want in 
the first form


Rafael Copquin


___
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/c5da99c1-d139-5480-ac3c-c8ef98a78...@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] Just like VFP...

[rafael copquin]

Just to clarify: I had been running W7 Prof in both machines (64 and 32 bit)

I installed W10 and for about a week _most_ apps ran smoothly. However, 
in one of the updates, about a week after W10 installed itself, when I 
started the computer the fg updating message started and took about 
half an hour until the computer was in operation. Then I realized that 
all my Windows apps were gone: Word, Excel,etc, etc. Some of the drivers 
were also gone such as the printer, fax, etc. I had to download W10 
versions. Even my Kaspersky dissapeared and had to download a W10 
version. I was naturally very pissed as you might have surmised by now.


But after reinstalling painstakingly everything back, I have no issues. 
As a matter of fact, I like the way W10 behaves.


Rafael


On 24/06/2016 11:51, Kurt Wendt wrote:

REALLY? You had to reinstall ALL your Apps??? CRAP - that sounds like a 
Nightmare - ESPECIALLY If you have a LOT of things installed!

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 rafael 
copquin
Sent: Friday, June 24, 2016 10:47 AM
To: profoxt...@leafe.com
Subject: Re: [NF] Just like VFP...

I've been running W10 both in my laptop (64 bit) and my desktop (32 bit) for 
some months now and I had no major issues, appart from the fact that conversion 
eliminated all Windows apps I had in operation (Office, Skype, etc) and others 
such as Thunderbird, and had to reinstall them.
And yes, everything runs smoothly.

The only caveat is that it updates itself automatically even though I had been 
running Windows 7 Professional in both machines. I believe there is a way to 
prevent W10 to update itself automatically but it appears to be quite involved.

Rafael Copquin



On 24/06/2016 11:02, Dave Crozier wrote:

Well 12+ hours in from Brexit and the world hasn't ended and life seems to be 
carrying on much like before... in fact even the weather is the same i.e. Crap!

As for VFP, been up and running on Windows 10 64 Bit now for a week and no 
problems to report at all apart from the fact that it runs much faster than on 
Windows 7 (same machine and memory). Only gripe is that Windows has 
automatically rebooted twice for updates (presumably)  overnight as I put this 
as the preferred update time and subsequently reloaded my two USB security 
disks which were encrypted but with the wrong drive assignments and leaving 
them locked by Bitlocker. Hence my overnight backups haven't been successful - 
Hey Ho, Life goes on!

Dave



[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/d086dace-1edc-274b-4b99-125f11b8f...@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] Just like VFP...

[rafael copquin]

I've been running W10 both in my laptop (64 bit) and my desktop (32 bit) 
for some months now and I had no major issues, appart from the fact that 
conversion eliminated all Windows apps I had in operation (Office, 
Skype, etc) and others such as Thunderbird, and had to reinstall them. 
And yes, everything runs smoothly.


The only caveat is that it updates itself automatically even though I 
had been running Windows 7 Professional in both machines. I believe 
there is a way to prevent W10 to update itself automatically but it 
appears to be quite involved.


Rafael Copquin



On 24/06/2016 11:02, Dave Crozier wrote:

Well 12+ hours in from Brexit and the world hasn't ended and life seems to be 
carrying on much like before... in fact even the weather is the same i.e. Crap!

As for VFP, been up and running on Windows 10 64 Bit now for a week and no 
problems to report at all apart from the fact that it runs much faster than on 
Windows 7 (same machine and memory). Only gripe is that Windows has 
automatically rebooted twice for updates (presumably)  overnight as I put this 
as the preferred update time and subsequently reloaded my two USB security 
disks which were encrypted but with the wrong drive assignments and leaving 
them locked by Bitlocker. Hence my overnight backups haven't been successful - 
Hey Ho, Life goes on!

Dave



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

Re: A Blank Value for a Number?

[rafael copquin]

I felt I did not understand the issue but replied anyways.

However, check the SET NULL command in help. If ON it will allow you to 
store a null value.


Also you can create a cursor with fields that accept null values thus:

create cursor blabla(number I null,desc C(10))

append blank

replace number with null, desc with 'null value'

browse

will show null in the number column and 'null value' in the desc column

Then, when you save the cursor as an excel file _perhaps_ you will have 
a null value in the applicable cell (_this I did not try_)


Rafael


On 15/06/2016 9:57, Kurt Wendt wrote:

Rafael - its quite the reverse. Its manipulating data in VFP - then simply 
Exporting the data to an Excel file using COPY TO command.

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 rafael 
copquin
Sent: Tuesday, June 14, 2016 6:27 PM
To: profoxt...@leafe.com
Subject: Re: A Blank Value for a Number?

I'm not sure I understand your problem, but I often have to read an Excel file 
and pass the data to a table. Sometimes there is no value in a cell that should 
have a certain value (character or numeric)

Reading it line by line in those cases Excel sends a NULL value.

I just do something like this:

cFile = 'c:\exceldata\myexcelfile.xls'

this.oExcel=createobject("Excel.Application")

With this.oExcel

   .Workbooks.Open("")

   .Range("A27").Select

   oRange = .Range("A27:L27")

   Do while .t.

   with oRange

cDescription = Nvl(Alltrim(.Columns[3].value),'')

etc., etc.   && read more cells into ad hoc variables

   endwith

   oRange = oRange.Offset(1,0)  && jump to next
line on Excel sheet

   EndDo

and then it is a simple thing to replace the dbf DESCRIP field with cDescription

I re read your post and see that you want to blank certain cells automatically. 
Following the above technique it should be an easy thing to do. Just look at my 
example with the cDescription variable. The nvl function will give it a value 
of '' if it contains a null value, or the actual value if it is not null


Rafael Copquin


On 14/06/2016 17:02, Kurt Wendt wrote:

I know - it's a Crazy request. Trying to figure out the Easiest way to try and 
do this - and hoping to Avoid having to do more complicated solutions like 
Office Automation to manipulate an Excel file.

So - here's the deal. This system I work on - it outputs this Excel file. And, 
in the past - if there are certain records that have a Zero in a particular 
column - they would Manually wipe out the Zero - and also blank out several of 
the other fields in that Row.

But, the new request is to make those things happen automatically during 
process when the Excel file gets exported. So that they do NOT have to manually 
blank out certain fields. But, of course, therein lies the problem. For the 
other rows of data - this particular field is supposed to be a numeric value. 
And, AFAIK - there really is NO Way to have a DBF or Cursor that has a Numeric 
field - and yet have blank values in it.

As such, I suspect the answer is that this can't be done - to have a numeric 
data field hold any kind of blank data. They even suggested just a Dash. But, 
again - I figured it's not possible. However, I figured for the hell of it - I 
would post here - in case someone had an interesting insight that I hadn't 
thought of...

Kurt Wendt
Senior Systems Analyst
[GlobeTax_SecondaryLogo_TwoColor_Lo]<https://www.globetax.com/>
One New York Plaza - 34th Floor
New York, NY 10004-1936, USA
Tel. +1-212-747-9100
Direct +1-212-405-8246
www.GlobeTax.com<https://www.globetax.com/>

GlobeTax does not provide or offer, and this is not, tax, investment or legal 
advice. This email and any attachments hereto is intended only for use by the 
addressee(s) and may contain confidential information. If you are not the 
intended recipient of this email, please immediately notify the sender at 
+1-212-747-9100 and permanently delete the original and any copies of this 
email.



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


[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/e93340c6-2290-8964-dc0f-2f97c48b1...@gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This stat

Re: A Blank Value for a Number?

[rafael copquin]

I'm not sure I understand your problem, but I often have to read an 
Excel file and pass the data to a table. Sometimes there is no value in 
a cell that should have a certain value (character or numeric)


Reading it line by line in those cases Excel sends a NULL value.

I just do something like this:

cFile = 'c:\exceldata\myexcelfile.xls'

this.oExcel=createobject("Excel.Application")

With this.oExcel

 .Workbooks.Open("")

 .Range("A27").Select

 oRange = .Range("A27:L27")

 Do while .t.

 with oRange

  cDescription = Nvl(Alltrim(.Columns[3].value),'')

  etc., etc.   && read more cells into ad hoc variables

 endwith

 oRange = oRange.Offset(1,0)  && jump to next 
line on Excel sheet


 EndDo

and then it is a simple thing to replace the dbf DESCRIP field with 
cDescription


I re read your post and see that you want to blank certain cells 
automatically. Following the above technique it should be an easy thing 
to do. Just look at my example with the cDescription variable. The nvl 
function will give it a value of '' if it contains a null value, or the 
actual value if it is not null



Rafael Copquin


On 14/06/2016 17:02, Kurt Wendt wrote:

I know - it's a Crazy request. Trying to figure out the Easiest way to try and 
do this - and hoping to Avoid having to do more complicated solutions like 
Office Automation to manipulate an Excel file.

So - here's the deal. This system I work on - it outputs this Excel file. And, 
in the past - if there are certain records that have a Zero in a particular 
column - they would Manually wipe out the Zero - and also blank out several of 
the other fields in that Row.

But, the new request is to make those things happen automatically during 
process when the Excel file gets exported. So that they do NOT have to manually 
blank out certain fields. But, of course, therein lies the problem. For the 
other rows of data - this particular field is supposed to be a numeric value. 
And, AFAIK - there really is NO Way to have a DBF or Cursor that has a Numeric 
field - and yet have blank values in it.

As such, I suspect the answer is that this can't be done - to have a numeric 
data field hold any kind of blank data. They even suggested just a Dash. But, 
again - I figured it's not possible. However, I figured for the hell of it - I 
would post here - in case someone had an interesting insight that I hadn't 
thought of...

Kurt Wendt
Senior Systems Analyst
[GlobeTax_SecondaryLogo_TwoColor_Lo]<https://www.globetax.com/>
One New York Plaza - 34th Floor
New York, NY 10004-1936, USA
Tel. +1-212-747-9100
Direct +1-212-405-8246
www.GlobeTax.com<https://www.globetax.com/>

GlobeTax does not provide or offer, and this is not, tax, investment or legal 
advice. This email and any attachments hereto is intended only for use by the 
addressee(s) and may contain confidential information. If you are not the 
intended recipient of this email, please immediately notify the sender at 
+1-212-747-9100 and permanently delete the original and any copies of this 
email.



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


[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/3cb74a2c-adf2-ae7c-a465-c3fc2bdab...@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 automation

[rafael copquin]

This worked!

Thank you all that replied

Rafael Copquin



On 10/06/2016 19:09, Richard Kaye wrote:

The Excel object probably is waiting for you to ask it if you want to save any 
unsaved changes but the dialog is not being displayed. If you set the saved 
property of the active workbook to true before you call the Quit event, that 
should clear things up.

m.loExcel.ActiveWorkbook.Saved= .T. && this prevents Excel prompt when we 
destroy the Excel object

Another thing you can try to do if you want to dig into why the Excel object is 
in an odd state is make it visible in your error handler before you call the 
quit event.

--

rk

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Mike 
Copeland
Sent: Friday, June 10, 2016 5:28 PM
To: profoxt...@leafe.com
Subject: Re: Excel automation

Here's a snippit of code I have been using with great success recently.
I wish I remembered where it came from but it is the best way to
terminate a Windows application that I've found.

I use it to close the application if it is left running by the end user.
It simply tests to see if the # of seconds since midnight is greater
than a predefined # of seconds. For your need, I don't think you'd need
the time check.

Hope this helps!

  LOCAL loLocator, loWMI, loProcesses, loProcess, llIsRunning
  loLocator = CREATEOBJECT('WBEMScripting.SWBEMLocator')
  loWMI= loLocator.ConnectServer()
  loWMI.Security_.ImpersonationLevel = 3
  loProcesses= loWMI.ExecQuery([SELECT * FROM Win32_Process WHERE
Name = 'MyApplicationName.exe'])
  FOR EACH loProcess in loProcesses
  loProcess.Terminate(0)
  ENDFOR

Mike Copeland


rafael copquin wrote:

I've been using the following technique to open an instance of Excel
for years:

If Upper(Vartype(Thisform.oExcel)) = "O"
 Thisform.oExcel.Quit
 Thisform.oExcel = null
Else
 Thisform.AddProperty('oExcel')
Endif

If Upper(Vartype(Thisform.oExcel)) <> "O"
 Thisform.oExcel=Createobject("Excel.Application")
Else
 Thisform.oExcel=Getobject(,"Excel.Application")
Endif

The above is taken from the Hacker's Guide

However, sometimes Excel throws an error.
Therefore in my form class error method I put this construct:

If nError = 1426  && Excel error

If Vartype(thisform.oExcel ) = "O"

   thisform.oExcel.quit
   Thisform.oExcel = null

 endif
endif

Yet, it does not kill the Excel instance. I mean, the Excel instance
is still open. It just does not go away. The only way to kill it is to
open the task manager and kill it manually

I follow the Excel method step by step, and reproduce the error
condition. The error method fires, the oExcel object exists, the line
"thisform.oExcel.quit" executes, but it does not kill the Excel instance



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/28bbac6c-1224-58d6-ce64-f70e32685...@yahoo.com.ar
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Excel automation

[rafael copquin]

I've been using the following technique to open an instance of Excel for 
years:


If Upper(Vartype(Thisform.oExcel)) = "O"
Thisform.oExcel.Quit
Thisform.oExcel = null
Else
Thisform.AddProperty('oExcel')
Endif

If Upper(Vartype(Thisform.oExcel)) <> "O"
Thisform.oExcel=Createobject("Excel.Application")
Else
Thisform.oExcel=Getobject(,"Excel.Application")
Endif

The above is taken from the Hacker's Guide

However, sometimes Excel throws an error.
Therefore in my form class error method I put this construct:

If nError = 1426  && Excel error

   If Vartype(thisform.oExcel ) = "O"

  thisform.oExcel.quit
  Thisform.oExcel = null

endif
endif

Yet, it does not kill the Excel instance. I mean, the Excel instance is 
still open. It just does not go away. The only way to kill it is to open 
the task manager and kill it manually


I follow the Excel method step by step, and reproduce the error 
condition. The error method fires, the oExcel object exists, the line 
"thisform.oExcel.quit" executes, but it does not kill the Excel instance




Rafael Copquin


___
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/996fc85b-2310-cbce-8c82-7e0ab8085...@yahoo.com.ar
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

[NF] TEAMVIEWER

[rafael copquin]

Is the TeamViewer site down?

I can't get into www.teamviewer.com with any browsers and neither can I 
connect with my TeamViewer app


Rafael Copquin



___
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/6b0ff417-65fb-7807-b7c8-b116bccc8...@fibertel.com.ar
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do 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: Shortcut to generalized click column for sort order browse?

[rafael copquin]

In addition to what Peter says:

when you click on the column you want to, put this code

set order to ... in .(the table or cursor)

this.parent.parent.refresh

Those two lines of code will do what you want. Of course, we are talking 
of a grid here, not a browse


Rafael Copquin




On 13/05/2016 13:21, Peter Cushing wrote:

On 13/05/2016 16:44, Joe Yoder wrote:

I need to present information from several tables.  I want to enable the
user to click on a column header to control the order in which the 
records

are displayed.  At this point it does not need to be very polished so a
simple browse with scrolling, column resizing and repositioning, with
control F find will be fine.

I do this with a grid on a form.  I create a cursor in the init or 
load and set that as the recordsource etc. then fill it with data and 
index on the columns you want to be able to set order to.  To change 
the order just click on the column header and some code behind that 
changes the index order.  Grids are definitely more work than a browse 
but you can do a lot more with them, like the column header click.


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/26760f54-39d2-48fc-71e3-e09e77f2b...@fibertel.com.ar
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do 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] Virtual Box

[rafael copquin]

In my case I use an Oracle virtual box since 2014 with no problems. I 
have a Win XP, a Wndows Server and a Windows 7 in it with no problems 
whatsoever. You can use Chrome in it as well.


And it is FREE

Rafael Copquin




On 10/05/2016 11:46, Fernando D. Bozzo wrote:

Hi Mike:

I'm using VirtualBox since many years (VMWare have a free personal version
too) because my main OS is Ubuntu Linux, and I have Windows (7, XP, 10,
etc) only as virtual machines.

Not used Win 10 too much, but worked ok when I've used it.

Best regards

Fernando. -
El 10/5/2016 15:57, <mbsoftwaresoluti...@mbsoftwaresolutions.com> escribió:


https://www.virtualbox.org/wiki/Downloads

I'm going to let my main dev machine do the free upgrade to Win10 soon.  I
bought a Win7 Pro license yesterday to put on another older Dell laptop
I've got (where I currently have Linux Mint on it).  Tech buddy here at the
Corporate gig suggested I get Virtual Box (free!) to host multiple OSes.  I
searched the archive for the past year and didn't find much other than a
stray reference to it.

Anyone using Virtual Box and can attest to their experience with it?

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/7372892d-0e4a-e34a-39f1-82d61794c...@fibertel.com.ar
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do 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] Win10 Update anyone?

[rafael copquin]

Thank you all for the info
Rafael


El 29/04/2016 a las 22:49, Ken Dibble escribió:


> Is it possible to stop Windows 10 to automatically install its 
upgrades?

>

Absolutely - otherwise nobody would use it in a large corporate
environment. But you need to be on a 'pro/business' edition for that.

The EULA for the home editions states that MS will download the updates
automatically but you can still choose when to apply them.


What I am seeing is that, using a single workstation, you can delay 
downloading and/or installing updates indefinitely by a number of 
means, including turning off the Windows Update Service.


What you CANNOT do is pick and choose which specific updates to 
install. You either block all of them, or you are forced to accept all 
of them. (Yeah, you can let them all be installed, then go and revert 
some of them and "hide" them after the fact--if they haven't already 
hosed your computer. Not an acceptable work-around.)


The only way I can see to get control over individual updates is to 
use the Pro or Enterprise version with a WSUS server. Sure, we all 
have one of those at home


Ken Dibble
www.stic-cil.org



[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/57273e67.7090...@fibertel.com.ar
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do 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] Win10 Update anyone?

[rafael copquin]

The EULA for the home editions states that MS will download the updates
automatically but you can still choose when to apply them.


How is it done then? As I said, I was using W7 Prof before switching to 
W10. Now I have the Windows 10 Pro edition



Rafael




--
Rafael Copquin


___
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/57236761.7030...@fibertel.com.ar
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do 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] Win10 Update anyone?

[rafael copquin]

Very funny Steve.

Now as a related issue I have this question:

Is it possible to stop Windows 10 to automatically install its upgrades?

I used to run on Windows 7 professional (32 bit). I upgraded to Windows 
10 with no major issues other than reinstall some software with updated 
drivers.


But yesterday, when I started my PC it began to update itself and the 
damn thing took 37 minutes to do that

And I have a fast computer!!

In the meantime a lot of encouraging words appeared on the screen 
stating that now my Windows 10 experience would be enhanced and I would 
reach something akin to nirvana, but the screen was black most of the 
time and I could do absolutely nothing.


What a waste of precious time!!

Again, is there a way to control these updates?

Rafael Copquin


--
Rafael Copquin


___
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/572278d3.2010...@fibertel.com.ar
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do 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: problem with calculations with VFP9 and MSSQL Server

[rafael copquin]

Both Ted and Richard, thank you for replying.

However, the resulting cursor has the fields as numeric.

In the case of the table belonging to the database that behaves 
normally, the sql column is numeric(10,2) and vfp brings it as a 
numeric(12,2) field.


In the case of the one that behaves crazily, the sql column is 
numeric(18,2) and vfp brings it as numeric(20,2)


If I browse the first cursor (both are saved to disk to deal with after 
the queries) it shows the amount in the invtotal column as 12345.67 
which is correct


The weird one, even though it is showing the structure as numeric(20,2) 
shows as 12.345,67 and when the cursor is on the record it shows as 
123.45, which is completely wrong. Note the dot separating the 
thousands, which does not appear in the first case.


I solved the issue temporarily by casting the fields as character in the 
select from the sql server and the resulting cursor is then CASTed to 
numeric(12,2).


However, I want to know why the behavior is so wrong in the second case. 
Because I can't trust the queries if I do not tweak them as described.


El 25/03/2016 a las 12:40, Ted Roche escribió:

Have you taken a look at the structure (LIST STRU) of the resultant
cursor when you get the incorrect result? Perhaps there's a clue
there.

On Fri, Mar 25, 2016 at 11:00 AM, rafael copquin
<rcopq...@fibertel.com.ar> wrote:

A few months ago I posted the following:

quote

I am selecting a bunch of invoices from a MS SQL Server table. I just want
to add the total of all
invoices.
  In the management studio I do this:
  Select sum(total) as total from terbo.dbo.invoices
  I get 212649.17
  When I do the same calculation in VFP
  cCmd = ‘Select sum(total) as total from terbo.dbo.invoices’
sqlexec(thisform.nHandle,cCmd,’curTotals’)
  nTotal = curTotals.total
  nTotal  is 212.65
  How can I get the correct amount?
  unquote

I would still know the answer to this problem, because the weird thing is
that it only happens with the tables
of just one database. That  is, I have two similar databases, with similar
tables. However, the vfp cursor obtained
from this particular database table gives the above error where a similar
table in another database does not.

In both my Windows 10 and VFP9 SP2 the regional settings are a dot as a
thousands separator, a comma as
  a decimal point and a semicolon as lists separator. These are the Spanish
language settings for numbers

The numerical fields in the tables are defined as numerical (18,2) not null
with a default value of 0

A select statement such as this:

cCmd = 'select invtotal from mydatabase.dbo.invoices where invid =
'+transform(nPK)
sqlexec(nHandle,cCmd,'curInvTotal')

brings a cursor where a browse shows  12.256,85 (note the dot shown as a
thousands separator. It should show as
12256,85)  If I place the mouse over the invtotal column on the browse, the
number shows as 12.25

I am really baffled and do not know what to do.

Any leads on where to tweak the database on SQL Server, or configure the
software would be appreciated

Any help?

Happy Easter

Rafael Copquin







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

problem with calculations with VFP9 and MSSQL Server

[rafael copquin]

A few months ago I posted the following:

quote

I am selecting a bunch of invoices from a MS SQL Server table. I just want to 
add the total of all
invoices.
 
In the management studio I do this:
 
Select sum(total) as total from terbo.dbo.invoices
 
I get 212649.17
 
When I do the same calculation in VFP
 
cCmd = ‘Select sum(total) as total from terbo.dbo.invoices’

sqlexec(thisform.nHandle,cCmd,’curTotals’)
 
nTotal = curTotals.total
 
nTotal  is 212.65
 
How can I get the correct amount?
 
unquote


I would still know the answer to this problem, because the weird thing is that 
it only happens with the tables
of just one database. That  is, I have two similar databases, with similar 
tables. However, the vfp cursor obtained
from this particular database table gives the above error where a similar table 
in another database does not.

In both my Windows 10 and VFP9 SP2 the regional settings are a dot as a 
thousands separator, a comma as
 a decimal point and a semicolon as lists separator. These are the Spanish 
language settings for numbers

The numerical fields in the tables are defined as numerical (18,2) not null 
with a default value of 0

A select statement such as this:

cCmd = 'select invtotal from mydatabase.dbo.invoices where invid = 
'+transform(nPK)
sqlexec(nHandle,cCmd,'curInvTotal')

brings a cursor where a browse shows  12.256,85 (note the dot shown as a 
thousands separator. It should show as
12256,85)  If I place the mouse over the invtotal column on the browse, the 
number shows as 12.25

I am really baffled and do not know what to do.

Any leads on where to tweak the database on SQL Server, or configure the 
software would be appreciated

Any help?

Happy Easter

Rafael Copquin







  
Rafael Copquin



___
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/56f55299.1080...@fibertel.com.ar
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do 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: email from vfp

[rafael copquin]

By all means!

I have to send just one pdf file, a price list, to one or many selected 
recipients.


If you would give me an example on how to do this, plus where to get the 
CDO class, it would be greatly appreciated


Rafael


El 08/01/2016 a las 4:50, Laurie Alvey escribió:

I use CDO (runs on Windows 10) without problems. If you're interested, I'll
give you some details.

Laurie

On 7 January 2016 at 21:21, Tracy Pearson  wrote:


YAHOO wrote on 2016-01-07:

  Thanks for the info but I forgot to mention that it SHOULD BE FREE

  Sorry

  Rafael


Rafael,

If you don't need SSL or TLS connections you can use the BLAT everyone has
given many examples for.

If you need TLS but not SSL, one could use the .NET tools to build an EXE
or
COM object to use.

If you need SSL and TLS, you'll need to spend some money.

TLS is getting to be the preferred method.

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/568fc0f1.7090...@fibertel.com.ar
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do 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 from vfp

[Rafael Copquin]

I am aware that this subject has been addressed many times. However, a form 
that uses the cusmapi class from the mapimail.vcx that ships with VFP9, that 
has been used with no problems up to Windows 7, is not working under Windows 10

Is there any routine that I can use that will be simple and straight forward, 
to be able to send a PDF file from VFP?

I checked the VFP wiki and found a very complicated code which I hesitate to 
use. I need something easy that would require no learning curve.

Can anybody help by providing an example?


Rafael Copquin

Enviado desde Correo para Windows 10



--- 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/716035.27884...@smtp201.mail.bf1.yahoo.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: Array passing Suggestions...

[Rafael Copquin]

I do the same thing but using XMLAdapter at both ends (calling form and called 
form) The advantage is that you can pass several cursors simultaneously to the 
called form

** in the calling form

local oXML,cXML
oXML = CreateObject("XMLAdapter")
oXML.addtableschema(‘cursor1’)
  oXML.addtableschema(‘cursor2’)
  oXML.addtableschema(‘cursor3’)
oXML.ToXML("cXML")

do form calledform with cXML   && in this way you pass the three cursors

oXML = NULL   && to clean the memory

** in the init event of the called form

Lparameters tcXML

Local oXML,cXML
oXML = createobject(“XMLAdapter”)
oXML.loadxml(tcXML)
cXML.tables.item(1).tocursor()&& recreates cursor1
cXML.tables.item(2).tocursor()&& recreates cursor2
cXML.tables.item(3).tocursor()&& recreates.cursor3

Now you have your three cursors in the called form


Rafael Copquin

Enviado desde Correo para Windows 10



De: Laurie Alvey
Enviado: miércoles, 25 de noviembre de 2015 10:31
Para: profoxt...@leafe.com
Asunto: Re: Array passing Suggestions...


The way I pass stuff around between forms/objects is a bit convoluted but
works fine. I do this:

1. Create a local cursor populated with the data I want to pass.
2. From that cursor, create a XML string using CURSORTOXML(), (lcXML)
3. The calling object issues DO FORM myform WITH lcXML.
4. The recipient form's Init() converts the XML back into a cursor using
XMLTOCURSOR().
5. You can then do anything else you want with the cursor.

The advantage of doing it this way is that it works with COM, (strings are
about the only thing that will cross COM boundaries). Not maybe the
cleverest way to do it, but it works.

Laurie.

On 24 November 2015 at 15:16, Fernando D. Bozzo <fdbo...@gmail.com> wrote:

> Hi Dave:
>
> You can always pass the array to a form's method and this method can pass
> the array to any internal object.
> Only the final target need to acopy() it.
>
> Form1.passarray(@arr)
> ***
> Procedure passarray(taArray)
> Thisform.internalObject.passarray(@taArray)
> ***
> Procedure internalObject.passarray(@arr)
> Dimension...
> Acopy...
> El 24/11/2015 2:48 p. m., "Dave Crozier" <da...@flexipol.co.uk> escribió:
>
> > Peter,
> > That is exactly how I have done it woth forms Peter. However this is
> > passing it into a visually designed object class that sits on the form
> > itself. For some reason when the object you are passing in to is a form
> > then it all works but if it is another "object" i.e not a form then it
> > doesn't
> >
> > Dave
> >
> >
> > -Original Message-
> > From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Peter
> Cushing
> > Sent: 24 November 2015 13:45
> > To: profox@leafe.com
> > Subject: Re: Array passing Suggestions...
> >
> > Hi Dave,
> >
> > I have a form call frmpoship and call with
> >
> > DO FORM frmpoship WITH laDates, ...
> >
> > in the form INIT is:
> > PARAMETERS aShipdates,
> >
> > DIMENSION thisform.aShip[8,9]
> > DIMENSION thisform.aShip2[8,9]
> > ACOPY(aShipdates,thisform.aShip)
> > * make second copy to see if anything has changed
> > ACOPY(aShipdates,thisform.aShip2)
> >
> > The array size is fixed but the acopy should size it anyway.
> > aShip is already set up in the form under form/edit property/method, so I
> > don't need to add it.  It might be this bit that is tripping you up.
> > When you have your class open click on class edit property/method and it
> > should be at the end of the list, like myarray[1,0]
> >
> > Presume you just use this.aShip[8,9] etc instead of thisform Also at the
> > end (closing the modal form) I just hide the form and check the values of
> > the array before releasing it.
> >
> > Peter
> >
> >
> > On 24/11/2015 13:33, Dave Crozier wrote:
> > > Peter,
> > > That is fine but it is getting the external array to be recognised
> > within the class that is the problem. Once I can do that then the aCopy()
> > will work fine.
> > >
> > > You have said that in one of your forms you pass an array. What do you
> > pass it to, I want to pass it to a visually developed class where I can
> > then copy it to an array owned by the class and manipulate it
> accordingly.
> > >
> > > I am just going around in circles here at the moment and beginning to
> > think that I have missed something really basic.
> > >
> > > Dave
> > >
> > > -Original Message-
> > > From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Peter
> &g

problem with calculations with VFP9 and MSSQL Server

[Rafael Copquin]

I am selecting a bunch of invoices from a MS SQL Server table. I just want to 
add the total of all invoices.

In the management studio I do this:

Select sum(total) as total from terbo.dbo.invoices

I get 212649.17

When I do the same calculation in VFP

cCmd = ‘Select sum(total) as total from terbo.dbo.invoices’
sqlexec(thisform.nHandle,cCmd,’curTotals’)

nTotal = curTotals.total

nTotal  is 212.65

In my VFP regional settings I have set decimals = 2 and set point = [.]

How can I get the correct amount?


Rafael Copquin

Enviado desde Correo para Windows 10


--- 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/485895.37727...@smtp220.mail.bf1.yahoo.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: windows10 where is it?

[Rafael Copquin]

Found it!
I also found c:\$windows.~WS
In the latter there are two exe files, I guess setuphost.exe is the one 
to execute to install in another machine



El 21/08/2015 a las 6:59, Dave Crozier escribió:

Raphael,
I believe it is in the hidden folder C:\$windows.~BT

You can find this by setting your folder options to Show Hidden Files, folders 
and drives.

Dave


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Rafael Copquin
Sent: 21 August 2015 10:36
To: profox profox@leafe.com
Subject: windows10 where is it?

My system just finished downloading W10 automatically.

I wanted to know where it is, in what folder I mean.

I investigated a bit in my machine and saw a link in the windows update, but I 
hesitate to just double click it, because I do not want anything to tinker with 
my Windows 7 Professional that works like a charm now.

I would like to test it in a virtual machine, but do not know where it is.

Can anyone tell me please?

--
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/55d7121e.2020...@yahoo.com.ar
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do 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: windows10 where is it?

[Rafael Copquin]

I am using it right now, thank you!
Rafael

El 21/08/2015 a las 7:43, Gianni Turri escribió:

Better you create a USB key or DVD using the MS Tool at this page:

https://www.microsoft.com/en-us/software-download/windows10

Gianni

On Fri, 21 Aug 2015 09:59:41 +, Dave Crozier da...@flexipol.co.uk wrote:

Raphael,
I believe it is in the hidden folder C:\$windows.~BT

You can find this by setting your folder options to Show Hidden Files, folders 
and drives.

Dave

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Rafael Copquin
Sent: 21 August 2015 10:36
To: profox profox@leafe.com
Subject: windows10 where is it?

My system just finished downloading W10 automatically.

I wanted to know where it is, in what folder I mean.

I investigated a bit in my machine and saw a link in the windows update, but I 
hesitate to just double click it, because I do not want anything to tinker with 
my Windows 7 Professional that works like a charm now.

I would like to test it in a virtual machine, but do not know where it is.

Can anyone tell me please?

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

windows10 where is it?

[Rafael Copquin]

My system just finished downloading W10 automatically.

I wanted to know where it is, in what folder I mean.

I investigated a bit in my machine and saw a link in the windows update, 
but I hesitate to just double click it, because I do not want anything 
to tinker with my Windows 7 Professional that works like a charm now.


I would like to test it in a virtual machine, but do not know where it is.

Can anyone tell me please?

--
Rafael Copquin


___
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/55d6f0f6.1020...@yahoo.com.ar
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do 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] Thunderbird - Missing Sent Emails...

[Rafael Copquin]

Speaking of TBird..

I have been using Thunderbird for a number of years now (ever since I 
switched from XP to W7). However, about a month ago I noticed that it 
will forget my passwords (I use three accounts, one on Gmail, one on 
Yahoo and the other one on my private IP)


Every time I turn on my TBird it will require me to enter the password 
for each of the accounts, either to read messages or to send messages.


I tried deleting the passwords from the TBird memory, reentering them 
again, to no avail. It always asks for the password, even though I mark 
them as to be remembered by the software


Any leads?

-- Rafael Copquin

___
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/55d6f46f.1090...@yahoo.com.ar
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do 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: Cursor Adapter

[Rafael Copquin]

Perhaps you need to put this code in the load event of the form:

thisform.dataenvironment.howeveryounamedyourca.cursorfill()

Rafael Copquin


El 03/08/2015 a las 7:38, Dave Crozier escribió:

Fellow VFP Foxphiles, ladies and gentlemen,
I normally do all my Remote SQL through SQL Pasthrough but Tom here is 
branching out into Cursor Adapters which I dabbled with just after VFP8 and 
just before VFP9 and resorted to the SPT methods as the preferred method of 
accessing remote data.

So, question as I know I have done it before but the old brain cells just ain't 
functioning today!!


1.   Made up a subclassed cursoradapter for a table on SQL server - test 
connectivity ... OK

2.   DataEnvironment on a form ... go into builder and add in the 
subclassed CA above ... no problem

3.   Add grid on the form with recordsource set to cursor just created in 
DE ... no problem

4.   Cursor set to fetch all records

5.   Open the form and no data pulled back from the remote source at all. I 
have looked at the before fill(), fill() methods on the cursor as well as the 
beforetableopen() in the DE and no data ever passes back to VFP. It is just as 
though the cursor is set to open without data fill which I have checked of 
course.



Question:

How to automatically retrieve the data into the CAi am sure that something 
pretty basic is not being done here but despite readiing Megafox, 1001 things 
as well as the CA sections in what's new VFP8 and 9 I can't figure it out but 
it is pretty basic of that I am sure.



This is driving me totally mad now and I have tried attaching the CA to both 
remote SQL sources as well as using the ODBC link back to a local VFP 
database/table which gives exactly the same result.



I know I can do the whole process programmatically using either SPT or CA's as 
I have done both but it would be preferable to use the subclassed CA's in the 
DE in exactly the same way you use native tables.



Dave


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

Re: SQL Server 2014

[Rafael Copquin]

None of you use cursor adapters? I use them all the time and they are 
just great! And do not have any of the drawbacks mentioned about views


Rafael Copquin


El 14/07/2015 a las 5:04, Dave Crozier escribió:

Remote views are great but with one drawback. If you make them dynamic or 
generate them on the fly then the database needs to be locked and this can 
really screw up your system (other users). We have a private personal database 
that is created per user that you have exclusive access to all the time. Makes 
it easy, efficient and fast.

Dave


-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Claude nikula
Sent: 13 July 2015 19:54
To: 'ProFox Email List'
Subject: RE: SQL Server 2014

Coding is the easy part. The harder part is making the right decision on how 
you want to connect. With VFP you have lots of options, that's one of the 
things that makes VFP so powerful.
Here are some considerations you'll have to account for. On how to connect

1. Pass-through (ODBC) - with this option, you'll have to consider if you want 
to connect to the clients programmatically, or if you wish to set up a data 
source name (DSN).   Pro. Very flexible, very fast and powerful. Con. It can be 
very labor intensive

2. Remote views, this will require a DBC. Again, you'll have to decide if you 
want to use the programmatically connection string, or a data source name.   
Pro. Very easy to use. It takes care of all of your inserts, updates for you, 
which makes it very convenient.Con. In question is very large, It can 
become very slow.

3. ADO, is just another way of connecting to the server, it is very outdated, 
but still works.Pro. Very similar to pass-through with much more 
restrictions, it returns a data object that you can traverse through to pull 
specific data you looking for.Con. Can be difficult to work with, requires 
lots of additional work and if you're working with only one language in this 
case VFP. It doesn't make sense to use it

3. SQL Server data provider, I really never worked with this because it just 
seems to me, It is a waste of time. When it comes to actually working with VFP 
and MS SQL Server. There are some data engines out there where you have only 
the choice of using the data provider. It is mostly used in the.net world,  
guessing.

For my money, when it comes to using VFP. I would much rather prefer option 1, 
the pass-through and handling my connections programmatically. Therefore, do 
not have to set up any data source names on the client machines, which is a 
huge timesaver and gives you much more security. In fact, all of your 
connection string information can be stored in a table.

I genuinely use remote views for quick and dirty stuff. But I have used the 
remote view on a project with great success, and I do have to admit it really 
was a timesaver.

There are all kinds of examples online and the VFP help does provide good 
health and examples.

Be careful, VFP can really spoil you and make life easy for you. When connecting to 
third-party databases. So if you like me, who jumps back and forth between .net and 
Visual FoxPro, you start to realize how  it is using Visual FoxPro g


Cheers,
Claude
Mesquite Information Technologies, LLC.





-Original Message-
From: Laurie Alvey [mailto:trukke...@gmail.com]
Sent: Monday, July 13, 2015 3:30 AM
To: ProFox Email List
Subject: Re: SQL Server 2014

There's also quite a bit in the VFP9 help file.
Laurie

On 11 July 2015 at 13:17, Rafael Copquin rcopq...@yahoo.com.ar wrote:


I can recommend this book, which you can get at www.hentzenwerke.com
Client-Server Applications with Visual FoxPro 6.0 and SQL Server 7.0


  Building Client-Server Applications with Visual FoxPro 6.0 and SQL
Server 7.0

by Chuck Urwiler and others

It is a good primer that will teach you the basics on how to use VFP
with SQL Server. And there are a few white papers in the web that you
can consult

Rafael Copquin


El 11/07/2015 a las 0:56, Geoff Flight escribió:


I'm. back again.  I have SQL Server 2014 and want to use a basic VFP
program to access data in it.  Pretty easy except Ive never done it
and its been a few years since I played around with it.  Can someone
recommend a good book that could talk me thru the basics?  I had Les
Pinter's book but I have put it away safely never to be seen again.

Thanks people!

Geoff




[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/55a508d7.8090...@yahoo.com.ar
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added

Fwd: Re: SQL Server 2014

[Rafael Copquin]

None of you use cursor adapters? I use them all the time and they are 
just great! And do not have any of the drawbacks mentioned about views


Rafael Copquin

El 14/07/2015 a las 5:04, Dave Crozier escribió:
 Remote views are great but with one drawback. If you make them 
dynamic or generate them on the fly then the database needs to be locked 
and this can really screw up your system (other users). We have a 
private personal database that is created per user that you have 
exclusive access to all the time. Makes it easy, efficient and fast.   
Dave  




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

Re: SQL Server 2014

[Rafael Copquin]

I can recommend this book, which you can get at www.hentzenwerke.com
Client-Server Applications with Visual FoxPro 6.0 and SQL Server 7.0


 Building Client-Server Applications with Visual FoxPro 6.0 and SQL
 Server 7.0

by Chuck Urwiler and others

It is a good primer that will teach you the basics on how to use VFP 
with SQL Server. And there are a few white papers in the web that you 
can consult


Rafael Copquin


El 11/07/2015 a las 0:56, Geoff Flight escribió:

I'm. back again.  I have SQL Server 2014 and want to use a basic VFP program
to access data in it.  Pretty easy except Ive never done it and its been a
few years since I played around with it.  Can someone recommend a good book
that could talk me thru the basics?  I had Les Pinter's book but I have put
it away safely never to be seen again.

Thanks people!

Geoff




[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/55a1095a.7030...@yahoo.com.ar
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do 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 Autofit

[Rafael Copquin]

The best way to do this is thus:

Populate the grid on page 1 with the father records. This grid will 
never loose its settings.


In the afterrowcolchange method of this grid put the following code:
(this code operates on each record of page 1 as you go up or down its grid)

 thisform.pageframe1.page2.grid1.recordsource = ''

 use in select('curChildren')

     here goes your select statement to get the children records 
(say you name it curChildren)


  select * from father table where fatherid =  into cursor 
curChildren nofilter


   with  thisform.pageframe1.page2.grid1
   .recordsource = 'curChildren'
  .column1.controlsource = 'curChildren.field1'  the name of 
each field in your cursor

  .column2.controlsource = 'curChildren.field2'
  etc
  endwith

 thisform.pageframe1 .page2.refresh

BTW, the autofit property is used to make all records in a grid show 
without truncation, but only in the part of the grid that you see at any 
one time, so _it is not good for what you need_. You just click on the 
top left of the grid and it refits itself to show the full length of the 
contents in each column.




Rafael Copquin



El 18/06/2015 a las 12:16, Kevin Cully escribió:
I'm working on a VFP form and I don't think I'm using a best practice 
for AUTOFITting a grid.  I've a pageframe with two pages, each page 
has a grid. Many of these parent records have zero child sales records 
and/or labor records.  What's the best practice to get the grids to 
AUTOFIT reliably?


Grids are set as:
 ReadOnly = .T.
AllowCellSelection = .F.

In the THISFORM.LOAD() event, I create a cursor that I leave open for 
the life of the form. When I navigate through the order records, I SQL 
SELECT the child records, select the cursor that was created in the 
LOAD(), ZAP it, and then append records from the cursor for the 
display of the child records.  This saves me from using views, and the 
binding/unbinding problem with grids.


Here's the code I use to try to get that grid to autofit properly. 
This code is *after* I've reloaded the records in the child cursor.



THISFORM.LockScreen = .T.
 Lots of business stuff... including reloading the child cursor.
THISFORM.LockScreen = .F.

THISFORM.Pageframe1.Page1.grdSales.AutoFit()
THISFORM.Pageframe1.Page2.grdLabor.AutoFit()
THISFORM.Refresh()

The grids still aren't displayed with the optimized field sizes. 
Harumph. Thanks for any help.



[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/5582fde8.2030...@yahoo.com.ar
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do 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: Programatically using Regsvr32

[Rafael Copquin]

I don't know about using it programmatically. However, I found that the 
only way to use regserver32 to install an ocx in windows 7 is to open a 
dos window as an administrator and run it from there.


And get rid of the uac! We are big boys and know how to do things. We 
don't need Microsoft to protect us with the uac, at least not me !! A 
good antivirus software like Kaspersky plus a password in your router is 
all you need


Rafael Copquin


El 10/06/2015 a las 10:16, Dave Crozier escribió:

Has anyone in this wonderful throng of people had any success using regsvr32 to 
register an OCX programmatically in VFP.

I have a routine that used to run brilliantly on XP but it just fails on Win 7 
despite giving the indication that all is OK. I am sure it is to do with 
elevated permissions and UAC.

The additional problem is also to decide whether to copy the OCX into the Windows\System, 
or Windows\System32 or Windows\SYSWOW64 folder before registering it as the OCX's 
required are held on a network share, but that is just a nicety just to package the OXC 
installation up into a one off if it isn't there then install it routine.

I would ideally like to use only inbuilt VFP commends (DLL Calls etc) and not 
have to shell out to the command window on both 32 and 64 bit operating system 
versions.

Thanks in anticipation.
Dave




--- 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/55783f0d.8090...@yahoo.com.ar
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do 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: zip/unzip

[Rafael Copquin]

Thanks to all
I found it and solved my problem
Rafael


El 04/06/2015 a las 16:23, Kevin Cully escribió:
I posted a wrapper class of Craig Boyd's VFPCompression to make it 
easier to get the syntax right.


http://leafe.com/dls/vfp



On 06/04/2015 03:06 PM, Kurt Wendt wrote:
I swear that sounds like something that is available in the Downloads 
section of the ProFox forum. You might want to check there first.


Just a thought...

-K-

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of 
Rafael Copquin

Sent: Thursday, June 04, 2015 2:59 PM
To: profoxt...@leafe.com
Subject: zip/unzip

Years ago I had obtained a zip/unzip class from someone in this forum.
It would zip the database,tables and index files and place the zip 
file in a folder. And then one could unzip the files back to the 
tables folder, all of this automatically.


But I lost it and need something like that to include as a 
backup/recover routine in one of my programs


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

zip/unzip

[Rafael Copquin]

Years ago I had obtained a zip/unzip class from someone in this forum.
It would zip the database,tables and index files and place the zip file 
in a folder. And then one could unzip the files back to the tables 
folder, all of this automatically.


But I lost it and need something like that to include as a 
backup/recover routine in one of my programs


Rafael Copquin


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