Search:

Did you merely check the syntax or actually run the query? Of course you would have to change the stored procedure to some other than spBobstest (maybe sp%).

The reason I ask is that is...

Good catch, but I am still missing something here. I changed the procedure to read:

While (@@FETCH_STATUS = 0)
Begin

Exec ('IF EXISTS (select * from ' + @dbObject + '..sysObjects where...

Hello all,

I was wondering if anyone knew why I was receiving the following error:

Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'spBobsTest%'.

I don't get where my syntax is goig wrong here, I am hoping someone can help me out?

declare @pLevel varchar
set @pLevel = (select cast(serverproperty('productlevel') as varchar(8000)))
print...

Ok, I am at my witts end, and have been working on this for about a week now, with very little actual progress, so any help would be appreciated.

If I knew C++, I think this would be easy by...

I saw that class, no doubt, but was hoping someone would supply a code example??? Having not worked with registry permissions class before, the examples I saw in MSDN were confusing as all get go.
...

Does anyone know how to get the current permissions for any particular registry key using VB.NET? For example, if I open regedit.exe then right click on a key and choose permissions I can see the...

This is a great example, thank you!

One last question... I have been exploring the "Win32_DefragAnalysis" WMI object, but it appears only functional for win 2003. Does anyone know of anything...

Does anyone know how to write VB.NET code to:

1. Retrieve current system diagnostics for memory
2. as well as hard drive fragmentation

Is it part of the Garbage Collector class or the...

Hello all,

Setting the properties of the data grid during design time seems rather easy, however, I seem to be running into a brick wall attempting to set the column width, alternating backcolor,...

Hello all,

My apologies is I missed the correct forum to post this in, however, I would like to know if anyone has any information pertaining to this set of books (designed to study and pass the...

Does anyone know how to encrypt a string using Transact SQL?

Thanks!
Bob

Does anyone know of a utility that will compare the differences betweent two .RPT files?

Thanks,
Bob

Perfect-a-mundo my friend! Thanks for the help!

Bob

Does anyone know how to resolve this error?

Option Strict On Disallows Late Binding


My code is as follows:
Private Sub Data_Click(ByVal sender As System.Object, _
...

Thanks for the reply DSJ. I am not saving them in an array because quite simply, I haven't figured that out yet :).

So, I thought originally like you did, I should iterate through the controls to...

Thanks again DSJ for your great post! I took it a bit further and now I am running into another problem. I am attempting to change the backColor property on the previously instantiated buttons FROM a...

Thanks!

I have items in a list box control that I need to change the text of, but I haven't figured out how to do that yet.

If I could check the index of an existing item in the list box, I could then...

Wait! I got it.... I used a case 10 to 19, 20 to 29 statement and all is good!

Thanks again.

Bob

DSJ, thanks for getting me started! That was a big help for sure. Maybe I can run this one by you.

I'd like to add the controls in the following format:

1 2 3 4 5 6 7 8 9 10...

Hello all,

I need to create one hundred buttons on a form, which all behave with simaliar attributes. When each button is pressed it will have to remember that it was pressed and change color...

Winzip is much better... That's my opinion

Bob

I am getting the same error... although I do not have a resolution yet. If anyone has resolved this, please let me know.

Thanks in advance!

Bob

Oh... but I should say this... I only get the follow up error (error 432 if memory serves me right) after the orignial error. Again, VB crashes, then the next time I open VB an error 432 occurs.
...