Click here to Skip to main content
15,867,568 members
Home / Discussions / Database
   

Database

 
GeneralRe: Ado.net ODBC problem connecting to Progress database Pin
tanya foster10-Jul-06 3:50
tanya foster10-Jul-06 3:50 
QuestionError In Attach Database Pin
md_refay7-Jul-06 7:33
md_refay7-Jul-06 7:33 
AnswerRe: Error In Attach Database Pin
Colin Angus Mackay7-Jul-06 9:41
Colin Angus Mackay7-Jul-06 9:41 
GeneralRe: Error In Attach Database Pin
md_refay8-Jul-06 1:34
md_refay8-Jul-06 1:34 
GeneralRe: Error In Attach Database Pin
Colin Angus Mackay8-Jul-06 1:51
Colin Angus Mackay8-Jul-06 1:51 
QuestionAdd a new IDENTITY [modified] Pin
TheEagle7-Jul-06 7:07
TheEagle7-Jul-06 7:07 
AnswerRe: Add a new IDENTITY Pin
Elina Blank7-Jul-06 8:11
sitebuilderElina Blank7-Jul-06 8:11 
GeneralRe: Add a new IDENTITY Pin
TheEagle7-Jul-06 9:29
TheEagle7-Jul-06 9:29 
That is exactly what I needed but in the following code:

--The Identity column name: FieldNO
SET IDENTITY_INSERT [ProjectField] ON
INSERT INTO ProjectField_Locale (FieldNO,CultureID,FieldName,FieldDescription)
VALUES (@@Identity,dbo.GetCultureID(@CultureName),@FieldName,@FieldDescription)


The ProjectField_Locale has another ID column (FieldCultureID) with the same Identity properties(I didnt write its name in the INSERT INTO statement because it will be added automatically too) so which Identity value I will get from @@Identity(the one from [ProjectField] table or the new one in ProjectField_Locale table?).

"I am too late but i will never give up"
GeneralRe: Add a new IDENTITY Pin
Elina Blank7-Jul-06 10:34
sitebuilderElina Blank7-Jul-06 10:34 
GeneralRe: Add a new IDENTITY Pin
TheEagle7-Jul-06 22:37
TheEagle7-Jul-06 22:37 
GeneralRe: Add a new IDENTITY Pin
Elina Blank10-Jul-06 4:04
sitebuilderElina Blank10-Jul-06 4:04 
GeneralRe: Add a new IDENTITY Pin
TheEagle11-Jul-06 1:36
TheEagle11-Jul-06 1:36 
GeneralRe: Add a new IDENTITY Pin
Elina Blank11-Jul-06 2:32
sitebuilderElina Blank11-Jul-06 2:32 
QuestionORDER BY question Pin
leckey7-Jul-06 6:51
leckey7-Jul-06 6:51 
AnswerRe: ORDER BY question Pin
Jerry Hammond8-Jul-06 4:54
Jerry Hammond8-Jul-06 4:54 
GeneralRe: ORDER BY question Pin
Paul Conrad8-Jul-06 19:54
professionalPaul Conrad8-Jul-06 19:54 
GeneralRe: ORDER BY question Pin
Jerry Hammond9-Jul-06 3:22
Jerry Hammond9-Jul-06 3:22 
GeneralRe: ORDER BY question Pin
leckey10-Jul-06 3:17
leckey10-Jul-06 3:17 
GeneralRe: ORDER BY question Pin
Paul Conrad10-Jul-06 6:33
professionalPaul Conrad10-Jul-06 6:33 
Questiondynamic query in SQL Server 2000 Pin
SomeGuyThatIsMe7-Jul-06 4:50
SomeGuyThatIsMe7-Jul-06 4:50 
AnswerRe: dynamic query in SQL Server 2000 Pin
Eric Dahlvang7-Jul-06 5:57
Eric Dahlvang7-Jul-06 5:57 
GeneralRe: dynamic query in SQL Server 2000 Pin
SomeGuyThatIsMe7-Jul-06 6:04
SomeGuyThatIsMe7-Jul-06 6:04 
Questionsound & video Pin
md_refay7-Jul-06 4:09
md_refay7-Jul-06 4:09 
AnswerRe: sound & video Pin
Not Active7-Jul-06 4:17
mentorNot Active7-Jul-06 4:17 
AnswerRe: sound & video Pin
Scott Serl7-Jul-06 6:05
Scott Serl7-Jul-06 6:05 

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.