debasisdas

what is the database that you are using ?

Find out the max value of the field and add 1 to generate the new value.

Please pass more info , which control you are using ? how you make those cartoons ?

What is Crytsal 10 ? How are you connecting to Oracle DB ? If you have privileges you can create any object in DB.

How you are connecting to database ? through code or by setting properties only ? please mention the error code and error message for further assistance.

You can try the sample code in the [URL="http://bytes.com/topic/visual-basic/insights/726143-adding-items-treeview-listview-database"]link[/URL]. The code needs to be modified to suit your exact requirements.

No SQL command is going to change your archive log destination. Someone with good knowledge of oracle DB must have changed the same.

The following [URL="http://en.wikiversity.org/wiki/Functions_and_Subroutines_in_VB6"]link[/URL] might be helpful for you.

Have you tried the simplest method , subtraction.

Do you have any questions ?

what are you using to generate the report ? [B]data report[/B] or [B]crystal report[/B] ?

What exactly you want the VB code to do ?

stored procedure or trigger for what ?

There must be some code / event that is triggering the focus of the control. Is there any change event coding on the textbox ?

A project only using database ? What is the front end tool that you are planning to use ?

Try using [URL="http://msdn.microsoft.com/en-us/library/8c6yea83%28VS.85%29.aspx"]SendKeys[/URL] Method

What exactly you want to achieve from this model ?

You need to use [B]MSComm[/B] control for the purpose.

Would you mind posting your working code for review of our experts.

What is the database that you want to connect ? How you connect to database ?

This problem is because you are trying to create two objects by same name. You are creating a column and a constraint by the same name with in a table . this why u are getting this error . Try to use different name for the coumn and the constraint.

You need to set [URL="http://msdn.microsoft.com/en-us/library/bb226709.aspx"]this[/URL] security settings in outlook 2007.

You can check [URL="http://bytes.com/topic/visual-basic/insights/701826-drawing-chart-using-mschart-control"]this[/URL] as a sample . This is manual coding, you can go for DB connection also.

The link has been removed from [URL="http://www.oracle.com/technology/software/products/database/index.html"]parent site[/URL]. Try to go for the latest version .

You better contact the web hosting service provider.

Delete ----------- 1. DML 2. Affects only data. 3. Data can be rolled back after this command. Truncate ---------------- 1. DDL 2. Affects both data and structure (resets the High Water Mark) 3. Data can't be rolled back after this command.

Please have a look at this [URL="http://support.microsoft.com/kb/168204"]article[/URL] from MSDN. Also check [URL="http://articles.techrepublic.com.com/5100-10878_11-1050075.html"]this[/URL] .

Please post your code that you are working on. Our experts will advice you to improve the same. Don't expect the complete code.

Try using the following [URL="http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261.pdf"]link[/URL]. This is part of oracle documentation library.

If you want to move that like hands of a clock use SIN and COS trigonometric functions.

There are different ways to connect to database. you can either you code or components. try using ADO or DAO. What is the database that you are using.

What exactly is your requirement ?

What exactly is the error.

Welcome aboard.

1. declare a byte variable 2. check the value for 3>= before prompting for inputbox 3. increment the value by by 1 after the inputbox

Are you using the SPOOL command to generate the flat file ?

@sbchandru You need to post your working code before asking for code and specify in which part you are facing problem. Here we do not run a free code writing service.

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

Welcome aboard, See you soon in VB forum.

Welcome. C++ developers never gets old they only mature with time.

Welcome. Please post your question the related section of the forum only.

Hi nishanth, Welcome to Daniweb.

You are most welcome.

Then you need to use the free tool [URL="http://www.allroundautomations.com/plsqldev.html"]Query Reporter[/URL]

What did Google say ?

Kindly do your home work / assignment yourself. He re we do not run a free code writing service. If you want help, post the code that you are working on.

put the application in start up. run the application in system tray. use some third party control to display popup message.

if you are ready to pay use TOAD or PLSQL DEVELOPER, the best possible tools in market.

Please check [URL="http://www.daniweb.com/forums/thread243004.html"]this[/URL] thread.

Please find the connection string [URL="http://www.connectionstrings.com/mysql"]here[/URL].