Duplicating records in a table with a SQL query
You could do it this way: <pre>INSERT INTO YourTable SELECT * FROM YourTable GO</pre>

View Answer   |  January 14, 2009  7:01 PM
Duplicate records, SQL queries, SQL tables

Problem with delimiter in CPYTOIMPF
Hi, I suspect it’s a problem with the CCSID or Code Page – the FROMCCSID, TOCCSID and STMFCODPAG parameters on the CPYTOIMPF command. Have you tried specifying *PCASCII or *STDASCII for STMFCODPAG? Regards, Martin Gilbert.

View Answer   |  January 13, 2009  11:25 AM
CL/400, CPYTOIMPF, Pipe symbol, Pipe-Delimited Text File

inventory
Wrong question — any DBMS will store inventory information. The DBMS is just a fancy box to store the data in. You will need tools to enter and maintain the inventory. These would be programs. Question you should ask is – What software should I use for managing inventory Include as many details as you [...]

View Answer   |  January 12, 2009  8:53 PM
DBMS, Inventory management software

AutoCAD
Snap to object. Hope this helps! -Schmidtw

View Answer   |  January 11, 2009  6:57 PM
AutoCAD, Autocad 2007

Sending a print job to two separate printers using VB 6
There are actually a few methods to do this: One, you could have the document print to a file. Then a batch file runs and sends it to two different printers. Two, you could use a print server, which would simultaneously drive all printers. (probably my favorite and most reliable option) Hope this helps! -Schmidtw

View Answer   |  January 11, 2009  6:38 PM
Crystal Reports, Crystal Reports printing, Printers, Software development, Visual Basic 6, Visual Basic printing

DB2 SQL Confusion
To be able to help, I think we would need to know your table structures, and see what results are you getting and what results are you expecting with some example data. When joining tables, if you do not write the appropriate join conditions, you could be duplicating rows.

View Answer   |  January 9, 2009  9:45 PM
DB2, DB2 SQL, SQL

conditional formatting in crystal reports 8.5
Please provide your format so we may help you.

View Answer   |  January 9, 2009  9:08 PM
Crystal Reports, Crystal Reports 8.5, Crystal Reports Conditional Formatting

Crystal Reports fields truncating error
Look at the Regional Settings for both computers.

View Answer   |  January 9, 2009  9:04 PM
Crystal Reports, Crystal Reports 8.5, Crystal Reports Errors

Changing databases at run time in SQL Server 2005
You may try using Exec SP_ExecuteSQL in SQL Server, or ADO.NET and the System.Data.SQLClient Namespace. – Parameters for Stored procedure @DataBase_Name nVarchar(20) – set variables in SQL Declare @sql_All nVarchar(1024), @sql_Select nVarchar(1024), @sql_From nVarchar(1024) /* @sql_Where nVarchar(1024), @sql_Order nVarchar(1024) */ set @sql_Select = ‘ Select field1, field2′ + CHAR(13) set @sql_From = ‘ From ‘ [...]

View Answer   |  January 9, 2009  8:57 PM
Crystal Reports 8.5, SQL Server 2005, Visual Basic 6

How do I get a message to show when the report doesn’t return any data?
Hi, I’m not familar with Crystal but Access reports have a On No Data function where you can have a message box come up. If you don’t have that function then you can try doing a DCount on the query that runs the report and if it’s 0 then don’t run the report but show [...]

View Answer   |  January 9, 2009  5:08 PM
Crystal Reports, Crystal Reports Errors

Crystal Reports XI – Moving Grand Totals for several different types and totals within a group in a subreport to the main report
Crystal variables can have a “shared” scope that allows them to be shared between main reports and subreports. To pass the total calculated in the subreport back to the main report, you can declare that variable to be Shared in formulas in both the main and subreports. After the subreport has executed for a group, [...]

View Answer   |  January 8, 2009  6:53 PM
Crystal Reports, Crystal Reports Subreport, Crystal Reports XI

Crystal Reports can’t connect to Access 2007
http://www.microsoft.com/downloads/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en This download will install a set of components that can be used by non-Microsoft Office applications to read data from and write data to 2007 Office system files such as Microsoft Office Access 2007 (mdb and accdb) files and Microsoft Office Excel 2007 (xls, xlsx, and xlsb) files. Connectivity to text files is also [...]

View Answer   |  January 8, 2009  3:30 PM
Access 2007, Crystal Reports, Crystal Reports XI, Crystal reports Xi to Access 2007, Microsoft Access

Data Area Lock issue in RPG ILE
Hi, I don’t think what you want to do is going to be very easy to achieve. What you may be able to do is find out which sessions have a lock on the data area and either end the sessions using ENDJOB or send the sessions a message requesting the users to exit their [...]

View Answer   |  January 8, 2009  11:39 AM
Data Area, Data Area Lock, RPG, RPG ILE

Code to upload CSV file to AS400
Look at the CPYFRMIMPF command

View Answer   |  January 7, 2009  6:14 PM
CSV, CSV to AS400

How to convert DBGrid database information to text files with VB 6
in VB programme create all text variable like grid coloumn, all variable type is text. and then type following code i.e. in grid their r 4 col. srno as string * [20] name as string * [50] Addr as string * [90] mobile as string * [10] dim i fopen (“c:result.txt”) for i=0 to dbgrid.rows-1 [...]

View Answer   |  January 7, 2009  7:14 AM
Data conversion, Database programming, DBGrid, VB 6, Visual Basic, Visual Basic 6

Query/physical file headings
1. Use the ODBC Data Source Administrator tool of Client Access to setup a DSN using the library that your file is in and the IP address of your as400. 2. Open Excel 3. Data -> From other Source -> From Microsoft Query (make sure Microsoft Query is installed. If it isn’t, just use the [...]

View Answer   |  January 7, 2009  2:27 AM
CVS, Microsoft Excel, Physical File

Integrate Legacy Data and SAP data in BI
Hi BI dude Both solutions are worthwhile. Solution A – Loading into SAP and then loading from SAP to BI in the usual process: SAP team’s concern could be that it is a pretty good volume – 20,000 emp. This could impact the resources/performance in SAP. Solution B: This would be better I believe. I [...]

View Answer   |  December 30, 2008  11:04 PM
HCM, Legacy Data, SAP BI, SAP BW, SAP HR

crystal reports in delphi
The Delphi upgrade may have changed your data source names. You will find your data sources in the administrative tools in the control panel. You could start by checking the Data Sources (ODBC) in this control panel More info is <a href=”http://msdn.microsoft.com/en-us/library/ms188691.aspx”>Here</a>. This <a href=”http://www.ianywhere.com/developer/product_manuals/sqlanywhere/0902/en/html/dbdaen9/00000076.htm”>page</a>gives a good overview of the process. Good Luck! -Flame

View Answer   |  December 30, 2008  9:22 PM
Crystal Reports, Delphi, Delphi 5

ECM vs CM
A content management system (CMS) is a computer application used to create, edit, manage, search and publish various kinds of digital media and electronic text.[1] CMSs are frequently used for storing, controlling, versioning, and publishing industry-specific documentation such as news articles, operators’ manuals, technical manuals, sales guides, and marketing brochures. The content managed may include [...]

View Answer   |  December 29, 2008  1:58 PM
CM, ECM

AS400
Hi, Yes, there are plenty of field level keywords – for example :- COLHDG TEXT EDTCDE EDTWRD REFFLD VALUES Regards, Martin Gilbert.

View Answer   |  December 29, 2008  11:59 AM
DB2