|
I just joined a company that uses SQL 7.0,which am not that much used too.
i can view 'code' for views with 'INFORMATION_SCHEMA.VIEWS
and can view triggers and other objects with 'sysobjects'
i want to view the code for the triggers in a particular table...
PLEASE HELP ME...THANKS
|
|
|
|
|
the tool is called Query Analyser and is installed with SQL client.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
PLZ WHAT SQL COMMAND DOU TYPE THERE TO VIEW THE TRIGGERS AND THEIR CODES
|
|
|
|
|
Mate you have more problems than I am going to be able to help you with. SQL server 7 is so old it is no longer supported by MS, if you have QA you are just going to have to find your way around it. Most here have not seen SQL 7 for 8 YEARS or more.
I'm really sorry if you have to work with SW so old and truly hope you get the opportunity to upgrade because you are going to find very limited support for SW so far out of date.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
You might want to stop YELLING and then ask this question in the SQL Forum since it has nothing to do with VB or VB.NET.
|
|
|
|
|
I am using Vb.net 3.5 as FrontEnd.
When I am Open a Modal Form such as any Message box. I want to Chnage the Background Form Faded.
that means I want to Show the users the Active and DeActive form.
when I am using another form as faded Form, and opened before the modal form that is not good enogh. because, the whole things get flicker, I need a smooth task.
Can it be Possible,So how can I do that. Please give me a suggestion.
|
|
|
|
|
pdnet wrote: that means I want to Show the users the Active and DeActive form.
Windows already takes care of this for you with different colors for the window border and title bar.
pdnet wrote: I want to Chnage the Background Form Faded.
In that case, you'll have to create your own Sub's to change the Opacity of the form, show the message box, then when that returns, return the Opacity of the form to its previous value.
|
|
|
|
|
Exactly I am doing that.
But When a Modal form is open as show dialog the whole thing is Flikering
I need a smooth work.
|
|
|
|
|
What's flickering?? The entire Desktop or just the form you change the Opacity on? Did you try turning on DoubleBuffering on your forms?
|
|
|
|
|
Changing the Double Buffering on but the Problem same
Change the Double Buffering in all the Forms or just the modal form
|
|
|
|
|
hello tyhere , i really need a working project for marksheet development in vb 6 , if anyone can create for me aur tell me the codings for it , than i'll be really very thanful to one...............
thanx a million in advance..............
|
|
|
|
|
That's just not going to happen. We don't just hand over completed projects. We'll help you write your own code, but we won't write it for you.
BTW, what do you mean by "marksheet"??
|
|
|
|
|
Hi All!
In my application, i am trying to add an event handler at runtime using AddHandler, but cannot seem to find how to pass an argument with that event handler, for instance:
Function SomeHandler(ByVal MyMessage As String)
MsgBox(MyMessage)
Return 0
End Function
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
AddHandler Button1, AddressOf SomeHandler("Hello World!")
End Sub
This Will Not work, I'm told that I have to state the function name, without parentheses.
How would I use this method to pass arguments to an event handler function?
Thanks!
MrWolfy 
|
|
|
|
|
You don't pass arguments in AddHandler. It does exactly that, no more. AddHandler wires up an event to a method handling that event. AddHandler does not Raise the event. That's done using, oddly enough, the RaiseEvent statement.
MrWolfy wrote: Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load AddHandler Button1, AddressOf SomeHandler("Hello World!")End Sub
Your code wont event compile because you haven't told AddHandler which event to wire up to SomeHandler.
|
|
|
|
|
Dave,
that's not true is it? RaiseEvent will only work with the keyword 'event'
Example:
Private Event Test
Private sub ClickMe()
RaiseEvent Test
End Sub
======
You cannot raiseevent of another object that has built in events (where you didn't use the keyword 'event')
'Never argue with an idiot; they'll drag you down to their level and beat you with experience.' ~ anonymous
'Life's real failure is when you do not realize how close you were to success when you gave up.' ~ anonymous
|
|
|
|
|
You are correct. There was a guy around here a couple of days ago trying to wire up events the same way you do it in C#. Man did I have my head up my...
|
|
|
|
|
 no biggy. Just making sure incase I was missing something. I always thought it would be nice to raise an object's event but MS doesn't let us play that way...
'Never argue with an idiot; they'll drag you down to their level and beat you with experience.' ~ anonymous
'Life's real failure is when you do not realize how close you were to success when you gave up.' ~ anonymous
|
|
|
|
|
Hi!
Whoops... Didn't see that sorry! You're right it won't compile, and you were also right about the AddHandler thing. I should have done more research myself. I'm sure I'll find a workaround.
Thanks Again!
MrWolfy
|
|
|
|
|
Hi,
i am writing on a small test-programm wich lists all available trailers on youtube ->
Have a look[^]
I am German so don´t Wonder.
So now the problem is, that i had to write die Draw_Item Event on myself to get this style.
And on every Mousemove, the listview redraws all of it´s Items. And it´s flickering all the time.
Heres my Draw_Item Event:
If e.ItemIndex = Me.SelectedIndex Then
Dim brush As New Drawing2D.LinearGradientBrush(e.Bounds, Color.DodgerBlue, _
Color.White, Drawing2D.LinearGradientMode.Horizontal)
Try
e.Graphics.FillRectangle(brush, e.Bounds)
Finally
brush.Dispose()
End Try
e.Graphics.DrawImage(ImageList1.Images(e.ItemIndex), e.Item.Bounds.X + 2, e.Item.Bounds.Y, 130, 96)
e.Item.Text = " " & Trim(e.Item.Text)
Else
e.Graphics.DrawImage(ImageList1.Images(e.ItemIndex), e.Item.Bounds.X + 2, e.Item.Bounds.Y, 130, 96)
e.Item.ImageIndex = e.ItemIndex
e.Item.Text = "
" & Trim(e.Item.Text)
End If
e.DrawText()
What i tried:
- Setting the DoubleBuffer Property on True
- Suspend and Resume Layout while Drawing
and its still flickering, please help me!! im sitting on this for 24 hours now 
if you don´t know how to fix this, a downloadable listview with this style and no flickering would be also helpfull!
best regards
Julian
|
|
|
|
|
1) Make sure all drawing procedures are in their proper painting event. Do not alter graphics from other non-graphic events.
2) To changed graphics from non-graphic events: setup a variable that is checked in the graphic event, set the variable in the non-graphic event, then call Invalidate() to force the proper redraw of the function
3) Look into the SetStyles method. This enables double buffering as well as many other features that will improve painting performance.
4) Look at one of my articles: Basics of Falling Blocks in VB 2005[^]. The article has helped quite a few people in understanding the proper way of drawing graphics in applications.
Regards,
Thomas Stockwell
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
Visit my Blog
|
|
|
|
|
Hi Thomas,
Point 1 is ensured, im only drawing in the DrawItem Event.
Point 3, i had enabled:
ControlStyles.DoubleBuffer
ControlStyles.Opaque
ControlStyles.AllPaintingInWmPaint
ControlStyles.UserPaint
ControlStyles.OptimizedDoubleBuffer
but all of that dont seem to work.
My English was not good enough to understand point 2, it would be
really great if you would explain it in other words!
regards,
Julian
|
|
|
|
|
DAMN IT WORKS !!! 32 h of endless hate
I made a User Control inherit from the listview control,
and in the constructor i added (like you said):
Me.SetStyle(ControlStyles.DoubleBuffer, True)
Me.SetStyle(ControlStyles.OptimizedDoubleBuffer, True)
Me.SetStyle(ControlStyles.AllPaintingInWmPaint, True)
Me.SetStyle(ControlStyles.UserPaint, True)
Me.SetStyle(ControlStyles.Opaque, True)
This Combination is working!!
Seems like the last time i made something wrong, thanks of you i tried it again,
i also want to recommend This Article[^] + falling Blocks  )
My best regards
|
|
|
|
|
I want to find the creation date of an exe. I am using the following code.
Public Declare Function CreateFile Lib "kernel32.dll" Alias "CreateFileA" (ByVal lpFileName As String, ByVal dwDesiredAccess As Integer, ByVal dwShareMode As Integer, ByVal lpSecurityAttributes As Integer, ByVal dwCreationDisposition As Integer, ByVal dwFlagsAndAttributes As Integer, ByVal hTemplateFile As Integer) As Integer
Dim fHandle As Integer
fHandle = CreateFile(FileName, GENERIC_READ, 0, 0, OPEN_EXISTING, 0, 0)
Using this handle, with some more code we can find the creation date.
This is working fine in VB. But not working in VB.net. CreateFile is returning -1 in VB.net.
Could anyone of you please tell me why it is not working in VB.net and is there any other way(methods) to find the creation date of an vb.exe file.
Thanks in advance,
AR Reddy
|
|
|
|
|
Dim file As New System.IO.FileInfo("path to file")
Dim creationdate As DateTime = file.CreationTime
That should do it
|
|
|
|
|
System.IO.File.GetCreation???(string filename)
Look for a method similar to the above in .NET and run it on the specified file.
Regards,
Thomas Stockwell
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
Visit my Blog
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
