datatype

TechRepublic Resources

• sort by:
• Relevance
• Date
• Popularity

Comparing Double vs. Single data types in VB6

Decimal datatype claimPeter,I must disagree with your Decimal datatype claim that "unfortunately, it was never actually implemented." It and the scaled integer datatype, Currency, are actually variant objects that behave as a particular datatype. As such, they don't perform as well as the intrinsic numeric data types.===================================Try the...

Tags: aikimark@..., CDec, datatype, Microsoft Visual Basic 6.0, programming, vb

Discussion threads 2005-12-02

Specify data types in Access parameter queries

What if the query is too complex for the design view ?This article is fine for those who use the query design view. But, in the world of real applicstions, some SQL queries are reported by the design view wizard as being "... too complex ... ". In such cases,...

Tags: access, datatype, hardware, kaspencer, Microsoft Access, parameters, queries, SQL, SQL View

Discussion threads 2005-05-25

Oracle Tip: Use IEEE 754 FLOAT and DOUBLE datatypes in Oracle 10g

Oracle stores numbers with the NUMBERdatatype in an unusual format, with bytes in binary-coded decimal(where the byte hex value 0x99 represents 99 decimal). ANSIstandard datatypes such as INTEGER, FLOAT, and DOUBLE are aliasesfor the NUMBER datatype, with extra restrictions: INTEGER datatypesdon't allow decimal, FLOAT, and DOUBLE to restrict the number...

Tags: Programming languages, Databases, Oracle Application Server 10g, Scott Stephens, trade-off, Oracle Corp., datatype, significant digit

Technical articles 2004-06-02

SQL Server 2000 offers key enhancements

Microsoft SQL Server 2000 has introduced new datatypes, user-defined counters, and recovery options. Discover how to put these features to work.By Tim BradleyMicrosoft SQL Server 2000 has introduced many new features, including additional datatypes, user-defined counters, and recovery options. Here's an overview of these features and a look at how...

Tags: Performance management, Databases, Guest Contributor, datatype, Microsoft SQL Server, counter, user-defined counter, v2K, Microsoft SQL Server 2000, transaction log backup, BULK_LOGGED, performance

Technical articles 2002-03-11

Additional Resources

Supporting RFID-Based Item Tracking Applications in Oracle DBMS Using a Bitmap Datatype

This paper addresses the problem of efficiently modeling identifier collections occurring in RFID-based item-tracking applications and databases. The proposed bitmap datatype can model a collection of generic identifiers, including 64-bit, 96-bit, and 256-bit Electronic Product Codes EPCs, and it can be used to represent both transient and persistent identifier collections....

Tags: Oracle Corp., DBMS, Bitmap, RFID, Databases, Wireless, Security, Biometrics, Enterprise Software, Software, Data Management

White papers 2005-07-19

Towards an Industrial Strength SQL/XML Infrastructure

XML has become an attractive data processing model for applications. SQL/XML is a SQL standard that integrates XML with SQL. It introduces the XML datatype as a native SQL datatype and defines XML generation functions in the SQL/XML 2003 standard. The goal for the next version of SQL/XML is integrating...

Tags: SQL, XML, Programming Languages, Databases, Software/Web Development, Web Development, Software Development, Enterprise Software, Software, Data Management

White papers 2004-07-21

passing adodb rst into an array

can i pass a adodb rst into an array using vb code? if so how can i retrieve my rst from the array? thx!!Bit more infoBy rst I presume you mean recordset ?Do you want an array of recordsets.Do want want to access all the records or just the one...

Tags: rst

Q&A 2005-05-13

Limit to field size

Is there a limit to the number of characters that can be written to a text field in an Access form?255 characters. Look at the DataType options in design view again. There is one called "Memo" for potentially exceeding that.

Tags: marlenee

Q&A 2006-03-01

Copy legacy Oracle tables with SQL*Plus

Tables with a LONG datatype cannot be copied via the CREATE TABLE AS SELECT syntax. They can, however, be copied with the SQL*Plus COPY command. Bob Watkins shows you how in this Oracle tip. You may be running Oracle 10g Release 2, but the applications you're supporting may...

Tags: Oracle Corp., Bob Watkins, LONG RAW, Oracle Tips Newsletter, Downside, Corporate Communications, Storage, Databases, Marketing, Hardware, Enterprise Software, Software, Data Management

Technical articles 2007-04-24

eMbedded Visual C++ 4.0 Update 5636 (msi)

When you use eMbedded Visual C++ 4.0 SP4 to build Microsoft Windows CE-based projects for the ARM processor, the ARM compiler may generate code that causes a Datatype Misalignment exception at run time. This problem occurs when the following conditions are true: You access memory by using a BYTE pointer....

Tags: ARM, Microsoft Visual C++, Microsoft Corp., Microsoft Windows CE, Microsoft Development Tools, Microsoft Windows, Programming Languages, Development Tools, Handhelds, Operating Systems, Software, Software Development, Software/Web Development, Hardware

Software downloads 2007-08-29

Learn Oracle: Datatypes for SQL and PL/SQL, Dates

Use the article index for more articles on this subject.Oracle10g provides three types of date related datatypes: date, timestampsand intervals. Today I will be talking about all three of these.DATETheDATE datatype is a datetime datatype. It stores a date and a time. Thedate portion is based on the number of...

Tags: Oracle Corp., PL/SQL, SQL, these.DATEThe DATE

Blog posts 2006-08-07

Five XSLT 2.0 Features That Simplify XML Document Transformations

XSLT is a powerful language that has been widely used to transform XML documents. However, XSLT in its current 1.0 version has limitations that can make writing stylesheets difficult and complex. This paper describes five new features in XSLT 2.0 that will help overcome these limitations. The five features discussed...

Tags: XSLT, XML Document, XML, Software/Web Development, Web Development

White papers

PL/XML - XML Based Scripting for PL/SQL

I started working on atask for a project and decided that there were some very goodproperties that I could use to help me teach people PL/SQL and XML. Iexpanded a bit on the idea and ended up with a scripting language,implemented in XML, that can be passed into a PL/SQL...

Tags: 15:06:59MyValue, PL/SQL, XML

Blog posts 2006-09-22

Learn Oracle: Datatypes for SQL and PL/SQL, Numbers

Datatypes are a subject thatconfuses many people. There are many types and many sub-types. A typeis a basic datatype like NUMBER. A sub-type is derived from a type. AnINTEGER is a sub-type of NUMBER. A sub-type usually add a constraint toa type and that creates the new sub-type; for INTEGER,...

Tags: sub-type, Oracle Corp., PL/SQL, SQL

Blog posts 2006-07-30

XML Schema: Understanding Datatypes

The W3C XML Schema Datatype Specification defines numerous datatypes for validating the element content and the attribute value. These datatypes can be used to validate only the scalar content of elements, and not the non-scalar or mixed content. The text enclosed between the and element tags, and the value of...

Tags: XML Schema, W3C XML Schema Datatype Specification, XML, Software/Web Development, Web Development

White papers

Learn PL/SQL: Declaring Variables, Named vs Anonymous Blocks

This is part 2 of a series on learning PL/SQL. If you are new to PL/SQL, you should read part 1 first. Also, check out the Article Index. Declaring VariablesWe'vespoken about the declaration section of a PL/SQL block. The declarationsection is the first section of a block....

Tags: Programming languages, Databases, PL/SQL, declaration section

Blog posts 2006-07-30

ODBC Access 2003 to SQL 2000

I am presently using a ODBC link to link my Access database to an SQL server 2000. The database seems to be fine in most respects except on occassion a Write Conflict error comes up saying someone is in the tables and the record cannot be updated. You...

Tags: gwIT, Microsoft Access, ODBC, ODBC Link, software, SQL

Discussion threads 2004-12-13

Building a data values dictionary with SQL

When a client asked a developer to construct a data values dictionary, the client was actually referring to a list of the distinct values in various columns and tables. Check out the basic SQL that was developed to fulfill this client's request. TechRepublic's free SQL Server newsletter, delivered each...

Tags: SQL, Databases, Arthur Fuller, Programming languages, data values dictionary, distinct value, SELECT DISTINCT, SQL Server Newsletter, TechRepublic Inc., Procedure, Column, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

Technical articles 2005-04-25

Use VB6's TypeOf keyword to work with controls

While working this is very very inneficientHello Peter,This is a very nice trick which you can use in many ways. But there a catch here, its works but it's slow.2 reasons behind this. 1st - You're accessing the ctl in late-binding. It is always slower and moreover...

Tags: iterator, myrdhrin, Object sngStart, optimization, programming, Select Case, TypeName, TypeOf, TypeOf operator, vb

Discussion threads 2006-01-27

EASYSQL (exe)

EasySQL Tool using MS ADO 2.0 is a SQL script building tool. It lets you build mssql server data objects SQL scripts, open table, view to browse data, and batch build data, objects SQL scripts, save batch build project, execute SQL scripts or check syntax simultaneously. EasySQL2.0 can build all...

Tags: SQL, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

Software downloads 2005-12-08