Click here to Skip to main content
15,916,293 members
Home / Discussions / Database
   

Database

 
GeneralMdb question Pin
jzb27-Aug-04 23:40
jzb27-Aug-04 23:40 
GeneralRe: Mdb question Pin
Colin Angus Mackay28-Aug-04 2:08
Colin Angus Mackay28-Aug-04 2:08 
Questionado.net connections and .dispose? Pin
Roger Alsing27-Aug-04 1:39
Roger Alsing27-Aug-04 1:39 
AnswerRe: ado.net connections and .dispose? Pin
Colin Angus Mackay28-Aug-04 2:12
Colin Angus Mackay28-Aug-04 2:12 
GeneralRe: ado.net connections and .dispose? Pin
Roger Alsing29-Aug-04 20:25
Roger Alsing29-Aug-04 20:25 
GeneralRe: ado.net connections and .dispose? Pin
Colin Angus Mackay30-Aug-04 1:27
Colin Angus Mackay30-Aug-04 1:27 
AnswerRe: ado.net connections and .dispose? Pin
Rocky Moore31-Aug-04 20:01
Rocky Moore31-Aug-04 20:01 
GeneralIdentity primary key Pin
Diego F.26-Aug-04 23:18
Diego F.26-Aug-04 23:18 
Hi. I have a table with a primary key that I'd like to be an identity, so I don't worry about giving it a value manually (just increases automatically. 1, 2, 3, ...)

The problem is that I have another table where these key is a foreign key, so in my application, I must fill the value manually to the second table, but then I need to get the value in the first table.

I mean, imagine I have a table with: (id, name, age), where 'id' is the primary key and is identity, with values 1,2,...

Then I have another table with: (id, phone), where 'id' is the foreign key.

In my application, I can fill entries in the first table without giving values to id, as it is done automatically, but in the second table, I must give manually the values. How can I do that?

Should I make a query to get the 'id'?


Regards,

Diego F.
GeneralRe: Identity primary key Pin
David Salter26-Aug-04 23:28
David Salter26-Aug-04 23:28 
GeneralRe: Identity primary key Pin
Diego F.26-Aug-04 23:50
Diego F.26-Aug-04 23:50 
GeneralRe: Identity primary key Pin
David Salter27-Aug-04 1:12
David Salter27-Aug-04 1:12 
GeneralRe: Identity primary key Pin
Colin Angus Mackay27-Aug-04 1:33
Colin Angus Mackay27-Aug-04 1:33 
GeneralSQL and the growing log file Pin
totig25-Aug-04 20:02
totig25-Aug-04 20:02 
GeneralRe: SQL and the growing log file Pin
mikasa26-Aug-04 3:40
mikasa26-Aug-04 3:40 
GeneralRe: SQL and the growing log file Pin
Mekong River26-Aug-04 3:41
Mekong River26-Aug-04 3:41 
GeneralRe: SQL and the growing log file Pin
totig26-Aug-04 3:47
totig26-Aug-04 3:47 
GeneralRe: SQL and the growing log file Pin
Rocky Moore31-Aug-04 20:18
Rocky Moore31-Aug-04 20:18 
GeneralNested Transaction between ADO.NET and T-SQL Pin
Sanjeev Kumar25-Aug-04 14:29
Sanjeev Kumar25-Aug-04 14:29 
GeneralRe: Nested Transaction between ADO.NET and T-SQL Pin
S Sansanwal25-Aug-04 16:33
S Sansanwal25-Aug-04 16:33 
GeneralRe: Nested Transaction between ADO.NET and T-SQL Pin
Sanjeev Kumar25-Aug-04 16:46
Sanjeev Kumar25-Aug-04 16:46 
GeneralRe: Nested Transaction between ADO.NET and T-SQL Pin
Colin Angus Mackay25-Aug-04 22:34
Colin Angus Mackay25-Aug-04 22:34 
GeneralRe: Nested Transaction between ADO.NET and T-SQL Pin
Sanjeev Kumar26-Aug-04 7:07
Sanjeev Kumar26-Aug-04 7:07 
GeneralRe: Nested Transaction between ADO.NET and T-SQL Pin
Colin Angus Mackay26-Aug-04 8:45
Colin Angus Mackay26-Aug-04 8:45 
GeneralRe: Nested Transaction between ADO.NET and T-SQL Pin
Sanjeev Kumar26-Aug-04 13:59
Sanjeev Kumar26-Aug-04 13:59 
GeneralRe: Nested Transaction between ADO.NET and T-SQL Pin
Colin Angus Mackay27-Aug-04 6:07
Colin Angus Mackay27-Aug-04 6:07 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.