The app is importing data into an Oracle database (yeah, yeah). The MAX_AGE column is defined as a number. The source of the data are fixed length text files. r("MAX_AGE") is defined in the class as Public MAX_AGE As Int32. But the code is taking the imported data, which came in as a number, copying it to another temporary datatable, in which all fields are strings, then inserted from that data table into the database. Is it a number? Is it a string? Is it a floor wax? Is it a dessert topping? Hard to say...
johnt519
@johnt519
Best posts made by johnt519
Latest posts made by johnt519
-
RE: Uppercase ... what?
-
RE: Official Membership Thread -- Just Reply Here!
I'm in! How about our DBA who says she "doesn't do data" or "doesn't do SQL".. but is "very busy with my own work" all day. Uhh... if your work isn't "data" or "SQL", I'm guessing all that's left is babysitting the database?
-
Uppercase ... what?
I found this bit in an app I have to change/update. This is in code that was written by a "seasoned" developer - who liked to use the latest technology / techniques, even if noone else was (wrote one app in C#, when the rest of the codebase is VB) ('r' is a row of
a datatable, dt2Row is a row from another datatable)...
If Val(r("MAX_AGE").ToString) > 99 Then
dt2Row(4) = "99".ToUpper
Else
dt2Row(4) = r("MAX_AGE").ToString
End If
Words fail me...And just in case you think, "maybe it was just a copy & paste snafu... it was done 5 more times, for other data tables...