Recent content by SteveMac32

Hi Guys I ended up making a procedure out of the original loop and called it when I had a combo that needed to be set. thanks for all the input. Steve

Hi Guys I am loading a combo box With cboSalesCallReason .Clear Do Until rs.EOF .AddItem Trim(rs!CallReason) .ItemData(.NewIndex) = rs!URN rs.MoveNext Loop End With I need to set the combo box depending on the .ItemData (the URN)...

Hi Joe Thats exactly what I did as it looks like you cannot suppress messages well with sql2000. Thanks also gmmastros bit it is easier and quicker to do in vb, like your solution though. Steve

Thanks Emtucifor but I am afraid that SET NOCOUNT ON does not work in this case, I thought that NOCOUNT returned or not the number of rows affected by statement and did not suppress other messages. I have had to come up with a solution using the calling VB application.

I am running a stored procedure which populates a table and has a IGNORE_DUP_KEY and a clustered index on it I am getting the message that "Duplicate key was ignored" which creates an error in the calling VB program Can this be suppressed or changed somehow? I have tried a number of things...

oops sorry I have amended the Put to: .Execute , "put \\global\Files\Exports\Temp_ExportData\ExportTest.txt [b]ExportTest.txt[\b]"

Hi all sorry I need to raise this up again I am now connecting to a FTP not SFTP so i just need a sanity check on the above code, I know its correct well I think i do, Would you agree? If this code is correct it means I can move on and look for the problem elsewhere because when I run either...

Thanks that answers a lot of questions….

Hi all really hope you can help me out here.. I know Inet is not the best but this is protocols they use and they won’t let me change them... That said I have been working on this for hours and about to give up, if only I could, I can’t seem to get or put files onto the sFTP site even though I...

Yea sure did, there arnt any only a few default values.

Hi Thanks for the info I have tried them all in QA it runs fine I think you may be correct in the server timeout as it actually runs on two tables on one it works on the other it does not. Both tables are the same except for the data held in them. The full error message is Run-time error...

My VB6 program calls a stored procedure (SQL server 2000) that runs the code outlined below CREATE PROCEDURE [spExportResetDNP] @TableName as varchar(50) AS Declare @SQL as varchar(250) Set @SQL = 'UPDATE ' + @TableName + ' SET ExpProcess = Null Where ExpProcess = 1' Exec (@SQL)...

Thanks Guys That was the road i was going down but i keep getting these errors: vwData.ListItems.SelectedItem.Index ‘Method or data member not found’ on SelectedItem vwData.ListItems.Item.SubItems(17) ‘Argument not optional’ on Item thought i must have some strange property values but...

Hi all This is/should be a simple one but for some reason I just can’t get it, I think my brain has gone for a long walk. I load the listview from a recordset and when the user clicks on a row I want to be able to look in a particular element and if that element holds a true value we can then...

I Guys, thanks for all your answers and help some really interesting ones in there. Unfortunately I made a school boy error in actually believing what my client was saying, doh!!!!! Strongm thanks you turned the light on and was correct in saying “Erm, I'm slightly confused. A TAB char should...