Still looking to put together macro for sum of skips!

[Snides]

Ok Mirage, it's all ready.. or at least all ready to the point where you can use it. now i just need to create a new database with just the data that you need so it's a bit smaller and spit out the .exe file. So basically, i'll create a new database file with just the 6/49, on/49 and lottario draw information, and make the 3 exe files (one for each draw, in the future i'll change the program so that there is only one exe file and you'll be able to select which draw when you run it).

I am feeling better (sometimes..) I had quite a headache and gut ache today.. not sure what caused that.. I havn't been back to the ENT guy, i don't go again till after the CT scan, but i do still have an appointment with a different ENT booked for nov 3rd.

I may not get the program uploaded for you tonight, i think i'm gunna head to bed now. pretty sure i'll have it up tomorrow though, and i'll post a link to it in here then. I'm hoping you're familiar with zip files, as that is how i'll post it..

 

[mirage]

Ok Mirage, it's all ready.. or at least all ready to the point where you can use it. now i just need to create a new database with just the data that you need so it's a bit smaller and spit out the .exe file. So basically, i'll create a new database file with just the 6/49, on/49 and lottario draw information, and make the 3 exe files (one for each draw, in the future i'll change the program so that there is only one exe file and you'll be able to select which draw when you run it).

I am feeling better (sometimes..) I had quite a headache and gut ache today.. not sure what caused that.. I havn't been back to the ENT guy, i don't go again till after the CT scan, but i do still have an appointment with a different ENT booked for nov 3rd.

I may not get the program uploaded for you tonight, i think i'm gunna head to bed now. pretty sure i'll have it up tomorrow though, and i'll post a link to it in here then. I'm hoping you're familiar with zip files, as that is how i'll post it..

OK, not wanting to get too excited here. Can't wait to see what it looks like. I usually download directly to save to disk but a zip file shouldn't be a problem. At a loss for words. When is your CT scan? Hoping on your behalf for you to feel well all the time with loads of energy.

 

[mirage]

Snides,
I'm putting this comment here as I don't know if you would be bothered to go back to the Provincial Piks thread.
Hint! Hint! (Don't know how you - or the rest - will take this but), imho, it is not a good idea to post all your lotto piks, luck wise.
I noticed you posted a lot (60?) last night before the draw.
I also noticed that you posted a whole bunch - I forget when - a month or few ago? of Ont. 6/49 once before.
I thought to myself at the time, Snides! What are you doing?
You are laying yourself open and vulnerable...
It is not a good idea for you and not a good idea for the rest of us. Post some of your most inspired piks here and keep the rest secret. Don't ask me to explain why I'm telling you this just trust me on this one.

 

[tomtom]

Whoa, this thread is almost thrilling like a suspense movie. Wonder what will happen next…

 

[mirage]

Whoa, this thread is almost thrilling like a suspense movie. Wonder what will happen next…

tomtom,

Yeah.... Okie Dokie then....!

 

[Snides]

Why should I keep my on/49 picks secret? we're here to help each other aren't we? ON/49 has preset prize amounts, so no matter how many people win in the prize categories other than the top prize of 1 million, the prize amount is always the same.. and if I actually did post the jackpot prize and 20 people won it, that's still 50 grand which is enough to buy me a new car, and it would probably make the news.. "20 people won ON/49 jackpot last night, thanks to Snides for posting the winning numbers!" Wouldn't that be a fun headline to read in the paper?

Or maybe you're thinking that the OLGC is reading this site and deliberatly calling a miss-draw if my posted numbers come up, and they're drawing new numbers so that I lose?

Now 6/49, I could see you point (I guess..) cus the more winners there are the lower the prize amounts would be.. instead of winning $79.90 for four numbers, I might only get $79.70.. That would make me go insane...

 

[Snides]

hmmm.. I'm trying to create a package for you to install Mirage, but It's not liking me at the moment.. I've installed and removed it from my laptop about 15 times and continue to have errors where it can't find the database.. Must be some stupid little error somewhere, but these beers are making my brain swim... Hopefully I figure it out before the next beer, and then I'll have it posted for you tonight

 

[peter]

Why should I keep my on/49 picks secret? we're here to help each other aren't we? ON/49 has preset prize amounts, so no matter how many people win in the prize categories other than the top prize of 1 million, the prize amount is always the same.. and if I actually did post the jackpot prize and 20 people won it, that's still 50 grand which is enough to buy me a new car, and it would probably make the news.. "20 people won ON/49 jackpot last night, thanks to Snides for posting the winning numbers!" Wouldn't that be a fun headline to read in the paper?

Or maybe you're thinking that the OLGC is reading this site and deliberatly calling a miss-draw if my posted numbers come up, and they're drawing new numbers so that I lose?

Now 6/49, I could see you point (I guess..) cus the more winners there are the lower the prize amounts would be.. instead of winning $79.90 for four numbers, I might only get $79.70.. That would make me go insane...

You have the right attitude Snides, and I like that attitude That folks is about as unselfish as it gets.

 

[mirage]

(Originally posted by Snides)

Why should I keep my on/49 picks secret? we're here to help each other aren't we? ON/49 has preset prize amounts, so no matter how many people win in the prize categories other than the top prize of 1 million, the prize amount is always the same.. and if I actually did post the jackpot prize and 20 people won it, that's still 50 grand which is enough to buy me a new car, and it would probably make the news.. "20 people won ON/49 jackpot last night, thanks to Snides for posting the winning numbers!" Wouldn't that be a fun headline to read in the paper?

Or maybe you're thinking that the OLGC is reading this site and deliberatly calling a miss-draw if my posted numbers come up, and they're drawing new numbers so that I lose?

Now 6/49, I could see you point (I guess..) cus the more winners there are the lower the prize amounts would be.. instead of winning $79.90 for four numbers, I might only get $79.70.. That would make me go insane...
--------------------------------------------------------------------------------

You have the right attitude Snides, and I like that attitude That folks is about as unselfish as it gets.

Snides and Peter: OK, well forget it then. I had my reasons. What you do is your choice. And you have your own personal motivations.

This lottery forum is a bit of a paradox in that it is both "selfish" and "unselfish" in its intentions and goals - strange combination.
I was "unselfishly" trying to offer a suggestion - head you off at the pass, so to speak. But if you are OK about what you are doing then it's OK by me.

It's not just about the money.

It's more than likely that OLGC is aware of this site and some people at OLGC are reading it, but hey, who cares? We trust that the OLGC folks are doing the draws ethically all the time.

I'm pretty sure that the OLGC is quite aware that persons are always looking for ways to crack the lottery. I agree that "20 people won the lottery last night" as news headline in the paper would be funny alright, but the lottery corp would not be laughing. If people are winning more often than they - the OLGC - want people to win, then the lottery corp will just raise the bar higher. No problem.

But to my knowledge a jackpot lottery win on this board has yet to be achieved so it's a non-issue.

 

[mirage]

--------------------------------------------------------------------------------
(Originally posted by tomtom)
Whoa, this thread is almost thrilling like a suspense movie. Wonder what will happen next…
--------------------------------------------------------------------------------

You know what tomtom? Nothing much will happen next. It will be like a story without a finish, an anti-climax. It will just go on... and on... and on... and in the end become very boring.

 

[tomtom]

--------------------------------------------------------------------------------
(Originally posted by tomtom)
Whoa, this thread is almost thrilling like a suspense movie. Wonder what will happen next…
--------------------------------------------------------------------------------

You know what tomtom? Nothing much will happen next. It will be like a story without a finish, an anti-climax. It will just go on... and on... and on... and in the end become very boring.

Who knows…. maybe Snides will recognize that it is waste of time to read from an EXE file, since it is very extraordinary to avoid a simple usage of a TXT file here. That is because only one line –open "c: file.txt" for input as #1- is necessary, and it is valid for any .txt database named file.

 

[mirage]

Who knows…. maybe Snides will recognize that it is waste of time to read from an EXE file, since it is very extraordinary to avoid a simple usage of a TXT file here. That is because only one line –open "c: file.txt" for input as #1- is necessary, and it is valid for any .txt database named file.

tomtom,

I don't know enough about programming to say anything meaningful. I just sometimes feel like this is dragging on so long that there is some kinda glitch goin' on somewhere. But I don't want to speculate. Perhaps Snides will respond to your comment.

 

[Snides]

i'm not reading from an exe file, i'm reading from a mdb file. I'm not a big fan of txt files for data storage, I'd choose an ascii or binary file over txt anyday, would save a pile of disc space too, but that's not an issue these days with huge hard drives available.. I use mdb files because I use them more often than I use toilet paper (ok, that may be a bad analogy..)

There also is no glitch going on anywhere. I'm used to programming for myself, I usually leave everything in project form and rarely create exe's for any of my 'finished' programs. I put finished in quotes, because i rarely call something finished, I always find new things to add to them, and am always experimenting. I have only distributed 3 programs to the public in the past, one to a dude in south africa, and two that a few members of this board know about/use.

This is the first time I'm trying to make a distributable program that yer average non-computer geek can get running. I'm trying to add all the run-times dll's, references, and databases that are needed into one distributable package that doesn't require any tweaking by the end user...

I'm sorry that it is taking so long, but it's not like any deadlines or contracts were agreed to prior to commencing this project. I do have other things that need to be done, and my health hasn't helped out much. Comments criticizing the program, length of time since inception, and methods used certainly don't increase my speed of production either, in fact they may hinder it and make me wonder if it's users will truly appreciate it when it is finished..

This project was started for Mirage, so I'll ask her...

Mirage, can you wait a few days for a easy to install and maintain version of this program, or would you like to tweak 2 files into a specific location on your hard drive and possibly download a few missing files from microsoft that you might need, or do you think that this whole mess is a glitch that will never work and you want me to scrap the whole project?

 

[gsobier]

Mirage:

This sort of thing of waiting so long, having problems at the beginning, getting fixes is 100% normal. The most difficult task a programmer faces is making the customer happy. I'm sure Snides will do everything he can to have it working. Don't forget, the price you have paid can't be any better when its free (I have the impression its no charge here).

When I send out something for the first time, count on the first few days as hell day trying to meet the sometimes overwhelming demands.

For you guys who know, what is the difference in performance from an I/O rate point of view comparing txt to mdb?

Regards,
George

tomtom,

I don't know enough about programming to say anything meaningful. I just sometimes feel like this is dragging on so long that there is some kinda glitch goin' on somewhere. But I don't want to speculate. Perhaps Snides will respond to your comment.

 

[gsobier]

Snides:

I know many programmers with the same problem... ...not me, I don't drink any kind of alcoholic beverage and I HATE beer.

Regards
George

hmmm.. I'm trying to create a package for you to install Mirage, but It's not liking me at the moment.. I've installed and removed it from my laptop about 15 times and continue to have errors where it can't find the database.. Must be some stupid little error somewhere, but these beers are making my brain swim... Hopefully I figure it out before the next beer, and then I'll have it posted for you tonight

 

[tomtom]

For you guys who know, what is the difference in performance from an I/O rate point of view comparing txt to mdb?

Regards,
George

I am not an Access user but believe that for mdb files you have to work in original version. That means if the program was made in Access ‘97 you can only open it with Access ‘97. You might try to convert it, but usually it doesn’t work. Well, that is from my experience….

 

[gsobier]

TomTom:

Yuk, I don't think this would work out for me 'cause its a Microsoft program... ...I try to AVOID as much as I can from those morons. I have my reasons for this attitude from a strickly professional point of view.

Regards,
George

I am not an Access user but believe that for mdb files you have to work in original version. That means if the program was made in Access ‘97 you can only open it with Access ‘97. You might try to convert it, but usually it doesn’t work. Well, that is from my experience….

 

[gsobier]

Peter:

I'd never send you programs because its a big hassle unless you are up to the task. You must be proficient in Windows and then some to be able to keep up and work with me at my pace. Someone else you know (a red wine drinker) gets that burdon and punishment. She screams and yells at times... ...lots of fun (if you know what I mean).

Regards,
George

You have the right attitude Snides, and I like that attitude That folks is about as unselfish as it gets.

 

[tomtom]

TomTom:

Yuk, I don't think this would work out for me 'cause its a Microsoft program... ...I try to AVOID as much as I can from those morons. I have my reasons for this attitude from a strickly professional point of view.

Regards,
George

Well, I like those guys pretty much. If they didn’t make windows and all the other stuff after that, people at this forum would communicate by a …telegraph?

 

[Snides]

if an access 97 database is set up properly you can easily convert it to access 2000, I've done it many times. If you don't convert it, you can still use it, you just can't change anything, it becomes read-only. This is a access 2000 mdb file that i'm using, with a vb6 frontend. The exe file can open it no matter if you have access installed on the machine or not, it uses the jet engine. This is also why i want to create an install package, Mirage mentioned she doesn't have access installed, so she may need several dll files to make jet work.

George, I don't know the difference in the rate of I/O between txt and mdb, but i do know that the main database I created at work is over 40 meg, and I certainly wouldn't want to write code to constantly change the data that it holds if it were a txt file! mdb files follow a stricter format, you set each field for the type of data that it will hold, and therefore it provides it's own form of error-trapping. Yes a txt file would be easy for an end user to update, but there's no formatting done by notepad to decrease errors, and having information entered wrong could cause the program to freeze, crash, or produce unexpected results..

I'll figure out this stupid 'path not found' error soon, and if i don't i'll drink some beer and modify the program to make the user find the right path