Posts by debasisdas

You want to pick the records randomly or is there any order to follow (may be by name or date or something)

That depends on what you want to implement.

Which domain you are comfortable with ?

you can start with the following basic tables.

emp(emp_id,name,mgr,dept_no,doj,oth1,oth2,...,flag1,flag2,....);

loa(l_id,emp_id,approver_id,hr_id,apply_date,approval_date,hr_approval_date,approval_flag,hr_approval_flag);

leave(emp_id,leave_count,leave_type,leave_exp_date);

You need to link LOA and LEAVE to EMP on EMP_ID .

No, not at database level.

Hi Neil,

Welcome to Daniweb.

Get more information here.

If you need help then why shall i send queries ?

I am sorry,

i really do not understand the question.

Welcome aboard Tim.

Hi Mattox,

Welcome to Daniweb.

Welcome to Daniweb.

I think you are looking for scheduled jobs.

DBMS_JOB and DBMS_JOB

DBMS_SCHEDULER or DBMS_SCHEDULER

Hi ,

Welcome to the forum.

Better store the input values in separate variables.
Also check for scope of your variables.

It shows the date of the server, check for timezone as well.

If your tables are linked through PK / FK, you need to delete from clild table record first and move upwards to parent table records and delete.

SQL Server 2000 isn't supported on Vista+ OS's. The install will be blocked by Windows. Migrating MSDE to SQL Express may be the best option.

The simple reason being, windows 7 is a 64 bit os and SQL 2000 is 32 bit software.

Although you can install SQL Server 2000 on Windows 7 with some workarounds, it will not work properly. You can see several errors in both the database server and in Enterprise Manager MMC.
Only SQL Server 2005 SP3 or greater and SQL Server 2008 SP1 or greater are supported in Windows 7 by Microsoft.

Else you can use the REPLACE function for the purpose.

If you are looking for the connection string ,find it here.

Hi Vardonir,

Welcome aboard.

Mainly you need to work on co-ordinates.

for curves and all need to work with some of the trigonometric functions.

I think the way you are trying to implement is wrong.
The In and Out time entries should be independent of each other(not in the same row).

This is my personal opinion.

select sum(HoursWorked) from DTR where EmpID = empid 
and date between date1 and date2

NOTE :-- avoid using Date as a column name in DB table, that is a reserved key word so you may face with unexpected results.

Technically 2nd one.

You need to use Max(value) + 1 logic.

Increment the max of current number by 1 and proceed.

You should enjoy the work you do or do the work that you enjoy.

Welcome to Daniweb.

Welcome to the forum.

You will be a great asset for the VB6 forum.

You need to play with CAPTION property of the control for the purpose.

It can be simply reset by taking all the controls in a loop.

You can set the same property through code as well.

Place the code somewhere in Form_Load ().

What is the project ?

What is the code that you are working on ?

Yo need to show effort to get help from our experts.

All the details that you need is here.

That is required only if you are using SQL * Plus. serveroutput is a environment variable. It must be switched ON to use the screen buffer and display the output on screen.

1. Check if you have index on the column that is being used in the where clause.
2. Select only the desired column in place of all the columns (*).

May be your connection string is stored with wrong credentials.

Find more on connection strings.

454

Ohh...

You even didn't start as of yet..

Try to go through the code.
Understand if you can.
Implement the way you want....

Hi Laura,

Just be here and keep your eyes and ears open.

You will find a lot of ideas floating around here.

Welcome commando,

but why 1200 :-/

Welcome ,

Everybody say welcome....

Hi and welcome Sandesh.

Hi Gulraiz,

Welcome to the forum.

No, thanks. Been there, done that.

We don't do your work for you. We help you with problems you are having with work that YOU have done.

You need to upgrade the hardware, that would be better option than changing the DB.

No duplicate thread please.

Smileys are actually not images. They are special key stroke combination that is interpreted in a special manner to display a tiny graphics. The same key combination can be interpreted in a different manner by different application.

so you need to check how you application reads those special combinations.

Try this sample SQL.

select * from (select * from aer order by aer_id desc)
where rownum <= (select count(*)/4 from aer)

You code is not for the version VB6.

You need to use FileSystemObject to achieve the same in VB 6.