RipperJT

Hi, Here is a different example using an String.empty to stop input, and uses the number of elements in the arraylist for the loop count.... [code] Sub Main() Dim nameAL As ArrayList = New ArrayList 'Write Console.WriteLine("Enter a full name, Last, First") Dim emptyLine As Boolean = False Dim nameString …

Hi, You could prefix the table name to the column e.g.: SELECT Category.catagoryID, MAX( ..... The query engine doesn't want to guess which table is the one it's supposed to pull that column from... Jason. [QUOTE=geek_till_itMHZ;1045428]Iam writing (or trying to write) a simple join query statement in Query Analyzer. As …

Hi, you can use math comparison operators to select from a range of values, you can add an OR to the statement below to select from an additional range. [code] SELECT * FROM TableName WHERE ([lower] >= 12 AND [upper] <= 20) OR ([lower] >= 100 AND [upper] <= 150) …

Hi, You specified the connection and command objects but you probably want a data reader...also you'll need to open the connection. [code] Dim dr As OleDbDataReader dr = cmd1.ExecuteReader(CommandBehavior.Default) Do while dr.read() variablename = dr("columnName") loop [/code]

Hi, I would try using the GROUP BY & HAVING clause... [code] SELECT AFM, count(AFM) 'Count' FROM kyrf1 GROUP BY AFM HAVING COUNT(AFM) > 1 [/code]

You can use the ALTER TABLE statement to do this... [code] ALTER TABLE dbs ALTER COLUMN ename varchar(20) NOT NULL; GO ALTER TABLE dbs ADD CONSTRAINT pk_ename PRIMARY KEY (ename); GO [/code]

I can't test this right now but it should give you direction... [code]cmd1 = New OledbCommand("SELECT * FROM TABLE1 WHERE ((Ram >= @minRam) AND (Ram <= @maxRam))", con) cmd1.Parameters.Add("@minRam", ComboBox6.SelectedItem) cmd1.Parameters.Add("@maxRam", ComboBox7.SelectedItem)[/code]

Hi, the following statement should work... [code]SELECT min(Time),[Special Number] FROM table GROUP By [Special Number] [/code]

The wildcard is Access is the * but in T-SQL the % is the wildcard operator, and this is used in conjunction with the LIKE operator. Try... [code] select * from table1 where GRAPHICSCARD LIKE 'NVIDIA%'" [/code]

I worked on something like this a little while ago, we used the filter & sort propery to narrow down the list. [code]Me.BindingSource.Filter = "Column LIKE '" & Textbox.Text & "&'" And Me.BindingSource.Sort = "Column Desc"[/code]

Try checking the properties of the KlantTableAdapters update & delete commands to see if they are valid. If the table being affected has no primary key this can also cause this type of problem.

Were you specifying the decimal precision and scale before? The default scale is zero. [URL="http://msdn.microsoft.com/en-us/library/aa258832(SQL.80).aspx"]http://msdn.microsoft.com/en-us/library/aa258832(SQL.80).aspx[/URL]

If you've verified the connection string information and that you have insert permissions on the table, I would try add the owner or schema of table e.g. [code] INSERT INTO dbo.Table_name [/code]

I believe you need to specify the connection that the command object going to use. In ADO you can specify the timeout, command type, command, and the connection to use.