debasisdas 580 Posting Genius Featured Poster

Can you post the example?

This is what happens when someone is spoon feed.

debasisdas 580 Posting Genius Featured Poster

Hi Kevin,

Welcome to Daniweb.

debasisdas 580 Posting Genius Featured Poster

You need to put some effort and post the code here. We can modify it and make it work.

debasisdas 580 Posting Genius Featured Poster

Do you have any code that you are working on ?

debasisdas 580 Posting Genius Featured Poster

Show some effort to get any help here.

debasisdas 580 Posting Genius Featured Poster

What buffer codes ?

What exactly you are trying to do ?

debasisdas 580 Posting Genius Featured Poster

I don't think using command buttons is the best option for this.

debasisdas 580 Posting Genius Featured Poster

Read this.

debasisdas 580 Posting Genius Featured Poster

Welcome aboard.

debasisdas 580 Posting Genius Featured Poster

You need to use VARCHAR2.

debasisdas 580 Posting Genius Featured Poster

You need to manually rewrite the code.

debasisdas 580 Posting Genius Featured Poster

Welcome aboard.

debasisdas 580 Posting Genius Featured Poster

Welcome to Daniweb.

debasisdas 580 Posting Genius Featured Poster

Welcome to Daniweb.

debasisdas 580 Posting Genius Featured Poster

welcome aboard.

debasisdas 580 Posting Genius Featured Poster

You need to read this.

debasisdas 580 Posting Genius Featured Poster

You need to add Picturebox to panel or groupbox, it will be easy to manage.

Once the controls are grouped, you can loop through all the content controls and enable or disable at a single go.

debasisdas 580 Posting Genius Featured Poster

You should not get any error with this SQL statement.

debasisdas 580 Posting Genius Featured Poster

Welcome to Daniweb.

debasisdas 580 Posting Genius Featured Poster

Welcome aboard.

debasisdas 580 Posting Genius Featured Poster

what is the problem with step2 ?

suppose
on start of the timer
x=1500
y=2000

after 2 seconds
x1=2500
y1=3000


if x <> x1 and y <>y1 then
' your next logic here

debasisdas 580 Posting Genius Featured Poster

No need of using array ,using variables should work for you.

debasisdas 580 Posting Genius Featured Poster

For a basic design you need to store the database in the server and the application should be deployed in the client.

debasisdas 580 Posting Genius Featured Poster

You need to use some of the components of the device to capture the device signal in your application. You need to get the device and install the same in your system first.

debasisdas 580 Posting Genius Featured Poster

You need to pass the list of values as a subquery.

debasisdas 580 Posting Genius Featured Poster

If you do not want time factors, why use timestamp for the field.

If only data and time portion is required why not use DATE data type and sysdate only.

Majestics commented: Truly Amazing.... +7
debasisdas 580 Posting Genius Featured Poster

1. On a timer keep tacking of the X,Y coordinates of the mouse.
2. Check the same after desired time gap and compare with the old location, if it has changed call the click event.
3. On each mouse move reset the timer.

debasisdas 580 Posting Genius Featured Poster

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

debasisdas 580 Posting Genius Featured Poster

What is Dwell Clicking ?

debasisdas 580 Posting Genius Featured Poster

Welcome aboard.

debasisdas 580 Posting Genius Featured Poster

Modify what ?

debasisdas 580 Posting Genius Featured Poster

Take these following 2 items from you data as example

123--Phone power on but vibrate is too weak P300-3110-VX8575
124--place a test call. P300-1710-DROID

Line 1-----length----60---length of Item Number-----16-----starting position of Item Number--45
Line 2-----length----39---length of Item Number-----15-----starting position of Item Number--25

So, the data is inconsistent.

It will be difficult to design a generic logic for this kind of inconsistent data.

debasisdas 580 Posting Genius Featured Poster

no application asks for password to logout.

If you want to maintain a log of all the application login that is good but asking for password to log out is a bad idea.

debasisdas 580 Posting Genius Featured Poster

It is stored as a compiled object inside database.

Since you have the code you can recompile the same with changes and the trigger will be ready.

debasisdas 580 Posting Genius Featured Poster

From where you got this code ?
Why trigger will be stored as a procedure ?

Trigger is not a process. It is stored as an object in the database and is executed / fired when the triggering event occurs in the database.

debasisdas 580 Posting Genius Featured Poster

but i don't see any consistency in the data, neither length nor format.

debasisdas 580 Posting Genius Featured Poster

i did create my trigger and it works.

lets see the code.

debasisdas 580 Posting Genius Featured Poster

uninstall
reboot system
install

and then check

debasisdas 580 Posting Genius Featured Poster

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 ?

debasisdas 580 Posting Genius Featured Poster

do you have the device in place ?

debasisdas 580 Posting Genius Featured Poster

Oracle is an ORDBMS and sql is a programming language to interact with database.

Please read books for details.

debasisdas 580 Posting Genius Featured Poster

You need to read books for all those details.

debasisdas 580 Posting Genius Featured Poster

Hi Charanya,

Welcome to daniweb.

debasisdas 580 Posting Genius Featured Poster

Welcome to Daniweb.

debasisdas 580 Posting Genius Featured Poster

Welcome aboard.

debasisdas 580 Posting Genius Featured Poster

You need to create tables in desired database.
Use ADO to connect VB to database.
Store data from front end application into database.

debasisdas 580 Posting Genius Featured Poster

Please pass more information.

debasisdas 580 Posting Genius Featured Poster

Yes.

debasisdas 580 Posting Genius Featured Poster

don't try to insult me.

You asked for it.

BTW

Whose salary ?
How salary is determined ?
What are the components of salary ?
Where is the details stored ?

debasisdas 580 Posting Genius Featured Poster

try this.

j = Convert.ToInt32(txtstaff_id.text.ToString())

also change

select staff_id from staff

to

select max(staff_id) from staff