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 gkittelson 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: *

  1. raybetts

    Data Grid Problem

    Hi,<br><br>I have a data grid on a form which connects to a sql7 table via the dataenvironment.&nbsp;&nbsp;Initially the data grid is read only, but I allow the user to edit the data (via cmdbutton) and I then set allowupdates and allowdeletes to true.<br><br>The user then has to press an update...
  2. raybetts

    Stored Procedure Query

    Thanks Jerry
  3. raybetts

    Select Directory?

    Darkman,<br><br>Hopefully I can return the favour.&nbsp;&nbsp;By the looks of things you are doing an inner join on the two tables, yet this query only returns values which are populated in the parent and child tables.&nbsp;&nbsp;But you want it to return the values whether they are populated in...
  4. raybetts

    Date problem

    Thanks Darkman it works like a dream.
  5. raybetts

    Stored Procedure Query

    I have an SP which requires to dates being passed to it and the result should open a report.&nbsp;&nbsp;I have set this up in the dataenvironment and grouped it as i only want to see the parent details once and child details many times.<br><br>I know how to pass the params to sql 7 when I...
  6. raybetts

    Date problem

    I have a table with an ID, a qty, and a date (datetime) in sql 7.&nbsp;&nbsp;I want to query the database and retrieve all recs grouped by a given month. So rather than saying give me all recs = xx/xx/xxxx, I want to say give me all recs = 10 (or oct).&nbsp;&nbsp;Is this possible and if so...

Part and Inventory Search

Back
Top