1 Resources for

FieldName

Subscribe to this listing via:
RSS
Email

Sponsored White Papers, Webcasts, and Downloads

TechRepublic Resources

A utility to parse fixed length flat files in C# using XML templates: This article is also available as a TechRepublic download, which includes the sample application and the accompanying code.Fixedlength flat files hold data without delimiters between the fields of data.Usually the layout of a fixed length flat file is shown in a series of columnswith each column having a starting point...; Tags: C#, XML, Zach Smith; Technical articles 2007-02-06

Additional Resources

Doing an "indirect" SQL SELECT: Does anyone know how I can do an "indirect" SQL SELECT statement? (one in which the column to return from a table is not named explicitly, but is contained in a variable?)For example, instead of this:SELECT trailer FROM .... WHERE ...I need to be able to do something like this:DECLARE...; Tags: ttobin100@..., SQL, SELECT @FieldName, DECLARE @FieldName nVarChar; Discussion threads 2007-10-08
Access query to combine table fields: How do I construct an Access query to combine table fieldsOpen the query in design viewIn the Lower section, in the Field of teh column where you want to display the joined fields type the formulaExampleFieldname:[First Name] & [Last Name]orFieldname:[First Name]&" " & [Last Name] (if you need space between...; Tags: acampbell@..., First Name, Last Name, Microsoft Access, software; Q&A 2004-10-06
ACCESS DATABASE: Date Field: We use a lot of copying records. Although we have formatted the date field using the input mask (99/99/00;0;_) for a short date (MM/DD/YY) it still records the time. When we copy a record, it does not allow us to change the date of the new record because...; Tags: claire.ringel@..., database, Microsoft Access, new data, software; Q&A 2004-12-01
Access:Have 1field autofill another?: My form has 6 fields and all but 1, have data input via ten-key pad. Is it possible to have one field entry auto fill another (e.g. "MainDTCode"=24 "Code"=Set) without requiring alpha key entry or a "List Box"?Sure you can!If you use the AfterUpdate event on any of your...; Tags: jpadilla, MainDTCode, software, VBA, VBA CODE; Q&A 2005-12-23

Is SQL a legitimate programming language?: Developers often dispute the merits of SQL as a legitimate programming language, but this misses the point. SQL is a powerful 4GL for accessing data.Let’s face it: Bigotry within the ranks of the development community is rampant. Java developers look down on .NET stalwarts, and vice versa. Surprisingly, I’ve noticed...; Tags: Programming languages, Databases, programming, Baseline Inc., programming language, SQL; Technical articles 2002-08-26
MIL - Read Table (zip): MIL - Read Table is a powerful automation tool that can read table from SAP. Using this application, you can instantly view and search table and data from SAP. MIL - Read Table is designed for high flexibility, numerous options enable you to read SAP table that best suits your...; Tags: SAP AG, Microsoft Windows, .Net, Productivity, Operating Systems, Software, Software Development, Software/Web Development; Software downloads 2008-02-05
AccessForm:AfterUpdateEvent code writing: FieldName "MainDTCode" is set for DATA TYPE=text and limits the input range (1-999). I am currently utilizing 1-165 of the range.Each one the those entries requires a corresponding "Code," limited to only: MTN,PRO,OTH,SET and RAW.How do I write the code so that when the user iputs a number into the...; Tags: jpadilla, MainDTCode, software, text field; Q&A 2005-12-23
Getting a Total amount in Access Report: I 'm having trouble getting a total amount to appear in the footer of my Access report. I've been through the Access help documentation, I've written the formula in various ways, I've tried pulling the data from a table and a query, but I always a "#Error". I can drag...; Tags: Microsoft Access; Q&A 2006-03-16
SQL Server, Query Last month, always: I am trying to create a view in microsoft sql server 2005, where it pulls in invoice details for last month, i can use the between command and get it working just fine, but i have to change it every month, the view is used for a report that runs...; Tags: DatePart, GetDate, andresk@..., programming, Microsoft SQL Server; Q&A 2006-07-12
Look in field on form: How can I get Access to look for the last number in a field on a form and add one to that number? (Ex: 258 would become 259)technet.microsoft.com has articles how to do a counter in vb code. which is what i think you want.you would hook macro doing the...; Tags: Dim curY curY, DLast, lwwilliams@..., programming, Rework Number, rookie, Table ACC2000, technet.microsoft.com; Q&A 2006-03-24
Displayging Querie results from multiple tables in a form: I have a form I am using to Edit records from two joined table records. If it finds a match in the second table it works fine. I want to use a copy of the form to add new records to the second table. The first table has the master...; Tags: second table; Discussion threads 2006-01-04
Accessing Text from Word TextBox: i have been working on lots of word document files having same format of data.i cant access the text written in word textbox.i tried a lot but couldn't succeeded.need help badly...................Text Box TextThe easy part is working with the text:Selection.ShapeRange.TextFrame.TextRange.Textwill give you access once the textbox is selected. The tricky...; Tags: accessing, from, macro, Microsoft Word, programming, Silly, text, textbox, word; Discussion threads 2005-08-02
MS Access: I had to create a db with a 1:many relationship of date:on call personnel. short date formatI used a wizard to create the form that is to be published for use throughout the building. On Open, the date is always 1/1/2005; I want the form to consistently open to today's...; Tags: cp03246@..., Microsoft Access, Microsoft Corp., MyDate, software; Q&A 2005-03-24
Look inside the Java Reflection class: Java Reflection is a technology that looks inside a Java object at runtime and sees basically everything about the object that you would know at compile time. Discover the basic techniques involved in Reflection. Java Reflection is a technology that looks inside a Java object at runtime and...; Tags: Java Reflection, Reflection API, Java, Peter V. Mikhalenko, Programming languages, Java Tips Newsletter, Method, Parameter, Class, Object, Field, InvocationHandler, Productivity, Software Development, Software/Web Development; Technical articles 2006-11-08
Immediately convert a Recordset into XML: This article originally appeared on Builder.com.More and more Web application developers are jumping on the XML bandwagon. But a great number of them forge ahead without mastering the essential XML skills. One of the most common signs of this lack of expertise is the way developers create their XML from...; Tags: Phillip Perkins, Recordset, XML, XML-Data; Technical articles 2003-07-21
Immediately convert a Recordset into XML: This article originally appeared as a Web Development e-newsletter.More and more Web application developers are jumping on the XML bandwagon. But a great number of them forge ahead without mastering the essential XML skills. One of the most common signs of this lack of expertise is the way developers create...; Tags: Phillip Perkins, XML, Recordset, XML-Data; Technical articles 2003-06-12
Audit data using SQL Server 2005's COLUMNS_UPDATED function: Auditing data changes in your production environment is very important, especially if you are dealing with confidential information. Besides tracking the data that has been modified, it is also useful to track the individual field names that have been modified. This information is great for your auditing department, and it...; Tags: Function, Audit, Microsoft SQL Server, Auditing, Trigger, Microsoft SQL Server 2005, COLUMNS_UPDATED, COLUMNS_UPDATED Function, System Function, Tim, Databases, Enterprise Software, Software, Data Management, Tim Chapman; Blog posts 2008-05-13
Audit data using SQL Server 2005's COLUMNS_UPDATED function: DBA Tim Chapman looks at how the SQL Server 2005 COLUMNS_UPDATED function works and then discusses how to parse out the field names. Auditing data changes in your production environment is very important, especially if you are dealing with confidential information. Besides tracking the data that has...; Tags: Microsoft SQL Server, Microsoft SQL Server 2005, Tim Chapman, COLUMNS_UPDATED, Databases, Enterprise software, sys.fn_IsBitSetInBitmask, trigger, update statement, audit, SQL Server Newsletter, Function, Auditing, Microsoft SQL Server 2000, Listing B, COLUMNS_UPDATED Function, System Function, Listing C, Software, Data Management; Technical articles 2007-04-16
Inserting and updating records in SQL: After you've developed your skills in mining SQL table data, the next step is to learn how to add and update records. Follow this quick tutorial on using the INSERT and UPDATE commands.In previous SQL tutorials, I’ve demonstrated tricks for using the SELECT command to find and display data stored...; Tags: Programming languages, Databases, Jeff Davis, SQL, new record; Technical articles 2002-07-23

<< Previous
page 1 of 1
Next >>

TechRepublic's Peer To Peer Policy: Peer-to-peer networks--such as BearShare, Kazaa, LimeWire, Morpheus, and others--present numerous significant security threats to organizations. Permi ...; Buy Now

Microsoft Outlook Basics: This ready-to-deliver presentation will help you introduce your team to Microsoft Outlook -- even if you don't consider yourself a public speaker. It ...; Buy Now