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 biv343 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: krisb
  • Order by date
  1. krisb

    Tip of the day

    Does anyone know a good "tip of the day" website? Thanks! kb
  2. krisb

    Tip of the Day

    Does anyone know a good site that has a "tip of the day" for sql? Thanks! kb
  3. krisb

    Formatting dates in a cursor

    You can also: Alter table A alter column datetime d(8) Instead of creating a whole other table, just alter the one that already exists. K-
  4. krisb

    Finding row with highest priority and earliest datetime

    Just an FYI: Max(date) Gives you the Most recent date. Min(date) will give the earliest. Sorry, had to add my 2 cents :o)
  5. krisb

    ODBC DSN Creation

    We have a SQL server and use FoxPro access by having the driver created in: Control Panel ODBC (Very easily set up) Then in VFP: ?sqlconnect('servername') ?sqlexec('handle,"select * from database name") Then once you are "done" with the server, you can disconnect...
  6. krisb

    Set default to

    You can also : use f:\kjfdjfal.dbf set directory to c:\data\....
  7. krisb

    SubQuery Error

    Your sub-select table does not have to have only ONE field in it, but you DO have to specify WHICH field you want to select as Marsh explained. Thanks!

Part and Inventory Search

Back
Top