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 Chriss Miller 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: FoxAmateur
  • Content: Threads
  • Order by date
  1. FoxAmateur

    Invalid Subquery in VFP 8.0

    Does anyone know why the following code generates an invalid subquery error in VFP 8.0? SELECT * from tableA WHERE phone in (SELECT phone, count(phone) as count FROM tableA GROUP BY phone HAVING count > 1) I am trying to create a cursor of records where the phone number appears in tableA...
  2. FoxAmateur

    ODBC vs. OLEDB

    I am taking my first step into the remote data world and would rather use ODBC over OLEDB and have to deal with record sets. I have to take an ascii file and insert those records into an Oracle table. Do you have to create a DSN on each computer that runs this code? Chris [spin]
  3. FoxAmateur

    Sub-Query in the FROM clause of a Query?

    Does any know if VFP can handle a Sub-Query in the FROM clause of a Query? I get a systax error for the following query. SELECT county, zip, count(*) ; FROM (SELECT pm.*, z.county ; FROM pm_return pm, zipcodes z ; WHERE pm.zip == z.zip AND match = 'Y') ; GROUP BY county, zip ...

Part and Inventory Search

Back
Top