Posts by debasisdas

this time it is sub-continental wicket.

be prepared to see some big heads rolling.

604

hope not affected by tsunami :)

Welcome Ricky.

604

Try this.

SELECT CAST((STR( YEAR( @date ) ) + '-' +STR( MONTH( @date ) ) + '-' +STR( DAY(@date ) )
) AS DATE_AS_I_WANT

or this

SELECT CONVERT(varchar, @date,112)

If you want to install only the client, then read this.

Oracle Database 10g Express Client

Then you need to go to here.

604

the projet doesnt seem to exist yet on the web

then it must be the eighth wonder on the planet.

May i know please what exactly is your idea ?

What does your player do ?

I am not sure if you understand how a blog and a forum threads are treated.

In a thread
1. there could be multiple reply
2. a thread can be marked as solved.
3. it can be made a sticky .
4. one answer is marked as best answer.
5. a thread my receive some up or down vote.
6. there may be some infraction points.

A blog may or may not have any of the above on it.

Still you want to store the both in a single table , you need to maintain a lot of flags.

That is because you are opening the recordset everytime.

You need to open the recordset only once (in the form load).

Please find all that here.

Download what ever is your requirement.

Follow the manual for installation instructions.

Windows 7 is 64 bit platform.

What you plan to store in Nurse_In_Charge, because you already have a Nurse_ID column.

I would suggest make that a flag (store 0 or 1) depending up on if the particular person can be In charge or not.

Bangladesh wins yet another match.

Hold on your predictions at least for next couple of days.

Hi Sajid,

Welcome to Daniweb.

Hi Lorenzo,

Welcome to Daniweb.

Hi Conor,

Welcome to Daniweb.

you simply need to use ASCII function and call the same in

KEY_PRESS or KEY_DOWN event

Show some effort before asking for code.

Remove Nurse_In_Charge from WARD and maintain a separate table for day to day activty of the ward.

There you can maintain ward ward_id, nurse_id, date_of_activity etc.

Blog and forum entries must and should be stored in separate tables.

You need to download from here.

this file

Oracle Database 10g Client Release 2 (10.2.0.4)
10204_vista_w2k8_x64_production_client.zip (507,934,134 bytes)

Search in the net , you will get a lot of stuff.

What do you mean by How should i install ?

Are you facing any issue, during installation.

Start reading and thinking you will get a lot of ideas.

Most of the knock out berths are booked now.

596

The weekend is over now.

Only England could have lost from here.

Congratulations team A. :)

896

886

886

severe earth quack and tsunami in japan.

884

just had lunch

884

850

You need to mention the relation between the tables.

1. SMS is not sent from e-mail

2. Before asking for code you need to show effort and post the code that you are working on.

3. Does you project included any database operation ? If yes -- which DB ? How you connect VB to DB ?

848

You need to mention which block of the code is causing the problem.

Then you need to try to debug the part of the code that is causing the crash.

Comment the blocks of the code and check one by one.

Along with a button on a form you need to have a database in place and connect to that Db from vb before you could do any database related activity.

848

848

8 4 8

848

848

846

You need to use Db Link for the purpose.

838