Posts by debasisdas

Is that an independent stand alone field or has any dependency with data in the same / other table ?

Oracle Database Express Edition 11g Release 2 is mopst suitable for you.

You can downlaod it from below link.

http://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html

No, we are not a free code supplying service.

You have to develop it yourself.

Please do post back with what you have done so far and where you are stuck. You will definitely get help from our experts.

Capture the Insert statement into a string valiable and print it. That way it will be much easier to debug.

You need to capture keyboard and mouse events and use Timer.
Reset the timer on each user interaction (keyboard and mouse events).

I mostly take public transport.

You need to use SQL Loader for the purpose.

Also check for using External table.

To use SQL Developer you need to download from official site and just click on the EXE to start using it. It has nothing to do with SID. Please post the details of your error for further assistance.

You can disable the keyboard by handling the key_press and key_Down events and similar related mouse enents like Move and Over. But the question is if you disable both keyboard and mouse how the user is going to interact with the application.

Try using /*+ APPEND */ hint

The APPEND hint instructs the optimizer to use direct-path INSERT.In direct-path INSERT, data is appended to the end of the table, rather than using existing space currently allocated to the table. As a result, direct-path INSERT can be considerably faster than conventional INSERT.

If oracle Express in stalled the default database name will be XE only.

On an average 60 Hrs per week.

I really do not understand what is Oracle SQL Server,(there is no such thing) are you talking about Oracle SQL developer. If it is, you do not need Oracle SQL developer to create a database. It can be configured during installation of oracle itself.

And i really do not know why you need to use XAMMP to work with Oracle.

1. accept login credential from UI.
2. check the same in the DB. (select count(*) from user_table where user_id = "user_id" and password = "password" ). ensure user_id is unique/priamy key.
3. if it matches (if count = 1 then)proceed further
4. else re-prompt for credential.

You need to go through this and this for beginners.

You need not install Oracle SQL Developer to use it.

Just copy the installation set and invoke the application by ckicking on the EXE.

What exactly you mean by duplicate records.

Duplicate based on what ?

You need to write HIERARCHICAL QUERY by using the following.

The START WITH...CONNECT BY clause.
The PRIOR operator.
The LEVEL pseudocolumn.

So what do you expect from us here.

Do not move an ancient boundary stone set up by your ancestors.

You may be interested in this also.

Try the following SQL command.

PURGE RECYCLEBIN;

Facts are stupid things.

Please post the code that you are working on, to understand the exact requirement and come up with some solutions.

Here is a completely different approach, the code is in form of a Oracle procedure . You need to call the Oracle procedure in VB to achieve the same.

If the data format is consistent and is being stored in a database, you can filter it out at DB level based on the availability of colon (:) and period (.) in the string. But if it not consistent accross it will populate other data also.

for example

If you have some data like
ho.ney.be.e:2090
it will also be populated in the control.

Simple because it matches the pattern even though it is not a valid Ip address and port number combination.

What is the source of data, is it stored in a database ?

Are these samples IP addresses and port numbers ?

You need to polulate the controls from the recordset before closing it. Of course you have to check for BOF and EOF.

something like this.
If rsSearch.EOF <> True And rsSearch.BOF <> True Then
Text1.Text = rsSearch.Fields(0)

You need to include a CASE statement and a group by clause.

The code is perfectly fine, but what i understand from the question is the OP is aking for a wave file not how to play it. OP needs a file not the code to open it.

This is not the solution for what you are looking for.

Please let us know exactly in which step you are facing the issue.

The more experiences I have, the better I work , the more I work the better my experiences are.

That is how most of the mail services used to work a couple years back. But most of them have addopted the way as auggested by RJ. So its time Daniweb does the same as well.

That is because you never assoceated the seelct statement stored in SQL the variable to the rs.open method.

try this

rs.Open SQL, cn, adOpenDynamic, adLockOptimistic

You need to convert the file into .CSV format. Then use SQL Loader to upload the data into Oracle table.

It is better to convert all the files into .CSV format and then upload into oracle.

You need to write some code to clear the content of the input controls.

That may be the requirement, but to me the requirement itself is weird. This can never be a real time scenario. It really does not make any sense to me to have OrderFormNo=123 and CashBillNo='ABC' for all the subsequent records. This will end up with a scenario where all the records in the table will have the same data repeated across all records. Why not store this combination in a master table and refer the same by implementation of rerefential integrity from any dependent child table.

I was asking asking about the file that is containing 3000+ records as mentioned by you.

As already mentioned in the previous post, encryption is done for highly secure data fnot for all. Encryption/ decryption of data is implemented through some predefined objects like a procedure or function or some tool. So that there is no issue of loosing the key.

Simple,

make the field CashBillNo the primay key of the table.

It will not allow duplicate records.

Ok, got it.

But i also have a question.

Say you have 3 records like this

OrderFormNo=345 and CashBillNo='ABC'
OrderFormNo=123 and CashBillNo='ABC'
OrderFormNo=234 and CashBillNo='ABC'

Which one to delete.

What is the file format of source data ?

1. Polulate the combo box by querying a specific field of a table from DB.
2. while selecting the value from combo, pass the value from the combo back to the SQL query.
3. Execute the sql in the and capture the values from DB.(ensure that you get only a single value returned from DB)
4. Display in the textbox.

when i say parallel insert , what i mean to say is you need to execute 2 insert statments
1. into the table5
2. into the table4
by using the same input values.

and if you try to use sub queries for insert into table4 and execute the code for each new record, a lot of duplicate records will be inserted into table4 because of repeated select of old data from table5.

What about running parallel insert into both the underlying tables. So each time there is a new entry into table5 the same is also inserted into table4 for desired fields.

tyr this

rs.open "select count(*) as cnt from employee where emp_id='"& txtemplid.text &"'",con,adopendynamic

if count is zero then insert.

The error message is self explanatory. Did you test the connection before trying to pull reports.

and what is the code that you are working on ?

You need to store thsoe informations in a separate table and pass the value to the outer query by fetching from inner query.