debasisdas

i think simple subtract will do that for you.

Sorry, we do not solve home works /assignments here. The error message is self explanatory.

you want to build the database or the search functionality using any front end tool ?

that has nothing to do with database connection . check your other code.

there are number of tools for the purpose. Just use google with proper keyword for effective search.

as the name is icon it needs to be an icon (*.ico) or a cursor (*.cur) file. The size/dimension of the file should be 32 x 32 pixels.

Try this sample code for taking backup and restore of access database [code=vb] Dim DBTempSource As Database Dim DBTempDestination As Database Dim RecTempSource As Recordset Dim RecTempDestination As Recordset Sub MBackup() Set FSO = CreateObject("Scripting.FileSystemObject") On Error GoTo Errors If OptBackup Then TxtRemarks = "Backup Started at " & Time …

What happens when you click on the parent node . Does it not open the child nodes with its icon ?

then download some ebooks and go through that.

you should get correct output with your code. there is nothing wrong with it.

I think you are trying to redefine SQL with your own bunch of syntax. What are those [B]WHILE[/B] and [B]WHEN[/B] in your code ?

You need to pass unique values for the scheduled_num field. schedule_num should be the PRIMARY KEY and semester should be having an UNIQUE constraint. Try to use the insert statement in a procedure and use a SEQUENCE to generate the schedule_num.

i can say the copmpete reference from oracle press covers everything but nothing in details.

if you use timer at a particular time interval that will use a lot of system resources irrespective of any database changes. Better use a refresh button , so that the use can get the updated list at their will.

use the IN clause or simply write a procedure and pass the values. that u want to delete.

You can't disable the windows key.

You just need to store all the required file in specified folders before creating the setup and specify the same in the code as well. Next create the EXE from the file menu and then use the packager and deployment wizard to create the set up

It is always better to store the DB file in the application path and set the property of the control using code in the form load event.

you need to use some 3rd party tool for the purpose.

[QUOTE=cutedipti;951552]hello! As i am trying to insert multiple rows using following command [ICODE] insert into customer(c_id,c_name,c_city,c-street) values('C101','Hayes','Downtown','Main'), ('C102','Willum','Perryridge','North'), ('c103','Smit','Brooklyn','Park'); [/ICODE] It always gives me an error that ERROR at line 2: command not properly ended Please tell me why this error is occuring & what's solution to it? I am …

that is so simple , you just need to compare both the string and proceed further based on the comparison result.

You need to use some third party components and need to connect to SMS gateway for that. All those does not come free.

Welcome to Daniweb.

thanks for the feedback.

please post your your question the [URL="http://www.daniweb.com/forums/forum58.html"]vb.net[/URL] forum.

the community is glad to have you.

Hi Elly, Welcome to Daniweb.

Hi Vineeth, Hope you have a nice time here in the forum.

welcome to the forum.

welcome to the forum.

welcome aboard.

use the following [code]select sys_context( 'userenv', 'ip_address' ) from dual[/code]

Welcome we are glad to have such a useful resource like you.

to open any exe use SHELL from vb6.0

what are all those [B]*[/B] in your create table code ?

If the database is oracle you need to play with USER_TAB_COLS view. You need to frame queries dynamically at run time in a loop and execute.

Nothing is clear from your post . what do you want application design or database design ?

you need to use [B]set DataGrid1.DataSource = Adodc1.RecordSource [/B]

that depends on so many factors 1. are both DB compatible ? 2. are both DB directly compatible (do you need an intermediate level)? 3. Price of new S/W & H/W 4. Professional expenses.

DBA job is to manage the database.

passing parameter to a view ?

Please find the details [URL="http://www.bkent.net/Doc/simple5.htm"]here[/URL].

Hi Kirubakar, Welcome to Daniweb.

Welcome aboard.

* is not required in delete statement. use this strSQL = "DELETE FROM Product WHERE Expiry_Date = '" & Text1.Text & "'"

Windows XP is not a free software.

hope you have a nice time here with all of us.

Welcome to the great site.

Hi Tammy, Welcome to Daniweb.

what is the source of data in the control ? is it getting populated from database ?