try the following code, make changes as desired


Dim CN As New ADODB.Connection
Dim RS As ADODB.Recordset
Dim DataFile As Integer, Fl As Long, Chunks As Integer
Dim Fragment As Integer,...

All things changes with the pass of the time but true love expands in the heart of the faithful.

Being lonely is not necessarily the same as being alone.

There is a charm about the forbidden, that makes it desirable.

Try the following link (http://www.oracle.com/pls/db102/homepage) and select SQL Reference

You need to use the function RUN_REPORT_OBJECT


DECLARE
repid REPORT_OBJECT;
v_rep VARCHAR2(100);
rep_status varchar2(20);
BEGIN
repid := find_report_object('report4');
v_rep :=...

"If I had my way We'd sleep every night Wrapped around each other Like hibernating rattlesnakes." William S. Burroughs

To create jut an exe select makeEXE in File menu.

To create a complete setup use the Package and Deployment wizard .

From your post i became a bit curious and tried to trace back my old days here.

My first post was in community introduction section here (http://www.daniweb.com/forums/thread80215.html), as i was...

For that you need to use a staging table and update the master table based upon data in the look up table.

You need to handle the code in a PL/SQL block.

please find some related articles here (http://bytes.com/forum/thread724451.html) and here (http://bytes.com/forum/thread726143.html).

at command prompt type exp help=y you will get the list of parameters for export . repeat the same for import with keyword imp

how are you calling the reports from VB ?

that is because VBA is used to define macros notto compile an EXE or DLL.

you can call the .net exe from Vb at runtime ans pass the parameter.

Hi Neha

Here we do not write code for others. SO please do not expect others to design the GUI and send you the code . for getting help you need to post what you have tried so far for the...

you need to copy that componet to your system foolder and register that with windows using REGSVR32.

Sports serve society by providing vivid examples of excellence.

instead of hard coding the recordset object open and close that dynamically through a sub procedure.

You need to use BETWEEN clause .

Add Exit Sub before the error handler.

The mind that is anxious about future events is miserable.

Try using looping through all the controls on the form that have font property.

in sql *plus type HOST

in the command prompt type

exp username/password@databasename

then just follow the instructions as prompted

Try use this sample code


Private Sub tv1_NodeClick(ByVal Node As MSComctlLib.Node)
LV1.ListItems.Clear
rs.Open "select * from EMP", con, adOpenDynamic, adLockOptimistic

Dim li1 As ListItem...

It is better to start a different thread for a new question.

anyways try to use this sample query


DELETE FROM emp e WHERE rowid>(SELECT MIN(ROWID) FROM emp WHERE e.empno=empno)

If the truth were self evident, eloquence would be unnecessary.

You can't convert directly. But you can upload data of access into oracle.
You can export the data of access into a .CSV file and from oralce use the SQL LOADER to load the same data to oracle...

They wil rise highest who strive for the highest place.

You guys need to follow some book on the basic of DBMS / RDBMS.

Then kindly post the question in the proper forum only.

The wise only speak when they have something to say. Fools speak, because they have to say something.

The worst days of those who enjoy what they do are better than the best days of those who don't.

Fire is the test of gold; adversity, of strong men.

All men are not fools, some remain bachelor.

better late than never

thanx for self learning, that really helps a lot.

The future belongs to those who believe in the beauty of their dreams.

All the flowers of tomorrow are in the seeds of today. :)

there are 10 types of people

those who can understand this and those who can't.