Sending -/+ Number from VB.NET to COBOL
You are missing the understanding of what S9(3) means. The sign (positive or negative) is carried in the last byte of the field along with the numeric value. If you want “send like they normally would like -120″ then you are looking at a 4 byte field and it will not be a numeric field. [...]
View Answer
| January 13, 2011 9:22 PM
COBOL, OLE DB, VB.NET, Visual Basic, Visual Basic .NET
You are missing the understanding of what S9(3) means. The sign (positive or negative) is carried in the last byte of the field along with the numeric value. If you want “send like they normally would like -120″ then you are looking at a 4 byte field and it will not be a numeric field. [...]
View Answer
| January 13, 2011 9:22 PM
COBOL, OLE DB, VB.NET, Visual Basic, Visual Basic .NET
Adding another level of security to SQL 2005 database
No, it is a one or the other. The SQL Server can’t require both. Windows authentication is much more secure than SQL Authentication as brute force attacks can’t be used against a Windows account when connecting to SQL Server as when using Windows Authentication the user must already be logged into the domain with a [...]
View Answer
| January 12, 2011 11:10 PM
Network security, Network Security Management, SQL 2005 Database, SQL Security, SQL Server 2005, SQL Server security, Windows authentication
No, it is a one or the other. The SQL Server can’t require both. Windows authentication is much more secure than SQL Authentication as brute force attacks can’t be used against a Windows account when connecting to SQL Server as when using Windows Authentication the user must already be logged into the domain with a [...]
View Answer
| January 12, 2011 11:10 PM
Network security, Network Security Management, SQL 2005 Database, SQL Security, SQL Server 2005, SQL Server security, Windows authentication
Need project plan for Access 2007 database migration to SQL Server
Not much information to go on here but your answer is likely contained here: <a href=”http://support.microsoft.com/kb/2279654″> http://support.microsoft.com/kb/2279654
View Answer
| January 12, 2011 7:45 PM
Access 2007, Access Database, SQL Database, SQL Server, SQL Server database, SQL Server migration
Not much information to go on here but your answer is likely contained here: <a href=”http://support.microsoft.com/kb/2279654″> http://support.microsoft.com/kb/2279654
View Answer
| January 12, 2011 7:45 PM
Access 2007, Access Database, SQL Database, SQL Server, SQL Server database, SQL Server migration
The future of PHP
PHP is already popular, used in millions of domains, Source: NetCraft, supported by most ISPs and used by renowned Web companies like Yahoo ! The new version of PHP (version 6) aims to add to this success by introducing new features that make PHP more usable in some cases and more secure in others. As [...]
View Answer
| January 12, 2011 12:00 PM
MySQL, Open IT Forum, PHP, PHP Coding
PHP is already popular, used in millions of domains, Source: NetCraft, supported by most ISPs and used by renowned Web companies like Yahoo ! The new version of PHP (version 6) aims to add to this success by introducing new features that make PHP more usable in some cases and more secure in others. As [...]
View Answer
| January 12, 2011 12:00 PM
MySQL, Open IT Forum, PHP, PHP Coding
Rename file in CL
In your CL program do: CHKOBJ OBJ(&FILE) OBJTYPE(*FILE) MONMSG CPF9801 EXEC(GOTO FOUND) ** Do your rename here FOUND: You may rename a file by right-clicking and selecting ‘Rename’ – but as your question has a Database tag and a reference to CL, I am thinking that you mean something much more specific than your question [...]
View Answer
| January 11, 2011 10:49 PM
CL Procedure, CL Program, RENAME statement
In your CL program do: CHKOBJ OBJ(&FILE) OBJTYPE(*FILE) MONMSG CPF9801 EXEC(GOTO FOUND) ** Do your rename here FOUND: You may rename a file by right-clicking and selecting ‘Rename’ – but as your question has a Database tag and a reference to CL, I am thinking that you mean something much more specific than your question [...]
View Answer
| January 11, 2011 10:49 PM
CL Procedure, CL Program, RENAME statement
Creating Access Form
Use the Like statement with the wild card operator * Ex. Find all rows where field1 has a word that starts with “con” Select * from table where field1 like “con*” Ex. Find all rows where field1 has a word that has “con” anywhere in the word Select * from table where field1 like “*con*” [...]
View Answer
| January 10, 2011 2:30 PM
Access Database, Access forms, Access Forms Database, Access query
Use the Like statement with the wild card operator * Ex. Find all rows where field1 has a word that starts with “con” Select * from table where field1 like “con*” Ex. Find all rows where field1 has a word that has “con” anywhere in the word Select * from table where field1 like “*con*” [...]
View Answer
| January 10, 2011 2:30 PM
Access Database, Access forms, Access Forms Database, Access query
Alter proc to fetch a table structure from SQL Server 2005 database
Why not just use sp_help_table?
View Answer
| August 4, 2012 11:28 AM
FETCH statement, SQL 2005, SQL 2005 Database, SQL Server 2005, SQL Server tables
Why not just use sp_help_table?
View Answer
| August 4, 2012 11:28 AM
FETCH statement, SQL 2005, SQL 2005 Database, SQL Server 2005, SQL Server tables
Create “if then” formula in Access 2003
I think it would help for you to give an example of what you have and what you want. If I am understanding you, each article number has three intro dates and three outro dates, but you want it to only have one of each?
View Answer
| January 6, 2011 6:59 PM
Access 2003, Access 2003 date query, Access 2003 forms, Access forms
I think it would help for you to give an example of what you have and what you want. If I am understanding you, each article number has three intro dates and three outro dates, but you want it to only have one of each?
View Answer
| January 6, 2011 6:59 PM
Access 2003, Access 2003 date query, Access 2003 forms, Access forms
Formview from gridview in Visual Basic
DataGridView.CellClick Event Dim intSelectedColumn As Integer Dim intSelectedRow As Integer intSelectedRow = e.RowIndex intSelectedColumn = e.ColumnIndex ‘ Now run through the Cells and populate Form fields or Read the selected record ‘ from the database (one of the cells must hold the Identity, of course).
View Answer
| January 6, 2011 8:05 AM
Database, DataGridView, GridView, VB, Visual Basic
DataGridView.CellClick Event Dim intSelectedColumn As Integer Dim intSelectedRow As Integer intSelectedRow = e.RowIndex intSelectedColumn = e.ColumnIndex ‘ Now run through the Cells and populate Form fields or Read the selected record ‘ from the database (one of the cells must hold the Identity, of course).
View Answer
| January 6, 2011 8:05 AM
Database, DataGridView, GridView, VB, Visual Basic
Photo upload in a profile with PHP and MySQL?
You should go to this site: A genius computer programmer answers all the questions: http://forums.geeksww.com/list.php?9 Hope this helps.
View Answer
| January 2, 2011 4:53 PM
MySQL, PHP, Web development
You should go to this site: A genius computer programmer answers all the questions: http://forums.geeksww.com/list.php?9 Hope this helps.
View Answer
| January 2, 2011 4:53 PM
MySQL, PHP, Web development
Install MySQL as Non-Root User
No, I have not attempted to install MySQL as a normal (non-root) user. You should go to this site and check out the forums, it tells you how to install MySQL and all: www.geeksww.com/forums/
View Answer
| January 2, 2011 4:45 PM
MySQL
No, I have not attempted to install MySQL as a normal (non-root) user. You should go to this site and check out the forums, it tells you how to install MySQL and all: www.geeksww.com/forums/
View Answer
| January 2, 2011 4:45 PM
MySQL
Recursive Association with compound primary key in SQL database
I see three options for you. 1. Change the foreign key so that it uses the same columns for the parent and the child. 2. Add computed columns to the table so that if the Lead_Client value is not null then the values are entered in automatically. 3. Change the front end so that the [...]
View Answer
| January 2, 2011 8:38 AM
Database issues, Design principles, SQL, SQL Database, SQL Server database, SQL Server errors
I see three options for you. 1. Change the foreign key so that it uses the same columns for the parent and the child. 2. Add computed columns to the table so that if the Lead_Client value is not null then the values are entered in automatically. 3. Change the front end so that the [...]
View Answer
| January 2, 2011 8:38 AM
Database issues, Design principles, SQL, SQL Database, SQL Server database, SQL Server errors
How to connect Forms 6i with MS Access
Rashid bhai Aslam-o-Alaikum, have you gotten the solution of problems. if u have please send me at my email address tnx. Asif Majeed asifmajeedsahal@hotmail.com
View Answer
| January 2, 2011 6:27 AM
Microsoft Access, Oracle 6i, Oracle Forms, Oracle Forms 6i
Rashid bhai Aslam-o-Alaikum, have you gotten the solution of problems. if u have please send me at my email address tnx. Asif Majeed asifmajeedsahal@hotmail.com
View Answer
| January 2, 2011 6:27 AM
Microsoft Access, Oracle 6i, Oracle Forms, Oracle Forms 6i
Recovering database files from failed Brightstor 12 server
As of ARCserve 12.0 the default ARCserve database is SQL Express, however SQL Server can also be used. If the database resides on another system then during the installation of ARCserve just point it to the location of the database and select to not overwrite the database. By detault ARCserve creates a database protection job [...]
View Answer
| December 31, 2010 7:29 PM
Backup and restore, BrightStor, BrightStor ARCserve Backup 12, Database Files, Database Recovery
As of ARCserve 12.0 the default ARCserve database is SQL Express, however SQL Server can also be used. If the database resides on another system then during the installation of ARCserve just point it to the location of the database and select to not overwrite the database. By detault ARCserve creates a database protection job [...]
View Answer
| December 31, 2010 7:29 PM
Backup and restore, BrightStor, BrightStor ARCserve Backup 12, Database Files, Database Recovery
Guidance for starting my career in networking
If u r interested to work as Network specialist, it is better to go for CCNA. CCNA gives u extensive knowledge of networking/switch/router/hub but before changing your field just consult with the right person
View Answer
| December 27, 2010 7:41 AM
IT career planning, IT careers, Networking, Networking careers
If u r interested to work as Network specialist, it is better to go for CCNA. CCNA gives u extensive knowledge of networking/switch/router/hub but before changing your field just consult with the right person
View Answer
| December 27, 2010 7:41 AM
IT career planning, IT careers, Networking, Networking careers
Is it possible on iSeries that an index is defined keeping in mind an sql select criteriea however when the queryis run this index does not get used.
Hi JohnsonMumbai: I do not know for sure since I had asked that question myself, but I think you should use the new index (which I assume is a logical file or view) in your query. Then you can be sure it is used (specially if the query order matched the logical). FlorenJM
View Answer
| December 23, 2010 7:17 PM
Index Performance, iSeries, SQL, SQL Select, V5R4
Hi JohnsonMumbai: I do not know for sure since I had asked that question myself, but I think you should use the new index (which I assume is a logical file or view) in your query. Then you can be sure it is used (specially if the query order matched the logical). FlorenJM
View Answer
| December 23, 2010 7:17 PM
Index Performance, iSeries, SQL, SQL Select, V5R4
Count IIF Statement?
Why not put the criteria of field>0 in your criteria? Then you will only be counting rows where field is > 0 –msi77– Use the following: <pre>sum(IIf(field>0,1,0))</pre>
View Answer
| December 23, 2010 8:52 AM
Access query, IIF, IIF function, IIF statement, Query Design
Why not put the criteria of field>0 in your criteria? Then you will only be counting rows where field is > 0 –msi77– Use the following: <pre>sum(IIf(field>0,1,0))</pre>
View Answer
| December 23, 2010 8:52 AM
Access query, IIF, IIF function, IIF statement, Query Design
SAP modules after MBA in Marketing?
You can go for SAP CRM. this is relating to marketing. Though, u can consult of ur nearest persons for better suggestions. Here provided some links, please visit to gather more knowledge about ur query ! For <a href=”http://itknowledgeexchange.techtarget.com/itanswers/what-is-the-future-of-sap-crm/”>CRM</a> For <a href=”http://itknowledgeexchange.techtarget.com/itanswers/career-prospects-for-sap-fico-consultant/”>SAP</a> For <a href=”http://www.sap.com/solutions/business-suite/crm/featuresfunctions/marketing/index.epx”> Marketing</a>
View Answer
| January 26, 2013 5:38 AM
IT careers, SAP careers, SAP modules
You can go for SAP CRM. this is relating to marketing. Though, u can consult of ur nearest persons for better suggestions. Here provided some links, please visit to gather more knowledge about ur query ! For <a href=”http://itknowledgeexchange.techtarget.com/itanswers/what-is-the-future-of-sap-crm/”>CRM</a> For <a href=”http://itknowledgeexchange.techtarget.com/itanswers/career-prospects-for-sap-fico-consultant/”>SAP</a> For <a href=”http://www.sap.com/solutions/business-suite/crm/featuresfunctions/marketing/index.epx”> Marketing</a>
View Answer
| January 26, 2013 5:38 AM
IT careers, SAP careers, SAP modules
Create QA database with only some production tables
I believe that you are look for a file group backup and restore. That should give you the keywords to find the article you are looking for.
View Answer
| December 16, 2010 8:18 PM
Clone database, Filegroup, QA, SQL scripts, SQL Server 2008, SQL Server tables
I believe that you are look for a file group backup and restore. That should give you the keywords to find the article you are looking for.
View Answer
| December 16, 2010 8:18 PM
Clone database, Filegroup, QA, SQL scripts, SQL Server 2008, SQL Server tables
about visual basic.net
What is the error message ? Are you sure your table name is “tblCustome” and not “tblCustome<b>r</b>” Also, if you used the ampersand (&) to indicate that intCustomerID is a parameter, you should do it this way (assuming that SqlClient was being used) : <pre> command.CommandText = “select * from tblCustomer where CustomerID = :pCustomerId” [...]
View Answer
| December 15, 2010 11:10 PM
Database connectivity, SQL, VB.NET, VB.NET 2003, Visual Basic .NET
What is the error message ? Are you sure your table name is “tblCustome” and not “tblCustome<b>r</b>” Also, if you used the ampersand (&) to indicate that intCustomerID is a parameter, you should do it this way (assuming that SqlClient was being used) : <pre> command.CommandText = “select * from tblCustomer where CustomerID = :pCustomerId” [...]
View Answer
| December 15, 2010 11:10 PM
Database connectivity, SQL, VB.NET, VB.NET 2003, Visual Basic .NET
