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!

Search results for query: *

  1. LesStockton

    Can't view references

    I've got a user (at a remote location) having trouble with an application that I wrote in VBA within Excel. It runs on some machines, but not all. I've determined that it's missing some dll because of the error popup that says it's missing a project or library. So I asked the user to view...
  2. LesStockton

    join and a count?

    I've got 2 tables; basically, topics and messages. How do I list the topics and then the count for each topic? set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[udForumTopics] @CompanyID int AS SELECT T_ForumTopic.ForumTopicID AS "ForumTopicID"...
  3. LesStockton

    Help with a query

    same result. I still don't get a record if the FollowupRepID is null. I should get those. It's just that if it's not null, I want to get the name from the T_Contact table.
  4. LesStockton

    Help with a query

    I've got the following query, which works fine, except in the case where one lookup field might be null. Null is allowed. set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[udFollowupByContactID] @ContactID int AS SELECT FollowupID AS "FollowupID"...
  5. LesStockton

    Simple join

    What's wrong with the join in this stored procedure I'm trying to write? set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[udCount_OrdersNew] @OrderOwnerCompany int AS SELECT Count(OrderID) AS Count FROM [T_Order O] JOIN [T_OrderStatus OS] WHERE O.OwnerCompany =...
  6. LesStockton

    DISTINCT clause problem

    So is there a way to accomplish what I want? Another way, maybe? A select within another select? If so ... please ...
  7. LesStockton

    DISTINCT clause problem

    I've got a problem with getting the DISTINCT clause here working: select Distinct(T_Contact.ContactID), LastName, FirstName, T_Contact.ActiveInd, ContactTypeDescription, T_ContactType.ContactTypeID, T_Organization.OrganizationID, OrganizationName, City, State, HomePhone from T_Contact join...
  8. LesStockton

    SQL: Join question

    Okay. I've gotten a little further and am now trying to build the query based upon what's being passed in. It doesn't like it when I'm trying to compare on the boolean ActiveInd near the end. Originally, I was passing in @ActiveIndicator as a boolean, defaulted to null, then then couldn't seem...
  9. LesStockton

    SQL: Join question

    Curious what the SQL would be if I had E.OrganizationID and wanted to get the C.ContactDescriptions and C.ContactTypeIDs, as well as Active A.Firstname and lastname. A. has ContactID and an activeindicator.
  10. LesStockton

    SQL: Join question

    thanx so much. Yes, I plan on a stored procedure. I'll try this out, but it looks good. Thanks so much. I'm glad to find experts that watch this forum.
  11. LesStockton

    SQL: Join question

    I don't do SQL on a regular basis and don't really know much about JOINs. Can someone help me form a proper SQL statement to achieve what I need. I have to do a search on any or all of: Lastname, firstname, active , contacttype, organization I know there will be multiple sql statements, but I...
  12. LesStockton

    Index checking from SQL query

    I'll do that. Thanx. I probably wont get to it until Monday, but thanx.
  13. LesStockton

    Index checking from SQL query

    This wont work. The SHOW INDEX command isn't something that I can send through ADO from my program. I need something that I can programmatically use to check, and in addition, the SHOW INDEX will not check for a specific index. Now, if I can get a recordset back from the SHOW INDEX command...
  14. LesStockton

    Index checking from SQL query

    Is there a SQL query to check to see if an index (by name) exists on a table? I have this for SQL Server and for Oracle, and need to be able to query to see if an index exists before I try to create it. In some cases, I just need to be able to programmatically check to see if the index, by...
  15. LesStockton

    Connecting via ADO and VB6

    I'm trying to connect to MySQL5 from my VB6 app. My code for connecting to SQLServer works fine. To MySQL5, it doesn't. It doesn't like the provider, but I'm not sure what's wrong and why. SQLDB is an ADODB.Connection, by the way. SQLDB.Provider = Provider ' I've tried "MYSQLPROV" and...
  16. LesStockton

    Database exists?

    What's the SQL statement to test if a database by name, exists?
  17. LesStockton

    Missing Tooltips

    I've got an application where I have tooltips on most all items, even labels. Within the VB environment, they show up, but the compiled version has 3 labels whose tooltips wont show up. Not sure why. Any suggestions? I checked and these labels are enabled, so it's not a case of that somehow...
  18. LesStockton

    RowCount?

    Select * From ImageRecords Where DateModified >= '" & StartingAt & "' AND DateModified <= " "'" & EndingAt & "' ORDER BY RecId " Ok. That's my statement that I'm building within VB6. How do I get a row count with this?
  19. LesStockton

    RowCount?

    I'm going through a simple database table doing a Select * from tablename order by blah I'd like to get the total number of rows and also be able to tell what record I'm on as I go through it, so that I can show a percentage complete message as progressing. How do I get the current position...
  20. LesStockton

    Add-in not in the toolbar as it should be

    I built a simple addin for Visual Studio using VB.Net. It worked fine and the add-in appeared under "Tool" in the toolbar. Then I added some additional functionality and did a rebuild. This is where I started having problems. It wouldn't rebuild because it said the addin was already open...

Part and Inventory Search

Back
Top