Click here to Skip to main content
16,021,757 members
Home / Discussions / Database
   

Database

 
GeneralRe: Get check time from separate fields in Microsoft SQL Server Pin
Richard Deeming14-Oct-15 2:47
mveRichard Deeming14-Oct-15 2:47 
GeneralRe: Get check time from separate fields in Microsoft SQL Server Pin
Chris Quinn14-Oct-15 2:50
Chris Quinn14-Oct-15 2:50 
QuestionInsert within Select Statement Pin
indian14313-Oct-15 7:50
indian14313-Oct-15 7:50 
AnswerRe: Insert within Select Statement Pin
Richard Deeming13-Oct-15 8:43
mveRichard Deeming13-Oct-15 8:43 
GeneralRe: Insert within Select Statement Pin
indian14313-Oct-15 8:58
indian14313-Oct-15 8:58 
GeneralRe: Insert within Select Statement Pin
indian14313-Oct-15 10:28
indian14313-Oct-15 10:28 
AnswerRe: Insert within Select Statement Pin
Mycroft Holmes13-Oct-15 22:55
professionalMycroft Holmes13-Oct-15 22:55 
QuestionSort GetChildRow datarow array Pin
BobW99912-Oct-15 2:58
BobW99912-Oct-15 2:58 
I just discovered what is a big problem with the order that child rows are retrieved from datatables created from a SQLCe database.

Definition

'Front Inner Camber Link
            Dim arrFrInnerCamb() As RCCarV2DataSet.FrInnerCambRow
            Dim FrInnerCambRow As DataRow


The child rows are retrieved and stored in an array of DataRows.

'Get the array of alternate Inner Camber Positions
                arrFrInnerCamb = FrSuspRow.GetChildRows("FrSuspension_FrInnerCamb")


The problem is the order the values are stored in the Sql database are not always stored in the order of the primary key as I expect. This problem only occurs after deleting rows from the database.

To correct this problem I would like to just sort the arrFrInnerCamb by the primary key and all will be good. Unfortunately can't figure out a simple way to do this. I can use a brute force and ignorance method but figure there must be an easier way. Any suggestions would be appreciated.
AnswerRe: Sort GetChildRow datarow array Pin
Mycroft Holmes12-Oct-15 13:07
professionalMycroft Holmes12-Oct-15 13:07 
GeneralRe: Sort GetChildRow datarow array Pin
BobW99912-Oct-15 17:34
BobW99912-Oct-15 17:34 
GeneralRe: Sort GetChildRow datarow array Pin
Mycroft Holmes12-Oct-15 17:40
professionalMycroft Holmes12-Oct-15 17:40 
SuggestionNeed to Optimize this Query Pin
Member 1205173711-Oct-15 23:33
Member 1205173711-Oct-15 23:33 
QuestionTimeline for Work Completion Pin
macca249-Oct-15 0:48
macca249-Oct-15 0:48 
AnswerRe: Timeline for Work Completion Pin
CHill609-Oct-15 2:12
mveCHill609-Oct-15 2:12 
QuestionMSSQL behavior: I need to round instead of truncation when number scale is exceeded Pin
px058-Oct-15 21:32
px058-Oct-15 21:32 
AnswerRe: MSSQL behavior: I need to round instead of truncation when number scale is exceeded Pin
GuyThiebaut8-Oct-15 23:04
professionalGuyThiebaut8-Oct-15 23:04 
GeneralRe: MSSQL behavior: I need to round instead of truncation when number scale is exceeded Pin
px058-Oct-15 23:26
px058-Oct-15 23:26 
AnswerRe: MSSQL behavior: I need to round instead of truncation when number scale is exceeded Pin
Eddy Vluggen9-Oct-15 1:39
professionalEddy Vluggen9-Oct-15 1:39 
AnswerRe: MSSQL behavior: I need to round instead of truncation when number scale is exceeded Pin
Wombaticus10-Oct-15 8:00
Wombaticus10-Oct-15 8:00 
QuestionSql Server Back-end with Access or Asp.net Front-end Pin
macca247-Oct-15 23:23
macca247-Oct-15 23:23 
AnswerRe: Sql Server Back-end with Access or Asp.net Front-end Pin
CHill608-Oct-15 14:29
mveCHill608-Oct-15 14:29 
AnswerRe: Sql Server Back-end with Access or Asp.net Front-end Pin
Daniel Miller19-Oct-15 14:18
professionalDaniel Miller19-Oct-15 14:18 
Questiondatagrid code Pin
Maristello7-Oct-15 3:47
Maristello7-Oct-15 3:47 
AnswerRe: datagrid code Pin
CHill608-Oct-15 14:25
mveCHill608-Oct-15 14:25 
QuestionSQL server query Pin
Swap96-Oct-15 4:04
Swap96-Oct-15 4:04 

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.