DB/Reporting :: Vb6 To Vb2k8 Migration Sql Select Hangup?
Jul 22, 2010
I am attempting to migrate from vb6 to vb2k8. My first attempt is a program with three forms. The first form extracts data from Oracle into a local Access DB. It works great but the second form only pulls data from Access to generate a text file. The VB6 version does it in 10 minutes, the VB2k8 version gets 1/10th through the data in two hours. It is hanging on:
"select sum(hrs) as thrs from tablename where emp_id_no='xxxxxx' and hours_type='CE' and org_ofc_sym='oos'"
I have to hide identifying fields but the emp_id_no and oos are correct.
View 9 Replies
ADVERTISEMENT
Jan 8, 2010
I have with a good level of success got a C# application to use TAPI to connect to my office PBX and dial and hangup calls but need to go further and be able to monitor activity and provide CTI to client pc's as well as integration back to my companies web based CRM.
I am focusing on the client app for CTI popups and dial/hangup functions as the phone number lookup to the CRM is relatively easy.
I initially started by registering one handset in the tapi that I could then dial and hangup, I even seem to have registered all the handsets on the system and to be able to dial from any of them but I don't seem to be able to get any activity logs as to when any of the handsets are ringing etc.
Does anyone have any example tapi code that can get me started or point me in the right direction? I can work with C++, C# or VB.Net as I am okay with any of them.
View 1 Replies
Oct 13, 2010
I am doing data migration two database in MS SQL 2005. The records are more than 200000 nearly 300000. I need to query from source database using joins and insert 2 or 3 tables in destination databse. Which way is the best way to do so? I am trying to write a program with VB.NET. If you have sample,
View 1 Replies
Nov 25, 2008
I'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?
View 2 Replies
Jun 28, 2011
Not 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].....
View 3 Replies
Dec 29, 2008
I'm using Vb2005 and Db MS access Is it possible to use tow Select in same sql Statement like this example:
Code:
"Select....Select......."
View 5 Replies
May 11, 2008
I want to take a drop down menu. It will contain LastName, FirstName. I want that to select a record from a table. First Name and LastName are two different columns
View 5 Replies
Jun 3, 2009
Im new to database programming and was wondering if you can save a select statement to an array:I tried this but obviously wont work, does anyone have any ideas?
Code:
Public Sub store_select_star_to_array()
Dim myCommand
[code]......
View 2 Replies
Feb 25, 2008
Ive got a web page so that the users select a day from the calendar and the date is input to a text box, the format is dd/mm/yyyy, it is the same format in the database table.
I want to select the data from the database when it is = the date in the text box but it is retrieving data in mm/dd/yyyy format. My sql is:
SELECT Booking.Date, Booking.RoomNo, Booking.Lesson, [NoComps] - " & students & " AS diff FROM Rooms INNER JOIN Booking ON Rooms.RoomNo = Booking.RoomNo WHERE booking.Date= #" & txtdate.Text & "# AND booking.Lesson = '" & lessonlist.SelectedValue & "' AND booking.Type IS NULL
how can i make sure it retrieves the data using the correct date format?
View 1 Replies
Nov 1, 2010
I need to filter a measurements table that consists of 63 measurement objects that may or may not be tested more then once. The entries are put in a Batch table on a SQL server in the following fashion:
ID: | Serie | Test object | Min Amps | Max Amps | OK?
DateTime| String | Integer | Double | Double | Boolean
So there may be multiple entries in my database with the same series and testobject number but with (slightly) different results.
Currently I just select: SELECT * FROM Measurements WHERE Serie = 'XXXX' and use a datareader object to fill a datatable and then I let loose a routine on it that will either: Get the last result that produced a good measurement, so OK = 1 and max ID. Or the last result that produced a bad measurement if there are no good ones. I then end up with a list of 63 either good or bad measurement objects with the last good result, and if there isn't one then the last bad result.
Now I know that SQL is quite powerfull and I suppose that it must be possible to directly query for these results without a programatical routine re-filtering the results. I suppose it's like Selecting within a select statement..
View 2 Replies
May 1, 2008
I am trying to use sql to select a row and then find the minimum and maximum values in the row, do some preprocessing, update the recordset using in visual basic 6.0, and then go ahead select the second row, find the minimum and maximum values again.. and go on, until the last row.
The problem is I am having difficulties using sql select for a ROWS.. I am aware how to do this for COLUMNS.. if I want to extract the first row from a recordset, find the min max values, and then, extract the second row and so on.. how will it be possible? (discouraged to use VBA, since i am limited to VB only)..
Here is an example of my recordset:
Code:
Col1Col2Col3Col4Col5
0.43530.05630.74350.92510.0325
0.28430.00320.82430.73250.9981
This example only lists two rows currently. I want to extract the minimum and maximum values from each row at a time, and then the second row. The reason for extracting minimum and maximum values is because I want to normalize my data in the range from 0 to 1.
Logic: After I find the min and maximum values for each row, I will use the recordset back, read the same row, and update every columns entry with my normalized data value... then proceed to the next row and do the same for every row in my database.
View 2 Replies
Nov 18, 2009
I already have a problem..
Im trying to get the soft recognize the timerange between times:
For example:
START TIME: 10:00
[Code]....
I need to pick the time range between 10:00 and 05:00 in the morning.
I tried both - SQL Select and Visual Basic - both options didnt work when I needed to pick the time range as above. Normal ranges during the 24 hour cycle where ok.
View 2 Replies
Dec 6, 2008
I have a stored procedure that I need to be able to change the table name that the select statement in the stored procedure uses depending on a user input, however I am having a problem with the code:
Code:
CREATE PROCEDURE [dbo].[spQryParentComments] @projTable as varchar(50)
AS
[code].....
View 3 Replies
Apr 7, 2012
I'm just a frustrated noob trying to get past my first DB Program. My goal is to get relational data from different tables all ordered by a certain field..Ive noticed early on that i cannot select a column when its name has a space.[code]Now the statement i want to use is sql = "SELECT [PT.Chart Number],[PT.Last Name],[CA.Case Number] FROM Table1 AS PT INNER JOIN Table2 AS CA ON PT.Chart Number = CA.Chart Number ORDER BY PT.Chart Number"..When i Debug i get the same type of error ("... Can't find column name PT.Chart... ")I'm new to sql so i dont know if my syntax is off.
View 4 Replies
Apr 6, 2009
I have a database and I wanna select a field ..I usually do this with access:
dim chosen as string
chosen = textbox1.text
Dim querysql = "select * from table where field = " & chosen & ""
But with SQL it doesnt work =S I really need to make this work .
View 7 Replies
Apr 23, 2008
This is the only code I could find and it doesnt work:
Private Sub DataGridView1_MouseUp(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles DataGridView1.MouseUp
Dim pt = New Point(e.X, e.Y)
[Code]....
View 2 Replies
Sep 24, 2011
anyone knows the query of selecting from monthname and year(September 2011) from mysql database DATE format(yyyy-MM-dd)
View 1 Replies
Jan 29, 2010
I 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].....
View 4 Replies
Sep 16, 2011
I need this for displaying in my crystal report here's my code:
Code: cmd.CommandText = "Select * from pos where date= '" & datetimepicker1.text"'" and nothing displays on my crystal report, I need the right query for that...the field value is DATE...I need the conversion for the 1/11/2001 format from date time picker to 2001-1-11 in DATE field
View 3 Replies
Oct 24, 2011
I have developed an application using .NET 4.0 Framework, now i want to migrate to .NET 3.5 Framework.
When i change the Framework in advance compile option and run the application it gives me the following error. how can i over come this....
View 7 Replies
Jun 22, 2010
I have made the dreaded (but forced) change from vb6 to .NET.
View 1 Replies
Jan 19, 2009
Any program written in Vb 6.0 Is there any free source code available to convert vb code to vb.net?
View 3 Replies
Apr 23, 2010
I'm going to convert VB6 code to vb.NET 2008. Please advise me What is the best way to convert the code. My VB6 system used following comp.
View 3 Replies
Oct 22, 2009
I am working on a VB to C#.Net migration project. Has anyone used a tool called CSharpener to convert VB.Net code to C#? What is your experience with this tool? How much code does this tool migrate & how much is the rework?
View 1 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
Mar 26, 2008
I am using VB2008 Express and a MSSQL Server 2005 db by the way! I have a comprehensive SQL statement, which should fill my Grid:
DECLARE @Sum NUMERIC(9,2)
SELECT @Sum = SUM(I_LS.lmenge)
FROM dbo.lfs AS I_L
[CODE]...
Now here is my problem! I want to have a form with a datagridview that displays all of the values I am querying. This shouldn't be a problem I guess. However, I have no idea how I can integrate two textboxes that can be used to enter the selection criteria (WHERE I_L.lfsnr LIKE '%1253') AND (l.sped_journal = '11-08')[/SIZE]. I have googled and read many threads so far but didn't stumble upon anything that would suit my needs and answer my question. Maybe it's just too elementary!? By the way, it is very important that the input of textbox1 ((WHERE I_L.lfsnr LIKE '%1253')) is linked to 3 positions in my SQL query to define the search criteria!
The worst thing is that I don't want to have a bindingnav displayed! I do not need any delete, update or add functions just the select option, however!
View 1 Replies
Apr 26, 2012
I got a chance to work in the migration project(VB to VB.NET).I was confusing in the RecordSet functionality.In our project we are taking the DataReader according to the scenario.But in the Looping cases like dsr.EOF.
Dim recordset As dao.RecordSet
If recordset .EOF Then
' ' msgbox "Please enter some number ", vbOKOnly, "Number Not Found"[code].....
How to convert this into VB.NET?Either we need to write If Not reader.Read or If reader.Read.
View 1 Replies
Feb 23, 2009
In my Live sql database ,I have to change the date value from (date, month ,year) to date. Now there is 100 records with the date as date,month ,year(3 Fields).iF I change directly to date Field all the datas in the 3 field of those 100 records will automaticly change to a default date and original dates will disappear.What should i do to migrate all my datas safely
View 2 Replies
Jul 21, 2009
I'm working on a project trying to migrate data from MS Access to CRM(Sales force) online web services database. Have you any ideas how this process can be done? Also, if you know of any VBA or SQL code or online sites that can help me with coding this migration?
View 2 Replies
Mar 10, 2010
I migrate a vb application from MS Access to SQL Server 2008 using DAO Connectivity.[code]My question is this Is there any way to just change connection from mdb to SQL 2008 without changing in code..
View 9 Replies
