Click here to Skip to main content
15,892,480 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
hi,
I'm using a function to backup 10 tables with 2 fields (P_no, and startdate and enddate) to use in a function

VB
If ora.Backup(ls_logid, ls_logpassword, ls_hostring, strPlazaNo, ls_backupdir, ls_startdate, ls_enddate, CheckBox2ID) = True

this is is syntax for backup of particular file with id, passward ,path,tablename,field names(pno and date)

VB
s_backupdmp = "exp" + " " + ls_lid + "/" + ls_lpassword & "@" & ls_hostring & " file = " + ls_backupdir + "" + strPNo + "_" + ls_startdate + "_" + ls_enddate + "HQ_CASHDETAIL tables=HQ_CASHDETAIL query = \""where HQRD_PLAZANO = '" + Session("plazano").ToString() + "'" & _ 
"and HQRD_DATE between to_date('" + ls_startdate + "','ddmmyyyy') and to_date('" + ls_enddate + "','ddmmyyyy')\""" 


i tried to put the parameters In function above(ora.backup) except for table name and corresponding fields ,as there are nearly 20 tables for user selects
checkbox 1 another 10 for checkbox2
so how to get the table name with corresponding field name in a loop or how

kindly any one suggest or give example for calling the function or how to use this kind of getting values from database
i am using web application VB.NET with oracle database
thanks in advance
Posted
Updated 16-Jan-11 17:42pm
v3
Comments
Sunasara Imdadhusen 16-Jan-11 23:43pm    
Added coding format.

1 solution

Questions to bring some clarity to the question itself:

Have you stored somewhere in the database which tables and fields should be backed up on click of which check box?

If you have not, then you cannot loop.

Or maybe I missed something.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900