Access SQL Server or MySQL from VFP other than ODBC?

I was talking with a PHP programmer today and he asked me if you can connect 'directly' to MySQL or SQL Server like PHP does in a VFP program, or are you restricted to having to use ODBC. Can some of you client/server gurus help answer these questions? First, I wasn't aware you could connect d

Re: [NF] A new way to run VFP on a Mac?

Has anyone actually tried this with VFP? I would suspect it might not work due to the way VFP works with the runtime library, but I could be wrong.. -Steve At 11:39 AM 6/14/2006, you wrote: http://www.alkyproject.com/ -- Alan Bourke [EMAIL PROTECTED] -- http://www.fastmail.fm - Or how I

Re: Access SQL Server or MySQL from VFP other than ODBC?

Thanks for all the replies everyone... So, what's you goal? Are you trying to avoid the burden of setting up ODBC on client workstations? If you're determined to continue coding in VFP, I don't think there are a lot of good options. This is what I had pretty much figured. I didn't really have

Re: [NF] Vista architecture

Easy.. Vista's architecture is like this.. Take input from the computer. Process it through countless bloated and redundant code libraries, lop off a few bits along the way to ensure a bug at some point, pass it through IE and back out the other side to prove IE's an integrated part of the OS,

RE: [NF] Vista architecture

I pretty much had that impression about Windows until now, but thought that Vista would bring Windows to a new level, i.e. a re-write that would actually be organized around rhyme and reason. Having spent plenty of time with my nose in Win32API, I can verify that the current Windows arch. is

Re: Transitioning from VFP backend to MySQL

Ted - Can you clarify what you mean about it being easier to detect what's changed via insert/delete as you mention here? I'm a bit confused.. maybe an actual example of some code would clarify what you mean? I'm planning on moving to mysql in the near future too, so am curious as well. Th

Re: Path resolution at design and run time

I've never dealt with logos on my reports so I don't know if this would work, but what if you stored the bitmap data in a database, and copy out to the expected filename when you run the report. So for example, the report would reference a bitmap called logo.bmp. In the database you would have

Re: Strong parameter checking

This is the style I tend to use as well.. It's good knowing that once you scroll down past any initial validation code, your variables are assumed to be just fine, and I do like the logical division of having the validation section and then the heart of the logic section as outlined by Mike.

Re: VFP7: Reassign a class to another one

If you will have access to the .vcx @ runtime, you can open it like a dbf, and change the class & classloc fields as needed, programmatically just as you would manually. Be aware that you'll prob. need to make sure no classes are in memory hosted in that .vcx. If you've embedded the class into

Re: Reassign a class to another one

Similar to the container approach, if I have more than 1 or 2 controls to swap out, I'll use an invisible pageframe, and just show the appropriate page as necessary. Much easier than setting visible and / or enabled for all the different controls. FYI - the pageframe is made by having no border

Suggestion for the mailing list

It would be really terrific if each email could contain a link automatically generated which would take the user to the mailing list website and show the email and thread in the browser. Why do I want this? 99% of the time, I follow this list via the emails in my email software, but many, man

Re: Grid Rows - some ReadOnly some Editable

Each column of the grid has it's own ReadOnly property, so you can individually set certain ones to readonly or not.. Another thing you can do is to return .f. in the when() of each textbox of the column you don't want to allow the user to get the focus of.. -Steve At 04:04 PM 7/7/2006, you w

Re: Grid Rows - some ReadOnly some Editable

Duh! Kevin Cully was kind enough to point out that I mis-read your request as columns, not rows. Sorry... not enough sleep or coffee I guess.. Nothing comes to mind as a solution off the top of my head, other than somehow using the when() idea to conditionally trigger .t. or .f. based on th

ODBC Setup Error - VFP8 & 2003 Server

Posting for a friend of mine.. He's installed VFP8 on a fresh new W2003 Server and is trying to setup a System DNS entry for Visual Foxpro. The goal being that he is going to access VFP data from his PHP coded website. The error message as he's trying to setup the DNS connection is: "You mus

Re: ODBC Setup Error - VFP8 & 2003 Server

Thanks Richard, but never received it.. Also, where did you get this installer from? I've got every VFP CD there is, so surely you'd think it'd be on one of those.. -Steve At 07:19 PM 7/11/2006, you wrote: I've sent you the installer off-list. Steve Ellenoff wrote: Pos

Re: ODBC Setup Error - VFP8 & 2003 Server

Thanks Helio W & Richard K for the info.. I passed it on this morning, and he just reported back that it solved his problem. Much appreciated! Steve At 12:27 AM 7/12/2006, you wrote: http://msdn.microsoft.com/vfoxpro/downloads/updates/odbc/default.aspx On 7/12/06, Steve Ellenoff <

Re: How to count Pageframes in a form

Iterate for each control on the form. Use the baseclass property of the control to see if it's a pageframe. Example code (untested): *Iterate through each control on the form FOR EACH loControl IN THISFORM.Controls IF UPPER(loControl.BaseClass) == "PAGEFRAME" *Iterate thr

Re: MS Virtual PC *and* VMWare server - free!

I've posted this here before, but I'll be happy to repeat it for anyone who missed it. I really like the VMWare product. I've used the free server version, and liked it so much I decided to buy the Workstation version. The workstation version is reasonably priced ( i forget now how much ), bu

RE: How to count Pageframes in a form

This doesn't just happen to me in software, but in other areas.. Most notably, if I buy something off ebay, and it seems the package is taking much longer to arrive than it should, within 1 hour of me emailing the seller why I don't have the package, it arrives. Why is it that so many times,

Speed Send equivalent for VPF?

Does anyone know of something comparable to pcAnywhere's Speed Send that can be purchased for VFP integration? For more details about my question see my blog post: http://sellenoff.blogspot.com/ Thanks for any suggestions - Steve ___ Post Messa

RE: Speed Send equivalent for VPF

Thanks for the info Bill. Not exactly what I was looking for, but certainly interesting all the same. What kind of costs are involved, the website doesn't mention it. -Steve At 05:31 PM 7/13/2006, you wrote: Heya Steve - I've used this with VFP apps in the past -works very well, as long as yo

Re: Speed Send equivalent for VPF?

/2006, you wrote: On 7/13/06, Steve Ellenoff <[EMAIL PROTECTED]> wrote: Does anyone know of something comparable to pcAnywhere's Speed Send that can be purchased for VFP integration? You'll have to tell us what Speed Send does. If it transfers files quickly by only sending diff

Re: Speed Send equivalent for VPF?

Thanks for the info Ted! As previously posted, one implementation idea was to backup/sync database files. Another was to improve the speed of a custom application that I have to support where data is stored centrally (DBF), but the data can be worked on by the salesforce on their laptops. They

Re: Speed Send equivalent for VPF?

As long as you can count on users not performing data changes while you do the synchronization, you could probably set this up as a batch job to run in the evenings... come to think of it, I have a client where this might be a good deal for us, too! Let me know if you end up trying this out,

Checkbox in Grid oddities.

Anyone else ever had strange issues using a checkbox in a grid? Specifically, the column with the checkbox is used as an Include or Select? column to designate which records to choose for some processing. I got it working fine, but... I've noticed the following strange behaviors: 1) Sometimes

Re: Checkbox in Grid oddities.

Short answer? 1) Mouse movement can cause this behavior, though I have seen this behavior with a laptop touchpad clicking the button, not tapping. 2) Buffering Tracy I turned off the buffering, it didn't help it.. What's the long answer? ;) At 07:19 PM 7/18/2006, you wrote: .refresh ??

Pulling Data from Website from different location

I'm not sure why I'm asking this, as I'm pretty sure I know the answer but it's been a very tough week, my brain is dead, so I just need someone to confirm - I've done plenty of West Wind Connection websites where you post data from a webpage and the server pulls in the variables and returns

Re: multithreading in VFP

Finally someone posts the appropriate response to the VFP multithreaded question!! Way to go Ted!! While I don't disagree with people saying that VFP is not the correct choice for multithreaded apps, ( I agree it's not the best choice there ), most programmers I've met have no real idea what

Re: [NF] Installing XP Pro over XP Home

If you have a choice, do a clean install. I've got a notebook that I had no choice to install pro over, and although it went fine, it continues to have occasional networking issues that I've never had problems on machines were I did a pro install from scratch. At 10:03 PM 8/8/2006, you wrote:

[NF] Website Survey software?

Can anyone here recommend website survey software that allows for an administrator to generate surveys and of course record the recipients answers online? I am putting together a proposal to program one, but want to make sure I offer my client any viable alternatives to reinventing the wheel.

Re: [NF] Website Survey software?

Thanks guys for the quick responses.. Sorry if I wasn't clear... I was hoping to get recommendations based on your or a coworker/friend's actual direct experience with a product. With so many to choose from, I'd prefer to narrow the choice based on positive feedback from the community rather t

Re: Rick Schummer blogs on Eli's invoice scam...

I've also gotten a ton of mail "last chance" particularly from them recently. It's definitely ridiculous. -Steve At 10:56 AM 9/12/2006, you wrote: I know that I've about had it with that company. I had renewed a month or two back and it seems like their mail barrage has just increased since

[NF] Test ignore

Testing sending from a new email address.. please ignore. ___ 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 Ar

[NF] Test ignore

Testing sending from a new email address.. please ignore. ___ 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 Ar

Re: NF: Anyone (else) seen Eudora handling junkmail wrong?

Yes, in fact, most posts from profox are now getting logged as junk with a 99 out of 100 score. I have not found a solution other than to manually filter my junk box each day and have it place the profox messages into the correct folder. If you find a solution let me know. At 07:35 AM 5/9/2008

Limit to # of Parameters in a Parameterized View?

I've been wondering if anyone knows if there is (and if so what is it) the limit of how many parameters you can supply in a parameterized view such as: SELECT * FROM customer WHERE first = ?pcFirst AND ?pcLast (in this case there are 2 parameters) I'm wondering more from a SQL Pass through poi

Re: Integer 64 bit field

You may not have a choice other than to split them into 2 Integer fields on his end, since I don't think there's an easy way to get VFP to handle getting a 64-bit integer. I hope I'm wrong, and would love someone to correct me. While you may possibly be able to store it in a 8 byte field, it's

Re: Can I programattically set method code?

Bindevents can do the same thing for you but much easier unless I misunderstand what you're trying to do. At 12:29 AM 7/24/2008, you wrote: >Perfect! We have a winner. That's what I needed. My idea is to use >sys(1270) to create an object based on a grid, then use code to set all >the text box

Re: VFP Development on Linux

Hi Jeff- I spend 100% of my development time in virtual machines which I host on my laptop. I still do quite a lot of VFP development, and thus I find the VM environment more than capable for both testing and development. I happen to be hosting on a Windows XP machine, but there's no reason I

Re: [NF] MySQL numeric type clarification

MySQL numeric fields work very different than they do in VFP, and I found this very confusing at first (still do actually as old habits die hard).. Unlike VFP, for numeric fields, the field's size (ie the maximum number allowed in the field) is dictated only by the type you choose, ie, tinyint,

Re: [NF] MySQL numeric type clarification

Having been programming in Foxpro long before there was an integer type I still tend to think of fields that need numbers in terms of the plain old original numeric field, rather than using the integer type. Thus to some extent I'm unfairly not thinking in apples to apples comparison (ie MySQL

Re: crazy defaults

While this is purely speculation on my part I believe the reason the VFP team made the default .F. was to save memory and avoid loading any un-necessary dlls. The reason is because in order to have form tooltips when programming to the Windows API (as VFP must do internally), you have to initi

Re: EFT/ACH transfers?

From my experience with this, there are several companies that offer this service, and the specifics of what you need to do are slightly different based on who you use. I'm doing ACH for a customer where we simply create a text file (very simple no complicated fields), and have a user upload i

Re: crazy defaults

>Really? Seems odd that they would use the common controls for tool >tips but nothing else... Maybe ActiveX controls support tool tips >somehow and that'd be why... It could be they use them for something else besides the tips although I think the original VFP didn't really need to make use of

Re: [NF] MySQL update theory question

AFAIK Limit is applied last, just as you said. Explain is more for determining what indexes (or lack thereof) a certain query is using. Glad to hear I'll have at least 1 attendee! :) At 12:59 PM 5/3/2007, Kevin Cully wrote: >I would think that it would be faster doing one SPT to MySQL than to

Re: [NF] MySQL defaults question

Have you looked at the advanced ODBC options for MySQL5? I vaguely remember having to tweak some settings for VFP. Sorry, I don't have my MySQL project in front of me at the moment, so I can't really check it out.. Let me know if you come up with anything.. Steve At 11:15 AM 5/3/2007, you wrot

RE: 35 attendees at the Advisor Conference?

What kind of bait/switch did they pull? At 02:04 PM 5/7/2007, you wrote: >Do you have a link for that count? > >All I can say is that with the cost - benefit given the high price tag and >the bait/switch sessions for the more recent conferences I had attended, I >don't even consider going to the A

Re: any one gots the demo package of Visual WebBuilder 2.0 ?

I believe they did quite some time ago, or at least, there was nothing on their website last time I checked (awhile ago). At 03:59 PM 5/7/2007, you wrote: >William Sanders / EFG wrote: > > Don't tell me to contact EPS - they don't sell it anymore. > > >Why not? Have they dumped all of their VFP

Validating an email address?

Does anyone have some nearly fullproof code to validate an email address for proper syntax? I have continually tweaked some code over the years to prevent user entered email addresses from being input which are wrong so as to lessen the # of failed messages sent, but I still haven't been able

RE: Validating an email address?

Thanks Dave!! This is great! Only question I have is, what are the requirements for having the VBScript.RegExp available on the client machine, ie, does it come preinstalled with XP (or some other software) or do I have to manually install on each client machine? At 12:41 PM 5/9/2007, you wro

Re: Validating an email address?

Yes it would, and what would be even better is if there was a standard supported way to know that an outbound email message was either sent and received successfully (by the server, not necessarily the end-user) or not. That is to say that once you've got a syntactically successful address in

Re: Denial isn't just a river in Egypt

Alan- I think you raise an excellent point and a very possible one. I'm completely baffled at how poorly Vista handles so much of the existing software. Notice I didn't say surprised! :) It's not that hard a stretch to see that backwards comparability might not work nearly as smoothly going fo

[NF] Brilliant Mac Ad bashing Vista, did you see it yet?

Since I've been TIVO'ing for a long time, I seldom catch commercials these days, but I happened to be watching live tv and caught (what I assume is) a fairly new ad where the Mac & PC guy are talking about Vista, with the Vista wheel of choices! I laughed my head off, not so much because the ad

Re: [NF] Brilliant Mac Ad bashing Vista, did you see it yet?

You can do the same exact thing using VMWare's products as well as Microsoft's virtual machine products.. It was the point I was trying to make in the 'denial' thread about keeping VFP apps running forever in a VM machine running on an "old" OS like XP, or as some have suggested 2000 (which is

Re: [NF] Brilliant Mac Ad bashing Vista, did you see it yet?

Windows and Linux run very well on VMWare for me. I've been using it for about a year or more. I'm running VMWare workstation 5, but the free one is great too (albeit with less features like linked clones and stuff). I'd play with the free one and see what you think before spending any money on

Re: [NF] Brilliant Mac Ad bashing Vista, did you see it yet?

although I haven't spent that much trying either using it mostly for business related stuff. At 03:53 PM 5/10/2007, you wrote: >On May 10, 2007, at 3:08 PM, Steve Ellenoff wrote: > > > Windows and Linux run very well on VMWare for me. I've been using it > > for ab

Re: [NF] Brilliant Mac Ad bashing Vista, did you see it yet?

>They have announced upcoming support, but I doubt that any serious >gamer who maxes out their hardware would ever be happy with any VM. I agree - I was thinking in terms of the developer working in DirectX or OpenGL or other 3D Hardware based API wanting to use a VM for development & testing a

Re: [NF] MySQL4 and MySQL5 residing on same machine

I'd just keep a virtual machine with it installed. At 01:33 PM 5/18/2007, MB Software Solutions wrote: >I downloaded MySQL5 recently and installed it, but it seems that ver4 >and ver5 can't co-exist on the same port (3306), so I chose to use 3307 >for MySQL5. > >My dev laptop (where MySQL is insta

Find out when a cursor is closing?

I'm working on an inherited project and there's a bug I'm trying to track down where a cursor is expected to be open as the app is exiting, but it's closed already. Easily handled by just bracketing the code with IF USED("tempout"), but I want to find out why this used to work before and no lon

Rant about the management of the Foxpro magazines

It's been well covered how completely annoying the almost monthly "Renew Now or Else" letters we get for FoxTalk subscription is, but what I have recently learned is how equally annoying it is that the reverse happened to me for Foxpro Advisor and on several occasions over the years. My subscri

Re: MySQL ODBC

Make sure the following in your mysql odbc advanced settings are turned on/checked: flags 1: Don't optimize Column Width flags 2: Pad Char to Full Length Most likely the "Pad Char to Full Length" should fix your problem with varchar fields. Not sure why the view would blowup after in-activity.

Re: FoxDataObjects - Comments?

I tested it out quite some time ago. I liked the product, but found quite a # of bugs and issues at the time. At first the developer was rather quick at addressing the issues, but then suddenly stopped responding to my emails. I eventually got busy and never really looked back at it. I would e

RE: [NF] The Top 10 Dead or Dying Computer Skills

For once, I am thrilled Fox didn't get any press on this one! At 01:52 PM 6/19/2007, you wrote: >On Tuesday, June 19, 2007 1:36 PM Matthew Jarvis wrote: > > > From GlobalKnowledge: > > >http://globalknowledge.rsys1.net/servlet/cc5?sghOQSCAQUVuHllrxIpsLMjpKH >PQJhuVaVR > >I was just reading that a

Re: To list inclusions or exclusions in the database...that is the question!

I'm no expert, but from what I've read: fixed is better if you can use it, and yes to the tinyint question.. :) At 02:58 PM 6/24/2007, you wrote: >I've got the following tables: Customers and Products. I want to >create an intersection table called Customer_Products to house the >specific pro

Re: [NF] Windows 2000 Professional under some open source virtual machine.

I'm a big fan of qemu, but ever since vmware has been free, I've had no use for it, and can't see why anyone else would either, especially since vmware is still better, faster, and far easier to setup than qemu. At 08:17 PM 6/28/2007, you wrote: >After hearing about qemu, I decided to take a loo

Re: Slow load of runtimes

If the run time files are loaded on her local pc already, the only thing I can think of is some kind of virus scanner is hitting those run times when they load. You might also check that her network connection is the same speed as others, ie, perhaps she's only 10Mbit and others are 100Mbit?

[NF]Need clarification of GPL license for commerical use for MySQL

Recent threads have sparked my curiosity to inquire to the open source experts amongst us to help clarify what exactly is considered commercial use of an application that connects to a MySQL database. I very briefly read over the GPL FAQ and understood the MySQL license to allow a company to us

Re: [NF]Need clarification of GPL license for commerical use for MySQL

> Exactly. As long as you are not creating a product to be > distributed >to others outside of your organization, you can use it without >restrictions. Thank you for clarifying Ed! Glad to see I had it right. ___ Post Messages to: ProFox@l

Re: FoxForward -- thanks

I also want to extend my personal thanks to Kevin for putting together a great conference. Although I was unable to attend 2 of the 3 days, what I did see was terrific. Everyone did a nice job of presenting and I found the topics very fresh compared to the usual stuff you see. I also wanted to

Re: FoxForward -- thanks

At 02:42 PM 9/18/2006, you wrote: I also want to extend my personal thanks to Kevin for putting together a great conference. Although I was unable to attend 2 of the 3 days, what I did see was terrific. Everyone did a nice job of presenting and I found the topics very fresh compared to the usua

[NF] - Project Management - What do you/your company use?

I'm curious what everyone out there uses to track their projects and to deliver reasonable estimates on meeting project deadlines and/or milestones, whether you are a consultant or employee? Are you using home brew software or someone else's product(s)? One of the companies I work with has rec

RE: Toolbar Menus

I've never used formsets based on similar people's opinion, but I've also never actually seen someone explain why they are so much trouble to use? Can you or someone spell out what it is exactly that makes working with them not recommended? -Steve At 03:23 PM 9/20/2006, you wrote: Kevin, S

VFP Siting @ The Dentist

I've started going to a new dentist recently, and after yesterday's cleaning, I happened to get a good look at some of the screens on the system they are using. At first, I wasn't sure, but it had the unmistakable look of a VFP application. What started to give it away was the 3 paged pageframe

Re: [nf] 10 programming languages to learn know

Cool Demo. Now who want's to make one for VFP? :) -Steve At 03:36 PM 9/21/2006, you wrote: If anyone wants to take a look at Ruby (as in Ruby on Rails), there's a neat interactive demo over at http://tryruby.hobix.com/. [excessive quoting removed by server] _

RE: VFP Siting @ The Dentist

Happily, no drilling was required. Of course, they reminded me that I don't brush enough.. Gee thanks, I'll add that to my 'not doing enough' list, such as exercise, drink water, read for fun, relax, spend time with kids & wife... -Steve At 09:42 AM 9/22/2006, you wrote: This may be a tad O

RE: [nf] 10 programming languages to learn know

I assume the Ruby on Rails is different than developing in just Ruby? I've seen a lot of blogging from former .NET programmers who've switched over and love it. -Steve At 11:53 AM 9/22/2006, you wrote: >Ruby looks to be a great language. I tried *very* hard to like it, but it didn't click f

RE: [nf] 10 programming languages to learn know

They won't be doing rich UI Windows-based fat client stuff with it I bet. You're probably right. Most of the stuff I've seen mentioned was "AJAX style" (but not necessarily using AJAX) web apps, no mention of desktop apps. Then again, I thought desktop apps are considered dead? ;) -Steve

RE: Slow VFP9

Thanks for posting the Wiki link, I was totally unaware of this information!! -Steve At 03:03 AM 10/25/2006, you wrote: Malcolm, Good spot Malcolm, I forgot about that one and I got bitten with it about 6 months ago when I set up a server and forgot to set the codepage correctly. Details are o

Re: VFP++ - back on track again

He's probably interested from a "how does it work" point of viewnot as a buyer of rights from M$. Kevin and I spoke about this topic in person. The answer is: His interest is in how he could take his product "REAL Basic" and make it more attractive to the growing # of VFP users who are

RE: VFP++ - back on track again

I don't see why it would be anything but a good thing. Choice is good. I'm not planning on dumping VFP *ever* unless I am "forced" to do so, or find a better tool. Considering I doubt the latter will happen, more likely it will just become harder and harder if not impossible to get new VFP work

RE: VFP++ - back on track again

This sounds like a great idea to me.. I'm all for supporting it. The only drawback I could think of is that you might end up with lots of code that's no longer transferable to someone who doesn't have the ++precompiler installed, but I'd see that as not a big deal as a tradeoff for us to have c

VFP - Remote Connections - How many, how often?

I'm curious what everyone's adopted standard is regarding creating remote connections to access remote databases from VFP. Specifically, how often do you create/open and close connections in both a desktop and web environment? Some may use different approaches for each environment, others may u

Re: VFP - Remote Connections - How many, how often?

Special for Whil: Just send me your completed Appendix to your MySQL book about Connection Strategies, as it seems you've outlined the very questions I have.. No wonder I came up with them reading your book! :) Unfortunately, looks like I might be waiting awhile till you reach that section.. ;

Re: [NF] Sysinternals lives...

I love this new 'feature' that ms put in: "Workaround for .NET runtime handle leak" ROTFL!! At 06:34 PM 11/9/2006, you wrote: > > >For those of us who were worrying that the tools from Sysinternals were >going to disa

Re: [NF] ubuntu live cd

I ran into the exact same trouble and ended up giving up on it and going with a different distro. One would think they could address this issue in an update. -Steve At 04:08 AM 11/16/2006, you wrote: >Morning Guys, > >I was playing with the live CD on my copy of ubuntu 6.06 last night, and >I

Async not working, what am I doing wrong?

I cannot seem to get an asynchronous connection to work. Am I missing something obvious? Despite the call to SQLSETPROP("Asychrounous",.T.), the SQLEXEC() locks until the entire result set is returned, despite finishing with a 0 return value. I've tried in VFP8 & 9SP1 & SP2 hitting a PostgreSQL

RE: Async not working, what am I doing wrong?

Yes it hung on the first SQLEXEC call. Using your code had some interesting results which I will theorize about in a follow up post, since I have found more info over the weekend. Your code acted as follows: First Call is printed.. Pause for (a long time) Then it prints 0 and goes through the l

RE: Async not working, what am I doing wrong?

I googled over the weekend and found the real problem. I tried Tracy's terrific suggestions before posting this answer just to see if it would change anything. The answer I found is the PostgreSQL ODBC driver does NOT support async mode!!! ARGH!! One of the primary reasons I dumped MySQL for Po

RE: Async not working, what am I doing wrong?

>fwiw, I'm not experiencing problems with MySQL...which version were you >using? I think I was still using the 3.23 ODBC driver version. I posted about it here about 3/4-1 year ago, I was using a 3.xx based version. The two things I recall from memory was that Medium Text fields were treated a

Re: Async not working, what am I doing wrong?

Hi Stephen- Thanks for your reply. Yes, I'm very aware that select * is a foxpro mentality, I was only using it to test out the async functionality. In fact, my app runs just fine w/o async for the very reason that I only pull columns I need and I always use a fairly restrictive where clause.

Re: [NF] MySQL MyISAM table crashes -- your suggestions for better design?

If you're getting a lot of hits on the MyISAM table I'd definitely see if making it InnoDB solves the problem as that's the simplest change (no coding changes) and likely will help your corruption issues. At 11:41 AM 12/02/2008, you wrote: >Background: >* MySQL5 - MyISAM tables >* Customer is a

Non Modal Report Preview?

A user was complaining the other day about the report preview being a Modal window (of course they didn't use that term), and I got to thinking if there's any way to make vfp's report preview window non-modal. Having never investigated this before, does anyone know of ways to do this, in older

Re: Non Modal Report Preview?

:) At 02:26 PM 12/05/2008, you wrote: >Steve Ellenoff wrote: > > A user was complaining the other day about the report preview being a > > Modal window (of course they didn't use that term), and I got to > > thinking if there's any way to make vfp's rep

RE: Non Modal Report Preview?

ry/ms965281.aspx > >I picked up her book from Whil's site when I wanted to "Pust it to the Limit >and Beyond" >(sorry Cathy, couldn't resist) > >It's fantastic ... Really got into it using 'Listeners' > >Good Luck, >Francis > >

RE: Non Modal Report Preview?

past. > >Cathy Pountney > > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >On > > Behalf Of Steve Ellenoff > > Sent: Friday, December 05, 2008 3:44 PM > > To: [EMAIL PROTECTED] > > Subject: RE: Non Modal Report

[NF] MS Word Mail Merge multi detail band?

Any Word Mail Merge gurus out there know how to simulate multi detail bands? I have a vfp app which generates a dbf of people who should receive a word document selected by the user and this works just fine, ie, I've got automation doing the merge automatically. The problem is on some of the le

Re: [NF] MS Word Mail Merge multi detail band?

populating line breaks as Word treats that as 1 field, am I right or does your solution solve that problem also? At 09:23 AM 12/10/2008, you wrote: >On Wed, Dec 10, 2008 at 6:28 PM, Steve Ellenoff <[EMAIL PROTECTED]> wrote: > > Any Word Mail Merge gurus out there know how to simulate

RE: Interaction between Firefox and VFP9

I can also confirm this as I posted about it here when I first started using FF3. It's nothing to do with VFP9 as I see the same thing on machines that don't have vfp9 installed. I never used to reboot my (virtual) machines and now I'm forced to frequently as the memory that FF3 uses and never

[NF] Online storage solutions - too good to be true?

http://www.onlinestoragesolution.com/index.html Was looking for some really cheap online storage solutions and found this company from a PC World article. Any thoughts on them or any real experience with them? The deal which seems far too good to be true is 10$ a year for unlimited storage. I

Programmatically place text into the clipboard?

What's the easiest way to place text into the user's clipboard for easy pasting programmatically from VFP? Ie, let's say I roll up a string via STRTOFILE and now I want the user to be able to Paste it into some other application. Thanks for any help- Steve

  1   2   3   4   >