Re: Help with GATHER and AutoInc fields

2008-12-29 Thread Rafael Copquin
by itself, incrementing the fields value automatically and allowing a new record to be added. Happy New Year Rafael Copquin - Original Message - From: Matt Slay foxst...@jordanmachine.com To: profoxt...@leafe.com Sent: Sunday, December 28, 2008 1:38 AM Subject: Help with GATHER

Fw: Help with GATHER and AutoInc fields

2008-12-29 Thread Rafael Copquin
Sorry I made a gross mistake: the line should be scatter name, not gather name, when you create the object scatter name oCustomers memo blank (two much champagne during the Christmas celebrations) Rafael Copquin - Original Message - From: Rafael Copquin rcopq...@ciudad.com.ar

Re: Help with GATHER and AutoInc fields

2008-12-29 Thread Rafael Copquin
V. Berard, Life-Cycle Approaches -- From: Rafael Copquin rcopq...@ciudad.com.ar Sent: Monday, December 29, 2008 4:47 PM To: profoxt...@leafe.com Subject: Fw: Help with GATHER and AutoInc fields Sorry I made a gross mistake: the line should

Re: vfp and sqlserver express edition 2008 (first steps in VFP andSQLServer)

2008-12-23 Thread Rafael Copquin
My apologies for the delay in answering this one, but I had been using my notebook and this email entered via my desktop and just read it today. Hope this helps. Yes, it does, thank you and Merry Christmas (extended wish to all of you profoxers!) Rafael Copquin - Original Message

vfp and sqlserver express edition 2008 (first steps in VFP and SQLServer)

2008-12-17 Thread Rafael Copquin
tell me how to write the connection string? TIA Rafael Copquin ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech

The Matrix runs on Windows [NF]

2008-12-16 Thread Rafael Copquin
http://www.collegehumor.com/video:1886349 Merry Christmas and a Happy New Year to all profoxers! Rafael Copquin ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version

Re: Menu pads, popups and bars

2008-11-24 Thread Rafael Copquin
helps to know how it works, and we can use as in this case. Hope it helps Rafael Copquin - Original Message - From: Paul Newton [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, November 23, 2008 10:34 PM Subject: Menu pads, popups and bars Hi I have a third-party tool/add

Re: stored procedures in SQL

2008-11-19 Thread Rafael Copquin
a Stored Procedure on SQL Express in VFP: http://blogs.msdn.com/calvin_hsia/archive/2006/05/19/602089.aspx Dave Crozier -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rafael Copquin Sent: 19 November 2008 00:19 To: Profox Subject: stored

Re: stored procedures in SQL

2008-11-19 Thread Rafael Copquin
Thanks, Stephen, good tip. Rafael - Original Message - From: Stephen Russell [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 19, 2008 11:04 AM Subject: Re: stored procedures in SQL On Tue, Nov 18, 2008 at 6:19 PM, Rafael Copquin [EMAIL PROTECTED] wrote: Perhaps

Re: stored procedures in SQL

2008-11-19 Thread Rafael Copquin
Wow,Jeff ! That's just what I needed to start with ! Thank you very much indeed ! Rafael Copquin - Original Message - From: Jeff Trusty [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 19, 2008 2:47 AM Subject: Re: stored procedures in SQL Rafael, Creating

stored procedures in SQL

2008-11-18 Thread Rafael Copquin
(passing for instance a customer PK), so the procedure will return the customer name, address, email, etc. A very simple sql call. But how do you create the procedure in the SQL engine? Or should I ask this question in a SQL forum? TIA Rafael Copquin --- StripMime Report -- processed MIME parts

udl files

2008-11-12 Thread Rafael Copquin
smart trick. But as usual when I assist to an all-day course, I was drowsy at the time and missed the explanation on how to make this file. Thanks in advance Rafael Copquin ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http

Re: udl files

2008-11-12 Thread Rafael Copquin
Thanks for the info Stephen Rafael - Original Message - From: Stephen Russell [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 12, 2008 2:08 PM Subject: Re: udl files On Wed, Nov 12, 2008 at 11:41 AM, Rafael Copquin [EMAIL PROTECTED] wrote: Does anyone know how

Re: udl files

2008-11-12 Thread Rafael Copquin
and it will open a Data Link properties window. On Wed, Nov 12, 2008 at 10:41 AM, Rafael Copquin [EMAIL PROTECTED]wrote: Does anyone know how to make a udl file to test a SQLServer connection? Last week I attended a course on how to integrate SQLServer to VFP and the instructor showed a way to create

passwords and automation

2008-09-30 Thread Rafael Copquin
) .visible = .t. endwith In the above scenario I have to also send the password, so what code should I write? TIA Rafael Copquin ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free

autoincremental values

2008-09-24 Thread Rafael Copquin
with tableupdate if save is ok then end transaction otherwise rollback I need the second autoincremental value from the father table, the control field ctl, to replace in the appropriate field in the child table. So again, how can I obtain this value? TIA Rafael Copquin --- StripMime Report

Re: autoincremental values

2008-09-24 Thread Rafael Copquin
) Is there a better way? Rafael Copquin Original Message - From: Rafael Copquin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 24, 2008 2:38 PM Subject: autoincremental values I have a table with two fields configured as integer autoinc.This is a father table. The child

Word automation

2008-09-22 Thread Rafael Copquin
. However, if I wanted to know in advance whether an instance of Excel is open in the user's computer, is there any API call or function that would tell me this] And if there is, could any of you post the code to accomplish this] TIA Rafael Copquin

Re: Word automation

2008-09-22 Thread Rafael Copquin
Thank you guys I'll look into your suggestions Rafael - Original Message - From: Rafael Copquin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 22, 2008 7:47 AM Subject: Word automation I usually use this code to launch Excel via automation: if upper(vartype

strange issue with formsets

2008-09-09 Thread Rafael Copquin
the application before closing the formset I get this message: property closeformset is not found Any clues?? Rafael Copquin --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html

Re: strange issue with formsets

2008-09-09 Thread Rafael Copquin
Thanks Mike - Original Message - From: MB Software Solutions General Account [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 09, 2008 4:21 PM Subject: Re: strange issue with formsets On Tue, September 9, 2008 4:56 am, Rafael Copquin wrote: First of all let me tell

Re: DAFUG - September 2008

2008-09-09 Thread Rafael Copquin
I would be very interested myself in receiving such info Rafael Copquin - Original Message - From: Rick Schummer [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 09, 2008 4:34 PM Subject: RE: DAFUG - September 2008 Is there any way people outside USA get access

Re: DAFUG - September 2008

2008-09-09 Thread Rafael Copquin
Fair enough Rafael Copquin - Original Message - From: Cathy Pountney [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 09, 2008 5:08 PM Subject: RE: DAFUG - September 2008 My consider my first obligation to be with the Southwest Fox conference. I wouldn't release

Re: sql server and windows vista

2008-08-26 Thread Rafael Copquin
: On Mon, Aug 25, 2008 at 3:35 AM, Rafael Copquin [EMAIL PROTECTED] wrote: Hi Stephen I have the Home edition of Vista . Do not know whether I can use IIS with that version, but, is it necessary to install the Developer Edition of SQL 2000

Re: sql server and windows vista

2008-08-26 Thread Rafael Copquin
Well, I'll [EMAIL PROTECTED] I am beginning to agree with all those who advice me to dump Vista and go back to XP. Thanks for the tip Un abrazo Rafael Copquin - Original Message - From: Jaime Vasquez [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 26, 2008 3:04 PM

sql server and windows vista

2008-08-25 Thread Rafael Copquin
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://leafe.com/mailman/listinfo/profox

Re: sql server and windows vista

2008-08-25 Thread Rafael Copquin
in to Management studio? On Mon, 25 Aug 2008 07:22:13 +0200, Rafael Copquin [EMAIL PROTECTED] said: Hi all I just got a new Dell computer with a Windows Vista Home Premium OS. I also installed SQL 2000 Server Developer Edition, because I want to start learning how to integrate VFP 9 with SQL Server

Re: SQL VFP6 Integer

2008-08-25 Thread Rafael Copquin
select as intcolumn from yourtable into cursor yourcursor Rafael Copquin - Original Message - From: Gérard Lochon [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 25, 2008 1:57 PM Subject: SQL VFP6 Integer Hello guys. My mind is out my brain today, so i

Re: sql server and windows vista

2008-08-25 Thread Rafael Copquin
Sorry, better English would have been: I simply can't start ANY of it (:-)) Rafael - Original Message - From: Rafael Copquin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 25, 2008 8:51 AM Subject: Re: sql server and windows vista I simply can't start none of it Rafael

Re: sql server and windows vista

2008-08-25 Thread Rafael Copquin
Gil -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Rafael Copquin Sent: Monday, August 25, 2008 3:01 AM To: [EMAIL PROTECTED] Subject: Re: sql server and windows vista Sorry, better English would have been: I simply can't start ANY

Re: sql server and windows vista

2008-08-25 Thread Rafael Copquin
, 2008 2:46 PM Subject: Re: sql server and windows vista On Mon, Aug 25, 2008 at 12:22 AM, Rafael Copquin [EMAIL PROTECTED] wrote: Hi all I just got a new Dell computer with a Windows Vista Home Premium OS. I also installed SQL 2000 Server Developer Edition, because I want to start learning

Can I programattically set method code?

2008-07-25 Thread Rafael Copquin
Well, every day you learn something new, and, like they say: there are many ways to skin a fox (:-) I never new how to use allowsellselection. Thanks for the tip. Best regards Rafael Copquin - Original Message - From: Christof Wollenhaupt To: [EMAIL PROTECTED] Sent: Friday

Re: Third issue of FoxRockX - and VFP Lifetime Achievers....

2008-07-25 Thread Rafael Copquin
thanks Rafael - Original Message - From: Rick Schummer To: [EMAIL PROTECTED] Sent: Thursday, July 24, 2008 8:34 PM Subject: RE: Third issue of FoxRockX - and VFP Lifetime Achievers Would you post the url again please ? I'd like to take a look at it. For more

Re: Can I programattically set method code?

2008-07-24 Thread Rafael Copquin
Once the PK is obtained then I use it in the calling form as needed. In my experience, bindevents is great !! Rafael Copquin - Original Message - From: Rick Schummer To: [EMAIL PROTECTED] Sent: Thursday, July 24, 2008 12:47 AM Subject: RE: Can I programattically set method code? Ed's

Re: Can I programattically set method code?

2008-07-24 Thread Rafael Copquin
or enters on a grid. Maybe I waste 90 % of the possibilities of bindevents, but for me, when handling grids, its ok. Regards Rafael Copquin --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html

Re: Third issue of FoxRockX - and VFP Lifetime Achievers....

2008-07-24 Thread Rafael Copquin
Would you post the url again please ? I'd like to take a look at it. Rafael Copquin - Original Message - From: Kevin S. Goff To: [EMAIL PROTECTED] Sent: Thursday, July 24, 2008 5:38 PM Subject: Third issue of FoxRockX - and VFP Lifetime Achievers Hi, all... Third

speaking of triggers

2008-05-30 Thread Rafael Copquin
field would be updated with the current datetime. I get an error message: cannot modify record because the table is readonly. Is this by design and if so, why? Is there a workaround? (I know, I can code that in my form, but was wondering whether triggers would do) Please, clarify. Rafael

Re: setfocus() not taking complete effect on cmd group

2008-05-08 Thread Rafael Copquin
Hi , Whil: Two ideas: a) Keypreview on the form - set it to true b) keypress event on the button if nKeyCode = 13 this.value = i endif Untested Regards Rafael Copquin - Original Message - From: Whil Hentzen To: [EMAIL PROTECTED] Sent: Wednesday, May 07, 2008 3:06 PM

Re: Barcode article en espanol...

2008-04-23 Thread Rafael Copquin
Ricardo, as you asked, I reviewed your translation and it is extremely good. No correction is necessary. Muchos saludos Rafael Copquin Here you go Richard (see below). Rafael, hice lo mejor que pude, tal vez te sirva de punto de partida para una mejor traducción. Cualquier corrección es

Re: Barcode article en espanol...

2008-04-23 Thread Rafael Copquin
I would ask the original writer (Luis Maria Guayan) to do that. His site is full of articles on VFP themes. Rafael Copquin - Original Message - From: Ricardo Araoz To: [EMAIL PROTECTED] Sent: Wednesday, April 23, 2008 8:04 PM Subject: Re: Barcode article en espanol

Re: Barcode article en espanol...

2008-04-21 Thread Rafael Copquin
I can do that for you, but it is a very long article. If you give me a few days, I can try it. FYI Luis Maria Guayan is a very knowledgeable MVP and co-owner of PortalFox. Rafael Copquin - Original Message - From: Richard Kaye To: [EMAIL PROTECTED] Sent: Monday, April 21

Re: Grid - Remember Last positions

2008-04-16 Thread Rafael Copquin
it comes from a sql clause thisform.grid1.recordsource = select * from accounts into cursor curMyCursor.. thisform.set_grid() Regards Rafael Copquin - Original Message - From: Kent Belan To: [EMAIL PROTECTED] Sent: Tuesday, April 15, 2008 8:35 PM Subject: Grid - Remember

Re: VFP 6, MDAC and Vista

2008-03-31 Thread Rafael Copquin
Thank you Alan on behalf of my colleague. I'll relay this info to him right away Rafael Copquin - Original Message - From: Alan Bourke To: [EMAIL PROTECTED] Sent: Sunday, March 30, 2008 4:56 PM Subject: Re: VFP 6, MDAC and Vista Visual Studio 6 Service Pack 5

VFP 6, MDAC and Vista

2008-03-29 Thread Rafael Copquin
version (whichever it is) so he can run his VFP 6 with the SP 5 ? Thank you in advance on my colleague's behalf Rafael Copquin --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html

Re: Need more than just the pulldown main menu...toolbar orcustom form?

2008-03-26 Thread Rafael Copquin
browsers (after you click on the enlarge icon at the bottom right corner of your browser) Hope you like them BTW, if this does not work, then I will send the images to Mike Rafael Copquin - Original Message - From: MB Software Solutions General Account To: [EMAIL PROTECTED

Re: Need more than just the pulldown main menu...toolbar orcustomform?

2008-03-26 Thread Rafael Copquin
Subject: Re: Need more than just the pulldown main menu...toolbar orcustomform? Rafael Copquin wrote: I decided to open a temporary web site in my computer so you guys can take a look at the images. I was inspired to do this by Michael Babcock's offer to host the images in his own web site

Re: Need more than just the pulldown main menu...toolbar orcustomform?

2008-03-26 Thread Rafael Copquin
Ok, I entered into my home computer from the office, resaved the images as jpeg and tried connecting from the office browser. The images take an average of 15 to 20 seconds to load. I hope now you can see them Rafael - Original Message - From: Rafael Copquin To: [EMAIL

Re: Need more than just the pulldown main menu...toolbar orcustom form?

2008-03-25 Thread Rafael Copquin
the directory, BIG NUMBERS and just lets me speak or send a short SMS. My kids laugh at me but, oh well When I get home tonight I shall send them to you. Rafael Copquin - Original Message - From: MB Software Solutions General Account To: [EMAIL PROTECTED] Sent: Monday

Re: Need more than just the pulldown main menu...toolbar orcustomform?

2008-03-24 Thread Rafael Copquin
Well, I see that the images were left out I wonder how I can send them so you can see them. Rafael - Original Message - From: Rafael Copquin To: [EMAIL PROTECTED] Sent: Monday, March 24, 2008 8:42 AM Subject: Re: Need more than just the pulldown main menu...toolbar

Re: Need more than just the pulldown main menu...toolbar orcustom form?

2008-03-24 Thread Rafael Copquin
. Again, a bit late now, but Happy Easter anyway. Rafael Copquin - Original Message - From: Dan Olsson To: [EMAIL PROTECTED] Sent: Monday, March 10, 2008 8:58 AM Subject: Re: Need more than just the pulldown main menu...toolbar orcustom form? At 2008-03-10 16:49, you wrote

Re: VFP9 Wierd Behaviour

2008-03-19 Thread Rafael Copquin
and subclasses that precede it. Rafael Copquin - Original Message - From: Dave Crozier To: [EMAIL PROTECTED] Sent: Wednesday, March 19, 2008 7:08 AM Subject: RE: VFP9 Wierd Behaviour Alan, That seems to work fine, however it is a little worrying as to WHY DoDefault() sometime

Re: Universal Thread Magazine resumed

2008-03-17 Thread Rafael Copquin
is received by me with open arms. My two cents Rafael Copquin - Original Message - From: Cesar To: [EMAIL PROTECTED] Sent: Monday, March 17, 2008 1:53 AM Subject: Re: Universal Thread Magazine resumed 5 years ago, when I decided to try VFP, the main resources I found were

Re: Need more than just the pulldown main menu...toolbar or custom form?

2008-03-10 Thread Rafael Copquin
, statistics, utilities, etc) Works very well for me and my clients respect me (if not as a good programmer, at least as a sensitive artist, he,he,he) Regards Rafael Copquin - Original Message - From: MB Software Solutions General Account To: [EMAIL PROTECTED] Sent: Sunday, March 09

Re: from VFP to Access

2008-02-28 Thread Rafael Copquin
Thanks to all of you who responded. I'll follow your suggestions Rafael Copquin - Original Message - From: Allen To: [EMAIL PROTECTED] Sent: Wednesday, February 27, 2008 11:16 AM Subject: RE: from VFP to Access The FTP was talked about recently. In the archive

from VFP to Access

2008-02-27 Thread Rafael Copquin
is slow and not reliable, but since I never tried this I may be totally wrong. Also, the client needs to send stuff directly from VFP using FTP. I also need an example of this Thank you all in advance Rafael Copquin --- StripMime Report -- processed MIME parts --- multipart/alternative

Re: VFP project version?

2008-02-20 Thread Rafael Copquin
Check the vfp help for the version() function, the version property and similar. Rafael Copquin - Original Message - From: Lou Syracuse To: [EMAIL PROTECTED] Sent: Tuesday, February 19, 2008 6:58 PM Subject: VFP project version? We have about a dozen VFP applications

Re: Need for webservice to be called from our app in near future(VFP9)

2008-01-25 Thread Rafael Copquin
, who knows his way around WS, components and the like, which I am still ages away to master. But the main thing is: no need for ASP, C# or any .NET component or language. Just VFP 9 alone. Hope this was helpful Rafael Copquin Treasurer - Microsoft Users Group of Argentina - Original

Re: Copy of dbsalvage?

2007-11-19 Thread Rafael Copquin
You can use the NVL function, like this: insert into myfreetable(code,company,purchasedate) values( nvl(nCode,0),nvl(cCompany,''),nvl(dPurchDate,{}) Rafaell Copquin - Original Message - From: Ed Leafe To: [EMAIL PROTECTED] Sent: Thursday, November 15, 2007 2:00 PM Subject:

Re: xmltocursor blues

2007-11-19 Thread Rafael Copquin
on the basis that the source code is yours - there are plenty around). Rafael Copquin wrote: Hi guys, I want to insist in the enclosed post. Mike Babcock already replied to question 3) but I still do not know how to deal with 1) and 2) Any ideas? Thank you Rafael Copquin

Re: xmltocursor blues

2007-11-16 Thread Rafael Copquin
Thanks for the information. However, what about questions 1 and 2 ? Rafael - Original Message - From: MB Software Solutions To: [EMAIL PROTECTED] Sent: Thursday, November 15, 2007 7:52 PM Subject: Re: xmltocursor blues Rafael Copquin wrote: snipped 3) the handheld

xmltocursor blues

2007-11-15 Thread Rafael Copquin
the other fellow will not release the source code 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

VFP 9 SP2 foreign language versions

2007-10-15 Thread Rafael Copquin
tell me about this, I mean, what should I warn my fellow programmers to be aware of? TIA Rafael Copquin --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages

grid footers

2007-10-02 Thread Rafael Copquin
on the right, I would like the bottom labels to move in sync with the columns. Is this possible? Rafael Copquin --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages

Re: grid footers

2007-10-02 Thread Rafael Copquin
-0300 From: Rafael Copquin [EMAIL PROTECTED] Subject: grid footers To: [EMAIL PROTECTED] Message-ID: [EMAIL PROTECTED] Content-Type: text/plain; charset=us-ascii I am building a complicated information system which involves creating a grid with a variable number of columns

Re: DragDrop

2007-10-01 Thread Rafael Copquin
,3,@nRow,@nCol) = this.ActivateCell (nRow,nCol) Insert into (this.RecordSource) (companyname) values (oSource.value) Delete In (oSource.parent.parent.recordsource) thisform.Refresh EndIf The above code was developed by a friend of mine, who does not participate in this forum. Rafael Copquin

Re: Can a #DEFINE constant be used in a SQL SELECT statement?

2007-09-15 Thread Rafael Copquin
, it will not be seen Rafael Copquin - Original Message - From: Jon Westcot To: [EMAIL PROTECTED] Sent: Tuesday, September 11, 2007 11:42 PM Subject: Can a #DEFINE constant be used in a SQL SELECT statement? Hi all: I'm trying to generalize an application that I've

Re: varchar vs character type fields

2007-09-10 Thread Rafael Copquin
to the varchar type? Why? TIA Rafael Copquin --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages

varchar vs character type fields

2007-09-08 Thread Rafael Copquin
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://leafe.com/mailman/listinfo/profox OT-free

Re: navigating in parent of table one to many form

2007-08-31 Thread Rafael Copquin
You then run your select and populate the grid again and refresh the form You don't have in this manner any problems with relations, avoid the problem you described and, in addition, since you are using a select statement, your datasource could even be SqlServer, MySql, VFP, etc regards Rafael

quit in Excel automation

2007-08-24 Thread Rafael Copquin
intervention. What is the Excel command I should send to avoid this question? TIA Rafael Copquin --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox

quit in Excel automation

2007-08-24 Thread Rafael Copquin
intervention. What is the Excel command I should send to avoid this question? TIA Rafael Copquin --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox

Re: quit in Excel automation

2007-08-24 Thread Rafael Copquin
That did it ! Thank you - Original Message - From: Peter Cushing To: [EMAIL PROTECTED] Sent: Friday, August 24, 2007 12:55 PM Subject: Re: quit in Excel automation Rafael Copquin wrote: Hi all I am reading an Excel sheet using automation. When I send

Re: quit in Excel automation

2007-08-24 Thread Rafael Copquin
it already under a name then oExcel.Quit -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rafael Copquin Sent: 24 August 2007 16:50 To: profox@leafe.com Subject: quit in Excel automation Hi all I am reading an Excel sheet using

Re: quit in Excel automation

2007-08-24 Thread Rafael Copquin
I heard you the first time :) Sorry, my fault thank you for your reply take care - Original Message - From: Dan Olsson To: [EMAIL PROTECTED] Sent: Friday, August 24, 2007 12:55 PM Subject: Re: quit in Excel automation At 2007-08-24 17:49, you wrote: I am reading an

Re: Multiple controls on Grid Column

2007-08-03 Thread Rafael Copquin
Yes, it is possible. Simply put all those controls in a container and add the container to the grid column Rafael Copquin - Original Message - From: David Boatright To: [EMAIL PROTECTED] Sent: Friday, August 03, 2007 12:15 AM Subject: Multiple controls on Grid Column

Re: VFP9 - cursortoxml

2007-06-13 Thread Rafael Copquin
. instead of the 1 or the 0 Thank you very much in advance Rafael Copquin - Original Message - From: Eyvind Axelsen To: [EMAIL PROTECTED] Sent: Wednesday, June 13, 2007 4:20 AM Subject: Re: VFP9 - cursortoxml An xsl is not the schema (while an xsd file is). The xsl

Re: VFP9 - cursortoxml

2007-06-13 Thread Rafael Copquin
melding- Fra: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] På vegne av Rafael Copquin Sendt: 13. juni 2007 10:45 Til: profox@leafe.com Emne: Re: VFP9 - cursortoxml Hi Eyvind You seem to know how to create a schema in VFP 9 I want to use the xmladapter class with the following xmlfile

Re: xmltocursor

2007-06-12 Thread Rafael Copquin
Thank you Wayne Rafael - Original Message - From: Wayne Sobers To: [EMAIL PROTECTED] Sent: Monday, June 11, 2007 10:52 AM Subject: Re: xmltocursor Depending on the XML organisation, the XML adapter class can load and create multiple cursors from a single XML file.

Re: How to update a table ?

2007-06-11 Thread Rafael Copquin
back, you could select them directly from the oRecord object, thus: gather from name oRecord fields account,custname,custaddress Hope it helps Rafael Copquin - Original Message - From: Eurico Chagas Filho To: [EMAIL PROTECTED] Sent: Monday, June 11, 2007 8:17 AM Subject

Re: How to update a table ?

2007-06-11 Thread Rafael Copquin
(1,.t.,'thetabletobeupdated') then, in the calling form: do form secondmodalform and you should refresh the grid (if you used one to do your lookup) or the combo (if it is a small table) thisform.grid1.refresh or thisform.combo1.requery() Rafael Copquin - Original Message

xmltocursor

2007-06-09 Thread Rafael Copquin
for the xmltocursor function to work? 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://leafe.com/mailman

Re: xmltocursor

2007-06-09 Thread Rafael Copquin
In addition to the below message, I should say that the table structure I need from this file is 7798121754621001.DBF articulo C(13) this would be the 13 digit item bar code as read by the scanner cantidad N(4) Rafael Copquin - Original Message - From: Rafael Copquin

Re: xmltocursor

2007-06-09 Thread Rafael Copquin
Thank you very much I tried it and can read it, though it does not give me the field names. I guess I will have to interpret the output. One question, ¿is there a limit to the number of records the xml can have? What I mean is this: the xml I get is the result of filling up a sales order, by

Re: xmltocursor

2007-06-09 Thread Rafael Copquin
Yes, that certainly can help. I'll read it and see what I can do. Thank you again. BTW, because of the time difference I assume you are in Europe. Great Britain, perhaps? Rafael - Original Message - From: Bill Arnold To: [EMAIL PROTECTED] Sent: Saturday, June 09, 2007 7:13

Re: xmltocursor

2007-06-09 Thread Rafael Copquin
I see, well I work weird hours too. Take care Rafael - Original Message - From: Bill Arnold To: [EMAIL PROTECTED] Sent: Saturday, June 09, 2007 9:58 AM Subject: RE: xmltocursor Yes, that certainly can help. I'll read it and see what I can do. Thank you again.

Re: VFP to XML

2007-05-29 Thread Rafael Copquin
no interference with the original form. In your case, you say you receive and XML file, so play with the above functions and you're all set. Regards Rafael Copquin - Original Message - From: Sytze de Boer To: [EMAIL PROTECTED] Sent: Tuesday, May 29, 2007 3:21 AM Subject: VFP to XML Hi

Re: hitting enter to advance record in a grid?

2007-05-04 Thread Rafael Copquin
described in the article to use grids as data entry screens for many situations. Hope it helps Rafael Copquin - Original Message - From: Derek Kalweit To: [EMAIL PROTECTED] Sent: Friday, May 04, 2007 5:49 PM Subject: hitting enter to advance record in a grid? Hello. Has

[OT] from a father whose chest is inflated with pride

2007-05-01 Thread Rafael Copquin
I know that perhaps this is not the right place to express my feelings, but I have been reading all kinds of feelings and opinions from you guys, and thought that with the proper OT branding, the attached can be shared. Rafael Copquin --- StripMime Report -- processed MIME parts --- multipart

imagelist control

2007-04-12 Thread Rafael Copquin
from records in a special table. And there is where I get the error. Why does it work when designed visually and not when instantiated from a class ? I know that some of the authors of the book are in this list and would appreciate some help on this issue Thanks very much in advance Rafael

Re: passing parms to a modal form

2007-04-05 Thread Rafael Copquin
in the unload or destroy events of the called form. Hope this helps Rafael Copquin - Original Message - From: Andy Davies To: [EMAIL PROTECTED] Sent: Thursday, April 05, 2007 6:36 AM Subject: passing parms to a modal form I'm sure I've done this dozens of times but can't get this one

Re: Preventing .null. Values in a view

2007-03-21 Thread Rafael Copquin
This function replaces the value not found with whatever you send it as the second parameter. This parameter has to be of the same type as the missing value, ie, character, logic, number, date, etc Rafael Copquin - Original Message - From: John J. Mihaljevic To: [EMAIL PROTECTED

Re: Caption Property

2007-03-19 Thread Rafael Copquin
thisform.pageframe1.pageframe2.activepage = 2 Rafael Copquin - Original Message - From: Eurico Chagas Filho To: [EMAIL PROTECTED] Sent: Monday, March 19, 2007 10:38 AM Subject: Caption Property Hi I have a form, a pageframe with two pages. On page two( pgp2) I have

Re: Caption Property

2007-03-19 Thread Rafael Copquin
Where do you want to use the key combination, in popups or combos? (I haven't played tennis for a while, but I'd love to) Take care Rafael - Original Message - From: Eurico Chagas Filho To: [EMAIL PROTECTED] Sent: Monday, March 19, 2007 11:19 AM Subject: Caption Property

Re: INI Files

2007-03-17 Thread Rafael Copquin
ExecScript(cpath) the memo field name is cpath Use in knet Rafael Copquin www.copquin.com.ar - Original Message - From: John Weller To: [EMAIL PROTECTED] Sent: Friday, March 16, 2007 5:55 PM Subject: INI Files I'm having a real brain stall here! I'm trying to write

Re: INI Files

2007-03-17 Thread Rafael Copquin
tks Rafael - Original Message - From: MB Software Solutions To: [EMAIL PROTECTED] Sent: Saturday, March 17, 2007 11:48 AM Subject: Re: INI Files Rafael Copquin wrote: I do precisely that in all my apps. I place a small text file (I call it knet.ini, so smart ass users

Re: Joke

2007-01-26 Thread Rafael Copquin
As a Public Accountant myself, I enjoyed this joke very much ROFL Rafael Copquin - Original Message - From: Nicholas Geti To: [EMAIL PROTECTED] Sent: Thursday, January 25, 2007 2:34 PM Subject: Joke Three accountants and three Lawyers take a train trip. The accountants

Re: Triplicate/duplicate forms need -- how do you handle it?

2006-12-19 Thread Rafael Copquin
command (inkey) will give the USB port 2 seconds after printing each page, which is time enough for the next set printer command to work Regards Rafael Copquin ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman

Re: Triplicate/duplicate forms need -- how do you handle it?

2006-12-19 Thread Rafael Copquin
That's because you're too young! I go back to 1987 with the fox and, living in a Latin American country, had to make do with what was available, not always the most rational solution. (I mean the do while loop I posted) But the printjob/endprintjob construct works well and is really

Re: Triplicate/duplicate forms need -- how do you handle it?

2006-12-19 Thread Rafael Copquin
in the Southern Hemisphere. Bye for now Rafael Copquin - Original Message - From: Hal Kaplan To: [EMAIL PROTECTED] Sent: Tuesday, December 19, 2006 5:55 PM Subject: RE: Triplicate/duplicate forms need -- how do you handle it? = Subject: Re: Triplicate/duplicate forms need

[admin] not receiving posts from PROFOX

2006-12-07 Thread Rafael Copquin
I have not received any postings in the last two days. Any administrative reason? Rafael Copquin ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com

<    3   4   5   6   7   8   9   >