Re: Word automation

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 > -- Richard Kaye Vi

Re: VFP9 SP1 taking more than 3 minutes to load a project?

for > certain files. Plus all > the version information needs to be re-entered -- Richard Kaye Vice President Artfact/RFC Systems Voice: 617.219.1038 Fax: 617.219.1001 For the fastest response time, please send your support queries to: Technical Support - [EMAIL PROTECTED] Internet Suppo

Re: VFP9 SP1 taking more than 3 minutes to load a project?

sider posting it on the ProFox downloads page! > -- Richard Kaye Vice President Artfact/RFC Systems Voice: 617.219.1038 Fax: 617.219.1001 For the fastest response time, please send your support queries to: Technical Support - [EMAIL PROTECTED] Internet Support - [EMAIL PROTECTED] All Other R

Re: Disable Mouse When A Form Is Visible

ange Server was to cut down on the amount of > spam we where getting. Many of -- Richard Kaye Vice President Artfact/RFC Systems Voice: 617.219.1038 Fax: 617.219.1001 For the fastest response time, please send your support queries to: Technical Support - [EMAIL PROTECTED] Internet Su

Re: VFP9 SP1 taking more than 3 minutes to load a project?

OK, MB. It's in the queue. MB Software Solutions General Account wrote: > http://leafe.com/dls > > Click on the "Upload page" link and fill out the details! > -- Richard Kaye Vice President Artfact/RFC Systems Voice: 617.219.1038 Fax: 617.219.1001 For the fastest

Re: Disable Mouse When A Form Is Visible

ile email is sending then start the service when it's done. That > would be too simple. > Thanks for your input. > Regards, > -- Richard Kaye Vice President Artfact/RFC Systems Voice: 617.219.1038 Fax: 617.219.1001 For the fastest response time, please send your support

[NF] Looking for Cold Fusion developer

Anyone here know of any CF devs looking for a gig? If so, please email me off list and I'll get you the particulars. We're located in the Boston area. Thanks. -- Richard Kaye Vice President Artfact/RFC Systems Voice: 617.219.1038 Fax: 617.219.1001 For the fastest response time, p

Re: [NF] Looking for Cold Fusion developer

Yeah, I'm afraid so. We're looking for someone in house. Matt Jarvis wrote: >> -Original Message- >> From: [EMAIL PROTECTED] >> > [mailto:[EMAIL PROTECTED] > >> On Behalf Of Richard Kaye >> Sent: Monday, October 20, 2008 9:05 AM >

Fun with VFP timers

table that gets updated by the controlling form and when I run both forms in the same instance of VFP, the slideshow form behaves as desired. However, when I run the slideshow in a second instance on the same computer, what takes a fraction of a second can occur seconds later. Signed, Puzzled -

Re: Fun with VFP timers

ote: > Sounds like a classic case for OLE Automation, especially when you > control the code on both ends! > -- Richard Kaye Vice President Artfact/RFC Systems Voice: 617.219.1038 Fax: 617.219.1001 For the fastest response time, please send your support queries to: Technical Support

Re: Fun with VFP timers

our REFRESH > settings, or caching: that's likely why Machine B doesn't see Machine > A's changes for a second or more. > -- Richard Kaye Vice President Artfact/RFC Systems Voice: 617.219.1038 Fax: 617.219.1001 For the fastest response time, please send your support quer

Re: VFP9 report behaviour

tually go into >> an endless loop. Im so thrilled... >> -- Richard Kaye Vice President Artfact/RFC Systems Voice: 617.219.1038 Fax: 617.219.1001 For the fastest response time, please send your support queries to: Technical Support - [EMAIL PROTECTED] Internet Support - [EMA

[NF] LINQ - RIP?

#x27;s just what it seems and that they have every intention of continuing work on this, just not as much as in other areas. In any case, it will be interesting to see if the Entity Framework provides any better benefits -- Richard Kaye Vice President Artfact/RFC Systems Voice: 617.219.1038 Fax

[NF] SQL 2005 vs 2008 comment

008-full-text-search-problems/> than it was in 2005. Something to be careful about if you're thinking of upgrading to 2008. http://blog.stackoverflow.com/2008/11/sql-2008-full-text-search-problems/ -- Richard Kaye Vice President Artfact/RFC Systems Voice: 617.219.1038 Fax: 617.219.1001

Re: I love ternary ifs, don't you?

n a report expression: > > iif(lOrder, "Order", iif(lQuote, "Quote", "Unknown")) > > Paul > -- Richard Kaye Vice President Artfact/RFC Systems Voice: 617.219.1038 Fax: 617.219.1001 For the fastest response time, please send your support queries to:

Re: [NF] Bye Bye Pc Magazine

Rick Strahl has blogged about it. Michael Madigan wrote: > I'm sure they're going to offer standing-room only next. > > Has anyone used the Amazon Kindle yet. I hear it gets good reviews, but I > can't imagine using it. > > http://www.amazon.com/Amazon-com-kindl

Re: VFP9 versions

SP1 will I have problems. > Al > -- Richard Kaye Vice President Artfact/RFC Systems Voice: 617.219.1038 Fax: 617.219.1001 For the fastest response time, please send your support queries to: Technical Support - [EMAIL PROTECTED] Internet Support - [EMAIL PROTECTED] A

Re: DAFUG - December 2008

Thursday, December 11, 2008 > > - " Getting Started with SVN/Tortoise " by Toni Feltma -- Richard Kaye Vice President Artfact/RFC Systems Voice: 617.219.1038 Fax: 617.219.1001 For the fastest response time, please send your support queries to: Technical Support - [EMAIL PROTECTE

spell check on the fly with standard VFP textbox?

The subject says it all. Has anyone here attempted to mimic the behavior of a full blown word processor, say using GDI+, in VFP? -- Richard Kaye Vice President Artfact/RFC Systems Voice: 617.219.1038 Fax: 617.219.1001 For the fastest response time, please send your support queries to

RE: DIR command output????

I think you're right; DIR was designed for DBFs first. Use ADIR() instead. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Matt Slay Sent: Thursday, August 11, 2011 9:16 AM To: profoxt...@leafe.com Subject: DIR command outpu

RE: PDF Output

In addition to the other suggestions, you could take a look at this, too. http://msdn.microsoft.com/en-us/library/ms947696.aspx -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of John Weller Sent: Monday, August 22, 2011 6:21 A

RE: FoxPro to Excel & Exponential Looking Data

You don't indicate how you are currently exporting data and subsequently opening in Excel. You could try putting a single quote in front of the tracking number but then you probably will see that as part of the value in that cell. The trick I've found with keeping Excel from being so helpful i

RE: Cannot resolve backlink

Did you use the RECOVER keyword when validating the database? Make sure you have backups of the tables. When you use RECOVER, it might delete files. Also, if you used any DBC functionality like long column names, that info will get lost when you FREE the table and you will have to add that back

RE: Select on Entry

I'm with Tracy. The user must be moving the mouse slightly when clicking and getting a click n' drag. Unless you have special user hostile interface ((c) 1992 Whil Hentzen) code just for this person... -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun

RE: [NF] chat client for internal use only

I have this vague memory that someone wrote a VFP "chat" client... http://www.tek-tips.com/viewthread.cfm?qid=541348 -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Lou Syracuse Sent: Wednesday, August 31, 2011 11:52 AM To:

RE: XFRX

Hi Kent, Yes, I've been using xfrx in my EXE which is running in ~50 locations round the world. I don't recall seeing that type of message. Have you included the fxp in your project or are you distributing it separately? Have you included xfrxlib.fll, hndlib.dll & zlib.dll with your distributi

RE: Primary Keys in SELECT Statement

Set the BoundColumn property to your pkey. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jeff Johnson Sent: Friday, September 02, 2011 9:57 AM To: profoxt...@leafe.com Subject: Primary Keys in SELECT Statement Forgive me i

RE: Primary Keys in SELECT Statement

That certainly seems odd. What is ControlSource set to? -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jeff Johnson Sent: Friday, September 02, 2011 10:11 AM To: profoxt...@leafe.com Subject: Re: Primary Keys in SELECT Stat

RE: Erase generates "File does not exist" Error 1

Maybe it doesn't like the THIS reference and that's causing the error? I'd wrap it in a try..catch. -- rk -Original Message- Sent: Tuesday, September 06, 2011 1:17 PM Subject: Re: Erase generates "File does not exist" Error 1 On 09/06/2011 09:59 AM, Tracy Pearson wrote: > I have a user

RE: VFP9SP2 - Error 2066: Index file "z:\data\costs.cdx" tag "Njobid" is corrupted. Please rebuild it.

Like Frank mentioned, SMB2 can cause issues although this was supposedly addressed in SPs for Vista/7/2008. If you have disabled SMB2, then you have to look at opportunistic lock settings in plain, old SMB. Here's a snippet from an email I sent to a client when discussing file corruption issues.

RE: VFP9SP2 - Error 2066: Index file "z:\data\costs.cdx" tag "Njobid" iscorrupted. Please rebuild it.

I had one instance recently where the same tag in the same CDX was getting corrupted on a semi-regular basis. Tracy's comment about the Windows Indexing service was another thing I hadn't thought of. I may have to add that to the list. Having said that, I had the client's IT guys add the appropr

RE: Error 1104

I'm all for keeping it simple. Having said that, this VFPX project might be worthy of investigation: http://vfpx.codeplex.com/wikipage?title=ParallelFox&referringTitle=Home -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ke

RE: Ole Web Browser control

I had similar behavior and you made me curious enough to look. Try Edit->Preferences->Page Display->Zoom. Now how you manipulate that for an individual document via automation, I don't know because I haven't worked with the Reader object at all. But the Object Browser in VFP might help solve tha

RE: XFRX support

I had a brief conversation with Martin in the last couple of weeks. I just emailed my question directly to eq...@eqeus.com. In general, I've found him to be responsive. Perhaps something is stuck in a spam bucket somewhere? -- rk -Original Message- From: profoxtech-boun...@leafe.com [m

RE: XFRX support

7-637-6766 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Tuesday, September 13, 2011 8:36 AM To: profox@leafe.com Subject: RE: XFRX support I had a brief conversation with Martin in the last couple of weeks. I just emailed m

RE: XFRX support

I might be able to help with the first question. The first parameter of the XRFX object SetParams method is the name of the output file: Local m.lcFilename AS Character m.lcFolder=[C:\My special folder] m.lcFilename=ADDBS(m.lcFolder)+SYS(2015)+[.xff] lnRetval = loSession.SetParams(m.lcFilename,

RE: (NF) Set up DSN in an Inno Setup - is it possible?

Some years ago (2001?), Mark McCasland posted some VFP code for creating an ODBC DSN in the registry. It probably needs some tweaking for a post-XP world but it might be helpful. It's in the public domain so I'll submit to Ed for the Profox archives. -- rk -Original Message- From: pro

RE: XFRX support

. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Tuesday, September 13, 2011 11:16 AM To: profox@leafe.com Subject: RE: X

RE: XFRX support

profox-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Wednesday, September 14, 2011 9:22 AM To: profox@leafe.com Subject: RE: XFRX support Are you using the Export Options form object that's included? Again, I don't use the Export Options dialog but I have the help file to be very u

RE: XFRX support

Hi James, I just got an email from Martin saying that he's been a bit busy but that he has replied to you. BTW my looking at the demo has made me want to try implementing the XFRX previewer into my EXE so I should be better able to chime in on issues related to that once I figure it all out m

RE: [NF] Windows 1 vs. Windows 8

Based on the little bit I've seen and read about it, it seems to me that's the direction Apple is headed with Lion, too. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Dan Covill Sent: Thursday, September 15, 2011 12:34 P

RE: VFPOLEDB issues in SQL 2008R2 / Windows 7

You definitely need the 32 bit ODBC administrator to make sure that it's installed properly. You did see the recent post that MS is deprecating OLEDB, right? I'll see if I can try this out on my W7 dev system and let you know what happens. How are you attempting to import the data? In SSMS? T

RE: XFRX support

7-8931 cell: 717-887-2565 fax: 717-637-6766 -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Wednesday, September 14, 2011 12:09 PM To: profox@leafe.com Subject: RE: XFRX support Hi James, I'll toss out one more thing b

RE: [NF] Programmers From India

Pete, you really need to think twice or maybe even 3 times before you hit that send button. -- rk -Original Message- Jeff Johnson wrote: They get, uh, BROWNIE points from Obama. -- Regards, Pete ___ Post Messages to: ProFox@leafe.com Subs

RE: XFRX default "output" file name

Hi James, I've found a way to assign a custom file name that the previewer class will use instead of output. If you're interested, let me know. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of James E Harvey Sent: Friday, S

RE: Runtime Filename VFP5.0a

http://fox.wikis.com/wc.dll?Wiki~VFPRuntimeDLLConcordance~VFP Also a useful reference point. And Paul McNett was on the bleeding edge for running VFP under WINE back in the day so you might want to search for his comments on the subject. -- rk -Original Message- From: profoxtech-boun..

RE: [NF] Programmers From India

f Pete Theisen Sent: Wednesday, September 21, 2011 11:26 PM To: profoxt...@leafe.com Subject: Re: [NF] Programmers From India Richard Kaye wrote: > Pete, you really need to think twice or maybe even 3 times before you hit > that send button. Hi Richard, If you have never heard of brownie

RE: Runtime Filename VFP5.0a

If you search the Fox wiki site for runtime, you'll find info for earlier versions. (Don't know how I managed to miss the version in the subject...) If you plan on running in Vista/W7, I'd recommend going right to 9 assuming you can find a copy. IIRC, a full license runs in the 5-600 vicinity an

RE: XFRX default "output" file name

Hi James, I haven't spent much time looking at the default file location yet but there are several ways you can approach setting the name itself. Probably the simplest way to do it is add your own code to the export options form class. You'll see this line in the init: this.text2.Value = thi

RE: XFRX default "output" file name

Yes. You can do both of those with or without the previewer. The latest version also supports exporting to Open Office Writer, too. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Friday, Se

RE: xml adapter

When I've needed to do this, I either create the XML manually using TEXT..ENDTEXT or use CURSORTOXML. m.lnResult=CURSORTOXML(ALIAS(),m.lcOutput,1,2+4+8+48+512,0,JUSTSTEM(m.lcOutput)+[schema.xsd]) It also really depends on how many columns you have but I did test with a ~33,000 record cursor wit

RE: xml adapter

If you're curious enough, step through it in the debugger. My guess would be that CURSORTOXML is nicely optimized for VFP data whereas the cursoradapter classes have a lot of other overhead. I do suggest you have a play with the various options for creating the XML. You may want to use differe

RE: [NF] Measuring code quality

Code review? WTF is a code review? -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Malcolm Greene Sent: Tuesday, September 27, 2011 6:04 AM To: profoxt...@leafe.com Subject: [NF] Measuring code quality WTF's per minute http:

RE: [NF] Measuring code quality

- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Dan Covill Sent: Wednesday, September 28, 2011 1:11 PM To: profoxt...@leafe.com Subject: Re: [NF] Measuring code quality On 09/28/11 06:45, Richard Kaye wrote: > Code review? WTF is a code review? Assuming you

RE: Report Builder (Dave Crozier)

I posted a utility prg here a long time ago that keeps the first 3 lines in the EXPR column in addition to clearing TAG & TAG2. Pass it a single FRX/LBX or a folder. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Brant E

RE: VFP9SP2 error on COPY TO command

There's an install on demand feature in O2010 and that can also cause problems, iirc. Unfortunately I can't find the reference off the top of my head. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Mike Copeland Sent: Mond

RE: ODBC write error in call from FedEx station

What does VALI DATA say? Do you have exclusive access to the DBC? Do you know what table is giving you this error? -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen Russell Sent: Tuesday, October 04, 2011 2:09 PM To:

RE: ODBC write error in call from FedEx station

18 PM, Richard Kaye wrote: > What does VALI DATA say? Do you have exclusive access to the DBC? > >  Do you know what table is giving you this error? -- Validate Datbase Shipping: Rebuilding structural index. Index rebuilt. Database container is valid. Table name: co

RE: Speed and complexity of report

I haven't used it myself yet but try looking at the Task Pane Manager Solution Samples. The What's New in VFP 9 section has a couple examples on how to use multi-detail band reports. -- rk -Original Message- Subject: Speed and complexity of report Questions Is this a multiple detail b

developer research

Hi ProFoxers, If all goes according to plan, my company will be in the market for adding a VFP developer in the not too distant future and I've been tasked with doing some market research. I went to various job posting sites (Monster, etc) and of the handful of VFP related listings, most did no

RE: developer research

Thanks all for the comments. I meant to reply back this morning but those pesky clients got in the way... Good point about the location. We're in Allston, MA which is just on the edge of Boston. Relocation will definitely be a requirement. (Sorry, Lou...) I'm just trying to get a ballpark idea

RE: developer research

- Original Message Subject: Re: developer research From: Richard Kaye To: profoxt...@leafe.com Date: 10/7/2011 4:28 PM Thanks all for the comments. I meant to reply back this morning but those pesky clients got in the way... Good point about the location. We're in Allston, MA which is j

RE: Cursor Adapter in DE Question

Mark McCasland wrote a CA builder utility and there's a reference to it in the downloads section. Unfortunately, it appears to point to a dead link. I've found a version on foxite and will submit it to Ed. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-

RE: [NF] RIP Dennis Ritchie

No. You leave a pile of pointers... -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jerry Wolper Sent: Thursday, October 13, 2011 5:39 PM To: profoxt...@leafe.com Subject: RE: [NF] RIP Dennis Ritchie > S*d Steve Jobs... this

RE: Copy & Paste From Grid

Add a logical column to the underlying grid datasource, show that column in the grid bound to a checkbox and then filter on that for output purposes? Maybe something like: Select from data where checked into cursor temp _vfp.DataToClip() Check the options on DataToClip. For example, if you pas

RE: Copy & Paste From Grid

That would be me, Rafael... You don't need to bother with a scan loop. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Rafael Copquin Sent: Thursday, October 20, 2011 5:27 PM To: profoxt...@leafe.com Subject: Re: Copy & P

RE: Copy & Paste From Grid

No apologies needed! I'm used to being ignored... -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Rafael Copquin Sent: Friday, October 21, 2011 11:19 AM To: profoxt...@leafe.com Subject: Re: Copy & Paste From Grid Sorry Ric

RE: VFP9: Multiple Check Box Clicks

That's really more like listbox behavior. Not sure what the performance of a list control with 1200 items would be. I usually provide some way to do a check/uncheck all. You could also have an invert selection button. Other than that, you'd probably have to get into some pretty fancy mouse down

RE: Insert Into with memo fields

Can you do it with a SQL insert? Insert into newtable select field1, field2, transform(field3) field3, upper(field4) field4, ... from oldtable I'd also drop any index tags on the new table before inserting and then add after the insert is done. -- rk -Original Message- From: profoxt

RE: What control would you use on a form to present 2 paragraphs worth of text?

Editbox, set to readonly, etc. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen Russell Sent: Thursday, November 03, 2011 9:46 AM To: profoxt...@leafe.com Subject: What control would you use on a form to present 2 para

RE: Report Image

Assuming this is a standalone prg, you should be able to do that by putting the compiled FXP in your application path. If it's part of a procedure file that's already in scope, you shouldn't have any issues calling it in the FRX regardless of project inclusion state. -- rk -Original Messag

RE: [NF] MS Access question on APPEND-like functionality

While pulling into VFP might be fun (& fast!), there are a some gotchas like weird column names in Access getting munged via ODBC. In theory, you should be able to use a SELECT ... UNION to get one big table/cursor which could then be dumped into the current what you want or maybe even do one DB

RE: Word Automation

Maybe... I've found that most of my automation code works without changing but the only way to know for sure is to test. (Did I just hear Ted?) They will definitely need to have the 32 bit versions of Office installed. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailt

VFP position available

isual SourceSafe, IIS & ASP a plus. Excellent written & verbal communication skills. Excellent problem solving skills. Excellent organizational skills. Artfact is located in Allston, MA. Richard Kaye Vice President Artfact/RFC Systems Voice: 617.746

RE: VFP position available

rom: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Wednesday, November 16, 2011 10:46 AM To: profoxt...@leafe.com Subject: VFP position available Hi all, Job Description We are looking for an experienced Visual FoxPro Developer to join our team. You mus

YAG says bye to MS

I always thought YAG was a forward looking guy... Looks like Dec 2, 2011 is already in the past for him. http://fox.wikis.com/wc.dll?Wiki~YAlanGriver -- rk ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/lis

RE: laFiles is not an array error

I vaguely recall seeing this on occasion and found that declaring arrays separately eliminates that problem. LOCAL m.var1 LOCAL ARRAY m.var2[2] -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Thierry Nivelet Sent: Tuesday

RE: trapping escape key

Is the main screen a "form"? If so, you can trap the ESC keystroke in the keypress method and put in a NODEFAULT. if nKeyCode=27 nodefault endif You'll need to make sure the form KeyPreview property is set .t. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto

RE: trapping escape key

You can have all kinds of fun with user hostile interfaces using the KeyPress method and NODEFAULT... -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Michael Madigan Sent: Wednesday, December 07, 2011 7:02 PM To: profoxt...

RE: vfpencryption71.fll

Have you deployed/installed the C++ runtimes with the fll? >From Craig's blog: The vfpencryption71.fll requires the VC++ 7.1 runtimes whereas the vfpencryption.fll requires the VC++ 9.0 runtimes. If you are getting a "FLL is Invalid" error when running either of these FLLs it is because you are

RE: date handling in sql server 2005 express

Another thing you can do is avoid building date/datetime values by using the date() or datetime() functions like this: DATE([nYear, nMonth, nDay]) DATETIME([nYear, nMonth, nDay [, nHours [, nMinutes [, nSeconds) Then there's no amibiguity about what portion of the date is in what position.

RE: Date typed-in problem

In addition to Dave's suggestion, you may want to put an acceptable default value in the data, assuming there is one, because the return .F. in the valid will prevent that control from being exited. Which means the user won't be able to close the form or even move to any other data entry field o

RE: VFP9 SP2 problem

AFAIK, the last update to VFP SP2 (9.00..7423) was back in 2006. It was a post-SP2 hot patch and basically required you to manually copy the new VFP9.exe to wherever you have VFP installed; update the common files location with the new DLLs; and finally update the MSM files if you are using

RE: VFP9 SP2 problem

s on travels. I wonder sometimes if Microsoft is trying to shoot VFP9 developers. Al -Original Message- From: Richard Kaye AFAIK, the last update to VFP SP2 (9.00..7423) was back in 2006. It was a post-SP2 hot patch and basically required you to manually copy the new VFP9.exe to wherever

RE: Data not updating

What values do you have for SET REPROCESS and SET REFRESH ? -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kent Belan Sent: Wednesday, January 18, 2012 5:41 PM To: profoxt...@leafe.com Subject: RE: Data not updating No cur

RE: Data not updating

As Fred mentioned, are you either moving the record pointer after an edit or calling TABLEUPDATE()? You may also want to try FLUSHing the workarea in question. Windows may be "helpfully" caching writes for you and the FLUSH command theoretically addresses that. -- rk -Original Message

RE: Vfp and sql

In theory, you could use a select to create the memodetails column in your newtable. Something like: select client,sum(invvalue) as invttl, desc, ordnum, (select memodetails from mytable where ...) as memodetails from mytable into table newtable group by client, ordnum But you don't have a f

RE: [NF] What's wrong with this CAST call?

Don't know if this has changed (apparently not) http://bugs.mysql.com/bug.php?id=34564 -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions General Account Sent: Tuesday, January 24, 2012 1:06 PM To: profox

RE: Foxpro and Excel question

Hmm... Not exactly. Don't confuse display with capacity. See the link below. (And it is different depending on what version of Excel you are using.) I dump large memo files into Excel cells on a regular basis. Finally, you do need to do this via automation as opposed to using xBase commands if y

RE: Foxpro and Excel question

xtech-boun...@leafe.com] On Behalf Of Michael Madigan Sent: Wednesday, January 25, 2012 2:20 PM To: profoxt...@leafe.com Subject: Re: Foxpro and Excel question There's a display limit, but can you print it?    ____ From: Richard Kaye To: "profox@leafe.com" Se

RE: Foxpro and Excel question

Did you look at that link, Michael? In Office 2010, 1024 characters will display in the cell itself but 32K will display in the formula bar. I'm sure there are similar numbers in earlier versions of Office. As to why you would want to store and manipulate 32K of text data in a cell in Excel, I

RE: VFP9: FTP Files

http://www.news2news.com/vfp/index.php Also, Craig Boyd has one of his libraries available but I don't know if it will work in 6. http://www.sweetpotatosoftware.com/spsblog/2008/12/05/VFPConnectionUpdateHTTPPostFTPCommandsAndMore.aspx -- rk -Original Message- From: profoxtech-boun...@

RE: Exporting a memo field to an Excel spreadsheet

And you might want to take a look at this. http://www.sweetpotatosoftware.com/spsblog/2008/09/30/UsingExcel2007FileFormatsInVFP90.aspx -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kurt Wendt Sent: Wednesday, February 01,

RE: Debugger - Source Not Available

I'm assuming you're working in a debug environment as opposed to production. Is the path to where your source code is located in the search path of your EXE? If not, can you use a CONFIG.FPW file to set your path at runtime? Is your project set to include DEBUG info? (See the project options.)

RE: decimals in remote data

I would use CAST in your SQL to make sure you get back the precision you want. You still may need a SET DECIMALS setting and maybe try SET FIXED OFF instead of ON. -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Rafael Cop

RE: decimals in remote data

ion string it fails but with SQLConnect and the DSN name, plus UID adn PWD it all works as expected? BTW Richard, thanks for your help but this puzzles me Rafael El 08/02/2012 12:57, Richard Kaye escribió: > I would use CAST in your SQL to make sure you get back the precision you > want.

[OT] Re: What Price Dinner?

[OT], please... -- Richard Kaye Vice President Artfact/RFC Systems Voice: 617.219.1038 Fax: 617.219.1001 For the fastest response time, please send your support queries to: Technical Support - [EMAIL PROTECTED] Internet Support - [EMAIL PROTECTED] All Other Requests - [EMAIL PROTECTED

VFP DLL/COM server newbie

f thing. Of course, I'm reading all of Rick Strahl's white papers related to VFP & COM but any other resources that folks have found helpful would be welcome. TIA -- Richard Kaye Vice President Artfact/RFC Systems Voice: 617.219.1038 Fax: 617.219.1001 For the fastest response tim

debugging conundrum

ble. I can see in the watch window that VFP can find the prg & the fxp and that the specific folder is in the VFP search path. When I try to open the prg directly in the debugger, I get a dialog asking me to Select Program from Application?!? This is a real WTF moment... -- Richard Kaye

Re: debugging conundrum

compile dialog. > > I would suggest you delete all the fxp files and let VFP to recreate them. > > I promise it will work then if your pathing is correct -- Richard Kaye Vice President Artfact/RFC Systems Voice: 617.219.1038 Fax: 617.219.1001 For the fastest response time, p

  1   2   3   4   5   6   7   8   9   10   >