Where does Silverlight fit into Web development?
<b>Silverlight</b> is a new cross-browser, cross-platform implementation of the<b> .NET Framework</b> for building and delivering the next generation of media experiences and <b>Rich Interactive Applications(RIA)</b> for the web. It runs in all popular browsers, including Microsoft Internet Explorer, Mozilla Firefox, Apple Safari, Opera. The plugin required to run<b> Silverlight </b>is very small in size hence [...]

View Answer   |  June 12, 2009  5:02 AM
Silverlight, Web development

How do I prevent from losing the first position of a non “0″ field?
Sorry this keeps crashing on me. Just this part — year? substring(concat(’00′,TRNYDS),2,2), assuming that perhaps 2009 is blank9 and 2010 is 10 1. Trim(TRNYDS) will make it 9 or 10 .. no blank 2. CONCAT(’00′,Trim(TRNYDS)) makes it 009 or 0010 3 now you want the substring of the last 2 If you have a left [...]

View Answer   |  June 11, 2009  11:13 PM
Concatenate

email macro
Where does this macro run? Is it from another application? Within excel itself? Please try to be more specific. -Schmidtw

View Answer   |  June 11, 2009  6:30 PM
Excel macros, Microsoft Excel, Outlook

Send email with Chinese character on it
You have to install East Asian language support for the OS, otherwise the characters will remain unrecognized. Hope this helps! -Schmidtw

View Answer   |  June 11, 2009  6:15 PM
ASCII, DBCS, Email

Emulators for AS/400
Thank you for visiting ITKE. We are happy to help you with solving specific IT questions, but need as much information as possible to do so. Let us know about the problem you are trying to solve, how you are approaching it and what work you’ve done so far, and we can help guide you [...]

View Answer   |  May 14, 2013  5:47 PM
AS/400 Emulator, Emulators

Copy Data from an entire row in Excel 2003 Sheet to another sheet in the same workbook automatically
There is excel syntax for making a cell in one spreadsheet equal to the data in another cell in a different spreadsheet. This means you change one field and the rest of the data changes. For example, cell A5 in “Yearly Data” contains value “=’December”!A8″. A5 of Yearly Data now is equivalent to A8 of [...]

View Answer   |  June 11, 2009  5:47 PM
Excel 2003, Excel formulas, Excel worksheets, Microsoft Excel

Oracle PL/SQL Toad for Oracle-How to make editor generate a script for tables,views,packages so that the script can be searched
All the (non-obfuscated) source code for stored procedures and functions can be accessed in the DBA_SOURCE view. If you just want to find all the code objects that contain a particular word, that is a simple query: select * from dba_source where upper(text) like upper(‘%<word>%’) However, when you ask for words contained in comments, that [...]

View Answer   |  June 11, 2009  3:49 PM
Oracle, Oracle PL/SQL, PL/SQL, TOAD

Best practices for approaching an IT Project
The best approach to any project is planning. Start basic, what are your MAIN goals; literally, ultimately what are you looking for. Second, create sub-goals (repeat if necessary). Third, determine the steps necessary to create each goal. Although you gave very limited details, I will try to help. For you project, you must answer these [...]

View Answer   |  June 11, 2009  2:44 PM
IT best practices, IT project management, Project management

How to remove tmp files in Crystal Reports 8.5
Crystal Reports may generate some temporary files (‘*.tmp’, ‘*.rpt’) in a temp folder (typically the c:windowstemp folder or you temp folder in “Local Settings”). This is not a big deal because these files are quite small (between 0k and 200k for the ones I have seen during my investigations) but it can be a potential [...]

View Answer   |  June 11, 2009  2:58 AM
Crystal Report 8.5, Crystal Reports, Temporary files, VB 6, Visual Basic 6

Concatenation
Please show the entire SQL statement. It is impossible to know what you are doing by looking at the fragment. Table definition info would also help. KCCrosser – If you are trying to ensure the month and day are 2-digits with leading zeros, the easy way is to use: set @monthstring = right(’0′ + convert(varchar(2),month(<date>)),2) [...]

View Answer   |  June 10, 2009  11:35 PM
Concatenate, SQL Query, SQL Select, Substring

Duplicating Form FieldsAccess 2007
One way to do it would be to copy the current record with Crrl-C or in the Edit Menu, select Copy. Then in the Edit Menu, select Paste Append. Then change your PK and save the record. In code, you could do: Dim rs as recordset Set rs = currentdb().OpenRecordset(“Select * From table Where PK [...]

View Answer   |  June 10, 2009  1:58 PM
Access 2007, Access forms, Microsoft Access

How to make a setup file in Visual Basic
Moderator Note: Have you tried the new search feature? Take a look at the results for “setup visual basic.” I had searched and succeded

View Answer   |  March 15, 2013  12:29 PM
Package and Deployment wizard, VB Setup File, Visual Basic

Creating a list in one Excel cell by referencing several other cells
Adventurous way to use excel. Apart from the large RAM requirement to run the queery, it would be a pig to administer. So, unless you have a definate reason for doing it this way, I’d use a db in the following way. I think I would have created an Access db with the symptom in [...]

View Answer   |  June 9, 2009  7:59 PM
Concatenate, Microsoft Excel, Microsoft Excel formulas

Parameter list is not refreshed from previous calls
Because the command is reusing space, you will see previous values in a list even if they are not now ‘valid’. In a simple list in a command definition, the first two bytes of the parameter passed to the CPP and to the validity checker are a binary number which tells you the number of [...]

View Answer   |  June 9, 2009  2:45 PM
AS/400, CL programming, Command Source, COMMANDS, CPP, iSeries, Parameter list -AS400, Validation

Separating dates into year, month and day componrents
To do this, use Text to Columns. Select the column where you have the dates, go to Data, Text to Columns, select Delimited in Step 1, in Step 2 make sure that the “other” checkbox is activated and put a “/” in the box to the right of the other checkbox. Finally, in step 3 [...]

View Answer   |  June 9, 2009  1:31 PM
Date conversion, Excel 2002, Excel 2007

How to get data from a Web-installed Microsoft Access database from VB6
Unless there is more to the problem than you’ve stated, either change your OpenDatabase command to the correct path: Set OpenDB = OpenDatabase(“x:path”) or change the location of the database in the Data control.

View Answer   |  June 8, 2009  5:18 PM
Database connectivity, Database-driven website, Microsoft Access 2003, VB6, Visual Basic 6, Web development

Debugging a Copybook
Yes – in CBL-ILE When you’re creating the module Debug view option: DBGVIEW Debug view . . . . . . . . . . > *SOURCE <– includes copy books Phil

View Answer   |  June 8, 2009  1:27 PM
COBOL debugging, Copybook, Debugging

How to export meta-data
As I understand this question – you are able to run the DSPFFD command to a file. If you use *ALL for the object you will capture all files in a library. This will have to be repeated for each library with *ADD for the member rules. Using SQL or Query/400 you can create a [...]

View Answer   |  June 7, 2009  12:24 PM
AS/400, AS/400 backup, AS/400 database, AS400 Data Definitions, AS400 Data Model Export, AttachMate and AS400, Metadata, XML

How to use API’s , SNDDTAQ & RCVDTAQ ?
SndDtaQ and RcvDtaQ are not API’s they are commands in TaaTools http://taatool.com/document/L_snddtaq.htm API’s are QSndDtaQ and QRcvDtaQ Examples are easy to find on Google. Phil

View Answer   |  June 5, 2009  6:03 PM
API, RCVDTAQ, RcvDtaQMsg, SNDDTAQ

error detected by database DLL
Can you run the report manually? Is it password protected? If so you need to supply the login info/

View Answer   |  June 5, 2009  4:01 PM
Crystal Reports, Crystal Reports Database, DLL