Posts by debasisdas - Page 81

I am not very sure what is the cause of the error.

That version of VB is gone from my system long long back

I would say YES to answer 1st part of your question(you can create a module of write a DLL for the purpose.).

But i am not sure what exactly you are trying to do (as per 2nd part of your question).

You can get more assistance from the forum if you post the problem / requirement in details.

If both the controls are using database as source then why you need to populate data from one control to another ?

This is how you store and retrieve image in Database.

The code is for SQL server.

You need to make some changes to do the same in Ms Access.

482

486

1. Add a check constraint with numbers only as value.
2. For the values refer to another column in some look up table.
3. In that table store the actual meaning of the numbers
i.e.-- 1="pending" 2="watched" etc..

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

suprise --> Surprise

:)

490

Yeah things have changed,, and stop wasting my time to read your trash replies.
Instead of making critics, you can just try to help a university student!
And you the worst moderator i have ever seen, i am going to find a better forum !

That sort of behavior is uncalled for.

If this is your attitude towards those who volunteer to help you, you are most welcome to find a better place.

The entities are too tightly coupled , it will be a real pain if any changes are required to implement in future.

(length of the string including space ) - (lenth of the string after LTRIM) = number of spaces in the start of the string.

Len("Visual Basic") - Len(ltrim("Visual Basic"))

If you understand what a cipher text is and how to encrypt and decrypt data that should be quiet easy task for you.

1. Collect data
2. Encrypt (using algorithm )
3. Store in DB
4. Retrieve.
5. Decrypt using reverse algorithm.
6. Use the record.

As a rule of thumb for deleting record form tables based on referential integrity .

Step 1. Delete record from child table.
Step 2. Delete record from parent table.

How enterprise edition of any version of any application can be free to use ?

It must be either trial or limited period editions .

Why these button are there on my own post ?

Flag Bad Post
Post Reply

How useful are these for me ?

Point #4 is not as that easy as you think (managing inventory).

Kindly post what ever you have so far and lets discuss on the same.

That depends on how much you can afford to spend on your server and database. Any standard database will that for you.

I really do not understand what is the table is callable from other procedure.

what exactly you mean by binary format ?

At first look this design seems to be too critical.

Some tables can be merged.

Needs dedicated time to provide a solution.

You need to update the database using SQL.

Try to frame queries as per your requirement and execute them in proper event.

Don't expect someone to supply you the complete code.

Life: It is about the gift not the package it comes in.

I suggest you store status_id in both jobs and application tables but without any rigid relationship.

Typically the look up table values are stored in 3 separate tables ,interdependent and independent from others.

for ex
1. CODELIST_NAME---what value it refers to (ex--country)
2. CODELIST_CODE---what are the possible code for the codelist (101,102,103,.... )
3. CODELIST_DECODE-decode vales for the actual codes (101--india,102--germany,103--usa ...and so on)

If implemented in your scenario, jobs and application tables will store the actual codes not the decode values.

I suggest the supplier part needs to be handled separately as that can't be managed in a single table.

not for sure.

496

Sorry , my mistake.

Actually i wanted to say LOOK UP table.

That is a table to which other tables refer for data but with out any right relationship.

Better to keep that table as a standalone table.

Have you tried handling the error using ON ERROR and then tired to find out what is the error number or message is ?

You need to hit google with proper keywords.

What you are asking for (index choice and every other database optimization related aspect ) comes with experience only and there is no rule of thumb for that. That varies from db to db based on use, data size , hardware implemented and somany other factors.

If that is a look table then there should not be any PK -- FK relationship between that table and other tables using values of that table.

Hi Machete,

Welcome to the forum.

If you know how to copy and paste with little intelligence, your future is bright so bright. :)

500

:)

Do you know how to write SQL ?

That will be the easiest solution for your problem.

I really do not understand the link between student_apps and posted_jobs via status_messages.

You need to merge the fields of profile with user.

Profile_id should be added to profile table.

1.try using ascii value of the character.
2.increment the number part till max value
3.increment the ascii value by 1(one) and repeat step-2

In the login table stare a flag value, which specifies if the ligin use is a normal user or an admin.

Based on that flag value you can enable / disable other dependent forms.

glitter --> dazzle

Many, really there are many.

But what you want to know ?

Hi Don,

Welcome and you have a nice time here at Daniweb.

Sorry i do not design databases for free, that is my bread and butter.

Wishing you luck in finding someone who can do the job for free.

You can simply try this logic.

select count(*) from useraccounts where username = val1 and password= val2.

if the above query returns 1 (as count). login should be successful and allow the user to proceed further else re-prompt for correct username and password(and repeat the same logic).

For the above logic to work the username column should be an unique column in the DB table.

You need to keep on thing in mind , don't be too rigid on core database design. There should be enough room for addition of new features and new functionality at a later stage. Since you are going for a e-commerce application changes are bound to come.

"When you can't laugh on the same joke again & again then why do you keep crying over the same thing over & over again" forget the past and MOVE ON.

Better start designing from scratch and keep adding new stuff as your requirements keep on changing.

Is that a paid job ?

Waiting for your response.

Is that a paid job ?

Waiting for your response.

Life is a whim of several billion cells to be you for a while.