Recent content by JohnEfford

Do not forget to set the command type to stored procedure command.CommandType = CommandType.StoredProcedure

Hi Because: 21/07/2004 13:13:52 <> 21/07/2004 Cheers

Should params.Append cmd.CreateParameter("Found", adInteger, adParamReturnValue, , -1) not be params.Append cmd.CreateParameter("Found", adInteger, adParamReturnValue) Plus your also need to have the '@' as part of your variable name. so:-- params.Append...

How are your writing to the text file, via a DTS package? if so this script will check if the file exists. Then perform the stage of the DTS package that writes to the file on the steps success. '********************************************************************** ' Visual Basic ActiveX...

Is it possible to perform snapshot replication over a dialup network. Is it possible but unfeasable. Cheers

I did not choose the first option because it seemed I was replicating code. But having coded a very tortous update statment by building the command as text string I have now decided that this is the way to go as although I am replicating code, the code is easer to read and therfore maintain. If...

I have two linked servers that I want to access. Currently the way I am doing this to build the command as shown... If @Department = 'P' Set @Server = N'Pervasive_1' Else Set @Sever= N'Pervasive_2' Set @SqlCommand = N'Select * OpenQuery(' + @Server + N',''Select * from...

In SQL null does not equal any value ie Null = Null returns false as this clause needs to be true to return a row, no rows are returned. To test for Null use Is Null There for: ..and (Qualifier = @Qualifier or @Qualifier is Null) Regards John

Hi Try TextBox1.DataBindings.Add(&quot;Text&quot;, ds, &quot;TechDisplayName&quot;) Regards

a. The same is also true of VB6, some types are value types and some type are reference types. You need to consult the documentation to see which type is which. Eg Strings and Arrays. b. As explained before if you pass and object reference byval, you are passing the value of the address of the...

I am sorry I do not understand what you are trying to do. Regards

I tested both version of your code, they both gave the same result. VB 6 some_stored_procedure some_other_stored_procedure VB.Net some_stored_procedure some_other_stored_procedure The program '[2620] ConsoleApplication2.exe' has exited with code 0 (0x0) The set command in VB6 is works exactly...

I am not sure that I understand the question! It is possible to have objects as properties in .Net. When you pass an object as a parameter you are passing a pointer to the object, if you the value of the pointer points to the the same object you have passed your object. Regards

As of version one this was one area where C# won over VB, as it was not possible to create the these tool tip comments in VB.Net. I am not sure about this situation in VS2003. In C# you use a triple / (ie ///) to make intellisence comments. Comments are then extracted into a XML with the file...

What is the SQL command you are using, does it not have any parameters that need setting? Also it is not necessary to use a data adapter to hold the insert command, you only need to use a data adapter in conjuction with a data table (although this should not be causing the error) Regards