Database

You need to make 3 joins to the user table, one for each of your user fields in lab_inestigations, something like SELECT * FROM lab_inestigations I INNER JOIN sysem_users S1 ON SI.UserID = I.CreatedBy INNER JOIN sysem_users S2 ON S2.UserID = I.ProcessedBy INNER JOIN sysem_users S3 ON S3.UserID = I.ClosedBy Never underestimate the power of human stupidity RAH

Without changing your connection string, you should be able execute this SQL statement: SELECT name FROM master..sysdatabases You could then determine whether or not your database is installed on that server. This of course will only work if the user you are connecting with has the proper permissions to access the master tables. Give it a shot. :thumbsup:

The WHERE clause isn't used to specify which columns you want to retrieve, but to limit the amount of records returned. It's a filter :) What you want to do can only be done using dynamic SQL. You'll have to know what columns you want to retrieve, or use a wildcard (*) to retrieve them all. I are Troll :suss:

One word of warning with this technique, the following give different results: 859 / 5 * 1.0 1.0 * 859 / 5 If you go down this route, you will need to understand how SQL Server applies its rules for implicit datatype conversion.

I found the issue - the FlexGrid version on my PC(s) was incorrect. I installed VB6 and patched to SP6 then downloaded the Microsoft Visual Basic 6.0 Service Pack 6 Cumulative Update (see http://support.microsoft.com/kb/957924[^]) Only then did I get the latest version (from March 2009) of FlexGrid.

You will have to use dynamic queries or a series of if/else blocks to do this. Dynamic queries are not a good way to do things. If/else, will look ugly if you have even 10 of them. So, either live with dynamic queries or redesign things.

Learn something new every day. :doh: Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

How to manually remove a replication in SQL Server 2000 or in SQL Server 2005[^] Yusuf May I help you?

from the forum guidelines: 6. Do not remove or empty a message if others have replied. Keep the thread intact and available for others to search and read. If your problem was answered then edit your message and add "[Solved]" to the subject line of the original post, and cast an approval vote to the one or several answers that really helped you. 8. Be courteous and DON'T SHOUT. Everyone here helps because they enjoy helping others, not because it's their job. :| Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

DECLARE @ID INT SET @ID = 4 SELECT TOP 1 ID FROM tablename WHERE ID < @ID ORDER BY ID DESC Test the result for null and replace with 0 OR Put the results into a variable in the procedure and test the variable and return the results. Never underestimate the power of human stupidity RAH

Hi I`m searching for the same thing. The only thing i have found is using SQL function EXEC master..xp_enum_oledb_providers

X| Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

thanks it does work fine!

Not this way. First Execute Comm = New SqlClient.SqlCommand("InsertNewPlot", LetsGo.AndGetConnection) Comm.CommandType = CommandType.StoredProcedure Comm.Parameters.Add("@Village", SqlDbType.NVarChar).Value = ComboBox1.SelectedItem.ToString Comm.Parameters.Add("@District", SqlDbType.NVarChar).Value = ComboBox2.SelectedItem.ToString to Insert Plot where InsertNewPlot is the first SP to insert plot then something like this Dim iPlotID as integer For I As Integer = 0 To AddName.Count Comm = New SqlClient.SqlCommand("InsertNewCustomerDetails", LetsGo.AndGetConnection) Comm.CommandType = CommandType.StoredProcedure Comm.Parameters.Add("@FirstName", SqlDbType.NVarChar).Value = AddName(I) Comm.Parameters.Add("@PlotId", SqlDbType.NVarChar).Value = iPlotID Dim da As SqlDataAdapter = New SqlDataAdapter(Comm) da.Fill(ds) iPlotID = ds.Tables(0).Rows(0)("PLOTID") Next