Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ozgirl
  • Content: Threads
  • Order by date
  1. ozgirl

    SQL phrase required for beginning and end of field

    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...
  2. ozgirl

    Checking Criteria/Formula

    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...
  3. ozgirl

    Access versus Visual Foxpro

    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...
  4. ozgirl

    Need help on de-duping records

    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...

Part and Inventory Search

Back
Top