debasisdas

you can't increment a string by a number directly as you have tried. try this way 1. separate the number from string. 2. increment the number as desired. 3. concatenate back with the string.

if the format is always same, order by last character.

Hi Shikha, Welcome to Daniweb. Hope you have a nice time here.

You can write the back up script into a batch file and schedule to run the same using scheduled tasks or execute from your application.

Please find the details [URL="http://www.oracle.com/technetwork/database/enterprise-edition/documentation/index.html"]here[/URL].

I clicked on a PM and got this. [B]Invalid Private Message specified. If you followed a valid link, please notify the administrator[/B]

Which version of oracle you are trying to install ?

Hi, Welcome to Daniweb.

so what you have tried till now ?

the code will be more readable this way [CODE]SELECT a.Id,b.data_desc,c.other_desc,d.DATE FROM tab1 a,tab2 b,tab3 c,tab4 d WHERE a.Id = b.Id AND a.Id = c.Id AND a.Id = d.Id;[/CODE] NOTE:- avoid using DATE as a field name as it is a predefined key word (data type). which record is duplicate in …

there is no reason why you can't set both min and max value for a dtpicker.

May be you need to look into [URL="http://www.databaseanswers.org/data_models/"]this[/URL].

Please find it [URL="http://www.connectionstrings.com/"]here[/URL].

Hi Raim, welcome to Daniweb.

what is the code that you are working on ?

without knowing what code you are working on , how can one guess if it is coding error or not .

what is the code that you are working on ?

To which version of SQL Server you are trying to connect to using Management Studio Express ?

what is [B]Datetime[/B] in your code ?

are you formatting the dates before importing ? Please have a look [URL="http://www.daniweb.com/software-development/vbnet/code/369512"]here[/URL].

You need to update the data not the application, right ? You need to use a centralized database and all the branches should access the single instance.

what is the database that you are using ?

What exactly is the problem, that you are facing ?

You need to store the MS Access database in a shared location in the server to which other system users has permissions and then point to the same from your application.

that will be easy if you calculate at database level.

please read more [URL="http://www.google.co.in/search?hl=&q=mysql+installation&sourceid=navclient-ff&rlz=1B3GGLL_enIN395IN395&ie=UTF-8"]here[/URL].

why not select the product with min(price) from second table and fetch that product record from 1st table.

what is the formula that you want to implement ?

try this [CODE]SELECT * FROM ProfilesWebsites LEFT JOIN ProfilesAccounts ON ProfilesWebsites.ProfileWebsiteName = ProfilesAccounts.ProfileWebsiteName[/CODE]

database should always be in centralized server.

Sorry, we do not solve assignment / home work questions here. Show some effort to get help.

No, if you do not want all the columns you need to specify the list of columns. If it a table or a view you can create a view on the source object using only the desired columns.

On Error Resume Next----is evil, especially in the context of log in screens. [CODE]"select count(*) from login where username = ' " & Text1.Text & " ' and password = '" & Text2.Text &"'"[/CODE] if count returns 1 proceed further and go to the next screen else re-prompt for login …

Hi David, Welcome to Daniweb.

Hi Radu, Welcome to Daniweb. Hope you have a nice time here.

what is the source of the data ? is it from any database ?

what is the input for the expected output ?

with the information provided by you it is not possible to guess anything.

have you tried using the NEW keyword.

you need to use ROWNUM.

Hi , welcome to Daniweb.

What you have tried so far ?

Please find it [URL="http://download.oracle.com/docs/cd/B19306_01/server.102/b14200.pdf"]here[/URL] and [URL="http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261.pdf"]here[/URL].

You granted from which schema system or HR ?

try this [CODE]select * from user_views[/CODE]

Hi, Welcome to Daniweb.

Which version ? check the details [URL="http://www.connectionstrings.com/"]here[/URL].

that should be feature of application not oracle database.

please check [URL="http://www.amazon.com/dp/0201694719/?tag=stackoverfl08-20"]this[/URL] and [URL="http://db.grussell.org/index.html"]this[/URL].

Can you please post your database table structures.