Re: Numeric vs. Integer fields in a dbf

2010-09-08 Thread Rafael Copquin
decimals. Check the literature or SQL BOL for definitions on integers in SQL. No point in using big int if you can do with small int or tiny int. Performance, space, future table growth considerations should help you in your decision. Rafael Copquin El 08/09/2010 2:19, Matt Slay escribió: I have

Re: Updating child records

2010-09-03 Thread Rafael Copquin
You could do it in this way: optimistic , one for the header table and the Hello, ProFox@leafe.com http://leafe.com/mailman/listinfo/profox http://leafe.com/mailman/listinfo/profoxtech http://leafe.com/archives/search/profox

Re: Updating child records

2010-09-03 Thread Rafael Copquin
=6D486D46474479367953553D20704A3267504C62623144375349667062312F355452413D3D Rafael Copquin El 02/09/2010 10:25, Kent Belan escribió: Hello, Just wondering how others handle this situation, maybe there is a better way. I have a parent / child setup, where I pull a cursor of the child records and then allow add/edit/delete on the child

Re: Code References VFP7 vs. VFP9

2010-09-02 Thread Rafael Copquin
download it from ProFox. I could email it to you if you can't find it. Rafael Copquin El 02/09/2010 17:50, Kurt Wendt escribió: Hey there Vincent, Thanks for the quick feedback! I agree - Code Ref IS a Great tool! And, yeah - I guess I kinda figured it was new and specific to VFP9

Re: Any gurus out there?

2010-08-31 Thread Rafael Copquin
of char. Rafael Copquin El 30/08/2010 23:03, Sytze de Boer escribió: I have now seen it with mine own eyes and stopped cursing my client In my invoicig system, a client can save all the invoices and print them at the end of the month This client runs Window Server 2008 with 15 work stations He

Re: Any gurus out there?

2010-08-31 Thread Rafael Copquin
, least I forget. Nofilter is really applicable when you derive a select from other selects, because it ensures that the data comes from the previous queries. BTW, it has nothing to do with READWRITE. This one just makes the cursor modifiable. Rafael Copquin El 31/08/2010 10:33, MB Software

Re: Any gurus out there?

2010-08-31 Thread Rafael Copquin
Contrary to what I just said, I consulted the book Taming VFP SQL from Tamar Graynor and others and they say: You don't need NOFILTER if you specify READWRITE So, I guess I was wrong, and you were right. I learned something new today. Regards Rafael Copquin El 31/08/2010 10:33, MB

Re: Res: Grids and tabbing

2010-08-30 Thread Rafael Copquin
I think you should try this: last column of the grid, text1 LOSTFOCUS this.parent.parent.column5.setfocus don't use the valid event You could use, as an alternative, the KEYPRESS EVENT of the textbox, thus if nKeyCode = 13 this.parent.parent.column5.setfocus endif Rafael copquin

Re: [NF] Kindle or something else?

2010-08-28 Thread Rafael Copquin
You can read pdf books without conversion but, with Calibre, it takes a few seconds to converto to the Nook format, and it reads much better. And again, Calibre is completely free. Rafael Copquin El 27/08/2010 22:23, Vincent Teachout escribió: Rafael Copquin wrote: BTW

Re: Grid Data Entry

2010-08-27 Thread Rafael Copquin
Put your code in the valid event of the textbox where you enter the payrate Rafael Copquin El 26/08/2010 17:51, Michael Savage escribió: Simple question: I have a grid, two columns. 1 - Reg Hours 2 - Reg Pay The rate of Pay is stored in the Employee Table I would like to enter

Re: [NF] Kindle or something else?

2010-08-27 Thread Rafael Copquin
of all sorts. This Calibre program converts doc, pdf, txt and many other formats to whatever ereader you own. Very cool and free!!! You can get it here http://calibre-ebook.com/download_windows Rafael Copquin I've looked at the specs for the Kindle, Nook, and Sony, and will be getting

Re: Brain problem - need to engage.. forgot how..

2010-08-25 Thread Rafael Copquin
put this line of code in the init event of the combobox this.listindex = 1 Rafael Copquin El 25/08/2010 12:57, Michael Savage escribió: I guess I'm getting old. How do I show the first value in a combo box, by default. Does it need to be bound to something?? or can I just show the first

Re: Windows 7 blues

2010-08-22 Thread Rafael Copquin
implications (:-)). Now, off to enjoy the rest of the Sunday, a not too cold day here today, taking into account that we are still in Winter, in the Southern Hemisphere. Rafael Copquin ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http

Re: Windows 7 blues

2010-08-22 Thread Rafael Copquin
Yes, I presently live here. El 22/08/2010 12:43, MB Software Solutions, LLC escribió: Rafael Copquin wrote: taking into account that we are still in Winter, in the Southern Hemisphere. Are you in Argentina, Rafael? ___ Post Messages to: ProFox

Windows 7 blues

2010-08-20 Thread Rafael Copquin
notes? Is there anything special to be done that I am missing? Or should I simply install SQL Server 2005 Express in sad resignation? Rafael Copquin ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo

Re: Windows 7 blues

2010-08-20 Thread Rafael Copquin
OK, I finally did it! SQL Server 2008 R2 package, which weighs 762 Mb, El 20/08/2010 9:54, Rafael Copquin escribi{oacute}: My notebook came with Windows Vista (excuse my language). A short time ProFox@leafe.com http

transact sql and vfp equivalence

2010-08-17 Thread Rafael Copquin
Hi all, just a quick one: what is the equivalent function in T-SQL of the VFP inlist function? I need to create a stored procedure where the inlist function is used and can't find the equivalent function in T-SQL Thanks Rafael Copquin ___ Post

Re: transact sql and vfp equivalence

2010-08-17 Thread Rafael Copquin
-SQL of the VFP inlist function? I need to create a stored procedure where the inlist function is used and can't find the equivalent function in T-SQL Thanks Rafael Copquin ___ Post Messages to: ProFox@leafe.com Subscription

Re: transact sql and vfp equivalence

2010-08-17 Thread Rafael Copquin
thank you very much Rafael El 17/08/2010 14:19, Rick Schummer escribió: can't find the equivalent function in T-SQL One resource I reference frequently when converting VFP language elements to T-SQL: http://fox.wikis.com/wc.dll?Wiki~VFPSQL-TSQL-Mapping~VFP or shortened...

Re: Res: [NF] Vista, system icons, Network

2010-08-08 Thread Rafael Copquin
That is why I disabled my automatic updates. No more interference by the MS assh**es!! I cover security needs with the McAfee suite. It is very good and does not screw up anything. Rafael Copquin El 07/08/2010 11:12, Eurico Chagas Filho escribió: Ok, i solved it, but this is amazing

Re: Issue with Modal window

2010-08-03 Thread Rafael Copquin
I wonder why you use modal forms at all. Why not use a background form with your buttons, make it top level and all the forms fired when you click the buttons just in-top-level but modeless. Rafael Copquin El 03/08/2010 13:03, Alan Bain escribió: Thanks for your response! Yes the timer

Re: INTO TABLE vs INTO CURSOR READWRITE

2010-07-30 Thread Rafael Copquin
record mark in the grid and you can go back to your regular operations unscathed (:-). Rafael Copquin El 30/07/2010 6:58, msav...@golden.net escribió: If you need to remove deleted records, ie issue a pack, on the readwrite cursor this will do the trick. SELECT * FROM CursorName WHERE

VFP,SQL Server and transactions (SQL Server Express 2008)

2010-07-29 Thread Rafael Copquin
? 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 Searchable Archive: http://leafe.com/archives/search/profox

Re: VFP,SQL Server and transactions (SQL Server Express 2008)

2010-07-29 Thread Rafael Copquin
Can you show me an example of a SP for the header table and one for the details table? Also, from your reply I understand that you advise me not to use VFP transaction code at all What about CA's? Should I replace them for regular cursors to be saved via the SP? I developed all my code after

Re: VFP,SQL Server and transactions (SQL Server Express 2008)

2010-07-29 Thread Rafael Copquin
Thanks professor (:-), I'll read that Rafael El 29/07/2010 18:09, Stephen Russell escribió: On Thu, Jul 29, 2010 at 3:46 PM, Rafael Copquinrcopq...@ciudad.com.ar wrote: Can you show me an example of a SP for the header table and one for the details table? Also, from your reply I

Re: [NF] OLD EXPERTISE REQUIRED !!

2010-07-19 Thread Rafael Copquin
. However, I am now using Windows 7 and it won't accept full screen. Hope this helps. BTW, I'm not THAT old (:-) Rafael Copquin El 19/07/2010 7:20, william escribió: Hi Alan: With suitably lowered voice, and down cast eyes ! and Real Thanks. The table below indicates Vars. ALL possible

VFP and SQL (was Large Data Tables)

2010-07-19 Thread Rafael Copquin
have been there, and can't make their examples work Thank you all Rafael Copquin --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription

Re: [spam] RE: VFP and SQL (was Large Data Tables)

2010-07-19 Thread Rafael Copquin
[mailto:profox-boun...@leafe.com] On Behalf Of Rafael Copquin Sent: 19 July 2010 15:24 To: ProFox Email List Subject: VFP and SQL (was Large Data Tables) Alternatively you could consider hosting the SQL server at your own company or by 3rd party remotely and have each client hit that one server

Re: VFP and SQL (was Large Data Tables)

2010-07-19 Thread Rafael Copquin
I use SQL Server Express 2008 in the Windows 2008 Server. Rafael Copquin Hi Rafael, profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Rafael Copquin profoxt...@leafe.com www.connectionstrings.com. I have been

Re: [WC] Argentina!

2010-07-07 Thread Rafael Copquin
{iexcl}Que viva Espa{ntilde}a! On 07/07/2010 05:37 p.m., Helio Wakasugui wrote: The octopus saw it. paulroberth...@gmail.com wrote: On Sat, Jul 3, 2010 at 9:55 PM, Helio Wakasugui helio.wakasu...@gmail.com wrote: Yeah, I feel for Argentina, but not for

Re: [NF] An email I've got this morning

2010-07-01 Thread Rafael Copquin
Congratulations, Grigore! Way to go! Rafael Copquin El 01/07/2010 16:18, Grigore Dolghin escribió: “Dear Grigore Dolghin, Congratulations! We are pleased to present you with the 2010 Microsoft® MVP Award! This award is given to exceptional technical community leaders who actively share

bar codes

2010-07-01 Thread Rafael Copquin
one tell a report or a label to print directly into a bar code printer, if the font in the object to be printed cannot be changed? Rafael Copquin ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox

Re: bar codes

2010-07-01 Thread Rafael Copquin
As usual, exact and to the point. Thank you Rafael El 01/07/2010 17:02, Stephen Russell escribió: On Thu, Jul 1, 2010 at 2:35 PM, Rafael Copquinrcopq...@ciudad.com.ar wrote: A client of mine just purchased a EasyCoder PD 41 code bar printer. This printer has its own set of embedded

Re: SPAM-MED: xmladapter

2010-06-30 Thread Rafael Copquin
class. And if you have to send your data in the form of tables or cursors over the internet, XML is the way to go, as I understand. A flat file like an XML file is much lighter than a DBF file, well you get the picture.. Rafael Copquin El 30/06/2010 5:04, Alan Bourke escribió: I can't help

Re: [spam] Re: SPAM-MED: xmladapter

2010-06-30 Thread Rafael Copquin
That could be it but, where can I read about it, I mean, the msxml version I need? The whole explanation in help about the XMLAdapter class is complex, to say the least. Rafael Copquin El 29/06/2010 22:58, DSS escribió: Maybe server doesn't have required version of msxml? Don't remember

xmladapter

2010-06-29 Thread Rafael Copquin
get the message that the object cannot find the cursor. It is only sometimes and in some Windows Server 2008 What is happening?? Rafael Copquin ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox

Re: [WC] Argentina!

2010-06-28 Thread Rafael Copquin
YEEES Rafael Copquin El 27/06/2010 17:52, Ed Leafe escribió: I picked Argentina before the WC started, because I felt that they had the strongest team. All my sentimental favorites are now gone: US ('cause I live here) England ('cause that's my heritage) Italy ('cause

Re: Screen display

2010-06-23 Thread Rafael Copquin
is called with this call: modify command home()+'\arranque.prg' And because it is a startup program, VFP sets itself to my liking as soon as it starts. Rafael Copquin El 22/06/2010 20:45, Sytze de Boer escribió: I have asked this before and have searched my archives but the answer escapes me

Re: [WC]

2010-06-23 Thread Rafael Copquin
I had to search acronymfinder.com to understand what you meant. Well, for one, I give lots of spits. We Argentines, as every nation in the world, need motives to be proud of. Soccer is not a very good example, (I'd rather be proud of scientific achievements, which, BTW, we had some), but these

Re: [WC]

2010-06-23 Thread Rafael Copquin
Oh, I am sorry, my bad! I was certainly confused. So, we are still friends,(:-)) Regards Rafael El 23/06/2010 9:35, Michael Oke, II escribió: Rafael, My comment was not directed at you nor the accomplishment of Argentine at the World Cup so far this year as your pride in that is

[WC]

2010-06-22 Thread Rafael Copquin
Can't help it guys, I hope there are not too many Greeks in this list, but ARGENTINA 2 GREECE 0 He,he,he Rafael Copquin ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version

Re: [spam] [WC] 4-1

2010-06-17 Thread Rafael Copquin
True, but even then, WE WON ARGENTINA 4 KOREA 1 Rafael Copquin El 17/06/2010 11:14, Ricardo Aráoz escribió: Hey! Did you watch the match? Here at work, 50' tv, croisants, coffee, 70 chairs in the hall, some people standing, the match lasted till 10:30. Then back to work

Re:[OT] [WC] 4-1

2010-06-17 Thread Rafael Copquin
and ready for the next one. El 17/06/2010 12:14, Ricardo Aráoz escribió: On 17/06/2010 11:36 a.m., Rafael Copquin wrote: True, but even then, WE WON ARGENTINA 4 KOREA 1 Rafael, winning is not everything.. there's also making fun of the looser ;c) [excessive quoting

Excel automation and errors

2010-06-14 Thread Rafael Copquin
error (Excel generated or form generated) ? 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

Re: Excel automation and errors

2010-06-14 Thread Rafael Copquin
. HTH, -K- -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Rafael Copquin Sent: Monday, June 14, 2010 10:37 AM I read Microsoft Office Automation with Visual FoxPro by Tamar Grainor and others, ages ago, and it has been very

Re: Excel automation and errors

2010-06-14 Thread Rafael Copquin
You and Stephen Russell made the same suggestion and I tried it. It works beautifully! I'll have to rewrite my error catching routine, but this is the way to go. Thank you both! Rafael El 14/06/2010 11:40, Alan Bourke escribió: I would do this: Try * -- Scan the cursor. Catch To

Re: Excel automation and errors

2010-06-14 Thread Rafael Copquin
object doesn't die. Rafael Copquin El 14/06/2010 12:50, Stephen Russell escribió: On Mon, Jun 14, 2010 at 10:18 AM, Rafael Copquinrcopq...@ciudad.com.ar wrote: You and Stephen Russell made the same suggestion and I tried it. It works beautifully! I'll have to rewrite my error

Re: Craig Boyds VFPEXMAPI.fll

2010-06-14 Thread Rafael Copquin
the VFP buffer size 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 Searchable Archive: http://leafe.com

Re: ADO and VFP

2010-06-09 Thread Rafael Copquin
(cConnString) The question is: How should I modify the above commands at the branch, to obtain a remote connection handle? Should I do anything else? Rafael Copquin El 08/06/2010 20:45, Rick Schummer escribió: Rafael, I am beginning to use VFP9 as a front end and SQL server

Re: ADO and VFP

2010-06-09 Thread Rafael Copquin
OK,OK I hear you all guys. Stop thrashing me,please(:-) Seriously now No opening of the router port. No violation of the firewall. Use a VPN. I got that. How about Hamachi, from LogMeIn? Rafael Copquin El 09/06/2010 9:35, Rafael Copquin escribió: As always, very informative

Re: VFP OLEDRAGDROP not working in dev mode

2010-06-09 Thread Rafael Copquin
I use Windows 7 home premium. I ran your prg in development mode and it worked very well. I dropped both text files and bitmaps. Rafael Copquin El 09/06/2010 11:05, Dave Crozier escribió: Guys, I have just spent over an hour trying to sort out a weird problem relating to OLEDRAGDROP

Re: [spam] Re: ADO and VFP

2010-06-09 Thread Rafael Copquin
Would clients off campus need 24x7 access or every once in a while? Only during store hours, 9:00 AM to 7:00 PM Mondays thru Fridays Rafael Copquin El 09/06/2010 13:27, Stephen Russell escribió: On Wed, Jun 9, 2010 at 11:19 AM, Rafael Copquinrcopq...@ciudad.com.ar wrote: OK,OK I hear

Re: [spam] Re: ADO and VFP

2010-06-09 Thread Rafael Copquin
Nope El 09/06/2010 13:51, Stephen Russell escribió: On Wed, Jun 9, 2010 at 11:41 AM, Rafael Copquinrcopq...@ciudad.com.ar wrote: Would clients off campus need 24x7 access or every once in a while? Only during store hours, 9:00 AM to 7:00 PM Mondays thru Fridays ---

Re: [spam] RE: VFP OLEDRAGDROP not working in dev mode

2010-06-09 Thread Rafael Copquin
! Dave C -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Rafael Copquin Sent: 09 June 2010 17:33 To: ProFox Email List Subject: Re: VFP OLEDRAGDROP not working in dev mode I use Windows 7 home premium. I ran your prg in development

ADO and VFP

2010-06-08 Thread Rafael Copquin
information, such as: update customers set lastname = 'Smith' where custid = ?nCustId How to create the ADO object, the connection, the recordset, etc. TIA Rafael Copquin --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html

ADO and VFP (more)

2010-06-08 Thread Rafael Copquin
In addition to my previous post, please explain the pros and cons of using ADO versus ODBC Thank you Rafael Copquin --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post

Re: ADO and VFP

2010-06-08 Thread Rafael Copquin
A collective thank you all for your replies. Grigore and Mike, I take it you would no use ADO, at least in a LAN. And Tracy, thank you for your code example. Rafael El 08/06/2010 10:11 a.m., Tracy Pearson escribió: Allen wrote on 2010-06-08: I thought ADO had its own scan or go next or

Re: [OT] Boyle's Law

2010-06-05 Thread Rafael Copquin
who would be offended if he took this seriously. So, having said this, I hope you guys enjoyed it, as I did. Rafael Copquin El 04/06/2010 22:13, Michael Oke, II escribió: Holy cow Pete. It's humour, accept it for what it is. ::michael On 6/4/10, Pete Theisenpetethei...@verizon.net

[OT] Boyle's Law

2010-06-04 Thread Rafael Copquin
more souls and, consequently it is extinguished, leaving Heaven as the only proof of the existence of a Divine Being, which explains why, last night, Anne could not stop shouting Oh my God! Unquote That student was the only one to get an A Rafael Copquin --- StripMime Report -- processed

Re: [spam] RE: VFP and SQL Server + Word files

2010-06-03 Thread Rafael Copquin
Thank you very much again Dave. I'll try all this at home in the weekend and see whether I have any more questions. Rafael Copquin El 03/06/2010 6:57, Dave Crozier escribió: Rafael, With regards to getting the info back off the server: Note that on the server in the documents table you need

[OT] VFP and SQL Server literature

2010-06-03 Thread Rafael Copquin
It has been years since I read this book: Client-Server Applications with Visual FoxPro 6.0 and SQL Server 7.0 by Cuck Urwiler and others. I wonder if there is an update or any publication that would shed some more specific light on the subject. Rafael Copquin --- StripMime Report

Re: VFP and SQL Server + Word files

2010-06-02 Thread Rafael Copquin
\temp.doc cData=FiletoStr(cFile) cBlob=Cast(cData as Blob) cSQL=Update Customers set WordFiles=?cBlob where .. SQLExec(nHandle, cCMD) Dave C -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Rafael Copquin Sent: 02 June 2010

Re: VFP and SQL Server + Word files

2010-06-02 Thread Rafael Copquin
Thaks Steve I'll try this Rafael El 02/06/2010 01:40 p.m., Stephen Russell escribió: On Wed, Jun 2, 2010 at 11:35 AM, Richard Kayerk...@artfact.com wrote: Does SQL 2008 Express support the ntext data type? That's a binary datatype and SQL won't try to do any character translation on a

VFP and SQL Server + Word files

2010-06-02 Thread Rafael Copquin
them back into Word documents and show them to the user? 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

Re: VFP and SQL Server + Word files

2010-06-02 Thread Rafael Copquin
Wow Richard! This is precisely what I need! Since it is 8:30 PM here, I'll adapt your code to my form tomorrow morning and see how it goes. Thank you very much Rafael Copquin El 02/06/2010 19:49, Richard Kaye escribió: For some reason, I got interested in this. Here's a little proof

Re: VFP and SQL Server + Word files

2010-06-01 Thread Rafael Copquin
with making wordfiles text,varchar(MAX) and varchar(8000) It has been impossible to save this to the SQLServer database. Rafael Copquin El 01/06/2010 11:26, Dave Crozier escribió: Ricardo Rafael, I'm just cleaning up the classes for you at the moment and will let you know when I post

Re: VFP and SQL Server + Word files

2010-06-01 Thread Rafael Copquin
Where is your .NET code, Steve? Rafael El 01/06/2010 11:35, Stephen Russell escribió: On Tue, Jun 1, 2010 at 9:26 AM, Dave Crozierda...@flexipol.co.uk wrote: Ricardo Rafael, I'm just cleaning up the classes for you at the moment and will let you know when I post the zip file in Ed's

VFP and SQL Server + Word files

2010-05-28 Thread Rafael Copquin
should I use? How would this be accomplished using VFP 9 as the front end? (I need some code snippet here, both for saving and retrieving the file) Are there any alternative ways, EXCLUDING .NET, since I have not learned that yet? TIA Rafael Copquin --- StripMime Report -- processed MIME

Re: VFP and SQL Server + Word files

2010-05-28 Thread Rafael Copquin
Thanks Steve, of all people I knew you would reply swiftly (:-) But I still need the push code into VFP and out Rafael Copquin El 28/05/2010 9:43, Stephen Russell escribió: On Fri, May 28, 2010 at 7:32 AM, Rafael Copquinrcopq...@ciudad.com.ar wrote: I have a requirement to save

Re: VFP and SQL Server + Word files

2010-05-28 Thread Rafael Copquin
By all means, send them to me!! Thank you very much indeed!! Rafael Copquin rcopq...@ciudad.com.ar El 28/05/2010 10:18 a.m., Dave Crozier escribió: Raphael, I have exactly the VFP coding that you need and you can hold any document type, pictures, Word, Excel etc etc. If you want it I'll

Re: [spam] RE: VFP and SQL Server + Word files

2010-05-28 Thread Rafael Copquin
Looking forward to that. Tks and enjoy your weekend Rafael Copquin El 28/05/2010 11:40, Dave Crozier escribió: Ricardo and Raphael and anyone else interested, I am away over the weekend but I will post the code and an appropriate message here on either Monday evening or Tuesday. Dave C

Fwd: consulta

2010-05-28 Thread Rafael Copquin
? Rosa unquote Please tell.. 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 Searchable Archive: http

vfp and sql function equivalence

2010-05-28 Thread Rafael Copquin
Where can I find a list of VFP functions and their equivalent T-SQL functions? Please post a good URL to check. TIA and have a nice weekend Rafael Copquin --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html

Re: [spam] Re: vfp and sql function equivalence

2010-05-28 Thread Rafael Copquin
? Please post a good URL to check. TIA and have a nice weekend Rafael Copquin --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server

Re: [NF] New job, new company, new ventures

2010-05-26 Thread Rafael Copquin
Congratulations! BTW, I just checked your site, but since I do not understand romanian Any chance to get input in English (or Spanish, he,he,he) ? Rafael Copquin El 26/05/2010 9:23, MB Software Solutions, LLC escribió: Grigore Dolghin wrote: I finally made the move - got myself

Re: backup to a pendrive

2010-05-24 Thread Rafael Copquin
that there is a pendrive there, otherwise, the backup procedure will not start. Thanks anyways Rafael Copquin El 23/05/2010 15:25, John Weller escribió: Could you put a small file on the pendrive and test for that? John Weller 01380 723235 07976 393631 I need to backup the database and all tables

Re: backup to a pendrive

2010-05-24 Thread Rafael Copquin
That's a good article, Rick, thank you. However, I cannot get the constants file mentioned. The download link quoted there just does not bring the WinUser.H file. How can I get it? Rafael El 23/05/2010 21:49, Rick Schummer escribió: About a year ago I made a form using the drivetype

Re: backup to a pendrive

2010-05-24 Thread Rafael Copquin
Not a bad idea, I hadn't thought of that. TKS Rafael El 24/05/2010 12:14, John Weller escribió: How about trying to copy a file and trapping the error? John Weller 01380 723235 07976 393631 Except - as Rafael mentioned - the program has to run automatically - during after hours -

Re: backup to a pendrive

2010-05-24 Thread Rafael Copquin
That's it thank you !! Rafael El 24/05/2010 14:09, Rick Schummer escribió: That's a good article, Rick, thank you. However, I cannot get the constants file mentioned. The download link quoted there just does not bring the WinUser.H file. If you have access to the Foxtalk Archives

backup to a pendrive

2010-05-23 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: garden slide show

2010-05-15 Thread Rafael Copquin
Rafael Copquin El 15/05/2010 0:56, Gary Jeurink escribió: I started out 8-years ago with a plant/garden database to keep track of plant/source, care, cost, location and so on. I have a general field to store one 4 x 4 jpg photo of each. Now I want to log about 1,000 plus photo's and sort them

Re: [spam] Re: taableupdate and autoincremental fields

2010-04-23 Thread Rafael Copquin
OK, I got it. Thanks again El 22/04/2010 14:37, Stephen Russell escribió: On Thu, Apr 22, 2010 at 10:36 AM, Rafael Copquinrcopq...@ciudad.com.ar wrote: I do not understand you fully. Are you suggesting I use SQL Server for that single table, while the rest of the app uses DBF's?

Re: taableupdate and autoincremental fields

2010-04-22 Thread Rafael Copquin
involved were not very large or frequent as the ones I am experiencing with this particular routine. I will go back to your approach in this one and see what happens. Thanks again Rafael Copquin El 22/04/2010 5:48, Dave Crozier escribió: Rafael, I got burnt in a similar way to you when I tried

Re: taableupdate and autoincremental fields

2010-04-22 Thread Rafael Copquin
Thanks Stephen I am not using SQL Server for this app, but will keep this code for reference. El 22/04/2010 10:30, Stephen Russell escribió: On Wed, Apr 21, 2010 at 3:29 PM, Rafael Copquinrcopq...@ciudad.com.ar wrote: -- Would you consider a SQL Server that has a

Re: taableupdate and autoincremental fields

2010-04-22 Thread Rafael Copquin
I do not understand you fully. Are you suggesting I use SQL Server for that single table, while the rest of the app uses DBF's? Or what? El 22/04/2010 11:11, Stephen Russell escribió: For doing HIGH volume transactions this may fit the bill just fine. I know that this will handle 10,000

taableupdate and autoincremental fields

2010-04-21 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

open office and vfp

2010-04-01 Thread Rafael Copquin
an example, it would be great. By the way, Happy Easter to everyone Rafael Copquin --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription

Re: open office and vfp

2010-04-01 Thread Rafael Copquin
Thank you Rafael Copquin El 01/04/2010 18:33, Jarvis, Matthew escribió: a quick google search found this by our own Ted Roche, from 2003. Perhaps (hopefully) things have improved since then... http://www.tedroche.com/Present/VFPOOoAutomation.htm matt jarvis eugene, oregon

Re: open office and vfp

2010-04-01 Thread Rafael Copquin
Thank you Rafael Copquin El 01/04/2010 18:32, Michael Madigan escribió: http://udk.openoffice.org/common/man/tutorial/office_automation.html --- On Thu, 4/1/10, Rafael Copquinrcopq...@ciudad.com.ar wrote: From: Rafael Copquinrcopq...@ciudad.com.ar Subject: open office and vfp

Re: Memo's in grids

2010-03-31 Thread Rafael Copquin
memo, confusing, annoying and useless. Rafael Copquin El 31/03/2010 9:24, Peter Hart escribió: Hi folks. I have a grid which is bound to a table with memo fields for the description and buckle columns. Running the form displays the word memo in the column. The client does not like

Re: [NF] seeing posted emails [WAS: RE: Memo's in grids]

2010-03-31 Thread Rafael Copquin
, is there a difference in technical English between American or British ? Rafael Copquin El 31/03/2010 12:32, Peter Hart escribió: Hi Tracy Tried that Receive your own posts to the list? is set to Yes What I would like to know is why when asked what language I want use English British is not available

Re: VFP9-SP2 addobject - Method Code

2010-03-29 Thread Rafael Copquin
to your cursor, it will work properly. Hope this helps. Rafael Copquin El 28/03/2010 15:44, Carl Lindner escribió: Grigore, Thanks for the nice warm welcome to the big leagues! Over the years I have survived of a single application and - for the most part - have always been able to use

Re: Unique Indexes = not so much

2010-03-08 Thread Rafael Copquin
What about using a select statement with a group by clause? In this way you will eliminate your duplicates. Rafael Copquin El 08/03/2010 3:33, Ken Kixmoeller f/h escribió: Rick Schummer wrote: Ken, Using old-fashioned Fox, I do the expedient thing and create a unique

Re: Can a cursor created with SELECT... INTO CURSOR have multiple indexes?

2010-03-05 Thread Rafael Copquin
(dbf (curAux)) in 0 again alias (cArea) use in select ('curAux') ENDPROC Rafael Copquin El 04/03/2010 21:43, Jon Westcot escribió: Hi all: D'oh! I forgot to mention something that's, sadly, incredibly important. This is running under VFP6. From what I can tell, READWRITE clause

[NF] image processing

2010-03-05 Thread Rafael Copquin
or whatever. IOW, the problem is: scan the pages using a special software, modify the pages as needed save them again, either as scanned images or ideally, as Word documents. Is there any software that can accomplish this, free if possible? TIA Rafael Copquin --- StripMime Report

Re: [NF] image processing

2010-03-05 Thread Rafael Copquin
Thank you all for your suggestions. Rafael El 05/03/2010 14:52, Rafael Copquin escribió: I have a client with a huge manufacturing procedures manual that needs to be copied into Word documents. I thought that each page could be scanned and then processed with a special software, because

Re: [spam] Can a cursor created with SELECT... INTO CURSOR have multiple indexes?

2010-03-04 Thread Rafael Copquin
where 1 = 0 this would give an empty yourcursor and you would still be able to index it with as many tags as you like. Rafael Copquin El 04/03/2010 19:14, Jon Westcot escribió: Hi all: The subject line kind of says it all. I'm trying to create a temporary cursor that has two indexes

Re: [spam] Re: [OT] damn windows 7 !!!!

2010-01-08 Thread Rafael Copquin
Why did he have to make the characters blue? Because the colors match better with the environment? ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list:

Re: [OT] damn windows 7 !!!!

2010-01-07 Thread Rafael Copquin
.. Hey, have you guys watched AVATAR? Fantastic movie, but I would love to see those computers some day in my lifetime!! Rafael Copquin El 07/01/2010 10:57, a...@abac.com escribió: Rafael: Maybe a command prompt as administrator will work. Frequently use it on Windows 7 to register DLLs

[OT] damn windows 7 !!!!

2010-01-06 Thread Rafael Copquin
the message that I need administrators rights to be able to do that. I AM THE ONLY USER OF THIS COMPUTER AND ARE LOGGED IN AS AN ADMINISTRATOR. How can I tell the f.g windows 7 that I am an administrator and so it will let me erase files? Please advise Rafael Copquin --- StripMime

<    1   2   3   4   5   6   7   8   9   >