Recent content by DekaFlash

  1. D

    Question Catching the request failed with an empty response

    Hi Is there anyway to catch or display the request failed with an empty response message somewhere other then in a message box, for a example in a text box? Thanks
  2. D

    Question Remotely accessing db - winforms app

    The connection string is currently, is this the correct way to go about it. Dim connstring As String = "Data Source=BM-PC;Initial Catalog=EMS;Integrated Security = True;TrustedConnection=YES;User Id=u;Password=p; Thanks
  3. D

    Question Remotely accessing db - winforms app

    I have a vb.net application, which I want to access a sql server 2005 from a remote workstation. When I run the application I get the following exception System.Data.SqlClient.SqlException: Login failed for user 'BM-PC\Guest'. at...
  4. D

    Question Class Inheritance

    I have the following class definition Public Class Car Public ReadOnly MaxSpeed As Integer Private CurrSpeed As Integer Public Sub New() End Sub Public Sub New(ByVal max As Integer) MaxSpeed = 55 End Sub Public Property Speed() As Integer Get...
  5. D

    Question Sql Select from group by

    Bolds and Arrows is another part of the criteria - each selection must have at least 1 bold and 1 arrow hence the > 1 but as this is easier to implement I've only just mentioned it. I'll look at adding race = @race as you suggested, at the moment however from the main screen they select if they...
  6. D

    Question Sql Select from group by

    Both SELECT * FROM VsrData WHERE (B IN (SELECT MAX(B) FROM VsrData)) AND (FDB IN (SELECT MIN(FDB) FROM VsrData)) and bolds > 1 and arrows > 1 and SELECT * FROM VsrData WHERE (B IN (SELECT MAX(B) FROM VsrData)) AND (FDB IN (SELECT MIN(FDB) FROM VsrData)) and bolds > 1 and arrows > 1 ORDER BY...
  7. D

    Question Sql Select from group by

    Yes that is the expected behaviour, as a result the number of times the selection criteria is met for the daily analysis can vary and on some occasions there may not even be any selections. The reason I highlighted that table was because your previous code identified a wrong selection. At the...
  8. D

    Question Sql Select from group by

    They are both equally important, unless a row has highest b and lowest fdb it does not qualify as a selection.
  9. D

    Question Sql Select from group by

    I believe the last query example you provided me with was SELECT TOP(3) * FROM VsrData ORDER BY (B - FDB) DESC I modified your code as follows - Dim sql As String = "SELECT * FROM VsrData where bolds > 1 and arrows > 1 ORDER BY (b-fdb) desc, Jockey DESC, TRAINER desc" When I run that as a...
  10. D

    Question Sql Select from group by

    Actually its B the highest and FDB the lowest, so the first example (5-2) would indicate a selection and the others would be disregarded. B - FDB 5 - 2 4 - 3 3 - 4 2 - 5 The majority of the time we will always produce the 3 best, the only exception is on the rare occasion where there are only...
  11. D

    Question Sql Select from group by

    The screen captures I provided are from a daily racing analysis we provided, we have two sets of criteria used to identify different types of bets. We only bet if the criteria highlights selections on the first or second row of each group of 3. One of the common factors for all selections is...
  12. D

    Question Sql Select from group by

    Hi Stonkie, I was just wondering if you had a chance to look at my last post please? Thanks
  13. D

    Question Sql Select from group by

    I am looking at criteria which will help me identify the two examples as illustrated in the screen capture below. There are two types of selection criteria but both requre highest B and lowest fdb values.
  14. D

    Question Sql Select from group by

    Is it possible to AND the b desc and fdb asc statements, so it gives me highest b and lowest fdb.
  15. D

    Question Sql Select from group by

    Thanks I'll give it a try and let you know the outcome :)
Top Bottom