Click here to Skip to main content
15,887,356 members
Home / Discussions / C#
   

C#

 
GeneralRe: Parse XML Sibling Pin
antrock1019-Apr-15 9:22
antrock1019-Apr-15 9:22 
GeneralRe: Parse XML Sibling Pin
Richard Deeming9-Apr-15 10:02
mveRichard Deeming9-Apr-15 10:02 
AnswerRe: Parse XML Sibling Pin
surya tri13-Apr-15 2:21
surya tri13-Apr-15 2:21 
Questiongenerate a sequence of number prefixed with a character Pin
Jimmy-IN8-Apr-15 23:17
Jimmy-IN8-Apr-15 23:17 
AnswerRe: generate a sequence of number prefixed with a character Pin
Freak308-Apr-15 23:26
Freak308-Apr-15 23:26 
AnswerRe: generate a sequence of number prefixed with a character Pin
Pete O'Hanlon8-Apr-15 23:29
mvePete O'Hanlon8-Apr-15 23:29 
GeneralRe: generate a sequence of number prefixed with a character Pin
Jimmy-IN8-Apr-15 23:35
Jimmy-IN8-Apr-15 23:35 
GeneralRe: generate a sequence of number prefixed with a character Pin
Eddy Vluggen9-Apr-15 0:23
professionalEddy Vluggen9-Apr-15 0:23 
No, you don't need to store it in exact the same way you present it. It is compound data, and consists of a prefix and an (unformatted) number.

To save "a00001", you'd use a identity-field to generate the number. Saving redundant zeros isn't going to help much, and you'd loose the ability to use the real number. You can combine both facts in a view, adding the prefix to the number and adding some formatting. That way the number would always be in the format you desire when someone fetches it from the database, while also having the advantage to be able to use the number as a real field to select on.

Otherwise there's a big chance that you'll need a "part" of that compound number in a query, and be forced to "substring" the field. That'd be a major cause for slow queries.
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]

AnswerRe: generate a sequence of number prefixed with a character Pin
V.9-Apr-15 2:08
professionalV.9-Apr-15 2:08 
QuestionGet listbox text to show in richtextbox + custom text Pin
Googooli868-Apr-15 22:52
Googooli868-Apr-15 22:52 
Answer[REPOST] Pin
Sascha Lefèvre8-Apr-15 23:35
professionalSascha Lefèvre8-Apr-15 23:35 
QuestionHow do I filter PPID between oPsType.PPIDFrom and oPsType.PPIDTo, and pay_type in oPsType.PAY_TYPE Pin
Member 115045458-Apr-15 9:42
Member 115045458-Apr-15 9:42 
AnswerRe: How do I filter PPID between oPsType.PPIDFrom and oPsType.PPIDTo, and pay_type in oPsType.PAY_TYPE Pin
Mycroft Holmes8-Apr-15 14:19
professionalMycroft Holmes8-Apr-15 14:19 
QuestionToday's Async Question #2 Pin
Kevin Marois8-Apr-15 8:35
professionalKevin Marois8-Apr-15 8:35 
QuestionAnother Async Question Pin
Kevin Marois8-Apr-15 8:18
professionalKevin Marois8-Apr-15 8:18 
AnswerRe: Another Async Question PinPopular
Richard Deeming8-Apr-15 8:27
mveRichard Deeming8-Apr-15 8:27 
GeneralRe: Another Async Question Pin
Kevin Marois8-Apr-15 8:30
professionalKevin Marois8-Apr-15 8:30 
GeneralRe: Another Async Question Pin
Mycroft Holmes8-Apr-15 14:22
professionalMycroft Holmes8-Apr-15 14:22 
Question{0} Pin
Member 115906308-Apr-15 3:04
Member 115906308-Apr-15 3:04 
AnswerRe: {0} Pin
harold aptroot8-Apr-15 3:35
harold aptroot8-Apr-15 3:35 
AnswerRe: {0} Pin
Sascha Lefèvre8-Apr-15 3:49
professionalSascha Lefèvre8-Apr-15 3:49 
Questionconverting given hex value into rgb Pin
Member 115353748-Apr-15 1:25
Member 115353748-Apr-15 1:25 
GeneralRe: converting given hex value into rgb Pin
harold aptroot8-Apr-15 1:44
harold aptroot8-Apr-15 1:44 
AnswerRe: converting given hex value into rgb Pin
OriginalGriff8-Apr-15 4:38
mveOriginalGriff8-Apr-15 4:38 
JokeRe: converting given hex value into rgb Pin
Richard Deeming8-Apr-15 8:04
mveRichard Deeming8-Apr-15 8: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.