Re: OLAF- Need help please.

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thanks Olaf.

I really appreciate you looking at this and making those adjustments.

The lessons I've learned from practicing with the demo you provided
has been invaluable.

Again, thank you!

Webbiz




On Tue, 12 May 2009 16:03:53 +0200, "Schmidt" <sss@xxxxxxxxx> wrote:


"Webbiz" <nospam@xxxxxxxxxxxxxxxx> schrieb im Newsbeitrag
news:ouoe05dc2vhbeqeevcf14gpab3266g598k@xxxxxxxxxx

I'm still working with your Metastock Demo code.

In my test project, I noticed that when I try to load my own Metastock
data that the the FirstDate field will have some bogus dates (like
03/01/2078) or will show "12:00AM" rather than a date.
Two errors in my "ad-hoc"-implementation - one (the real error)
was, that in the SingleToDate-Function the 7Char-Dates (for the
year 2000) were not correctly parsed.
The other "error" was, that I've thought (since we only have two
Chars, to identify a year), that the "switch-year" would be good
enough with 80 (two-char years before that were converted to
"20" & "78" as in your example above - years above the switch-
year 80 were converted to "19" & "xx" appropriately.
I've now set the switch-year to 50 - hoping that the stock-histories
don't reach that deep.

So when I went to you demo code to see if the same thing happens
there, it bugs out with an error about "trying to create a duplicate
table" via the SQL SELECT. Thing is, I don't know why it would do
this.
That's also fixed now - apparently only the stock-name is not
"unique enough" to act as a table-name - so in my new Demo
the StockName-Field and the StockSymbol are now concated
with a " " to the new TableName - that seems to be sufficient
regarding uniqueness.

So while I can run this demo code with the small data file you
provided with the demo, I was wondering if you'd run my own
Metastock data in your demo to see why the code does not
accept it without crashing.
All done and tested against your zipped data.

Please download the new Demo (including your larger data now
in an Extra-Folder in the Demo-Zip too).
www.datenhaus.de/Downloads/MetaStock-Demo.zip
Also included a small DirList-Control now, so that you
can change the Stock-Folders "on the fly".
But don't expect too much from this little Demo - I only
had a short interest in that topic and don't plan to build
a "full blown Stock-Trader-App" around it ;-).
It is only thought as a small demo, which covers a typical
"import from a file into a DB"-scenario.

BTW, there's also a new version of my toolset available
now (RichClient at 3.0.6, sqlite-engine at the newest 3.6.14)
and also the Toolset-Demo-Package got some additions -
there's a new Spread***-Demo and also (already contained
there for a few weeks now) a "Live-OLAP-Demo" using a
StarSchema (can be found within the NWind-DemoApp).
www.TheCommon.net/3.html

Olaf

.

Quantcast