Visual Basic

Wendelius3-Feb-09 10:03

Wendelius

3-Feb-09 10:03

Why would you consider using auto-increment keys as a bad practice Confused | :confused:

The need to optimize rises from a bad design.My articles[^]

Tom Deketelaere3-Feb-09 11:01

3-Feb-09 11:01

well as I said in my first post I don't recall the exact problem with it but do remember have some problems with it, and I try to avoid using them as much as I can now.

Wendelius3-Feb-09 11:13

Wendelius

3-Feb-09 11:13

One problem is that if you use auto increment keys only, you may have logically duplicate data. But on the upside, updating the user defined data is a whole lot easier and faster (no cascaded updates etc.).

These are the reasons I always use (at least) double keys on every table and I haven't experienced any problems. However, if you remember the scenario at some point, I would be very happy to hear it Smile | :)

The need to optimize rises from a bad design.My articles[^]

vijay24823-Feb-09 20:46

3-Feb-09 20:46

somebody help me to solve this problem

Tom Deketelaere3-Feb-09 20:57

3-Feb-09 20:57

Dave answered your question.

You'll need to "remember" (store in variable) the username from the first form and then when user entered data one the second you'll have to use a INSERT or UPDATE sql statement (depending on whether or not it is a new user or existing).
If you search the web you'll find thousands of examples.

vijay24823-Feb-09 21:29

3-Feb-09 21:29

I have two tables
first one contains username and password as fields and the second table contains username,date,project and hours field

the user has to logon from the first form with username and password which leads to a second form where date,project nd hours are entered

when the submit button is clicked on this form, username,date,project and hours has to be entered into the second table

from the logon form, username has to be fetched and stored in the second table and from the current form few fields has to be inserted in the same table when submit is clicked

Tom Deketelaere3-Feb-09 21:46

3-Feb-09 21:46

Repeating your question isn't going to change the answer.

Like I said you'll have to store the username in a variable that can be accessed by the second form.
Then in the submit click event you'll have to use a INSERT sql statement to insert the correct data into the second table (provided that the username is present in the first table)

On a side note you might want to take Dave's advice and change your key to a numeric key (auto increment).

Don't expect us to write this for you.
This is very basic and we are happy to help where needed but you need to program it. If you get stuck on a particular part you can then come back here and ask a more specific question, because the way your asking it now is asking us to write your whole program. If you want that go to rentacoder.com.

vijay24823-Feb-09 22:14

3-Feb-09 22:14

i have done my coding part
the datas from my second form is stored well in the table
i have used a variable as u said and have used that variable in my insert query but the data is not been retrieved

anyways thanks for replying and helping

Tom Deketelaere3-Feb-09 22:22

3-Feb-09 22:22

Well that's different then.

Do you get an error? If so post it here.

What do you mean with

vijay2482 wrote:
the data is not been retrieved

Are you trying to retrieve the data from the DB after you inserted it (if so you'll have to do a SELECT after it ).
Or do you mean that your variable is empty?
If so:
Try passing the username to the second form in the constructor of the second form and setting a local variable on the second form.

Accessing a variable on the first form from the second form will only work if that variable is declared as 'shared' or if you have a reference to the first form on your second, but since you probably close the first form there is no such reference.

vijay24823-Feb-09 22:43

3-Feb-09 22:43

i dont get any error msg
im trying to store a value from the first for in the database

Tom Deketelaere3-Feb-09 22:55

3-Feb-09 22:55

vijay2482 wrote:
im trying to store a value from the first for in the database

When? Upon clicking the submit?

If so:
You need to pass the variable to the second form when you open the second form:

dim frm as form2(variable)

Then in the second form:
private sUsername as string
public sub new(variable as string)
initializecomponent
susername = variable
end sub

Now you can use that variable (susername) in the submit button

Without more explanation(and perhaps a bit off your code) I can't give more info than that.

vijay24823-Feb-09 23:34

3-Feb-09 23:34

iam trying it out will get to you back if i find some problem

thanks

vijay24823-Feb-09 23:58

3-Feb-09 23:58

i have sorted out the problem

thanks a lot

modified on Wednesday, February 4, 2009 6:10 AM

Sumit Prakash Sharma3-Feb-09 3:54

Sumit Prakash Sharma

3-Feb-09 3:54

Dear use Update Query inplace of Insert

As i understand if UserName feild is primary key so in whole table we will found only one entry for that userName so use Update Query with WHERE Condition

Update tblName Set f1 = v1 ,f2= v2... WHERE UserName = "UserName"

Full Text Query

Muhammad Fahim Baloch3-Feb-09 1:35

Muhammad Fahim Baloch

3-Feb-09 1:35

Please Tell me about the Full Text Query!
Why and How we use the Full Text Query....
as soon as possible........
Thanx!!!!!!!!!!!!!!!!

Eddy Vluggen3-Feb-09 2:04

Eddy Vluggen

3-Feb-09 2:04

Class starts at 8.30. Make sure you're on time and bring pen and paper to make notes Smile | :)

I are troll Smile | :)

Dave Kreskowiak3-Feb-09 2:04

Dave Kreskowiak

3-Feb-09 2:04

All you had to do to find this out is use any search engine. Here, let me show you[^].

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Tom Deketelaere3-Feb-09 3:53

3-Feb-09 3:53

He can't google he is doing his exam and the teachers blocked it but forgot to block CP Smile | :)