Search results for query: *

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

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

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

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

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.

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

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

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

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

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

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