debasisdas

Why you need to do that . Try to use third party software for the purpose.

kindly post what have you tried.

There is no such function in Oracle.

what exactly is your requirment ?

the file contains data in which format ? is it binary ?

you need to use COUNT in the database by passing the username and password from the user input . if it returns 1(one) then allow to login else re-prompt for correct user name and password

to store data in database you need to use Insert query from frontend not select .

[QUOTE=brr;615322]if i give days between 4 months, but i want days only till end of the first month only[/QUOTE] why you need to pass dates for that. Last_day will do that for you with only one parameter.

In 10g once the table is dropped its related objects are renamed and stored in recyclebin. But grants will not work anymore.

Check the data foramt by using this select * from nls_database_parameters

you need to pass the password dynamically . If it is wrong return some error ,tap it at front end and reprompt for correct password.

you need to desing the frontend as well as the database and connect the both for the purpose. you need to store alll the details that you need for retrieving it back.

you need to set the properties.

why you need to compare the images . try to work on other fields line id or any other primay / unique key field.

that is not possible

you need to code your requirments.

it will be better to handle the database part manually if it is sql server or oracle.

To avoid duplicate addition you need to check that before adding the item to the tree view.

text fields needs to be enclosed by quotes.

what you have tried apart from this code ?

please do not double post your questions.

are you trying to modify a radonly file copied from a read only media like a CD ?

Please do not try MySQL commands in SQL. creation of database is diffent in oracle . Refer to books/manual for details.

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

Try to use ADO code for better result.

you can use string functions with concatination or just follow the previous post.

search the net . you can easily find some third party compoents for your purpose.

to take assistance of our experts you need to post what you have tried so far .

kindly post what you have tried so far .

Simply You need to create DSN with required credentials for the purpose.

If you are familar with oracle procedures then you just need to take care of the syntax and just implement the logic in PLSQL.

Please find an article on the topic [URL="http://bytes.com/forum/thread771381.html"]here[/URL] . It is tested on oracle 10.2 and uses UTL_SMTP.

Please pass more information. What do you mean by table will be created automatically. You can check if the table exists in database or not by using simple SQl statments.

try to change the border style.

you need to create two connection objects. Insert in access and if connection exists open the second connection and repeat the step1 again.

using the cache increases the performance but that can create problem in some circumstances also.

[QUOTE=MohammadAliSadi;597713] ................................. I do not understand what is the problem. ................................... [/QUOTE] I don't understand all that junk code .

What did Google say ? Have you tried for that option ?

try to execute the commands with EXECUTE IMMEDIATE .

kindly post your code for reference of our experts.

you need to call the function on button click.

option1 use EXECUTE IMMEDIATE for such commands option2 use ADOX instead of ADO.

try to use this me.backcolor=rgb(rnd*255,rnd*255,rnd*255) and call this on a timer . set the timer interval as desired.

You need to work with command objects .

That entirely depends on the type of projet you are doing.

Sorry we don't do home works here.

Have run the nextval from any other query or only for testing the values ? it never happens that it will get incremented automaticalyy or affect other sequence objects.

where do u plan to store the username and password ?

You can use the inbuild tool SQL*PLUS. if you want GUI then can download and use SQL DEVELOPER for free from oracle site.

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