Posts by debasisdas

what is the exact error message ?

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

at which line ?

have you named all the objects as mentioned in the code .

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

try the following

cn.Execute("insert into employee values('" & txtempname.text & "'," & txtempid.text & "," & txtssn.text & ") ")

This also may help you.

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 into temp tables.
4. Finally move the source data in temp tables to target tables by implementing some business logic.

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

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.

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"

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.

so what is the issue that you are faring with the code ?

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.

Have you stalled Oracle Client.

Do you have oracle server database available to you, to be used by your oracle client from your system.

10g versions are no longer available for download.
You can install Oracle client on your machine and connect to any existing database over the network.

If oracle is not atll installed your application SQLDeveloper is pointing to what ?

You need to understand that you must have a database to connect. Using any tool like SQLDeveloper is always secondary.

Nice, heart touching story.

Is oracle installed on same machine ?

You can connect to the DB using any frontend tool using the login credentials. Try using Oracle Sql Deveoper.

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.

For what ?

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

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

and again as i have said earlier, you have tried to copy and paste controls and that resulted in creating a control array of controls (for option buttons) . I am not sure if you have done the same for textboxes also.

then it should have been

a = textbox1
not the other way around.

and it should have been placed just below the declaration of a the variable.

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)

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 it is your project.

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

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.

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. :)

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 the same record.

The fear-factor of not knowing what is going to come out of the dark is wonderfully creepy to me.

Which database you are using ?

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

No one likes to admit they're less than perfect, but guess what? You are.

Please check this, may help you.

try this

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

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 ?

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

The essence lies not in the victory, but also in the struggle.

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 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

Pls check the line 4, you will find some difference.

You need to show some effort to get any help here.

try this

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