|
Looking at an MS Access database which has been (incorrectly) converted to an SQL Database.
Me no like.
MVVM # - I did it My Way
___________________________________________
Man, you're a god. - walterhevedeich 26/05/2011
.\\axxx
(That's an 'M')
|
|
|
|
|
what sort of issues are there ?
'g'
|
|
|
|
|
See my reply to Damo below
MVVM # - I did it My Way
___________________________________________
Man, you're a god. - walterhevedeich 26/05/2011
.\\axxx
(That's an 'M')
|
|
|
|
|
What was incorrect about the conversion?
|
|
|
|
|
The databases are entirely different - so it's not a case of simply migrating - so there is some logic concerning things like changing address formats, de-duplication of customer data etc.
Interestingly, the issue I am looking into at the moment is where an empty column in the Access table is appearing in the C# code (from a simple OleDbCommand Select * via a datareader) as a null-prefixed rubbish string (i.e. "\0someotherspuriousdata") which is then being used to update the SQL database.
I say 'interestingly' because I can see no faulty logic - immediately after the ExecuteReader, the OleDbDataReader.GetString("fieldName") method returns the corrupt string.
So I now need to find out if that string actually exists in the Access Db but is hidden by the Access Gui, or is there something wrong with the OleDb functionality.
MVVM # - I did it My Way
___________________________________________
Man, you're a god. - walterhevedeich 26/05/2011
.\\axxx
(That's an 'M')
|
|
|
|
|
|
Well, open the Access DB directly and have a look!! 
|
|
|
|
|
When you look at the field in Access it appears blank.
It appears identical to the same column in another row that is really blank (not null).
But when read into the C# proggy, one contgains string.empty, the other contains "\0somerubbish"
I had to fix it by checking every field as read in for a leading ascii null!
MVVM # - I did it My Way
___________________________________________
Man, you're a god. - walterhevedeich 26/05/2011
.\\axxx
(That's an 'M')
|
|
|
|
|
Ugly... good that you got a fix though!!
|
|
|
|
|
You may feel better - but me converting a AS/400 database created 25 years ago, where the original info with the developers are gone!
So I'm running the application and try to find out what every data is. And to add to this tables and columns are named by numbers so I have tbl201.c18!!!
That what I call happy coding!!! 
I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)
|
|
|
|
|
Hopefully that app is not written in RPG[^] (shudder).
(Edited, for some reason the link got cropped - maybe related to the URL ending with the same characters as the selected text) (that was a hint to the hamsters).
"If you don't fail at least 90 percent of the time, you're not aiming high enough."
Alan Kay.
|
|
|
|
|
Oh, RPG wasn't all that bad.
no, wait.,
Yes it was!
MVVM # - I did it My Way
___________________________________________
Man, you're a god. - walterhevedeich 26/05/2011
.\\axxx
(That's an 'M')
|
|
|
|
|
I'm glad you finished that as you did. I was beginning to make a metal note never to trust anything you said, ever, about programming.
RPG - a high-level language with all the idiosyncrasies of a very primitive assembler. Back in the day, I had to port from software from RPG to C, and it was painful just reading the dang thing.
I dread to think what it was like to actually write!
"If you don't fail at least 90 percent of the time, you're not aiming high enough."
Alan Kay.
|
|
|
|
|
In all seriousness, it wasn't as bad as perhaps you think - once a level of familiarity is reached.
Of course, a 6 character naming limit can be a put off - but I think in the more recent versions that's been removed.
I actually learned it 'on the fly' after being employed as an RPG developer contractor with literally no RPG development experience (long story)
Once understood, and work-arounds and standards developed, I used it for 3 or 4 years quite happily.
I then moved to Delphi ...
MVVM # - I did it My Way
___________________________________________
Man, you're a god. - walterhevedeich 26/05/2011
.\\axxx
(That's an 'M')
|
|
|
|
|
MS Access? You should have felt dirty in advance. 
Veni, vidi, vici.
|
|
|
|
|
Was digging around on my beaglebone black and learning about device trees and came across the BBB-BONE-BACON-00A0.dts and the inquisitive guy that I am I opened it and found that there was a bacon cape[^]. Well you can imagine my excitement so I googled and found the cape and dash it all it's not near what I expected.
|
|
|
|
|
Nothing worse than being a little idsapointed...
|
|
|
|
|
Except, perhaps, being a little ipssed off?
MVVM # - I did it My Way
___________________________________________
Man, you're a god. - walterhevedeich 26/05/2011
.\\axxx
(That's an 'M')
|
|
|
|
|
Did you know that, when dealing with angles in software, it doesn't matter whether a system uses degrees or radians, so long as the angle is zero 
Spent ages last night trying to figure out why there was so much 'jerkiness' in my iPhone game - turns out one subsystem is using degrees, the other radians.
So when I tried to set something to 45 degrees in the radians system it didn't quite do what I was expecting!
I have started to rename all my variables with a Deg or Rad suffix just to be sure!
MVVM # - I did it My Way
___________________________________________
Man, you're a god. - walterhevedeich 26/05/2011
.\\axxx
(That's an 'M')
|
|
|
|
|
_Maxxx_ wrote: I have started to rename all my variables with a Deg or Rad suffix just to be sure!
Yeah, that'll teach 'em.
This space intentionally left blank.
|
|
|
|
|
lol - back to bending bananas for you - its safer
'g'
|
|
|
|
|
Ouch! A little harsh!
I blame it one whoever decided to use degrees in their sprite engine, personally. I am, as ever, blameless.
Now, how many degrees to bend this 'nana?
MVVM # - I did it My Way
___________________________________________
Man, you're a god. - walterhevedeich 26/05/2011
.\\axxx
(That's an 'M')
|
|
|
|
|
yeah, I was just stirring - Im pretty sure you wernt born 'there' aka 'north of the border', so yes, a bit harsh 
'g'
ps.. and '15' degrees
|
|
|
|
|
| 42
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
|
|
|
|
|
0 is a value common across all dimensions!
For example 0 bananas + 0 Win8 * 0 kg = 0 litres!
Amazing!!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
