Search results for query: *

I found the issue. It wasn't that I had a bad SELECT statement. I had to remove the 'partmast.' from the report fields when getting the 'cost' to show up. 'partmast.cost' did not work, 'cost' did work. If that makes any sense. Thank you both very much for the help.

Thank you Mike, that did it! Now onto this SELECT problem... wish me luck :/

Here's a picture of what the Report looks like. I'd like the Date range that the user selects to display below the Title of the report. The costs are obviously not linked correctly. I'm going off what I learned from reading how another form / report was done. So this code may or may not be...

On what Olaf said, The SELECT statement I think I'm supposed to use looks something like this: SELECT partmast.cost FROM partmast LEFT JOIN oo_line ON oo_line.nsn = partmast.nsn I am using a 'SELECT outbound' statement to use the cursor as the ending select statement. I tried simply adding...

Mike, I already have them selected out by dates in some code up above what I have shown. I simply want the String value put into the report.

I'm not sure if everyone has read this but, I am a new software engineer, brought in on a really old product. I had never heard of FoxPro before until a couple months ago. I've managed to learn enough to make a few modifications to a form and report. SQL Statements still really get to me, but I...

I'm trying to create either a list or an array of unique 'location' items in my database, and place them in a drop-down box for a selection. So, you would click the drop-down box in the Form and you are presented with all the unique locations in the the DB. From that I can take the chosen...

I appreciate all the information and replies. I am however a visual learner. I will watch these videos and reference them for future questions. If I have a further questions, I will be sure to report back here. Thank you everyone. :)

I was brought in on an older program, as a fairly new programmer, I have little to no experience with VFP. I have upgraded the application from VFP7 to VFP9 by adding the line 'SET ENGINGBEHAVIOR 70' to allow this program to run. I am trying to add a report and form to choose what information...