Formula Assistance in Excel xlsx for Office 2010 w/ Windows 7
You could use the <a href=”http://office.microsoft.com/en-us/excel-help/left-leftb-HP005209153.aspx?CTT=5&origin=HP005203209″>LEFT function</a>: <pre>B2 =LEFT(A2,LEN(A2)-4)</pre> If the values in column A have a fixed length, you could do something like this: <pre>B2 =LEFT(A2,8)</pre> ******************************************** There is more than one way to skin a cat (I always wonder, if it is true for dog or hamster!). I liked the solution already provided. [...]
View Answer
| September 8, 2010 2:21 AM
Excel 2010, Excel Forms, Excel formulas, office 2010, Windows 7
You could use the <a href=”http://office.microsoft.com/en-us/excel-help/left-leftb-HP005209153.aspx?CTT=5&origin=HP005203209″>LEFT function</a>: <pre>B2 =LEFT(A2,LEN(A2)-4)</pre> If the values in column A have a fixed length, you could do something like this: <pre>B2 =LEFT(A2,8)</pre> ******************************************** There is more than one way to skin a cat (I always wonder, if it is true for dog or hamster!). I liked the solution already provided. [...]
View Answer
| September 8, 2010 2:21 AM
Excel 2010, Excel Forms, Excel formulas, office 2010, Windows 7
xp_fileexist workd in Query window but doesnt in stored procedure
The local account which the SQL Server is running under probably doesn’t have access to the file you are looking at. Change the SQL Server to run under a domain account, or local user defined user which has rights to the file. The problem is that the parameter is declared as TEXT which isn’t valid [...]
View Answer
| September 7, 2010 7:16 PM
SQL error messages, SQL Query, SQL Server, Stored Procedures
The local account which the SQL Server is running under probably doesn’t have access to the file you are looking at. Change the SQL Server to run under a domain account, or local user defined user which has rights to the file. The problem is that the parameter is declared as TEXT which isn’t valid [...]
View Answer
| September 7, 2010 7:16 PM
SQL error messages, SQL Query, SQL Server, Stored Procedures
Object Sender and EventArgs in Visual Studio 2005
From <a href=”http://msdn.microsoft.com/en-us/library/2ccyd347.aspx”>the documentation</a>: “When an event does not have any associated data, the class raising the event uses System.EventHandler as the delegate and System.EventArgs for the event data. Events that have associated data use classes that derive from EventArgs …” The EventArg class is used by events that do not pass additional information to [...]
View Answer
| September 7, 2010 4:11 PM
C#, Visual Studio, Visual Studio 2005, VS 2005
From <a href=”http://msdn.microsoft.com/en-us/library/2ccyd347.aspx”>the documentation</a>: “When an event does not have any associated data, the class raising the event uses System.EventHandler as the delegate and System.EventArgs for the event data. Events that have associated data use classes that derive from EventArgs …” The EventArg class is used by events that do not pass additional information to [...]
View Answer
| September 7, 2010 4:11 PM
C#, Visual Studio, Visual Studio 2005, VS 2005
Help in adapting the following code:
This question was already asked, and <a href=”http://itknowledgeexchange.techtarget.com/profile/Kccrosser/”>Kccrosser</a> provided an answer <a href=”http://itknowledgeexchange.techtarget.com/itanswers/sql-problem-2/”>here</a>.
View Answer
| September 6, 2010 6:13 PM
Code, Code Complexity, Source Code Analysis, Source code management
This question was already asked, and <a href=”http://itknowledgeexchange.techtarget.com/profile/Kccrosser/”>Kccrosser</a> provided an answer <a href=”http://itknowledgeexchange.techtarget.com/itanswers/sql-problem-2/”>here</a>.
View Answer
| September 6, 2010 6:13 PM
Code, Code Complexity, Source Code Analysis, Source code management
what are Rvalues and Lvalues in C++
L-values are expressions that refer to memory locations, and are usually variables or objects. An l-value is something that could appear on the left side of an equal sign (i.e. something that you can assign a value to). In your case, this part: <pre>++i++</pre> Is somehow equivalent to this: <pre>i++ = (i++) + 1</pre> But [...]
View Answer
| September 6, 2010 2:28 PM
C++, C/C+/C# error messages, Rvalues and Lvalues, Turbo C++, Visual C++
L-values are expressions that refer to memory locations, and are usually variables or objects. An l-value is something that could appear on the left side of an equal sign (i.e. something that you can assign a value to). In your case, this part: <pre>++i++</pre> Is somehow equivalent to this: <pre>i++ = (i++) + 1</pre> But [...]
View Answer
| September 6, 2010 2:28 PM
C++, C/C+/C# error messages, Rvalues and Lvalues, Turbo C++, Visual C++
Can RPG call a VB script
There are almost always facilities available for cross-platform (remote) program calls. The calls are usually easier to set up and execute than the setup of the security configurations that are needed. When a system allows external program calls, you should ensure that authentication and authorization is satisfied. You usually can’t risk allowing a system simply [...]
View Answer
| September 6, 2010 9:35 AM
AS/400 Parameters, RPG, VBScript, Visual Basic Script
There are almost always facilities available for cross-platform (remote) program calls. The calls are usually easier to set up and execute than the setup of the security configurations that are needed. When a system allows external program calls, you should ensure that authentication and authorization is satisfied. You usually can’t risk allowing a system simply [...]
View Answer
| September 6, 2010 9:35 AM
AS/400 Parameters, RPG, VBScript, Visual Basic Script
Running a VBScript from a batch file
cscript //b //nologo script C:>cscript /? Usage: CScript scriptname.extension [option...] [arguments...] Options: //B Batch mode: Suppresses script errors and prompts from displaying //D Enable Active Debugging //E:engine Use engine for executing script //H:CScript Changes the default script host to CScript.exe //H:WScript Changes the default script host to WScript.exe (default) //I Interactive mode (default, opposite of [...]
View Answer
| April 18, 2013 4:03 PM
Batch files, VB script, Visual Basic, Visual Basic Script
cscript //b //nologo script C:>cscript /? Usage: CScript scriptname.extension [option...] [arguments...] Options: //B Batch mode: Suppresses script errors and prompts from displaying //D Enable Active Debugging //E:engine Use engine for executing script //H:CScript Changes the default script host to CScript.exe //H:WScript Changes the default script host to WScript.exe (default) //I Interactive mode (default, opposite of [...]
View Answer
| April 18, 2013 4:03 PM
Batch files, VB script, Visual Basic, Visual Basic Script
SQL Server 2005 error after development
Sounds like your connection string isn’t correct.
View Answer
| September 2, 2010 4:18 PM
Application deployment, Application development, SQL Server, SQL Server 2005
Sounds like your connection string isn’t correct.
View Answer
| September 2, 2010 4:18 PM
Application deployment, Application development, SQL Server, SQL Server 2005
Benefits/disadvantages of hosting SQL server on site versus MySQL in cloud?
First you are talking about two different database platforms Microsoft SQL Server and MySQL. There are a lot of features that are different between the two. If you are thinking about moving a database into the cloud you should look at SQL Azure which is a Microsoft SQL Server database hosted in the cloud by [...]
View Answer
| September 2, 2010 4:17 PM
Cloud Computing, Cloud Computing in 2010, Cloud Services, MySQL, SQL, SQL Server, SQL Server administration
First you are talking about two different database platforms Microsoft SQL Server and MySQL. There are a lot of features that are different between the two. If you are thinking about moving a database into the cloud you should look at SQL Azure which is a Microsoft SQL Server database hosted in the cloud by [...]
View Answer
| September 2, 2010 4:17 PM
Cloud Computing, Cloud Computing in 2010, Cloud Services, MySQL, SQL, SQL Server, SQL Server administration
SQL Insert Error Against Runtime Control Error in FLP
This is the syntax for the SQL INSERT statement: <pre>INSERT INTO <table_name> [(<column list>)] VALUES (<values list>)</pre> So, your INSERT string should look like this: <pre>Insert into dummy(name,amount) values (“something”,some_value)</pre> but it seems that you are constructing it like this: <pre>insert into dummy(name,amount) values something some_value</pre> To debug it, I would display the contents of [...]
View Answer
| September 2, 2010 3:37 PM
C#, SQL 2000, SQL error messages, SQL Server, SQL Server 2000
This is the syntax for the SQL INSERT statement: <pre>INSERT INTO <table_name> [(<column list>)] VALUES (<values list>)</pre> So, your INSERT string should look like this: <pre>Insert into dummy(name,amount) values (“something”,some_value)</pre> but it seems that you are constructing it like this: <pre>insert into dummy(name,amount) values something some_value</pre> To debug it, I would display the contents of [...]
View Answer
| September 2, 2010 3:37 PM
C#, SQL 2000, SQL error messages, SQL Server, SQL Server 2000
DB Table/Query Layout for Ranking System
tbl_Member with MID, Name etc tbl_Rank with RID, rank_name, Description etc tbl_Member_Rank with MID, RID, Effective_From (date), Effective_To (date) When a member gets a rank, if they have a previous rank, then set their effective_to date as the current date for that record (using mid, rid parameters), and then create a new record with the [...]
View Answer
| September 2, 2010 2:02 PM
Access 2007, Access Database, Access query, Database, Query
tbl_Member with MID, Name etc tbl_Rank with RID, rank_name, Description etc tbl_Member_Rank with MID, RID, Effective_From (date), Effective_To (date) When a member gets a rank, if they have a previous rank, then set their effective_to date as the current date for that record (using mid, rid parameters), and then create a new record with the [...]
View Answer
| September 2, 2010 2:02 PM
Access 2007, Access Database, Access query, Database, Query
Firewall and Google Maps
Google has a lot of IP addresses in several different address chunks… They are often rearranged, so it’s not a good idea to rely on IP for acessing Google sites – it’s necessary to rely on Google DNS. So, instead of using firewall for IP-based filtering, better install a web proxy and filter web sites [...]
View Answer
| September 1, 2010 9:16 PM
Application firewalls, Firewalls, Google, Google Apps, Google Maps API
Google has a lot of IP addresses in several different address chunks… They are often rearranged, so it’s not a good idea to rely on IP for acessing Google sites – it’s necessary to rely on Google DNS. So, instead of using firewall for IP-based filtering, better install a web proxy and filter web sites [...]
View Answer
| September 1, 2010 9:16 PM
Application firewalls, Firewalls, Google, Google Apps, Google Maps API
Display Datagridview
Imports System.Data.SqlClient Public Class Form1 Dim connection as new sqlconnection("server = localhost; user id = root; password = ; database = (database name)") Private Sub b1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles b1.Click Dim cmd as new sqlcommand Dim dataAdapter As New SqlDataAdapter Dim ds as new dataset() cmd = connection.createcommand cmd.commandtext = [...]
View Answer
| September 16, 2012 4:05 PM
DataGridView, GridView, VB DataGrid, VB.NET, Visual Basic, Visual Basic .NET, Visual Basic .NET Web services
Imports System.Data.SqlClient Public Class Form1 Dim connection as new sqlconnection("server = localhost; user id = root; password = ; database = (database name)") Private Sub b1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles b1.Click Dim cmd as new sqlcommand Dim dataAdapter As New SqlDataAdapter Dim ds as new dataset() cmd = connection.createcommand cmd.commandtext = [...]
View Answer
| September 16, 2012 4:05 PM
DataGridView, GridView, VB DataGrid, VB.NET, Visual Basic, Visual Basic .NET, Visual Basic .NET Web services
how to limit data access on AS400 through ODBC, client access or Sequel viewpoint product
Is there any documentation out there on the proper way to setup database security to allow update authority on the data within the applications but to limit authority when data is being accessed by 3rd party apps like SEQUEL VIEWPOINT or an ODBC connection. Yes. It’s in the Information Center for your OS version/release level. [...]
View Answer
| January 28, 2013 9:07 PM
AS/400, Data access, iSeries Access, ODBC, SEQUEL ViewPoint
Is there any documentation out there on the proper way to setup database security to allow update authority on the data within the applications but to limit authority when data is being accessed by 3rd party apps like SEQUEL VIEWPOINT or an ODBC connection. Yes. It’s in the Information Center for your OS version/release level. [...]
View Answer
| January 28, 2013 9:07 PM
AS/400, Data access, iSeries Access, ODBC, SEQUEL ViewPoint
Alternative web filtering software
See this <a href=”http://itknowledgeexchange.techtarget.com/itanswers/blocking-spyware-and-inappropriate-sites/”>similar question and answer</a>.
View Answer
| August 31, 2010 5:39 PM
Monitoring software, Software, Software Management, URL Blocking, Web filtering, web filters, Websense
See this <a href=”http://itknowledgeexchange.techtarget.com/itanswers/blocking-spyware-and-inappropriate-sites/”>similar question and answer</a>.
View Answer
| August 31, 2010 5:39 PM
Monitoring software, Software, Software Management, URL Blocking, Web filtering, web filters, Websense
Active Directory reports
Quest Reporting suite will do all this and more www.quest.com no connection just a happy user.
View Answer
| August 31, 2010 10:56 AM
Active Directory, Active Directory Administration, Active Directory interoperability, Active Directory Reporting Tool, Batch file, VB script, Visual Basic
Quest Reporting suite will do all this and more www.quest.com no connection just a happy user.
View Answer
| August 31, 2010 10:56 AM
Active Directory, Active Directory Administration, Active Directory interoperability, Active Directory Reporting Tool, Batch file, VB script, Visual Basic
Career advice: Software versus Networking
The important thing for your students to remember is that they need to find a part of IT which makes them happy. If they don’t enjoy the work that they are doing, then they won’t success in IT and they won’t get into a position which makes a high salary.
View Answer
| August 30, 2010 8:00 PM
802.11 networking equipment, IT career planning, IT careers, Networking careers, Software development, Software Test Engineer
The important thing for your students to remember is that they need to find a part of IT which makes them happy. If they don’t enjoy the work that they are doing, then they won’t success in IT and they won’t get into a position which makes a high salary.
View Answer
| August 30, 2010 8:00 PM
802.11 networking equipment, IT career planning, IT careers, Networking careers, Software development, Software Test Engineer
Will the SQL performance improvements in V6R1 affect QUERY?
The general answer is that, yes, Query/400 queries can be helped by improvements in 6.1 as well as in V5R4. <i>Will the SQL performance improvements in V6R1 affect QUERY?</i> They aren’t exactly “SQL” improvements, although there are some of those. <i>Does QUERY use SQL under the hood?</i> As far as I know, no, it does [...]
View Answer
| August 28, 2010 1:34 AM
i5, SQL performance, SQL queries, SQL Query, V6R1
The general answer is that, yes, Query/400 queries can be helped by improvements in 6.1 as well as in V5R4. <i>Will the SQL performance improvements in V6R1 affect QUERY?</i> They aren’t exactly “SQL” improvements, although there are some of those. <i>Does QUERY use SQL under the hood?</i> As far as I know, no, it does [...]
View Answer
| August 28, 2010 1:34 AM
i5, SQL performance, SQL queries, SQL Query, V6R1
Runtime Session resolution change
Sign on to a workstation session that is defined to allow 27×132 — this is a setting in the emulator on the PC. Once the workstation device is capable of displaying 27×132, then you would simply display a 27×132 record format. (System displays will automatically adapt to the display size of the device.) The DDS [...]
View Answer
| August 27, 2010 8:30 PM
RPG ILE, RPGILE, Source code
Sign on to a workstation session that is defined to allow 27×132 — this is a setting in the emulator on the PC. Once the workstation device is capable of displaying 27×132, then you would simply display a 27×132 record format. (System displays will automatically adapt to the display size of the device.) The DDS [...]
View Answer
| August 27, 2010 8:30 PM
RPG ILE, RPGILE, Source code
FoxPro 2.6 DBFS Security
It is not possible to lock any dbf file, rather than just make them hide or read only. Hope u know this procedure. It is better u have to download Folder Lock utility and install it. By the help of this utility u may lock foxpro folder or unlock as ur wish. Hope it will [...]
View Answer
| August 27, 2010 4:40 AM
DBF file, FoxPro 2.6, FoxPro 2.6 for DOS, FoxPro 2.6 for WINDOWS, Windows 2000, Workstation Security
It is not possible to lock any dbf file, rather than just make them hide or read only. Hope u know this procedure. It is better u have to download Folder Lock utility and install it. By the help of this utility u may lock foxpro folder or unlock as ur wish. Hope it will [...]
View Answer
| August 27, 2010 4:40 AM
DBF file, FoxPro 2.6, FoxPro 2.6 for DOS, FoxPro 2.6 for WINDOWS, Windows 2000, Workstation Security
