Search results for query: *

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

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

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.

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

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

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

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

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

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.

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.

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

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

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

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

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

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

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

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?

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

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