Posts by debasisdas

I mean you need to set up separate databases.

It should not be like table 1 ..9 for one database and table 10..18 for another client.

It can also be achieved by storing all the client data into a single set of tables by maintaining some sort of flag, but that will involve high risk factor for data security.

Just imagine what happens when report of one client containing all the sensitive data goes to another client (may be a potential competitor) by mistake.

Better maintain separate database (not separate tables) for each client for data security.

From the daniweb welcoming community

Who is that ? :?:

690

692

Then try this .

You can try this sample for reference.

Ignore the part of the code that is not required for you.

create a control array of the check boxes with different caption.

In a loop check if the check box is checked if yes capture the caption property and add to list view.

You need to look into the availability column.

But that column shows status of the car or the driver ?

What does the check boxes contain ?

Are you getting values from database or are static values only.

You need to update after adding each set of values otherwise only the last bunch of values will over write all other previous values.

Sorry, we do not do your assignment / home work.

In others words rental can be created on once customer, movie and game tables are in existence.

694

Have you tried anything yet ?

Kindly post the code that you are working on for any help on the topic from experts.

Go through the following for further reference.

link1
link2 and link3.

What exactly you are trying to achieve, please elaborate.

702

It would be better if you re-phrase your question.

Please post one question only per thread.

706

Lets see your query and how you call the same from VB.

The following links may be useful to you.

Link1
Link2

708

You need to practice more than going for a certification. Certification will definitely add weight your profile but for that you good working knowledge also.

710

714

Sorry to say, but you have to solve your own assignment.

706

Hi Kraai.

Not sure exactly what is your confusion.

All arithmetic operations works on database tables while used as part of a SQL.

706

was traveling.

I consider you are asking about OUT parameter.

Please go through this sample code.

That code is written for Oracle, but VB part remains same.

Yeah, it is on the way.

CASE executes faster.

DECODE works with expressions which are scalar values.

CASE can work with predicates and subqueries in searchable form:

CASE handles NULL values differently

710

632

Congratulations team India.

The true champions.

548

550

550

538

514

518

That ER looks impressive.

May need some minor modification.

Seems you have to specify values when using RANGE. If one uses HASH then you don't need to specify values.

Exactly, that is how partition works.

Things becomes more challenging once you decide to you composite partition.
i.e.-- different types of partition logic on a single table.

518

522

please try working on this model

TYRE
------------
T_ID
T_TYPE
T_BATCH_NUM
T_MANUFACTURER
T_LOT_NUM
T_DESCRIPTION
T_POSITION
…
…
VEHICLE
--------
V_ID
V_DESC
V_TYPE
T_ID1
T_ID2
T_ID3
T_ID4
…
…

526

530

534

538