I'm converting a program from VB6 to VB 2005 and am having problems trying to figure out the connection and updating the database. In VB6 my code looked pretty much like this:
Set objCon = New ADODB.Connection
Set objCom = New ADODB.Command
'Creating the DB connection string...
I've been banging my head against this for the past few days and can't get past it. I'm using VB6 to access an Access DB. All I'm trying to do is compare a tables date field to 2 variables that contain dates. I've tried numerous delimiters and syntax and I either error out or the result...
lameid,
first off thanks for helping out a rookie I truly appreciate it. To answer your question, there might be 2 ways of determining (RaceNumberAgo). This could be done by either EventDate or EventID. Let me give you the important table configuration to better explain.
Table - Events...
I'm new to SQL and need some advice on performing various calculations. If someone could point me down the right path to get information on how to do these things I would appreciate it.
I'm trying to create a Racing Statistical Program. You can see thread "Selecting data with criteria from 3...
Awesome!! That did it. I now have the result set that I'm looking for. One more hurdle has been jumped and it's on to the next one.
I want to thank everyone for their help. This was fun and I have learned a lot from it. For quite some time I've been focusing on creating the database which...
OUCH!!! At first I thought that would work. I made the change and I got the following error: "No value given for one or more required parameters". After looking at the code it seems to me that this would limit the result set to only those records with same TrackID as that of the selected...
LOL!! I got a copy of Beginning SQL by Paul Wilton & John Colby. They have the best explaination of JOINS that I've come across so far. I put the extra "()" and got rid of the syntax error and at least received a result set. However all that is being returned are the results fro the selected...
Leslie
I tried your suggested code and received the following error: "Missing operator in expression" and it displays the following code in the pop-up:
Events E ON E.EventID = R.EventID " & _
" INNER JOIN Track T ON E.TrackID = T.TrackID " & _
" INNER JOIN TrackType T2 ON...
Leslie
Thanks for the SQL article I totally missed that thinking the 2 links were the same. I'll check that out. Thanks for the help. I'll be giving this a try a little late. I can't you enough for the help.
Lelsie/Golom
Golom's code worked great and your advice has helped me to better understand what's going on. I'm Technical. I'll keep your environment running, build, load, & maintain your servers, etc. but programming has always been difficult for me to pick up so please bear with me.
I'm...
Leslie
Thanks for the help. That worked great. Also thanks for the article. Much of that information I had used when I created my DB, but this gave a little better understanding of some areas I was fuzzy in.
To answer your question, there are no NULL values in the Points field however there...
I am new to SQL and need help with some complicated transactions. Using an Access DB and writing the code in VB6, I am creating a Racing Stats Program. The current 2 queries that I am trying to figure out gather driver stats for a selected track or track type. The tables involved and contents...
Thanks for the help, I truly appreciate it. However, I am currently utilizing an Access database. I could create the query in Access, but how would I call it from there?
Thanks again for the help.
I am new to SQL and need help with some complicated transactions. I am creating a Racing Stats Program. The current 2 queries that I am trying to figure out gather driver stats for a selected track or track type. The tables involved and contents are:
Results - DriverID, EventID, Points...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.