debasisdas

1. First of all you need to decide on your target Db structure as per your actual requirement. 2. Next you need to create a data mapping document that maps table wise and field wise from heterogenous source system to target system. 3. Load the data from different source sytem …

tyr this rs.open "select count(*) as cnt from employee where emp_id='"& txtemplid.text &"'",con,adopendynamic if count is zero then insert.

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.

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.

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 …

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.

[URL="http://en.wikipedia.org/wiki/Mohandas_Karamchand_Gandhi"]Mahatma Gandhi[/URL], father of the nation in my country.

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

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

what is the exact error message ?

when you mention update automatically, what exactly you are trying to achieve.

One of the easiest way would be to write soem key value to system registry. Try using **SaveSetting()**.

[This](http://bytes.com/topic/visual-basic/insights/739076-executing-oracle-stored-procedures-type-parameter) also may help you.

try something like this. select * from IASubcriberFuzzy1 where priamry_key in (select priamry_key from IASubcriberFuzzy1 minus select priamry_key from (your query goes here))

You need to declare the variable in a Module (.bas) file.

You need to include that from Project--> References menu

You need top qualify the teddtbox anme with the containing form name and then assign any value that you wantto display. ex. form1.textbox1.text = "Hello"

What about restriction the user input to certain length ? For output if the value is outside the range of decimal, simply show as out of range. That is exactly what the windows built in calculator does.

If you have not added any image to the background of the form, from where it is appearing. You need to change in the property pallet of the form.

If you want to over write the record you need to use UPDATE not INSERT.

Our's is not a free coding service. You need to show some effort to get any help from our experts.

Have you already written the code ? If so, in which language ?

In which step you are getting the error ? To add a new Environment Variables you need to add a new variable name and its corresponding values.

Is oracle installed on same machine ?

what about implement the filter at DB level through SQL by generating and executing queries dynamically at run time.

can u kindly mention what is the datbase u want to use.

what is the database that you want to use over LAN ?

You want to do that using VB 6.0 ???

Do you have password for SYSTEM or any other account with DBA roles ? If that is the case you can alter password of SYS and login with new password. without that you can't retrieve the password and can't login.

You can connect to the DB using any frontend tool using the login credentials. Try using Oracle [Sql Deveoper](http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html).

For what ?

At high level you need to implement data lock at record level from DB. It will depend on the DB taht you are working on for exact mechanism to implement. Aslo you need to capture the same from the application and inform the other user who is trying to access …

I think you need to join both the tables. It will be better if you post the structure of the underlying tables for better analysis.

You ned to generate the id based on some logic, the easiest will be to use a running sequence.

You guys needs to show some effort to get any help here from our experts. Please do not expect the complete code to be delivered to you. When you are talking about interesting and innovative topics, you need to do that. No onw will do that for you. After all …

What is the version of MS Access that you are using ?

What is the initial value of a ? and the screen shot suggests you have created control arrray of Option button. so tehnically there is no control named Option1, Option2 and Option3 what you have is Option1(1),Option1(2),Option1(3)

go on your knees and bow down before the pole and start begging it, that may help.

What if i am partially color blind and red appears maroon or saffron to me. Does this concept of typing the name of the color in the code work ? Just a thought, though. :)

Which database you are using ?

Is this the only code that you are compiling as part of the procedure ?

try this CREATE TABLE JOB (EMP_ID NUMBER PRIMARY KEY, MGR_ID NUMBER, CONSTRAINT EMP_CONST1 FOREIGN KEY (MGR_ID) REFERENCES JOB (EMP_ID) )

Please check [this](http://bytes.com/topic/visual-basic/insights/720399-capture-video-webcam-displays-picture-box), may help you.

Yes you need to declare the variable in a module (.bas file) with global scope.

> It can run smoothly if only one record has year value equal to 2012, but not if has multiple record with same value. I don't see why this code will not work. By the way what is the error you are getting ?

You can't log in with conn system as sysdba it has to be conn sys as sysdba if you want to login as system login with system/<password>@<connection_string>

You mean to say this number [B]1231231231231231[/B] is being stored in an [B]integer[/B] field in the database ?

You need to include all the 3rd party componenets as part of the setup and ensure all the DLL files are registered with Windows in the target system.

What is the relation between the following tables ? STUDENT_T, FACULTY_T COMMITTEE_MEMBER_T

try this CREATE USER john IDENTIFIED BY out_standing DEFAULT TABLESPACE users QUOTA UNLIMITED ON users TEMPORARY TABLESPACE temp QUOTA UNLIMITED ON system;