DB/Reporting :: Using Tow Select In Same Statement?
Dec 29, 2008I'm using Vb2005 and Db MS access Is it possible to use tow Select in same sql Statement like this example:
Code:
"Select....Select......."
ADVERTISEMENT
DB/Reporting :: Select Statement To Retrieve Data From .csv File Database?
Jan 29, 2010I am using the following Select Statement to retrive data from my .csv file database:
Code:
Dim comm As New OleDb.OleDbCommand("Select *, Left([Street Full Address], IIF(InStr(12,[Street Full Address],'-')>0, InStr([Street Full Address],'-')-1, Len([Street Full Address]))) as StreetFullAddress From " &
[Code].....
Sql - Perform An Inline Select Statement In A LINQ Statement?
Jun 24, 2011I have the following SQL:
[Code]...
I want to put it (the select count statement) in this LINQ statement so I can get the sales count in my linq statement: Dim TheLeads = (From L In DB.Leads Where L.IsDeleted = False Select L).ToList() Is this possible to do in LINQ?
ElseIf Statement Into A Select Case Statement?
Jun 23, 2010A co-worker wants to convert the following IfThenElseIf statement into a Select Case statement.
Explain why this is not possible.
If temperature = 100 Then
X = 0
ElseIf population > 1000 Then
X = 1
ElseIf rate < .1 Then
X = -1
End If
Database - ID Select ,select Statement?
Mar 23, 2012have a table with following fields
Emp_id varchar(50)
Emp_Name varchar(50)
Emp_surname varchar(50)
[code].....
Use A SELECT Statement To Select All Data?
Apr 2, 2009I need to use a SELECT statement to select all data under a column name (like all employee names) and then to add the values to a listbox.
I usderstand that the select statement must be:
"SELECT * FROM EmployeeTable WHERE EmployeeNames LIKE *" (at least I think)
but then what? combobox1.fill ("EmployeesTable") ?
Database - Compare Two Fields In An SQL SELECT Statement To Then Select Other Fields Based On This Result?
Apr 8, 2012I have a table which contains a list of products for a company. They input data about how much stock they have and also the level at which they want to be reminded that they need to order new stock.
[Code]...
I want to list all the true results in a form which the user is then able to navigate through. What would be the best way to go about doing this?
DB/Reporting :: Get Data From Oracle And Sql In One Sql Statement
Nov 6, 2009I will try and explain my problem as simply as I can
I have an Oracle database (external app) that contains a number of tables that I need to get data from, however I also have an SQL database that contains a number of tables that my app is using.
e.g. Oracle Table name PD_112
Structure:
CODE:
What I want to do is get all the data from the Oracle table to display in a list control however I want the values in the DISP_ID column of the Oracle table to be change to the corrosponding DESC values from the DispTbl e.g. 5 from the Oracle table would display Piping instead of 5.
I know how to do this if both the tables where in one database system e.g. Oracle or SQL, however I am not sure the best why to do this when the tables are in 2 different data sources.
Below is the code for doing this in the same datasource:
Code:
I am using VB.Net 2005, just for info
DB/Reporting :: Get Data From Oracle And Sql In One Sql Statement?
Feb 18, 2011I have an Oracle database (external app) that contains a number of tables that I need to get data from, however I also have an SQL database that contains a number of tables that my app is using.
e.g. Oracle Table name PD_112
Structure:
ID DISP_ID
1 5
2 8
3 5
[code]....
DB/Reporting :: INSERT Statement With WHERE Clause
Jun 12, 2011"INSERT INTO Images (PicName) VALUES (" & TextBox1.Text & ") WHERE ImageID = " & Summary..if i run the statement without the WHERE clause it works fine, with it i get the error ' Missing ; at end of SQL statement'
View 4 RepliesDB/Reporting :: Use SQL Statement In Crystal Report?
Feb 11, 2008i would like to ask if how can i call this SQL statement in my crystal report. im using Crystal Report 10.
Code:SELECT IF(out_balnce < 0, CONCAT(""("", FORMAT(ABS(out_balnce),2) ,"")""), FORMAT(out_balnce,2)) AS OutBalance, IF(acct_side < 1, CONCAT(""("", FORMAT(tran_amnt,2) ,"")""), FORMAT(tran_amnt,2)) AS TransAmount, user_code FROM LedgerHistory WHERE srvc_nmbr = '12345678' ORDER BY srce_date desc how can i place TransAmount and OutBalance in crystal report?
DB/Reporting :: Use SQL Statement To Return Value To Function
May 1, 2012I have 2 functions that need to work together.1 function is to generate a chart number. The other function is to search via SQL to see if the chart number exists. if the chart number doesn't exist then i need function 2 to return a boolean value so function one can generate a new chart number example code: [code] Now i know that i am probably using the incorrect sql statement, my main issue is that i dont know how return available back to the function.
View 1 RepliesDB / Reporting :: Syntax Error In UPDATE Statement.
Oct 5, 2010I try to update my data into Access using VB but I got the following error "Syntax error in UPDATE statement." [code]
View 4 RepliesDB/Reporting :: Error Missing Semicolon ( At End Of SQL Statement
Dec 3, 2008I use the following code to add a record but get the error:"Missing semicolon ( at end of SQL statement. " I removed the semicolon, placed it before the SELECT but it seems to continuously cause problems.
Quote:
Public Sub AddAccountRecord(ByVal name As String, ByVal type As String, ByVal user As String, ByVal balance As String)
Dim strSQL As String
Dim objConnection As New OleDbConnection(strConnection)
Dim objCommand As New OleDbCommand(strSQL, objConnection)
[code]....
DB/Reporting :: INSERT INTO Statement Working But Not Saving?
May 19, 2012I'm running into a slight problem with an SQL INSERT INTO statement. I've tried setting this up first as a command statement and now as a stored procedure. When the process runs it's not signaling any errors and it appears that it's working properly. However when I check the database nothing new has been added. I have the statement within a try catch and it's not catching any errors. I've gone so far as to delete the table and recreate it, still nothing. I should also point out that this entire statement was essentially a copy & paste from another program that's working perfectly.
vb.net code below
Code:
Try
Dim cmd As New SqlCommand
cmd.Connection = con
[code]....
DB/Reporting :: Listing SQL Statement In Crystal Report
Feb 20, 2008How do I list the SQL statement in my crystal report. I have the report loaded etc using
Dim DA As New SqlDataAdapter
Dim DS1 As New DataSet
DA.SelectCommand = New SqlCommand(gSQL, SQLConn)
DA.Fill(DS1, "JobID")
Dim CR1 As New ShowFiles
cr1.Load(gActiveReport)
cr1.SetDataSource(DS1.Tables("JobID"))
CRV1.ReportSource = cr1
This shows my report But how do I reference the SQL Statement, I can see in in report design but cant find it in the loaded report
DB/Reporting :: Syntax Error In UPDATE Statement
Sep 17, 2009I build a command.text that looks like this.
UPDATE a_list Set NOTE = 'This is text in a memo type field.' where index = 2;
I get the error --- Syntax error in UPDATE statement.
The provider is jet and the table is in an ACCESS MDB. I get the same thing on a DBF file.
DB/Reporting :: Error In Inserting - Not Working But Correct Statement
Dec 17, 2008I keep getting the following error when inserting in to my Access DB using VB.
THe code I use is:
Code:
Dim code As String = "INSERT INTO tblUser(Username, Password, Forename, Surname) VALUES('" + txtrEmail.Text.Trim + "','" + "dfd" + "','" + txtrForename.Value.Trim + "','" + txtrSurname.Value.Trim + "');"
[Code].....
I got the sql code to write in a text box and executed i manually in to Access DB and it works perfectly.
DB/Reporting :: VS 2010 Syntax Error In INSERT INTO Statement?
Sep 29, 2011I keep getting this error "Syntax error in INSERT INTO statement." on this line "da.Update(ds, "Llenar")" when i try to update a microsoft access 2003 database with this app.
Code:
1.Imports System.Data
2.Public Class A�adir
3.Dim coneccion As New OleDb.OleDbConnection
[code]....
Select Statement In .NET?
Jul 2, 2010with the following code which gets stucked on the line of reader = Cmd.ExecuteReader(). It says the SqlException was unhandled (An expression of non-boolean type specified in a context where a condition is expected, near '7/2/2010'.)
[Code]...
SQL Select And Where Statement In VB
Jan 8, 2010I have successfuly connected to a database and have create a select statement (with access) which works most of the time except when im trying to perform a where statement with a date:
strEmployeeDepartmentLocation = Application.StartupPath
con.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = " & strEmployeeDepartmentLocation & "swineFlu.mdb"
strSQLSelectQuery2 = "SELECT NumberOfCase FROM table1 WHERE Date = 21/04/2009;"
i dont no if im writing it in the wrong format or what but it dont seem to bring back any data
DB/Reporting :: Sql + And Statement - Selecting Rows On Multiple Column Values
Sep 15, 2010What iam trying to do is selecting rows on multiple column values. But the statement below doesn't preform like i thought it would...
Code:
Select Distinct Variable From TableName Where (ColumnA Like"%AAA%") And (ColumnA Like"%BBB%")
DB/Reporting :: Updates Statement Works In Query Builder But Not When Running
Mar 2, 2008I have developed an ASP page in Visual web developer that retrieves the data usingan AccessDataSource object. I have the following UPDATE Command:
[Code]...
DB/Reporting :: Select Second Highest Value?
Nov 25, 2008I'm having a problem with my Access database.I have to select the highest ActieAantal before the last action ( )because the last action is always the sum (Totaal).this is a part from my table
Persoonid..........ActieAantal..........acties..........Actieid....... ...datum..........aantal..........totaal
.......... 3 ................ 1 ................... aa ................. 99 ........ 31/12/1975
.......... 3 ................ 2 ................... bb 94 ............. 98 ....... 31/12/1975 ........ 94
.......... 3 ................ 3 ................... cc 10 ............... 5 ....... 17/03/1989 ....... 10
.......... 3 ................ 4 ................... dd 20 ............... 2 ....... 25/08/2003 ....... 20
.......... 3 ............. 999 ............. totaal = 124............. 9 . . . . . . . . . . . . . . . . . . . . . . . . . 124
The next person also has some acties with corresponding Actieid and a Total when I use this query I alway get the 999 values
SELECT Register.Persoonid, Max(Register.ActieAantal) AS MaxVanActieAantal
FROM Register
GROUP BY Register.Persoonid
ORDER BY Register.Persoonid, Max(Register.ActieAantal);
but when I try to exclude the 999 value I get nothing
SELECT Register.Persoonid, Max(Register.ActieAantal) AS MaxVanActieAantal
FROM Register
GROUP BY Register.Persoonid
HAVING (((Max(Register.ActieAantal))<>999))
ORDER BY Register.Persoonid, Max(Register.ActieAantal);
find the highest 'ActieAantal' after excluding the 999 values?
DB/Reporting :: Use The Select Statements In VB?
Jun 28, 2011Not sure if this is possible but can you use the select statements in VB to pull in from not just one but multiple tables and put the data in a gridview? [URL]
Code:
Imports System.Data
Imports System.Data.SqlClient
Public Class Form1
[Code].....
DataTable Select Statement?
Apr 9, 2012I have a datatable and I would like to get the MAX number from this table where Term Number (first Column) is a certain value. If my datatable is declared as dtMyTable, I'm assuming I need to use dtMyTable.Select(), but I'm not sure if this is the best way.
View 2 RepliesDisplay Id And Name Via Sql Select Statement?
Dec 29, 2011I have 2 dropdown lists, 1 label & 1 textbox.on selection of 'product categories' @ 1st ddl, 2nd ddl displays all product categories.question is, how may i display the product category id @ the label, and name @ the textbox, on load/selection of 2nd ddl?[code]....
View 3 RepliesSelect Statement By Row Numbers?
Sep 10, 2010If I have a datatable with 5000 rows for example can I do a select statement by row numbers. like paging throught it so I don't have to display all 5000 in the datagrid.. i want to go forward and back by 100 rows
vb.net 2008 (vs 2008)
For example:
dgInbox.DataSource = dsInbox.Tables("Inbox").select(between rows 200 and 300)
Select Statement For Date?
Sep 7, 2011I have a sql statement
SQL = "select * from Candidate where test_date = " & TextBox2.Text
I am getting error in the line myDataAdapter.Fill(myDataSet)
Conversion failed when converting the varchar value '03/15/11' to data type int
In my sql server test_date column data type is varchar.
SELECT Statement For MS Access DB?
May 23, 2012I am tryin to access a 2003 Microsoft Access Database using VB in an OleDb format. The database file name is Billings.mdb and there are 3 tables in the file the one I am trying to access is tbl Clients. When debugging the program I continue to get an Unhandled error point to the FROM part of the SELECT statement. It continues to occur regardless of my attempts to vary the input.
In the program my connection statement is as follows:
Dim connectionString As String = "Provider = Microsoft.Jet.OleDb.4.0; Data Source = C:Documents and SettingsTrialsBillings.mdb"
The Select statement is as follows:
Dim selectStatement As String = "SELECT ID, ..., PB " & "FROM tbl_Clients " & "WHERE ID = ?sngID"