We need someone who can evaluate an existing conversion that seems not to be going anywhere. $142,000 has been spent but it appears not much has been done. We will be taking over the work so one of our programmers could not be an impartial witness. You will be working directly with our customer and will be paid directly.
Wes Wilson, President ERW Custom Programming, Inc. Crescent Lake Plaza 5459 Elizabeth Lake Rd. Waterford, MI 48327 (248) 683-4182 www.visual-foxpro-programmer.com www.erw.com [email protected] From: "[email protected]" <[email protected]> To: [email protected] Sent: Tuesday, February 10, 2015 2:06 AM Subject: ProFox Digest, Vol 142, Issue 11 ----- Forwarded Message ----- Send ProFox mailing list submissions to [email protected] To subscribe or unsubscribe via the World Wide Web, visit http://mail.leafe.com/mailman/listinfo/profox or, via email, send a message with subject or body 'help' to [email protected] You can reach the person managing the list at [email protected] When replying, please edit your Subject line so it is more specific than "Re: Contents of ProFox digest..." Today's Topics: 1. RE: VFP Love/Hate Relationship (Richard Kaye) 2. Re: VFP Love/Hate Relationship (Jeff Johnson) 3. RE: VFP Love/Hate Relationship (Richard Kaye) 4. Re: VFP Love/Hate Relationship (Jeff Johnson) 5. RE: VFP Love/Hate Relationship (Richard Kaye) 6. Re: In search of vfpoledb.dll V8 for testing (Gojko Bo?i?) 7. RE: In search of vfpoledb.dll V8 for testing (Tracy Pearson) 8. Re: In search of vfpoledb.dll V8 for testing (Joe Yoder) 9. RE: In search of vfpoledb.dll V8 for testing (Tracy Pearson) 10. Re: VFP to SQL Server Migration (Ted Roche) 11. Re: Win10 on RasPi ([email protected]) 12. [NF] works like a champ, now how to do the next phase (Virgil Bierschwale) 13. Re: VFP to SQL Server Migration (Stephen Russell) 14. Re: Win10 on RasPi (AndyHC) Since your select is on a single table, try removing the table.field ref? -- rk -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Jeff Johnson Sent: Monday, February 09, 2015 1:18 PM To: [email protected] Subject: VFP Love/Hate Relationship Okay, I've been working with FoxPro since 1992. Seems every day I run into a snag where something reliable does not work. Here is an example: In the Requery() of a list box: DODEFAULT() SELECT customer.customer, id FROM customer WHERE !EMPTY(customer.customer) ORDER BY customer, id INTO CURSOR csrcustomer LOCATE RowSource is csrcustomer RowSourceType is 2 - Alias I get a 'field' phrase is not found. I've read Barbara Peisch's write up on this and still don't see what is wrong. Except for the fact that the programmer named a field the same as the table. Wassup? -- Jeff Same result Richard. I exclusively use arrays as my rowsources so I will try an array and report back. Thanks, On 2/9/2015 11:39 AM, Richard Kaye wrote: > Since your select is on a single table, try removing the table.field ref? > > -- > > rk > -----Original Message----- > From: ProfoxTech [mailto:[email protected]] On Behalf Of Jeff > Johnson > Sent: Monday, February 09, 2015 1:18 PM > To: [email protected] > Subject: VFP Love/Hate Relationship > > Okay, I've been working with FoxPro since 1992. Seems every day I run > into a snag where something reliable does not work. Here is an example: > In the Requery() of a list box: > > DODEFAULT() > > SELECT customer.customer, id FROM customer WHERE > !EMPTY(customer.customer) ORDER BY customer, id INTO CURSOR csrcustomer > LOCATE > > RowSource is csrcustomer > RowSourceType is 2 - Alias > > I get a 'field' phrase is not found. I've read Barbara Peisch's write > up on this and still don't see what is wrong. Except for the fact that > the programmer named a field the same as the table. > > Wassup? > -- Jeff Jeff Johnson [email protected] SanDC, Inc. (623) 582-0323 SMS (602) 717-5476 Fax 623-869-0675 www.san-dc.com www.cremationtracker.com www.agentrelationshipmanager.com Just curious, you got rid of it in both the column list and the WHERE clause? When does the cursor get created? Could this be similar to changing the data source of a grid after its initial creation? -- rk -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Jeff Johnson Sent: Monday, February 09, 2015 1:42 PM To: [email protected] Subject: Re: VFP Love/Hate Relationship Same result Richard. I exclusively use arrays as my rowsources so I will try an array and report back. Thanks, On 2/9/2015 11:39 AM, Richard Kaye wrote: > Since your select is on a single table, try removing the table.field ref? > > -- > > rk > -----Original Message----- > From: ProfoxTech [mailto:[email protected]] On Behalf Of > Jeff Johnson > Sent: Monday, February 09, 2015 1:18 PM > To: [email protected] > Subject: VFP Love/Hate Relationship > > Okay, I've been working with FoxPro since 1992. Seems every day I run > into a snag where something reliable does not work. Here is an example: > In the Requery() of a list box: > > DODEFAULT() > > SELECT customer.customer, id FROM customer WHERE > !EMPTY(customer.customer) ORDER BY customer, id INTO CURSOR > csrcustomer LOCATE > > RowSource is csrcustomer > RowSourceType is 2 - Alias > > I get a 'field' phrase is not found. I've read Barbara Peisch's write > up on this and still don't see what is wrong. Except for the fact > that the programmer named a field the same as the table. > > Wassup? > -- Jeff Jeff Johnson [email protected] SanDC, Inc. (623) 582-0323 SMS (602) 717-5476 Fax 623-869-0675 www.san-dc.com www.cremationtracker.com www.agentrelationshipmanager.com [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** 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.
