debasisdas

You need to use Max(value) + 1 logic. Increment the max of current number by 1 and proceed.

you can start with the following basic tables. [code] 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); [/code] You need to link LOA and LEAVE to EMP on EMP_ID .

I think you are looking for scheduled jobs. [URL="http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_job.htm"]DBMS_JOB[/URL] and [URL="http://psoug.org/reference/dbms_job.html"]DBMS_JOB[/URL] [URL="http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_sched.htm"]DBMS_SCHEDULER[/URL] or [URL="http://psoug.org/reference/dbms_scheduler.html"]DBMS_SCHEDULER[/URL]

Welcome to Daniweb.

Hi Mattox, Welcome to Daniweb.

Welcome aboard Tim.

Hi Neil, Welcome to Daniweb.

What is the project ? What is the code that you are working on ? Yo need to show effort to get help from our experts.

This topic has already been discussed here in the forum several times . You need to use the search box on top right side of the page for related discussions.

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.

You are talking in minutes and hrs ! There are section which do not receive any new post in days sometimes for weeks.

Get more information [URL="http://www.bkent.net/Doc/simple5.htm"]here[/URL].

If you need help then why shall i send queries ?

Technically 2nd one.

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 …

Hi Vardonir, Welcome aboard.

Hi , Welcome to the forum.

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

Welcome to the forum. You will be a great asset for the [URL="http://www.daniweb.com/forums/forum4.html"]VB6[/URL] 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 ().

All the details that you need is [URL="http://www.google.co.in/search?hl=&q=file+system+object+in+vb6&sourceid=navclient-ff&rlz=1B3GGLL_enIN395IN395&ie=UTF-8&aq=0&oq=fi"]here[/URL].

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

Mainly you need to work on co-ordinates. for curves and all need to work with some of the trigonometric functions.

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.

Else you can use the [URL="http://msdn.microsoft.com/en-us/library/ms186862%28v=sql.90%29.aspx"]REPLACE[/URL] function for the purpose.

[code]select sum(HoursWorked) from DTR where EmpID = empid and date between date1 and date2[/code] NOTE :-- avoid using [B]Date[/B] as a column name in DB table, that is a reserved key word so you may face with unexpected results.

You code is not for the version VB6. You need to use [URL="http://www.google.co.in/search?hl=&q=file+system+object+in+vb&sourceid=navclient-ff&rlz=1B3GGLL_enIN395IN395&ie=UTF-8&aq=2&oq=file+system+object+#sclient=psy&hl=en&rlz=1B3GGLL_enIN395IN395&source=hp&q=file+system+object+in+vb6&aq=f&aqi=&aql=&oq=&pbx=1&fp=991118fabfc2c1bb"]FileSystemObject[/URL] to achieve the same in VB 6.

Why you always keep asking for code ? Show some effort .

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 (*).

Welcome commando, but why 1200 :-/

Hi Gulraiz, Welcome to the forum.

Hi and welcome Sandesh.

Welcome , Everybody say welcome....

Hi Laura, Just be here and keep your eyes and ears open. You will find a lot of ideas floating around here.

I think your case is hardware dependent. You need to check the server and the LAN. Also check how much overloaded is your LAN because of other services.

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.

Try this sample SQL. [code]select * from (select * from aer order by aer_id desc) where rownum <= (select count(*)/4 from aer)[/code]

[URL="http://www.google.co.in/search?hl=&q=visual+basic+6.0+black+book&sourceid=navclient-ff&rlz=1B3GGLL_enIN395IN395&ie=UTF-8&aq=3&oq=vis"]This[/URL] may help you. Also try to find [URL="http://books.google.com/"]here[/URL].

Welcome to the forum. We are also pleased to have you here.

You want the entire projects to be delivered to you nicely packed or are you also interested in lending a helping hand ?

You need to replace ' (single quote) with ''(two single quotes) Use the function [B]replace[/B] or just play with CHR(39).

Please go through [URL="http://codingsense.wordpress.com/2008/12/31/mssql-output-in-xml-using-for-xml/"]this[/URL] and [URL="http://articles.sitepoint.com/article/data-as-xml-sql-server/3"]this[/URL].

I would suggest not to store the videos in the Database. Instead just store the file name with proper path and store the actual file in the file system . In the database you need to store other attributes (comments etc...) . After that implements a keyword based search is …

Try the following if you are trying to create a table by VB 6 code. [code] Private Function CreateTable() As Boolean Dim catDatabase As ADOX.Catalog Dim oTable As ADOX.Table Dim bCreateTable As Boolean ' ------------------------------- On Error GoTo PROC_ERR bCreateTable = False Set catDatabase = New ADOX.Catalog With catDatabase .ActiveConnection …

I really do not understand why are you setting the values back and forth from and to the same control. Why not use variables with wider scope.

Can you post a sample postal addresses (just to understand your question better).

Please tell us more. What is that control (grid) ? What is the database ? How it is connected ? How are you populating the grid ?

Try this..... [code] Dim conn As New ADODB.Connection Dim rec As New ADODB.Recordset Private Sub cmd_delete_Click() Dim rResult rResult = MsgBox("Do you want to delete the record", vbYesNo) If rResult = vbYes Then conn.Execute "Delete * from Employee where EmployeeID =" & DataGrid1.Columns(0).Value Set DataGrid1.DataSource = Nothing Set rec = …

There can't be any object (in oracle database) without any name.