hi,
I'm using a function to backup 10 tables with 2 fields (P_no, and startdate and enddate) to use in a function
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)
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