debasisdas

Hi Charanya, Welcome to daniweb.

uninstall reboot system install and then check

those are not characters but strings on data. On what basic / logic you want the output ? Is the format always same for all the records ?

what exactly you need to implement ?

Please pass more information.

What is the target field type ? Why you need to convert current_timestamp using to_timestamp ? Why not use current_timestamp of systimestamp directly.

You need to read books for all those details.

From your code i am not sure what are you inserting into the picture field ? Since you are using [B]Me.Picture_box1.Text[/B], i do not understand how that will store the picture in database.

please post the code that you are working on.

try this. [CODE]j = Convert.ToInt32(txtstaff_id.text.ToString())[/CODE] also change [CODE]select staff_id from staff [/CODE] to [CODE]select max(staff_id) from staff[/CODE]

How you define [B]file is corrupt[/B] ?

Welcome to Daniweb.

You need to handle null properly while reading from source.

Yes.

May be God know what you are asking.

You need to store the database file in application path.

Instead of doing that from another system and trying to synch the changes on target system. Create the changes as a script and apply the same on target system directly.

I don't understand anything from your question either.

Hi David, Welcome to daniweb.

Write your country name correctly.

What exactly you want to encrypt and decrypt in the database ? Data in particular fields or the entire database ?

Do you have indexes on the source table ?

Welcome aboard.

Welcome to Daniweb.

you need to format the dates properly before passing the same into the database.

what is the source of data.

You need to read [URL="http://support.microsoft.com/kb/158140"]this[/URL] and [URL="http://www.vb6.us/tutorials/playsound-api"]this[/URL].

Welcome aboard.

You need to join both the tables based on ItemNumber or Ponumber or both based on your database structure.

you need to use [CODE]SELECT price into product_price FROM product WHERE produc_id=777;[/CODE] and then check the value of the variable [B]product_price[/B] in a IF...END IF block.

try the sample code [code=oracle]select * from branch minus select * from branch where rownum < (select count(*) from branch)[/code]

else if you want to run the program without installation (in the same system) ,you can simple compile an EXE from file menu---->Make exe.

Try this. [CODE]select EmployeeID, sum(TransactionAmount) as TotalAmount from employee where EmployeeID IN ('E123','E234') group by EmployeeID;[/CODE]

Are you storing the login credentials in database ?

are you storing login credentials in database ?

May be you only understand what are you trying to do.

Your question has nothing to do with VB.net application. The business logic needs to be implemented entirely at database level.

how are you trying to connect.

[CODE]if val(text1.text) <> "0" or val(text1.text) <> "" then c = val(text1.text) * 1 + c end if[/CODE]

I can't find any code where you are executing the [B]OleDbCommand[/B] object.

You want to search for all hundred at once or in a loop ?

are you getting any error with the code ? check for your DB field type and the data that you are passing in the SQL.

The simplest thing to do is to check system date on start up. suppose you want for 30 days from today ---say 25_sep-2011. in the start up check if the date is less than the above date. if it is more display an error message. for a better and full …

Please find more details [URL="http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html"]here[/URL] and [URL="http://www.quest.com/sql-navigator/"]here[/URL].

what software you want to make ?

What happens when you execute the code ? Are you getting any error ?

please try to use the sample code to store picture. this sample code uses ADO for database connection [code=vb] Dim CN As New ADODB.Connection Dim RS As ADODB.Recordset Dim DataFile As Integer, Fl As Long, Chunks As Integer Dim Fragment As Integer, Chunk() As Byte, i As Integer, FileName As …

Try using [B]SHELL[/B].

Really difficult to guess anything without detailed information.

Another approach (using database). If using oracle as database, compile [URL="http://bytes.com/topic/oracle/insights/771381-sending-mail-using-utl_smtp"]this[/URL] procedure in database. Call the same from VB 6.0 using ADO like [URL="http://bytes.com/topic/visual-basic/insights/739076-executing-oracle-stored-procedures-type-parameter"]this[/URL]. The second link is a sample only, to show how to call a oracle stored procedure from VB 6.0..