Geez... I thought there were no null values inside the DB, but there were... That was causing the problem. Guess I could have avoided this problem by paying more attention to the values in the DB. =/
Problem solved. Thanks!
Yaridovich
Last Activity: Aug 24 '12, 09:04 PM
Joined: Aug 14 '12
Location:
-
Problem converting DB variable to double in C#
Hello everyone,
I'm having some trouble with a variable from a database. That variable in that database is of type double.
To read from the database, I'm using a variable dr of type OleDbDataReader .
So far, I've been using dr["variablena me"].ToString() to work with the variables from this database - without the ToString part it wasn't working.
However, with this specific variable... -
That worked, thank you once more!Leave a comment:
-
Access: query to remove rows with repeated values in a column?
Hello everyone,
I'm trying to come up with a query that removes rows where a certain column has the same value (for instance, the column's value is the same in rows #503, #677 and #1020).
There are two catches:
- I can't specify the value (or values) to be checked for repetition, the query has to check for any repeated value;
- I can't also specify the number of repetitions, the minimum is 2 but there's no maximum.... -
That didn't work, but it helped me find the correct syntax - I just need to add parenthesis to the first join. Like this:
Thanks for the help!Code:SELECT * INTO TableResult FROM (Table1 INNER JOIN Table2 ON Table1.A = Table2.A) INNER JOIN Table3 ON Table1.A = Table3.A
Leave a comment:
-
I tried that, but I just remembered I tried that while using alias. I'm gonna try it again, this time I'll do it like that. I'll then get back here to tell you if it worked. Thanks!Leave a comment:
-
Could you help me write the correct query? I've tried multiple things, but none are working, there's always some syntax error.
I've tried these:
Code:SELECT * INTO TableResult FROM ( SELECT * FROM Table1 AS T1 INNER JOIN Table2 AS T2 ON T1.A = T2.A INNER JOIN Table3 AS T3 ON T1.A = T3.A )
...Code:SELECT * INTO TableResult FROM ( SELECT *
Leave a comment:
-
It's just that, in the work I do, I don't use SQL queries much, it's basically just simple stuff. Now I'm needing to do some more complex stuff. And it seems that creating a table from an inner join isn't that simple.
I'm trying to do this, but it's not working. I've tried moving the closing parenthesis to the end, but it doesn't work either.
...Code:SELECT * INTO TableResult FROM ( SELECT * FROM
Leave a comment:
-
@Rabbit - But how can I save the resulting table into a new table? Is there any way of combining "Create Table" and "Join"?Leave a comment:
-
@Rabbit - Can you give me an example as how to do it using Join? Also, I forgot to add something to the original post. I just edited it and added this: "There's one catch: I want the code to get the names of the other columns, apart from column A."Leave a comment:
-
Combining multiple Access tables using C#
Hello everyone,
I'm having a bit of trouble with something. What I'm trying to do is create a new Access table by combining other already existing Tables.
For instance, let's consider Table1 (with columns A, B and C), Table2 (with columns A, D and E) and Table3 (with columns A, F and G), where Table1.A = Table2.A = Table3.A. From these, I want to create a new table TableResult, with columns A, B, C, D, E, F and G, with all the...
No activity results to display
Leave a comment: