Posts by debasisdas - Page 112

you can remove the titlebar itself just by changing the property.

also find out the employee id and pas that employee id to outer query to find out all the other details.

the USER_...........views contains info about user data but SYS_............ and ALL_...... contains data of all other users also to which notrmal users may not have priviliges.

You need to use BETWEEN clause .

A good general not only sees the way to victory; he also knows when victory is impossible.

As soon as the fear approaches near attack and destroy it .

for select statments (opening recordset)

rs.open "your sql statment here"

for any DML

conn.BeginTrans
conn.Execute "Your sql statment here"
Conn.CommitTrans

There is no difference in using access or oracle or mysql queries in VB. The process is all the same.

The synonym becomes invalid if the base table is dropped. You need to drop the synonym manually.

Don't tell your secrets to others.
If you can't keep it don't expect others to do it for you.

Are you getting any error from the query.
Are you sure related data exists in the tables ?

Kindly post the query that you are working on.

Life is a tragedy for those who feel, and a comedy for those who think.

We are far more liable to catch the vices than the virtues of our associates.
Denis Diderot

Change your thoughts and you change your world.

Character is a diamond that scratches every other stone.

If we do not plant knowledge when young, it will give us no shade when we are old.

What exactly you are trying to do ?

That simply means you are not using the correct version or oracle database. You are trying to execute some advance commands in the un-supported earlier versions.

If you create the database with same structure in oracle then you only need to change the Connection string for opening the connection in Vb. Rest all are remains the same and you can use the advantages of procedures & functions

Kindly post your code . What are you doing exactly and what are the problems that you are facing.

My life has been full of terrible misfortunes most of which never happened. - Michel de Montaigne

Add Exit Sub before the error handler.

The universe is change;
our life is what our thoughts make it.

Seconds away from my room , i saw a ghost.

Line

Balk

4547

-929

Modules are a way to declare objects at one palce and access them globally.

Are you facing any problem with your code ?

Better to put the database in some FTP server and access that through the net using the Ip address with username and password for security.

What exactly you are trying to do ?

You need to design the report in crystal report and call that from VB.
You can pass the query to filter records at runtime.

What is var_list1

you have declared var_list

The unexamined life is not worth living. - Socrates

Nature does nothing in vain. - Aristotle

What exactly youa re trying to do.

Both are easy provided that you have intrest.

You need to check if the data already exists in database using COUNT before inserting the same to database.

Deity

day and night is a never ending process.

^ Another Nice Human on Earth

< Browsing for last 4 hours.

V will continue.

4537

-916

tall

4535

Your imagination is your preview of life's coming attractions.
Albert Einstein

You mean to say ,you want to write to the same file in parallel from two different proceses ?

Can some one help me with the following. Any help will be appriciated.

Platfprm : Visual Studio 2005, Visual Basic

...........
..................
........................

NK

Please do not hijack others threads .
Start a thread of your own instead for fresh discussions.