hi raam..
u can try this connection..
dim cn as adodb.connection
set cn = new adodb.connection
cn.provider="msdaora.1"
cn.open "server","scott","tiger"
where... "server" is ur oracle server connection string..
but i ve never tried on a unix...
hi..
as much i know... u can only rename a label at run time which are already listed in the list box....
like report title, date etc... and nothing more than that...
coz ive spend around 1 month on data reprots for finding an alternative for this.....
bye.. Good Luck
Varnit
IF U R USING DATA REPORTS THEN U CAN EXPORT THAT REPORT TO INTERNET EXPLORER.... AND THEN TAKE OUT THE PRINT OUT...
THERE'S A DEFAULT EXPORT BUTTON ON THE TOP OF THE REPORT WHEN U VIEW THE REPORT...
Good Luck
Varnit
hi..
scotty told u the right thing...
but according to me u should add one more line which is
dataenvironment1.<command name>
before showing the report....
this might be very useful to u...
Good Luck
Varnit
hi...
u can update that record by just adding the sql statement for update... and the command is like this..
set rs=cn.execute(<SQL STATEMENT>)
Good Luck
Varnit
hi..
just add a command before showing the dr. the command is
DE.<command name>
command name is the command which u configure to connect to the access. it is a sub tree of the DE.connection1.<commands>
and u r done... it will solve ur problem.... reply me is ur problem is solved... i will be...
ya..
u can either create two adodc controls and then update them
or u can do it at runtime..
simply at clicking the command button
add this code:
adodc1.recordset.addnew
adodc2.recordset.addnew
adodc1.recordset.fields(<fieldname>)=<textbox name>...
hello..
u can input the values to create a view for this table and then display that view according to ur requirement in a Data Report through a data environment.
the syntax which i know is for Oracle as it is-
create or replace view master_view as (select name, age, address from master)...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.