Text handling in Visual Basic
if the data file is a simple text file then you can get the data per line using stream reader . please give more details of your question if your trying to say anything else.
View Answer
| October 14, 2008 7:29 PM
Data Extraction, VB.NET, VB.NET 2005, Visual Basic, Visual Basic 2005
if the data file is a simple text file then you can get the data per line using stream reader . please give more details of your question if your trying to say anything else.
View Answer
| October 14, 2008 7:29 PM
Data Extraction, VB.NET, VB.NET 2005, Visual Basic, Visual Basic 2005
Idoc file location
I found the solution. Run Tcode WE21.
View Answer
| October 8, 2008 3:18 PM
iDoc, SAP R/3
I found the solution. Run Tcode WE21.
View Answer
| October 8, 2008 3:18 PM
iDoc, SAP R/3
Help finding duplicate info in Excel in different columns
I think I have a solution for your problem. Take a <b>copy your file for safety</b>. In the copied file You have to write macros to solve the problem. Just <b>copy & paste the code below in a module</b>. Then <b>first, run the macro “FindDuplicate”</b>, to mark duplicate rows. Then check if everything is ok, [...]
View Answer
| October 8, 2008 1:57 AM
Duplicate records, Excel functions, Excel macros, Functions, Microsoft Excel
I think I have a solution for your problem. Take a <b>copy your file for safety</b>. In the copied file You have to write macros to solve the problem. Just <b>copy & paste the code below in a module</b>. Then <b>first, run the macro “FindDuplicate”</b>, to mark duplicate rows. Then check if everything is ok, [...]
View Answer
| October 8, 2008 1:57 AM
Duplicate records, Excel functions, Excel macros, Functions, Microsoft Excel
regarding crystal report formula field
In design mode: Right click the formula field you want to change On the drop down select “Format Field” This should give you the formating options you are looking for Good Luck! -Flame ******************************
View Answer
| October 7, 2008 8:33 PM
Crystal Reports
In design mode: Right click the formula field you want to change On the drop down select “Format Field” This should give you the formating options you are looking for Good Luck! -Flame ******************************
View Answer
| October 7, 2008 8:33 PM
Crystal Reports
PC-2-PC File Copy
If both Pc’s have a USB port (not sure how old your “old” computer is), you could use a USB drive (you can get 2Gig drivers for less than $20 if you shop) as a sort of “taxi” If there is not an quick way to network them, using the USB drive would probably be [...]
View Answer
| October 2, 2008 7:49 PM
File transfers
If both Pc’s have a USB port (not sure how old your “old” computer is), you could use a USB drive (you can get 2Gig drivers for less than $20 if you shop) as a sort of “taxi” If there is not an quick way to network them, using the USB drive would probably be [...]
View Answer
| October 2, 2008 7:49 PM
File transfers
oracle forms 6i, export, import
is it possible for you to use the COMMIT option, at least for testing ? Specifying COMMIT=Y prevents rollback segments from growing inordinately large and improves the performance of large imports, but it is only advisable if the table has uniqueness constraints, so if the import fails and it is restarted, any rows that have [...]
View Answer
| October 1, 2008 9:52 PM
Export, Import, Oracle Forms 6i
is it possible for you to use the COMMIT option, at least for testing ? Specifying COMMIT=Y prevents rollback segments from growing inordinately large and improves the performance of large imports, but it is only advisable if the table has uniqueness constraints, so if the import fails and it is restarted, any rows that have [...]
View Answer
| October 1, 2008 9:52 PM
Export, Import, Oracle Forms 6i
How to mirror two databases (PRD to DEV)?
The AS400 has remote journal capabilities that manage this type of process. But you might as well buy a D.R./H.A. package from Vision Solutions. It’ll be cheaper and faster. It might help you to look at only saving the changed objects. SAVCHGOBJ Perhaps you find that many of the files you’re saving don’t change very [...]
View Answer
| October 1, 2008 4:54 PM
AS/400, AS/400 development, AS/400 FTP, Backup to Disk, Data mirroring, Database mirroring, iSeries
The AS400 has remote journal capabilities that manage this type of process. But you might as well buy a D.R./H.A. package from Vision Solutions. It’ll be cheaper and faster. It might help you to look at only saving the changed objects. SAVCHGOBJ Perhaps you find that many of the files you’re saving don’t change very [...]
View Answer
| October 1, 2008 4:54 PM
AS/400, AS/400 development, AS/400 FTP, Backup to Disk, Data mirroring, Database mirroring, iSeries
crystal report 2008 and visual basic 6
This <a href=”http://msdn.microsoft.com/en-us/vbasic/bb419144.aspx”>interop toolkit</a> allows .NET functionality to be used in VB6. You should be able to use it with ideas from <a href=”http://www.codeproject.com/KB/cs/CrystalHelper.aspx”>This site</a> which discusses using a helper class that allows intergation of VB.NET and Crystal reports. Good Luck! -Flame ******************************************
View Answer
| September 30, 2008 10:22 PM
Crystal Reports, Crystal Reports 2008, VB 6, Visual Basic 6
This <a href=”http://msdn.microsoft.com/en-us/vbasic/bb419144.aspx”>interop toolkit</a> allows .NET functionality to be used in VB6. You should be able to use it with ideas from <a href=”http://www.codeproject.com/KB/cs/CrystalHelper.aspx”>This site</a> which discusses using a helper class that allows intergation of VB.NET and Crystal reports. Good Luck! -Flame ******************************************
View Answer
| September 30, 2008 10:22 PM
Crystal Reports, Crystal Reports 2008, VB 6, Visual Basic 6
Why do IT projects fail?-3
First of all, I absolutely agree with Bob’s points. I had a few additional thoughts: + A very basic reason for project failure is that it does not follow any formal project methodology, which, sadly, is true in too many organizations. Not folling project metholdogies will allow just about anyting to derail any project. It [...]
View Answer
| September 30, 2008 8:11 PM
390, Cabling, Career development, Data analysis, Data mining/analysis, Data warehousing applications, Database, DataCenter, DB2, Desktops, Development, Hardware, Hubs, Linux, Mainframe, Management, Manufacturing applications, Microsoft Windows, Networking, Oracle, OS, Patch management, Project management, Routers, Security, Servers, Software Quality Assurance, Software testing, SQL Server, Switches, Tech support
First of all, I absolutely agree with Bob’s points. I had a few additional thoughts: + A very basic reason for project failure is that it does not follow any formal project methodology, which, sadly, is true in too many organizations. Not folling project metholdogies will allow just about anyting to derail any project. It [...]
View Answer
| September 30, 2008 8:11 PM
390, Cabling, Career development, Data analysis, Data mining/analysis, Data warehousing applications, Database, DataCenter, DB2, Desktops, Development, Hardware, Hubs, Linux, Mainframe, Management, Manufacturing applications, Microsoft Windows, Networking, Oracle, OS, Patch management, Project management, Routers, Security, Servers, Software Quality Assurance, Software testing, SQL Server, Switches, Tech support
Future in Database management systems
The IT boom pretty much ended in the late 90s. These days getting the high paying jobs takes years of experience to get into. That said, there are many high paying jobs in the database field. It will however take several years of work to get into these positions. Long gone are the days of [...]
View Answer
| September 28, 2008 6:58 PM
Career development, DBMS, IT careers, IT jobs
The IT boom pretty much ended in the late 90s. These days getting the high paying jobs takes years of experience to get into. That said, there are many high paying jobs in the database field. It will however take several years of work to get into these positions. Long gone are the days of [...]
View Answer
| September 28, 2008 6:58 PM
Career development, DBMS, IT careers, IT jobs
What constitute as System Migration?
Yes that would absolutely be considered a system migration. A system migration is any time that you are converting from one application to another or moving from one physical server to another. If you are doing both at the same time it is also a system migration, all be it a more complex one.
View Answer
| September 28, 2008 7:22 AM
Database migration, Migration, Software migration, system migration
Yes that would absolutely be considered a system migration. A system migration is any time that you are converting from one application to another or moving from one physical server to another. If you are doing both at the same time it is also a system migration, all be it a more complex one.
View Answer
| September 28, 2008 7:22 AM
Database migration, Migration, Software migration, system migration
Crystal Reports and varchar(MAX) not printing
I know that with SQL 2000 servers using the TEXT fields someone the TEXT column would only work correctly if the TEXT column was the last column in the recordset. Try moving the column to the end of the recordset and see if that helps.
View Answer
| September 28, 2008 6:09 AM
Crystal Reports, VARCHAR, Vista compatibility, Visual Studio 2005
I know that with SQL 2000 servers using the TEXT fields someone the TEXT column would only work correctly if the TEXT column was the last column in the recordset. Try moving the column to the end of the recordset and see if that helps.
View Answer
| September 28, 2008 6:09 AM
Crystal Reports, VARCHAR, Vista compatibility, Visual Studio 2005
CRM on demand versus on premises solutions?
Since “On-demand” refers to services/applications that usually reside on a server at a remote site, I think that if integration is an important factor, the best choice could be an on-premises solution, but some other factors need to be taken into consideration, such as time of implementation (which is usually bigger with a on-premise solution), [...]
View Answer
| September 26, 2008 7:31 PM
CRM integration, CRM on demand, ERP, Oracle, SAP
Since “On-demand” refers to services/applications that usually reside on a server at a remote site, I think that if integration is an important factor, the best choice could be an on-premises solution, but some other factors need to be taken into consideration, such as time of implementation (which is usually bigger with a on-premise solution), [...]
View Answer
| September 26, 2008 7:31 PM
CRM integration, CRM on demand, ERP, Oracle, SAP
Problem in Crystal report null value.
This may not be exactly what you are looking for, but, it is not possible for you to change your query using the ISNULL function on the fields that can contains NULLS ? (I’m assuming that when you say “blank” you mean null). If your field is of date type, you might want to change [...]
View Answer
| September 25, 2008 10:17 PM
Crystal Reports, Crystal Reports 2005, VB.NET 2005
This may not be exactly what you are looking for, but, it is not possible for you to change your query using the ISNULL function on the fields that can contains NULLS ? (I’m assuming that when you say “blank” you mean null). If your field is of date type, you might want to change [...]
View Answer
| September 25, 2008 10:17 PM
Crystal Reports, Crystal Reports 2005, VB.NET 2005
ERP form error message on a SQL database
It could be useful to know some more details about your database and forms versions. It sounds to me like a network issue, but I think it could also be that the database connection is timing out due to some database/sqlnet setting. Is there some network device between the database and the application (or app [...]
View Answer
| September 25, 2008 7:05 PM
ERP, SQL, SQL Database, SQL Server errors
It could be useful to know some more details about your database and forms versions. It sounds to me like a network issue, but I think it could also be that the database connection is timing out due to some database/sqlnet setting. Is there some network device between the database and the application (or app [...]
View Answer
| September 25, 2008 7:05 PM
ERP, SQL, SQL Database, SQL Server errors
Converting numeric dates
This <a href=”http://www.kenhamady.com/form02.shtml”> Site </a> has a formula to covert both 8 character dates like YYYYMMDD (The type your looking for) as well as 6 character dates MMDDYY. Good Luck -Flame ******************************************************
View Answer
| September 24, 2008 7:34 PM
Alphanumeric conversion, Crystal Reports, Crystal Reports 8.5
This <a href=”http://www.kenhamady.com/form02.shtml”> Site </a> has a formula to covert both 8 character dates like YYYYMMDD (The type your looking for) as well as 6 character dates MMDDYY. Good Luck -Flame ******************************************************
View Answer
| September 24, 2008 7:34 PM
Alphanumeric conversion, Crystal Reports, Crystal Reports 8.5
How can i connect DB and input values in stored procedures using VBA
This article on <a href=”http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1318837,00.html”>SQL Injection Attacks</a> shows how to use .NET. VBA should be similar.
View Answer
| September 23, 2008 7:51 AM
DB2, Stored Procedures, VBA
This article on <a href=”http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1318837,00.html”>SQL Injection Attacks</a> shows how to use .NET. VBA should be similar.
View Answer
| September 23, 2008 7:51 AM
DB2, Stored Procedures, VBA
Error messages in Business Intelligence Development Studio on SQL Server Integration Sevices
Try reinstalling the client tools and reapplying the latest service pack and hotfix. This should force all the dlls to be re-registered.
View Answer
| September 20, 2008 11:06 PM
Business Intelligence, SQL error messages, SQL Server, SSIS
Try reinstalling the client tools and reapplying the latest service pack and hotfix. This should force all the dlls to be re-registered.
View Answer
| September 20, 2008 11:06 PM
Business Intelligence, SQL error messages, SQL Server, SSIS
ERP re engineering
Yes you are right, the ERP systems have their origin in Business Process Re-engineering. Earlier there were heterogeneous system not talking to each other and a need was felt for an ERP system which will encompass all functions. BPR study would form a basis for designing good ERP.
View Answer
| September 20, 2008 5:32 AM
BPR, Business Process Reengineering, ERP
Yes you are right, the ERP systems have their origin in Business Process Re-engineering. Earlier there were heterogeneous system not talking to each other and a need was felt for an ERP system which will encompass all functions. BPR study would form a basis for designing good ERP.
View Answer
| September 20, 2008 5:32 AM
BPR, Business Process Reengineering, ERP
in dbms
In general, the conceptual model is built before the logical model, and it is more abstract, including only the most important entities/relations. Some information can be found <a href=”http://www.1keydata.com/datawarehousing/data-modeling-levels.html”>here</a> and <a href=”http://www.aisintl.com/case/CDM-PDM.html”>here</a> Hope this helps. -Carlosdl
View Answer
| September 19, 2008 3:37 PM
Conceptual model, DBMS, Logical model
In general, the conceptual model is built before the logical model, and it is more abstract, including only the most important entities/relations. Some information can be found <a href=”http://www.1keydata.com/datawarehousing/data-modeling-levels.html”>here</a> and <a href=”http://www.aisintl.com/case/CDM-PDM.html”>here</a> Hope this helps. -Carlosdl
View Answer
| September 19, 2008 3:37 PM
Conceptual model, DBMS, Logical model
