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!

Recent content by seckner

  1. seckner

    Beginner needing TSQL help

    Using what I've learned so far I've cleaned up a BUNCH and it's starting to make some sense. Given this line (yes, 20 times): CASE WHEN OCode = '17' THEN '"' + RIGHT(RTRIM(REPLACE( CASE WHEN CommentLine1 = NULL THEN '' ELSE RTRIM( REPLACE( CommentLine1,'"','')+ ' ') END + I know that the...
  2. seckner

    Beginner needing TSQL help

    As messy as it is this is one of the 20 'Parts' statements in the query I've inherited. My goal is to simplify it if I can and try to make it more manageable for me. This is day #1 for me at SQL so I'm looking at it as a true outsider. Just what I've gotten from both of you in the last few...
  3. seckner

    Beginner needing TSQL help

    Thank you sir! I have 2 big problems, 1 is I'm not a dbase guy (yet anyhow) and I've inherited a very old UNIX back end, so we're forced into 'mirroring' their data structure. When we get the data from it we have 20 parts fields, 20 parts cost fields, 20 parts description fields, etc... forever...
  4. 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 =...
  5. seckner

    Excel Import

    Wow - Thank you! Small problem, again it's my lack of knowledge - when I try to run this I get an error stating that USEDROWS does not evaluate to an object. I apologize but I don't know where to go from here.
  6. 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...
  7. seckner

    SQL Table nvarchar to FoxPro field

    I think the greatest thing about this board is two-fold. First, a new-be can come and ask questions without being made to feel, well, like a new-be. I don't have to be 'afraid' of misspeaking. Second, and more important I think, is I don't just get an answer. I get an solution, an explanation of...
  8. seckner

    SQL Table nvarchar to FoxPro field

    Thank you! My fault completely for not explaining clearly. I'm still trying to wrap my head around FoxPro's terminology. I'm doing a "Select *" in FoxPro against an SQL table to get it into FoxPro. This works except: If I open the table on the SQL Server I see that the field named "Entry" has a...
  9. 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 -...
  10. seckner

    FoxPro 9 SP2 and SQL Server dates

    Thanks for your quick reply! I really do appreciate it. I made the changes you suggested and ran it - it still brings back an empty cursor - if I type the values in there are 3350 records returned. I noticed something though - running it through the debugger it shows your cLastMonday value to...
  11. 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...
See more

Part and Inventory Search

Back
Top