MYSQL connection

2021-02-26 Thread Rafael Copquin
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

Re: sql server connection

2021-02-11 Thread Rafael Copquin
'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 Serve

sql server connection

2021-02-11 Thread Rafael Copquin
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

Re: now it is cxi files

2020-10-26 Thread Rafael Copquin
t; -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 w

now it is cxi files

2020-10-26 Thread Rafael Copquin
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

Re: phdbase

2020-10-13 Thread 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

phdbase

2020-10-13 Thread Rafael Copquin
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

AZURE and VFP

2020-06-26 Thread Rafael Copquin
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

Re: TSQL equivalent of strtran function

2019-05-03 Thread Rafael Copquin
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

TSQL equivalent of strtran function

2019-05-02 Thread 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

Re: VFP9 Grid record focus

2018-11-17 Thread Rafael Copquin
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

Re: Print salary receipts to a pdf image

2018-09-14 Thread 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

Re: Print salary receipts to a pdf image

2018-09-14 Thread 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.

Re: Print salary receipts to a pdf image

2018-09-14 Thread Rafael Copquin
s 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 > &g

Re: Print salary receipts to a pdf image

2018-09-14 Thread 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

Print salary receipts to a pdf image

2018-09-13 Thread Rafael Copquin
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

Re: Backup in SQL Server

2018-09-11 Thread 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

Backup in SQL Server

2018-09-10 Thread Rafael Copquin
. 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 Rafa

Re: alter column in sql server

2018-09-06 Thread Rafael Copquin
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 impo

alter column in sql server

2018-09-06 Thread Rafael Copquin
, 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

between clause in TSQL (from VFP9)

2018-08-08 Thread Rafael Copquin
inning 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-signa

Re: recno() function in t-sql

2018-07-05 Thread Rafael Copquin
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:profox

Re: recno() function in t-sql

2018-07-05 Thread 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

recno() function in t-sql

2018-07-04 Thread 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

vfp and sqlsever

2018-07-04 Thread Rafael Copquin
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

Re: VFP9, SqlServer and NULL values

2018-06-13 Thread Rafael Copquin
e 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 tab

Re: VFP9, SqlServer and NULL values

2018-06-13 Thread Rafael Copquin
E() > > 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 2

VFP9, SqlServer and NULL values

2018-06-13 Thread Rafael Copquin
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

Re: Resetting VFP

2018-04-27 Thread Rafael Copquin
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-

Re: Appending from a Cursor

2018-04-12 Thread 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 >

Re: persistence of sql server database in memory

2017-11-10 Thread Rafael Copquin
rce=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&g

persistence of sql server data in memory

2017-11-10 Thread Rafael Copquin
. 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://w

persistence of sql server database in memory

2017-11-10 Thread Rafael Copquin
. 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://w

Re: WG: recno() function in tsql

2017-10-27 Thread 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 REC

recno() function in tsql

2017-10-26 Thread 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

Re: Using AWS from a VFP app

2017-10-24 Thread Rafael Copquin
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 host

Re: Using AWS from a VFP app

2017-10-24 Thread Rafael Copquin
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

Re: Email with CDO error

2017-09-26 Thread Rafael Copquin
il 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ó:

Re: email with CDO error

2017-09-26 Thread Rafael Copquin
ing 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

Re: Email with CDO error

2017-09-26 Thread Rafael Copquin
ing 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

RE: Email with CDO error

2017-09-25 Thread Rafael Copquin
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 &

Email with CDO error

2017-09-25 Thread Rafael Copquin
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

Re: VFP and CDO banging my head against the wall

2017-09-04 Thread 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

VFP and CDO banging my head against the wall

2017-09-04 Thread Rafael Copquin
;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://

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

2017-08-16 Thread 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

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

2017-08-15 Thread Rafael Copquin
, 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

Re: numeric overflow

2017-07-10 Thread 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") = "***.**" E

Re: numeric overflow

2017-07-07 Thread 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

numeric overflow

2017-07-07 Thread 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

Re: VFP and Gmail

2017-06-06 Thread 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

VFP and Gmail

2017-06-06 Thread rafael copquin
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

Re: generate pdf files by batch and send them by email

2017-05-16 Thread rafael copquin
eedles 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 Me

Re: [NF] Anti-Virus Programs

2017-02-20 Thread 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

Re: SQL Backend Question - Part Deux

2017-02-10 Thread 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

Re: SQL Backend Question - Part Deux

2017-02-10 Thread 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

Re: SQL Backend Question - Part Deux

2017-02-09 Thread rafael copquin
, 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 c

Re: SQL Backend Question - Part Deux

2017-02-08 Thread rafael copquin
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'

Re: SQL Backend Question - Part Deux

2017-02-08 Thread rafael copquin
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 g

cursor adapter class

2016-11-22 Thread rafael copquin
://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

Re: Problem with VFP IDE (VFP9SP2, fully patched)

2016-10-24 Thread 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

Re: Excel errors

2016-10-21 Thread rafael copquin
ing 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:prof

Excel errors

2016-10-21 Thread rafael copquin
. 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 _

Re: Report label caption expression

2016-08-25 Thread 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

Re: Report label caption expression

2016-08-25 Thread 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

Re: Too simple report?

2016-08-23 Thread 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

Re: GETFILE and SET DEFAULT

2016-07-20 Thread 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

more on PDF and VFP

2016-07-14 Thread rafael copquin
: 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

Re: VFP Display a PDF

2016-07-13 Thread 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

Re: VFP Display a PDF

2016-07-12 Thread rafael copquin
','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

Re: updating 2 forms

2016-07-06 Thread rafael copquin
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

Re: [NF] Just like VFP...

2016-06-24 Thread rafael copquin
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

Re: [NF] Just like VFP...

2016-06-24 Thread rafael copquin
, 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

Re: A Blank Value for a Number?

2016-06-16 Thread rafael copquin
...@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

Re: A Blank Value for a Number?

2016-06-14 Thread rafael copquin
ins 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 manipu

Re: Excel automation

2016-06-13 Thread 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

Excel automation

2016-06-10 Thread rafael copquin
sk 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

[NF] TEAMVIEWER

2016-06-01 Thread 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

Re: Shortcut to generalized click column for sort order browse?

2016-05-13 Thread 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

Re: [NF] Virtual Box

2016-05-10 Thread 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

Re: [NF] Win10 Update anyone?

2016-05-02 Thread 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

Re: [NF] Win10 Update anyone?

2016-04-29 Thread 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

Re: [NF] Win10 Update anyone?

2016-04-28 Thread rafael copquin
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

Re: problem with calculations with VFP9 and MSSQL Server

2016-03-25 Thread rafael copquin
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.

problem with calculations with VFP9 and MSSQL Server

2016-03-25 Thread rafael copquin
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

Re: email from vfp

2016-01-08 Thread 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

email from vfp

2016-01-07 Thread Rafael Copquin
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

RE: Array passing Suggestions...

2015-11-25 Thread Rafael Copquin
alled 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

problem with calculations with VFP9 and MSSQL Server

2015-11-12 Thread Rafael Copquin
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

Re: windows10 where is it?

2015-08-21 Thread Rafael Copquin
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

Re: windows10 where is it?

2015-08-21 Thread Rafael Copquin
...@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

windows10 where is it?

2015-08-21 Thread Rafael Copquin
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

Re: [NF] Thunderbird - Missing Sent Emails...

2015-08-21 Thread Rafael Copquin
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

Re: Cursor Adapter

2015-08-03 Thread 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

Re: SQL Server 2014

2015-07-14 Thread 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

Fwd: Re: SQL Server 2014

2015-07-14 Thread 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

Re: SQL Server 2014

2015-07-11 Thread Rafael Copquin
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

Re: Grid Autofit

2015-06-18 Thread Rafael Copquin
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

Re: Programatically using Regsvr32

2015-06-10 Thread Rafael Copquin
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

Re: zip/unzip

2015-06-04 Thread Rafael Copquin
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

zip/unzip

2015-06-04 Thread Rafael Copquin
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

  1   2   3   4   5   6   7   8   9   >