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 derfloh 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: kenndot
  • Order by date
  1. kenndot

    Intellisense manager

    oh , sorry... have you checked it out? if you keep it open in the corner somewhere you can just click the funtion name you want.... kinda the same thing?
  2. kenndot

    Intellisense manager

    not exactly, but you can use the document viewer... that gives you list of all your functions/procedures and then you can click on THAT to manipulate where you go.. does that help?
  3. kenndot

    This Forum

    Ditto on everything! One thing, though, we're starting to use Cognos here (Impromptu) but migrating over to ReportNet, if anyone has any of that background, please visit the Cognos Solutions forum! There's NOTHING out there right now for Cognos and what IS out there, nobody answers most of the...
  4. kenndot

    calculated reportnet field using runtime dates

    Using Reportnet I have 2 dates: date1 date2 on each row I want another field to tell me the difference in minutes between the two. When you create a calculated field, you have 3 options, the documentation tells you to use the 3rd option (Layout) to use runtime info. (I have tried all 3...
  5. kenndot

    Help with grouping a ReportNet report by Month only

    DoubleD You mention that it's possible to hide/show groups? Where is that option? FYI: I've had problems w/grouping, it's not as straightforward as you would expect. Furthermore, there is a known bug which I ran into (it was logged back in March I guess) where when you group and view the...
  6. kenndot

    2 tbls w/same field/datatype - 1 lookup tbl - 1 tbl joins 1 won't why?

    Just in case anyone has a similar problem... I figured out the solution. Somewhere in SQL Server an older view of the table that I am using in the database was stuck and that had a different datatype for the field I was working with. So eventually I decided to recreate the view in SQL Server...
  7. kenndot

    2 tbls w/same field/datatype - 1 lookup tbl - 1 tbl joins 1 won't why?

    I have two tables tblallclaims tblpaidclaims they both have this field: age decimal 9 I have a lookup table tbl_ageranges and an alias of this lookup table alias_tbl_ageranges this table&view have fields - exactage decimal 9 tblallclaims will link to tbl_ageranges on the exactage field...
  8. kenndot

    reportNet report - Report on grouped data by month using a prompt

    Trying to recreate an Impromptu report in ReportNet. I have a very simple grouped report: Priority # Completed 1 201 2 100 3 103 ... and so on. There is another field being used in the query called Completed that is a date/time field. I am...
  9. kenndot

    CRUD matrix

    thanks everyone, what everyone said was great and certainly true but not really what I meant to ask for. I don't think it came out the way I thought it did. I will try to think of a more clear way to post the question that I am trying to answer.
  10. kenndot

    VFP bug? this is very strange

    i tried it in 6 & 8 and i got 0 in both... i don't have 7 or i'd try that too are you doing this in the command window and then displaying "x"? or are you putting this into a table with perhaps not the correct field size? that could give you those results, too
  11. kenndot

    CRUD matrix

    I am actually trying to take that just a bit further and translate the commands SHARED,EXCLUSIVE,NOUPDATE into CREATE,READ,UPDATE,DELETE so then based on what you are saying the answer to my question is as follows?: CREATE - anything that's opened with SHARED,EXCLUSIVE READ - anything opened...
  12. kenndot

    CRUD matrix

    Hi all, Making a crud matrix in I guess the "traditional" format. So I need to determine what Foxpro keywords match up with the CREATE READ UPDATE DELETE All I'm aware of as far as access to tables is NOUPDATE and SHARED and EXCLUSIVE. How do those translate? EXCLUSIVE C,R,U,D SHARED...
  13. kenndot

    VFP8 - Code reference

    can you take it a step further and automate the lookup and output to excel file? I am looking to direct it to a directory which is full of subdirectories (which are app names) and find the tables it uses (from the code) and export that to an excel spreadsheet or html and move along to the next...
  14. kenndot

    use index file from one table for another table-diff is name else same

    here's an even better way, though I open the original table copy structure with production insert into thetable SELECT blah from blah where blah fast and efficient thank you for your suggestions
  15. kenndot

    use index file from one table for another table-diff is name else same

    actually, it did work. I take a small subset of a table, rename it, then copied over the index file and renamed that and it openened fine and I was able to use the indexes and everything. Problem is, however that it takes some time because the files are big and I'm not sure that I want to do...
  16. kenndot

    use index file from one table for another table-diff is name else same

    HI All, I have a "best practices" question, looking for not necessarily code, but english on "how to" do the following... ( a little explanation first) I have a big production table that I hit on a nitely basis to perform calculations and a variety of things. I am using a subset of this table...
  17. kenndot

    how to design tables for dynamic queries

    wow - thank you all! I think I've got some great ideas now and I'm sure I will be back w/more questions, though, since I'm not exactly sure how to implement all of it. I appreciate your comments.
  18. kenndot

    how to design tables for dynamic queries

    I was thinking about what you mentioned, the problem getting a user to understand the AND/OR situation. That made me think of yet another question. What about those times where you need to include brackets, for instance, in an OR statement. What is a good way to handle that?
  19. kenndot

    how to design tables for dynamic queries

    I was hoping to clarify what I am doing here so it makes more sense, because I'm getting the feeling I haven't done a great job of explaining my real question. I have an application that pulls some data and when it was built, the user had specific business rules as to what the criteria was in...
  20. kenndot

    how to design tables for dynamic queries

    Just looking for some ideas on the design of the tables that hold the criteria that the user has selected, like the field names and table names.... the logic I will deal with, I'm just looking for design For instance does this make sense? tblbuildQuery cSelect - holds the field name values...

Part and Inventory Search

Back
Top