Search results for query: *

Sorry - first part worked - now I need to update this selection by replacing a field with another date and it's saying cannot update the cursor USE fforder SELECT order_no, recall, bqt_type FROM fforder WHERE LEFT(bqt_type,1) = "W" AND RIGHT(ALLTRIM(bqt_type),1) = "2"; and...

Thanks heaps - it works!! Katie

Hello, I need to search on our bouquet code field for everything beginning with W and ending with 2, examples of what may be in the field are:WWH2, WTAB2, WNUTPAC2 (ie: varying lengths) Can you please provide me with the sql so I can include it in my following program: USE fforder REPLACE ALL...

Does the following look right. As a double check I combined the first two programs and made the condition =>2 and I get different numbers to when I run them as below SELE TEMP.ORDER_NO,TEMP.RECALL,POSTCODE.LEADTIME FROM TEMP,POSTCODE ; WHERE TEMP.PCODE=POSTCODE.POSTCODE AND...

We do currently have a bespoken software program in Visual Foxpro. We've been using this platform for over 5 years. We're now looking at re-developing the program and adding a CRM component to it. We have 6 users and currently a customer base of 40,000 with over 12 tables. We're a mailorder...

Thanks heaps - that was fantastic. I've been working on this for 1/2 a day and you've fixed it for me within 1/2 an hour of me posting my problem Thanks again. Katie

Can you please answer why my programmer says that Visual Foxpro is more powerful than Access? We're looking at re-writing our program and employing a new programmer and people (like father-in-law)are asking why not just use Access. I've been told it's a bit like the different between Notepad...

In one single database I'm trying to de-dupe the records that fit the criteria if [ADDRESS_1] matches [ADDRESS_1] in another record show me the results. I'm using Visual Foxpro version 7.0 and typing FROM ffdbc!ffdonor; WHERE Ffdonor.address_1 = Ffdonor.address_1 = .t. This is bringing up all...