Search:

This command will give you the trigger names

select trigger_name from user_triggers

All the best.

Kishore.

Thank you very much.

Kishore.

In my application there are many class files. I have made a jar file from these class files. The jar file executes well. My program reads from a text file and displays its contents while running. I...

In VB, you can make a project group and add more than one projects to it. But this feature is included for testing ActiveX controls, ActiveX dlls and such things. You cannot load one form from in...

Hai,

You can use the AppActivate command to activate (focus) another program from your program.

For example

AppActivate "Calculator"

Dear Jing,

I hope the following code will work. I assumed that bookid and chapterid columns are numeric. Place a treeview in the form and run the code.


option Explicit
Dim iKey as Integer ' ...

Dear Rater,

Thank you for your reply. The code worked well for my local system. But what about other workstations in the network? It is important for me. Any reply will be very much appreciated.
...

Hai,

I am developing an application for a Windows NT network. Now I would like to know the users logged in different workstations in the network. Is there a way to get around this?

Thanks in...

Dear NeOmega,

The ScrollBar property of text boxes is read only at runtime. So changin the scroll bar property is impossible. But you can place four text boxes with different scroll bar properties...

Hai,

Here is the code


option Explicit
private astrColors() as string

private Sub Command1_Click()
Dim iArrayCount as Integer

Hai,

Here is the code, which i hope meet your requirements. To run this code place a label in a form and paste the code to declaration section of the form.

option Explicit

private Sub...

Dear babu,

I am still using Crystal Reports 4.6. I would like to know what the later versions have to offer me before I invest money for it.

I appreciate your kindness to spend your valuable...

Hai,

As you are loading the same picture to all cells, why do you load the picture every time? The following code will run more efficiently


Dim X as IPictureDisp

Grid.Redraw =...

Hai,

As you get the report printed correctly when you close and open the form, it seems the data is not saved before you close the form. Try the following.

1. Commit all transactions before you...

Dear Kirun,

write the code in key down event of form rather than key press event. Also, make sure KeyPreview propery of the form is set to true.

The following code displays a message box when...

Hai,

With minor modifications, your code worked very well. The following is the code.


' module level variable.
Dim starttime as date

private Sub Command1_Click()
starttime = Now ' both...

Hai Nitish,

I don't heard of VB's execute insert statement. But I can show you how to insert a apstrophe to a varchar2 field by using ADO. The following code inserts a line into a table TEST.

...

Hai,

I have a very simple problem. I want to find out the difference (number of days) between two GregorianCalendar Classes.

Thanks in advance.

Kishore.

Hai,

I want to turn on/off the Caps Lock, Num Lock and Scroll Lock in my VB Project. Can anyone help me?

Thanks in advance

Kishore

Hai,

Can I display the properties dialog box of a file?

Thanks in advance

Kishore.

Hai,

The wild card charactor supported by oracle is '%'. So your second line should be

rs.Open "select Name from test WHERE name Like 'L%'", cnn1




All the best and regards