2 SQL Statements The Same? Will They Produce The Same Results?
Aug 22, 2011
Are the following 2 SQL statements the same? Will they produce the same results?
sql1 = "SELECT * FROM [StudentDetials] WHERE ([Subject1] LIKE '" & Subject(0) & "' OR [Subject2] LIKE '" & Subject(0) & "') AND ([Day1] LIKE '" & TabDay & "' OR [Day2] LIKE '" & TabDay & "') AND ([Time1] >= '" & Time(0) & "' AND [ETime1] <= '" & Time(1) & "' OR [Time2] >= '" & Time(0) & "' AND [ETime2] <= '" & Time(1) & "')"
sql1 = "SELECT * FROM [StudentDetials] WHERE ([Subject1] LIKE '" & Subject(0) & "' AND [Day1] LIKE '" & TabDay & "' AND [Time1] >= '" & Time(0) & "' AND [ETime1] <= '" & Time(1) & "') OR ([Subject2] LIKE '" & Subject(0) & "' AND [Day2] LIKE '" & TabDay & "' AND [Time2] >= '" & Time(0) & "' AND [ETime2] <= '" & Time(1) & "')"
In my case they simply produce the same results but that's because of the data i'm using.
View 1 Replies
ADVERTISEMENT
Apr 12, 2009
At present i have an interface which displays a string of sql code in a rich text box.
I also have my microsoft access database connected to the form.
How would i go about getting the sql code in the rich text box to produce the results for the query??
View 2 Replies
May 4, 2012
I have a table of student information. Each student has a contact date and a source of information.
I want to produce the results like this
CODE:
At the moment I am using this sql
CODE:
But my results are like this
CODE:
It is just putting the total not the seperate amounts.
View 1 Replies
Apr 17, 2012
If I have the following code I expect to see FF and AA in a Realterm capture window.Instead I get C3 BF.why I cannot output data on a comport and expect to see the same data captured?
Dim aChars() As Char
ReDim aChars(1)
aChars(0) = Chr(255)[code]......
View 6 Replies
Dec 18, 2009
I am trying to rewrite some code and I am trying to determine if I am writing it correctly. My goal is to make sure that the old code and my new code produce the same results(i.e. are logically equivalent). Are the 2 code blocks below equivalent?
Old
If a = 1 then
If b = 3 OrElse b = 18 OrElse b = 20 OrElse b = 21 OrElse b = 4 then
' Do something
[code]....
View 4 Replies
Oct 15, 2011
I have a question regarding the dataset usage in Reporting Services. I have a stored procedure which returns multiple select statements (result tables), and I created a Dataset in Reporting Services 2005 with this stored procedure. The problem is that I can not reference the second or third result table, and I can only use the first select statement fields. Is this the limitation on Reporting Services Dataset or is there a way to use multiple table results in one dataset?
View 1 Replies
Oct 11, 2009
Can someone give me a site to a tutorial that will help me write a program that will generate a pattern using do while, if else statements,and do until statements. I have been using google but I can't find anything. I need to generate patterns a certain size 6 by 6 or similar such as something like a checkerboard but where the ^ symbols is there a suppose to be a blank space..
View 3 Replies
Mar 14, 2012
I am trying to figure out how to do this:
if (phrase = hello) then
"say hello"
if (phrase = how are you?) then
[CODE]...
So basically, I want it to work like a timeline. If I say hello, then it will respond and move onto the next if statement. Get it?
Here is the code I have now:
If phrase.Result.Text = "hello" Then
synth.Speak("Hello to you too")
If phrase.Result.Text.Contains("How are you") Then
[CODE]...
View 21 Replies
Sep 28, 2010
I have a form that allows users to select file and then it reads the contents, parses the data and then executes a sql insert statement to add it to a database. What I am having issues with is showing real-time results. Currently, I have the import operation take place on the import form within the OnLoad event. The problem with this is it only shows the final results instead of the results real-time. Is there anyway to do this without creating a seperate thread and delegates?
View 1 Replies
Apr 3, 2012
PrivateSubForm1_Load(ByValsender
AsObject,
ByVale
AsSystem.EventArgs)
[code]....
View 4 Replies
Oct 28, 2009
'I am having trouble with the line "senda = suba(sendaobj, EventArgs.Empty)". [code]...
View 12 Replies
Aug 25, 2009
Here's the
Sub DestroyUser(ByRef Victomcheck As Integer, ByRef Victorcheck As Integer)
Dim num As Object
WriteSub("destroyuser")
[Code]......
View 5 Replies
Jun 10, 2011
i am making a hairstyle and makeup software in vb and i need to upload the picture which will be edited, to put a hairstyle and makeup on. ive no idea how i can do it.. it is a virtual makeover software and i need to produce the before and after images. please someone help me, my deadline is on the 31st
View 3 Replies
Dec 23, 2011
I tried to convert following C# code into VB.NET and got "Expression does not produce a value" error while compiling the code
C# Code
return Fluently.Configure().Mappings(m => m.FluentMappings.AddFromAssemblyOf<MyEntityMapping>())
.Database(SQLiteConfiguration.Standard.InMemory().ShowSql())
.ExposeConfiguration(x => new SchemaExport(x).Execute(false, true, false))
.BuildSessionFactory();
VB.NET Code
Return Fluently.Configure() _
.Mappings(Function(m) m.FluentMappings.AddFromAssemblyOf(Of SubscriptionMap)()) _
.Database(SQLiteConfiguration.Standard.InMemory().ShowSql()) _
.ExposeConfiguration(Function(x) New SchemaExport(x).Execute(False, True, False)) _
.BuildSessionFactory()
The error happens on 2nd last line of VB.NET code, while C# code is compiled without problem.What is wrong with the converting?
View 1 Replies
Dec 23, 2011
I tried to convert following C# code into VB.NET and got "Expression does not produce a value" error while compiling the code
[Code]...
View 7 Replies
Apr 1, 2011
I am porting over some code from .net (vb) to php and I came across some md5 hashing that I can't reproduce in php. In the .net one there are two functions one uses UTF-8 encoding and the other uses Unicode encoding. The output is a different hash when passed in a string
// First function (returns GUID)
Dim oHasher As Cryptography.MD5 = Cryptography.MD5.Create()
Dim oEncoder As New System.Text.UTF8Encoding()
Dim csData() As Byte
[Code]...
but they both produce the same result. Is it possible to produce the same results in php with md5 hashing?
View 1 Replies
Jun 2, 2010
I'm using the below code to produce a ToolTip for each row of a ListView.
When moving vertically across the ListView a ToolTip will appear when the mouse touches between two rows - bypassing any of the ToolTip's options.
Private m_HoveredItem As ListViewItem
Private Sub ListView1_MouseMove(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles lv.MouseMove
[Code].....
I'm not using the ShowItemToolTips property of the ListView because I want to have a more formatted ToolTip (ToolTipIcon, Title etc) I don't believe these options can be set for the ListViews ToolTip?
I've updloaded a sample project of the issue here: [URL].
View 1 Replies
May 28, 2009
I have created an program that can produce an XML file from the SQL database.and the code is looks like below:
[Code]....
why is there a <NewDataSet></NewDataSet> node?2. How to remove that node?
View 4 Replies
Mar 14, 2009
I am now looking for a way to produce pdf files from xls files. Since the completed programme will be distributed to others, it would have to work on environment without the "pdf producer" I am using.Which is the "pdf producer" to use"?I am now working on the express version of VB 2005 (which does not have crystal report). I have acrobat 8.0 installed but have not figured out how to do that...
View 2 Replies
May 13, 2010
I noticed that when I build a given C# or VB.NET source to produce a DLL, the binary output is different each time. It would be helpful for our build / deployment process if this was not the case. Can I control this?
View 3 Replies
Feb 15, 2010
I am trying to create a custom datasource control.
I have been following this article to the letter (I think...).
I have a skeleton / basic implementation of my datasource, however when I declare it in the markup and try to statically bind it to a gridview, I receive the following error:
The DataSourceID of 'grdVw' must be the ID of a control of type IDataSource
This seems extremely strange to me, since my datasource inherits from DataSourceControl, which in turn implements IDataSource. Even if I explicitly implement IDataSource in my custom datasource, it makes no difference.
My Markup is:
<DataBrokerDataSource ID="objSrcDBroker" runat="server" />
<div>
<asp:GridView ID="grdVw" DataSourceID="objSrcDBroker" DataMember="Table0" runat="server">
[Code].....
View 1 Replies
May 1, 2011
Why I cannot get a variable to come in. I keep on getting the error "Expression does not produce a value" for one of my Dims.
Imports System.IO
Public Class Main
Dim image_1 As Integer = Openimg1.FileName
'The line below is the one causing my problem
Dim image_2 As Integer = My.Computer.FileSystem.RenameFile(Openimg1.FileName, "_hid" + System.IO.Path.GetExtension(Openimg1.FileName))
[Code] .....
So basically, how can I create a variable from something that has yet to be created?
View 5 Replies
Dec 18, 2009
I have done the following in a LoginForm:
Private Sub OK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OK.Click
If UsernameTextBox.Text = ("username") And PasswordTextBox.Text = ("password") Then MainMenu.Show(Me.Hide) Else MsgBox("Wrong")
End Sub
But it gives me the following error:
Error 1 Expression does not produce a value (on Me.Hide)
View 4 Replies
Aug 19, 2011
how to create data charts in Access / VB ?
View 2 Replies
Mar 25, 2010
I am trying making a appliction that produce a invoice, its just a type of business application, in that i want to and form that contain a email sector divided on two tabs one to send email, and second to receive email (like to check my inbox, etc)
View 1 Replies
Oct 6, 2009
I have 36 numbers in sets of 5. (eg. 1-2-3-4-5, 2-3-4-5-6 etc..) I need to find all the possible combinations of these numbers which total the same sum. For instance the lowest sum would be: 1 + 2 + 3 + 4 + 5 = 15. The highest possible sum is: 32 + 33 + 34 + 35 + 36 = 170. Now every five number combination within these 36 numbers will sum up between 15 and 170. How would I go about this in vb.net to produce all the possible combinations which would total say 92.
View 6 Replies
Jul 13, 2011
I want to re-produce the equivilent of the DowArrow sign on a VB2010 Form label. label1.Text = Chr(ConsoleKey.DownArrow) doesn't work. The nearest character seems to be ASCII DEC 30 value., which will do fine, but Is there anyway I can reproduce this char on my form label, using one line of code, viz- label1.text =
View 6 Replies
Apr 11, 2011
In my project I have a summary data table which i want to export in Excel document, for this purpose i have deployed the following code:
Public Shared Function Main() As Integer
Dim exc As New Application
exc.Visible = True
[Code]....
I get the error of : Exception has been thrown by the target of an invocation
View 1 Replies
Jan 6, 2011
I've been working creating a few programs in visual studio 10. These work fine on my own PC because I have the .net framework installed. However I need to be able to distribute these programs as a single .exe file download from our website and also as a single .exe file via CD.
Most of the PCs which will be installing my programs won't have .net framework installed and I don't want to force people to have to download the files from the internet (it just seems like so much hassle and I can't guarantee that everyone who wants to install my programs will even have access to the internet).I know that I can set pre-requisites in the publish tab and I have done this whilst setting "Download prerequisites from the same location as my application". I've already downloaded the redistributable files WindowsInstaller-KB893803-v2-x86.exe and dotNetFx40_Full_x86_x64 and I've put the files in the same folder as my project.I then go into the publish wizard and select that users will install the application from a CD-ROM or DVD-ROM. Unfortunately I then get the following errors:
Error 2 The install location for prerequisites has not been set to 'component vendor's web site' and the file 'WindowsInstaller3_1WindowsInstaller-KB893803-v2-x86.exe' in item 'Windows Installer 3.1' can not be located on disk. See Help for more information.ConsumptionCalculatorDraft1
Error 3 The install location for prerequisites has not been set to 'component vendor's web site' and the file 'DotNetFX40dotNetFx40_Full_x86_x64.exe' in item 'Microsoft .NET Framework 4 (x86 and x64)' can not be located on disk. See Help for more information.
ConsumptionCalculatorDraft1
View 5 Replies
Jan 18, 2012
For my applications I created a class to produce custom cursors. One of them is a waitcursor with a percentage in it. It has several backgrounds each one with a filled circle on it and they are positioned in a circle it self (a bit like the java wait thingy). Since I put it in my application I started to get errors at different places in my code, but all related to some memmory problems.
[Code]...
View 1 Replies
