ASP Hosting sale!
Double disk space and transfer for FREE!
Limited time offer! Act Now!
aspdev | articles | tutorials | forums

 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Row Differentiation

 
Post new topic   Reply to topic    ASPdev.org Forum Index -> SQL Programming (MS SQL Server, MS Access, MySQL)
View previous topic :: View next topic  
Author Message
trams



Joined: 08 Feb 2006
Posts: 2
PostPosted: Wed Feb 08, 2006 3:53 am    Post subject: Row Differentiation Reply with quote
I have a list of tables in my database. every table doesn't have the primery key how do i differetiate between row?...
It is not possible to modify database by adding autonumber field or primery key field.
my question is:
How do i differentiate between records using query ?....
_________________
all the best
Back to top
View user's profile Send private message Send e-mail AIM Address Yahoo Messenger
administrator
Site Admin


Joined: 01 Oct 2004
Posts: 183
PostPosted: Wed Feb 08, 2006 9:13 am    Post subject: Reply with quote
Why can't you add unique primary key field? What is your database?
_________________
Peter
ASP & ASP.NET Articles and Tutorials
Back to top
View user's profile Send private message
trams



Joined: 08 Feb 2006
Posts: 2
PostPosted: Thu Feb 09, 2006 4:00 am    Post subject: Row Differentiation Reply with quote
I can not change the table design that's the main issue or ican't add field in table. b' coz i don't have the info. about tables that is genrated dynamically.I don't know the field name.

Plz. tell me somefeature in MSAccess tha uniquely defines the row other than primery key.....
_________________
all the best
Back to top
View user's profile Send private message Send e-mail AIM Address Yahoo Messenger
administrator
Site Admin


Joined: 01 Oct 2004
Posts: 183
PostPosted: Thu Feb 09, 2006 10:00 am    Post subject: Re: Row Differentiation Reply with quote
trams wrote:
I can not change the table design that's the main issue or ican't add field in table. b' coz i don't have the info. about tables that is genrated dynamically.I don't know the field name.

Plz. tell me somefeature in MSAccess tha uniquely defines the row other than primery key.....


You need a primary key, or database table field that is unique, or a combination of database table fields that is unique for each row. Otherwise the rows simply won't be unique.
_________________
Peter
ASP & ASP.NET Articles and Tutorials
Back to top
View user's profile Send private message
Missie



Joined: 06 Feb 2006
Posts: 25
PostPosted: Thu Feb 09, 2006 8:06 pm    Post subject: Reply with quote
I think that this is really cool that you guys just give out cool codes. You know what you should do is make a kinda walk though for newbies like me. Smile And then you could like zip it and people could down load it. Smile It's just a suggestion. Smile
Back to top
View user's profile Send private message
administrator
Site Admin


Joined: 01 Oct 2004
Posts: 183
PostPosted: Thu Feb 09, 2006 9:02 pm    Post subject: Reply with quote
There are several tutorials on this site ... Smile
_________________
Peter
ASP & ASP.NET Articles and Tutorials
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    ASPdev.org Forum Index -> SQL Programming (MS SQL Server, MS Access, MySQL) All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2002 phpBB Group

SQL Tutorial