Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 10 of 14 total |
Unique indexes |
Tue, May 3 2011 8:35 AM | Permanent Link |
Rita Tipton | I never really bothered with them before except in duplicate
address details. I had reason to from an outside source this week though and I didn't trust a pro gamblers permutation in a 243 line perm. I delimited them in a text file imported the little buggers to a DBISAM Table setup a unique index on them and wow 81 duplicates thats 1/3rd of the 243 lines (records) So I made it known and it turns out this guy has a huge following paying £5 a month for perms. His customers have perms going back years and they will be sending them to me for verifying. My thoughts are he has been keeping the best chances to himself and using the £5 fees to gamble on them. That would be fraud so as soon as them perms are verified cops will get a call as will racing media. Below what 3 from 5 races should look like. Without dupes. 243 lines 5 races 3 in each race "A1","B1","C1","D1","E1" "A1","B1","C1","D1","E2" "A1","B1","C1","D1","E3" "A1","B1","C1","D2","E1" "A1","B1","C1","D2","E2" "A1","B1","C1","D2","E3" "A1","B1","C1","D3","E1" "A1","B1","C1","D3","E2" "A1","B1","C1","D3","E3" "A1","B1","C2","D1","E1" "A1","B1","C2","D1","E2" "A1","B1","C2","D1","E3" "A1","B1","C2","D2","E1" "A1","B1","C2","D2","E2" "A1","B1","C2","D2","E3" "A1","B1","C2","D3","E1" "A1","B1","C2","D3","E2" "A1","B1","C2","D3","E3" "A1","B1","C3","D1","E1" "A1","B1","C3","D1","E2" "A1","B1","C3","D1","E3" "A1","B1","C3","D2","E1" "A1","B1","C3","D2","E2" "A1","B1","C3","D2","E3" "A1","B1","C3","D3","E1" "A1","B1","C3","D3","E2" "A1","B1","C3","D3","E3" "A1","B2","C1","D1","E1" "A1","B2","C1","D1","E2" "A1","B2","C1","D1","E3" "A1","B2","C1","D2","E1" "A1","B2","C1","D2","E2" "A1","B2","C1","D2","E3" "A1","B2","C1","D3","E1" "A1","B2","C1","D3","E2" "A1","B2","C1","D3","E3" "A1","B2","C2","D1","E1" "A1","B2","C2","D1","E2" "A1","B2","C2","D1","E3" "A1","B2","C2","D2","E1" "A1","B2","C2","D2","E2" "A1","B2","C2","D2","E3" "A1","B2","C2","D3","E1" "A1","B2","C2","D3","E2" "A1","B2","C2","D3","E3" "A1","B2","C3","D1","E1" "A1","B2","C3","D1","E2" "A1","B2","C3","D1","E3" "A1","B2","C3","D2","E1" "A1","B2","C3","D2","E2" "A1","B2","C3","D2","E3" "A1","B2","C3","D3","E1" "A1","B2","C3","D3","E2" "A1","B2","C3","D3","E3" "A1","B3","C1","D1","E1" "A1","B3","C1","D1","E2" "A1","B3","C1","D1","E3" "A1","B3","C1","D2","E1" "A1","B3","C1","D2","E2" "A1","B3","C1","D2","E3" "A1","B3","C1","D3","E1" "A1","B3","C1","D3","E2" "A1","B3","C1","D3","E3" "A1","B3","C2","D1","E1" "A1","B3","C2","D1","E2" "A1","B3","C2","D1","E3" "A1","B3","C2","D2","E1" "A1","B3","C2","D2","E2" "A1","B3","C2","D2","E3" "A1","B3","C2","D3","E1" "A1","B3","C2","D3","E2" "A1","B3","C2","D3","E3" "A1","B3","C3","D1","E1" "A1","B3","C3","D1","E2" "A1","B3","C3","D1","E3" "A1","B3","C3","D2","E1" "A1","B3","C3","D2","E2" "A1","B3","C3","D2","E3" "A1","B3","C3","D3","E1" "A1","B3","C3","D3","E2" "A1","B3","C3","D3","E3" "A2","B1","C1","D1","E1" "A2","B1","C1","D1","E2" "A2","B1","C1","D1","E3" "A2","B1","C1","D2","E1" "A2","B1","C1","D2","E2" "A2","B1","C1","D2","E3" "A2","B1","C1","D3","E1" "A2","B1","C1","D3","E2" "A2","B1","C1","D3","E3" "A2","B1","C2","D1","E1" "A2","B1","C2","D1","E2" "A2","B1","C2","D1","E3" "A2","B1","C2","D2","E1" "A2","B1","C2","D2","E2" "A2","B1","C2","D2","E3" "A2","B1","C2","D3","E1" "A2","B1","C2","D3","E2" "A2","B1","C2","D3","E3" "A2","B1","C3","D1","E1" "A2","B1","C3","D1","E2" "A2","B1","C3","D1","E3" "A2","B1","C3","D2","E1" "A2","B1","C3","D2","E2" "A2","B1","C3","D2","E3" "A2","B1","C3","D3","E1" "A2","B1","C3","D3","E2" "A2","B1","C3","D3","E3" "A2","B2","C1","D1","E1" "A2","B2","C1","D1","E2" "A2","B2","C1","D1","E3" "A2","B2","C1","D2","E1" "A2","B2","C1","D2","E2" "A2","B2","C1","D2","E3" "A2","B2","C1","D3","E1" "A2","B2","C1","D3","E2" "A2","B2","C1","D3","E3" "A2","B2","C2","D1","E1" "A2","B2","C2","D1","E2" "A2","B2","C2","D1","E3" "A2","B2","C2","D2","E1" "A2","B2","C2","D2","E2" "A2","B2","C2","D2","E3" "A2","B2","C2","D3","E1" "A2","B2","C2","D3","E2" "A2","B2","C2","D3","E3" "A2","B2","C3","D1","E1" "A2","B2","C3","D1","E2" "A2","B2","C3","D1","E3" "A2","B2","C3","D2","E1" "A2","B2","C3","D2","E2" "A2","B2","C3","D2","E3" "A2","B2","C3","D3","E1" "A2","B2","C3","D3","E2" "A2","B2","C3","D3","E3" "A2","B3","C1","D1","E1" "A2","B3","C1","D1","E2" "A2","B3","C1","D1","E3" "A2","B3","C1","D2","E1" "A2","B3","C1","D2","E2" "A2","B3","C1","D2","E3" "A2","B3","C1","D3","E1" "A2","B3","C1","D3","E2" "A2","B3","C1","D3","E3" "A2","B3","C2","D1","E1" "A2","B3","C2","D1","E2" "A2","B3","C2","D1","E3" "A2","B3","C2","D2","E1" "A2","B3","C2","D2","E2" "A2","B3","C2","D2","E3" "A2","B3","C2","D3","E1" "A2","B3","C2","D3","E2" "A2","B3","C2","D3","E3" "A2","B3","C3","D1","E1" "A2","B3","C3","D1","E2" "A2","B3","C3","D1","E3" "A2","B3","C3","D2","E1" "A2","B3","C3","D2","E2" "A2","B3","C3","D2","E3" "A2","B3","C3","D3","E1" "A2","B3","C3","D3","E2" "A2","B3","C3","D3","E3" "A3","B1","C1","D1","E1" "A3","B1","C1","D1","E2" "A3","B1","C1","D1","E3" "A3","B1","C1","D2","E1" "A3","B1","C1","D2","E2" "A3","B1","C1","D2","E3" "A3","B1","C1","D3","E1" "A3","B1","C1","D3","E2" "A3","B1","C1","D3","E3" "A3","B1","C2","D1","E1" "A3","B1","C2","D1","E2" "A3","B1","C2","D1","E3" "A3","B1","C2","D2","E1" "A3","B1","C2","D2","E2" "A3","B1","C2","D2","E3" "A3","B1","C2","D3","E1" "A3","B1","C2","D3","E2" "A3","B1","C2","D3","E3" "A3","B1","C3","D1","E1" "A3","B1","C3","D1","E2" "A3","B1","C3","D1","E3" "A3","B1","C3","D2","E1" "A3","B1","C3","D2","E2" "A3","B1","C3","D2","E3" "A3","B1","C3","D3","E1" "A3","B1","C3","D3","E2" "A3","B1","C3","D3","E3" "A3","B2","C1","D1","E1" "A3","B2","C1","D1","E2" "A3","B2","C1","D1","E3" "A3","B2","C1","D2","E1" "A3","B2","C1","D2","E2" "A3","B2","C1","D2","E3" "A3","B2","C1","D3","E1" "A3","B2","C1","D3","E2" "A3","B2","C1","D3","E3" "A3","B2","C2","D1","E1" "A3","B2","C2","D1","E2" "A3","B2","C2","D1","E3" "A3","B2","C2","D2","E1" "A3","B2","C2","D2","E2" "A3","B2","C2","D2","E3" "A3","B2","C2","D3","E1" "A3","B2","C2","D3","E2" "A3","B2","C2","D3","E3" "A3","B2","C3","D1","E1" "A3","B2","C3","D1","E2" "A3","B2","C3","D1","E3" "A3","B2","C3","D2","E1" "A3","B2","C3","D2","E2" "A3","B2","C3","D2","E3" "A3","B2","C3","D3","E1" "A3","B2","C3","D3","E2" "A3","B2","C3","D3","E3" "A3","B3","C1","D1","E1" "A3","B3","C1","D1","E2" "A3","B3","C1","D1","E3" "A3","B3","C1","D2","E1" "A3","B3","C1","D2","E2" "A3","B3","C1","D2","E3" "A3","B3","C1","D3","E1" "A3","B3","C1","D3","E2" "A3","B3","C1","D3","E3" "A3","B3","C2","D1","E1" "A3","B3","C2","D1","E2" "A3","B3","C2","D1","E3" "A3","B3","C2","D2","E1" "A3","B3","C2","D2","E2" "A3","B3","C2","D2","E3" "A3","B3","C2","D3","E1" "A3","B3","C2","D3","E2" "A3","B3","C2","D3","E3" "A3","B3","C3","D1","E1" "A3","B3","C3","D1","E2" "A3","B3","C3","D1","E3" "A3","B3","C3","D2","E1" "A3","B3","C3","D2","E2" "A3","B3","C3","D2","E3" "A3","B3","C3","D3","E1" "A3","B3","C3","D3","E2" "A3","B3","C3","D3","E3" |
Wed, May 4 2011 3:51 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Rita,
I don't understand any of that, but then again, I don't gamble. -- Tim Young Elevate Software www.elevatesoft.com |
Thu, May 5 2011 10:10 AM | Permanent Link |
Rita Tipton | "Tim Young [Elevate Software]" wrote in message news:F362CE39-08A2-4BFA-8F5E-EF94DA321D82@news.elevatesoft.com... Rita, I don't understand any of that, but then again, I don't gamble. Ok then I shall not lead you astray but if you lived in the free west like I do you can walk into any licensed betting shop you like if you are 18 or over. Amongst some of the bets you find in there is one called a SuperYank that involves 5 selections it can be anything you like. So in each event you select your 3 most favoured likely to win. Such as below 3 selections in each of 5 event's is a permutation of 243 calculated as 3 * 3 = 9 * 3 = 27 * 3 = 81 * 3 = 243 possible winning combinations. Then the fun starts you need at least 2 to win to get anything back whatsoever. That's known as a double example = A1 + B1 win Then there are trebles example = A1 + B1 + C1 win Then there are fourfolds example = A1 + B1 + C1 + D1 win Then one Fiver timer A1 + B1 + C1 + D1 + E1 Thats a possible 10 Doubles 10 Trebles 5 FourFolds 1 FiveFold Making 26 units if you only picked one in each Event so at 0.10 it will cost £2.60 for each ticket. In my club you have 9 members each writes out 27 betting slips spread from Scotland Yorkshire Ireland Cornwall and Southeast of the UK. Thats 243 possible winning tickets. Each member gets 27 lines from the delimited file in first post and a list of 15 horses mostly with the code next to each name all this goes on with DBIsam as the database complete with a 10 year record of all UK and Irish horse races DBIsam just spews it out you created a beast This week we have had 2 days with 4 horse winning on 4 tickets eachday. That plus doubles trebles has paid very nice its a big race week in Ireland and at Chester England. One horse yesterday was thrown up by the early declarations 2 weeks ago at 16/1 we all had that price one member won £32,000 and was just on racing chan on Sky tv 415 ######################### Ice Hockey NorthEast final Tims Team = A1 Sams Team = A2 Kids Team = A3 ####################### Gold Cup horse final. BigBob = B1 RedRum = B2 SkinnyTim =-B3 ###################### Golf Open Birkdale TigerWoods = C1 FredPerry = C2 JackNics = C3 ##################### American Idol Some Idiot = D1 Some FatGuy = D2 Someones Babe = D3 ################### WW3 USA E1 UK E2 MIDDLE-EAST E3 ################## I HOPE I HAVE ENLIGHTENED YOU TO THE DAY TO DAY USAGE OF YOUR BABY. rITA |
Thu, May 5 2011 10:19 AM | Permanent Link |
Rita Tipton | FORGOT TO MENTION
Go to link click superyankee enter the fraction odds like demo below + stake to see how much you win http://www.ladbrokes.com/betCalculator/betCalc.html Attachments: LADCALC.JPG |
Thu, May 5 2011 10:51 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Rita
Thank you for the explanation. Its nice to see Tim getting a taste of his own medicine. An explanation that make perfect sense to the person that wrote it but leaves a non-techy bemused. BTW if you're winning to much I'm a good charity <vbg> Roy Lambert |
Thu, May 5 2011 11:53 AM | Permanent Link |
Rita Tipton | "Roy Lambert" wrote in message news:8CCFC365-2795-4286-BA36-E18D1F28C139@news.elevatesoft.com... BTW if you're winning to much I'm a good charity <vbg> Maybe yanks think a perm is what the little lady gets in the hairdressers ? Us limey's from the footy pools days know what a perm is. As soon as I can figure out the sql question to perm the lotto in the same way and ask John for the sql code I will do the euro and UK draws in the same members club. Rita |
Fri, May 6 2011 4:38 AM | Permanent Link |
Rita Tipton | "Roy Lambert" wrote in message news:8CCFC365-2795-4286-BA36-E18D1F28C139@news.elevatesoft.com... BTW if you're winning to much I'm a good charity <vbg> Sorry it begins at home. Our very own Eryk Bottomley worked on a DBISAM project for the Hong Kong jockey club. We could all be rich if we knew a backdoor to that. Maybe thats why we dont see him much lately. To busy swigging pimms on that yacht in exotic tropical paradise hideaways. pimms ??? http://en.wikipedia.org/wiki/Pimm's Rita |
Fri, May 6 2011 11:47 AM | Permanent Link |
John Hay | Rita
> > pimms ??? http://en.wikipedia.org/wiki/Pimm's > Mmm Pimms. We have a barbq and pimms party every year at the end of May for my other half's birthday. We have had beautiful sunshine, pouring rain, gazebos taking off like hang gliders through the years but there is nothing like a couple of buckets of Pimms to get the party going!! John |
Fri, May 6 2011 5:26 PM | Permanent Link |
Rita Tipton | "John Hay" wrote in message news:BFD2DCBD-0B3C-48BD-B182-70B69F82836D@news.elevatesoft.com... nothing like a couple of buckets of Pimms to get the party going!! Hi John If I bring my own bucket will you fill it Rita |
Mon, May 9 2011 11:04 AM | Permanent Link |
John Hay | > Hi John > If I bring my own bucket will you fill it > > Rita Sure. And maybeyou can bring me a couple of racing tips so I can improve on my dismal efforts so far for our company betting syndicate <bg> John |
Page 1 of 2 | Next Page » | |
Jump to Page: 1 2 |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |