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 strongm 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: seckner
  • Content: Threads
  • Order by date
  1. seckner

    Beginner needing TSQL help

    Pretty new to SQL so I'm looking for the correct way of looping. What I mean is I have a small part of a statement: ,CASE WHEN [PN1] = NULL THEN ' ' ELSE [PN1] END ** lot's more ** Now in the language I know I could do something like this - where the %x% just substitutes the x value: For x =...
  2. seckner

    Excel Import

    Could someone show me a drop dead example of pulling rows out of Excel and into VFP9? We get a spreadsheet by email several times a day and I've been able to importing them. Well, they have changed the format with about 5 lines of "Header Junk" and the data now starts on row 6 vs row 1. I know...
  3. seckner

    SQL Table nvarchar to FoxPro field

    Please be patient with the noob.. I'm querying an SQL Server table where a few badly needed fields are coming into FoxPro as memo fields. The SQL field type is nvarchar, size is 255. I've been trying to figure out how to get them from memo to what they are which are file names -...
  4. seckner

    FoxPro 9 SP2 and SQL Server dates

    I'm really confused over dates between FoxPro and SQL Server. I'm trying to use FoxPro to pull back records from our SLQ Server 2008 - I need all records between 1/03/2011 and 1/07/2011 from the server to a FoxPro cursor. This part works well but it's very manual using "between...

Part and Inventory Search

Back
Top