Search results

  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 :)
  16. D

    Question Sql Select from group by

    Hi Stonkie - I was wondering if you had a chance to read my last post. Thanks
  17. D

    Question Sql Select from group by

    Each group of 3 is the result of a calculation to identify the strongest 3 horses from any race. There is a column which identifies which of the 3 we are dealing with - this is non unique and there is also a column containing a unique id, this is generated in code to prevent duplicate data...
  18. D

    Question Sql Select from group by

    Thanks, the last code example you provided still returns a blank grid. I will try and provide a clearer explanation of what I am trying to achieve. I have an application into which data on horse races is entered, I then click calculate to work out and save the top 3 horses into a seperate...
  19. D

    Sql Queries

    Hi When running such sql queries in vb.net SELECT * FROM VsrData WHERE RaceTitle Like '%{0}%'" and SELECT * FROM VsrData WHERE Venue=@Venue, what is required to perform the inverse query. Thanks
  20. D

    Question Sql Select from group by

    Whilst your code has its uses, there are times I have to work with subsets of the data. How would I get it to do a similar thing with a subset of data (this is data that is filtered). Thanks
Top Bottom