Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 4 of 4 total |
Multiple Update |
Fri, Jun 6 2008 12:43 AM | Permanent Link |
"John Postnikoff" | I have to change or update a field that may have up to 30 different text
values on a daily basis from an imported file. The the list of new values are always consistant. eg. ABC1 needs to be just shown as 1 not ABC1 ABC2 needs to be just shown as 2 not ABC2 There may be up to thirty variations and need to do this with one click of a button somehow, or should I look at some kind of grid or lookup of some sort on a batch routine. How do you think this could b best handled. |
Fri, Jun 6 2008 3:24 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | John
Something like UPDATE tble SET fld = SUBSTR(fld,4,1) WHERE LENGTH(fld) = 4 Roy Lambert |
Fri, Jun 6 2008 5:00 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
You lost your [Team Elevate] tag. You didn't quit, did you ? -- Tim Young Elevate Software www.elevatesoft.com |
Sun, Jun 8 2008 5:29 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
>You lost your [Team Elevate] tag. You didn't quit, did you ? Nah - the electron eater got it Roy Lambert [Still Team Elevate] |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |