I'd go with Plan B. I've never liked surprises, and I can debug easier if I have the SPT all put together for me before I try to execute it. I usually do a TEXTMERGE to get the values into the SPT.
Kevin Cully CULLY Technologies, LLC Sponsor of Fox Forward 2006! http://foxforward.net MB Software Solutions wrote: > App written in VFP9SP1. > My O/S: WinXP Pro > MySQL database local version is 4.0.13-nt. > MySQL web database version is 4.1.15-Debian_1-log. > MyODBC driver version is MySQL ODBC 3.51. > These SQL statements are stored in a local DBF lookup table and > retrieved for SPT execution on the fly. > Other: I'm wearing green today and I like pumpkin pie. <g> > > Problem: > I have a SPT that is something like this using private variables for the > '?' variables below: > > select cname, iage, ddate from MySQLTable where iAge = ?piAge and dDate > between ?pdBegDate and ?pdEndDate > > This query works great (read: "returns data") on my local MySQL > database (on my Windows laptop); however, the same query running on my > ISP's Debian Linux box does not return any data (and yes, I've verified > the data is there). > > > > Suggestions (if sufficient information posted above)? My "Plan B" is to > have the ?variables substituted/manipulated somehow prior to the SQLEXEC > so that the actual values get embedded literally in the SPT. > > Thanks, > --Michael > _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
