Re: Create Table and Integer

From: Brian Bushay TeamB <BBushay@xxxxxxxxx>
Date: Thu, 05 Jan 2006 21:43:30 -0600

>Win2K, D7, ADO, Access DB
>
>Is there any way to distinguish between INTEGER and LONG INTEGER in a CREATE
>TABLE sql statement?
>

Jet Data Type Synonyms Storage Size
TINYINT INTEGER1, BYTE 1 byte
SMALLINT SHORT, INTEGER2 2 bytes
INTEGER LONG, INT, INTEGER4 4 bytes
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.

References:
- Create Table and Integer
  - From: Bob Berry

Prev by Date: Re: create ACCESS 2003 database at runtime
Next by Date: Re: How can I access the fields of TADOStoredProc?
Previous by thread: Create Table and Integer
Next by thread: Re: Tracking Changes in an ADOQuery
Index(es):
- Date
- Thread

Relevant Pages

Re: ADO Behaving VERY badly...
... > VB6 and VBScript to retrieve ADO Recordsets for a number of individual SQL ... > two second pause, and a few more statements will execute, then another ... It's not dependent on the SQL statement being issued, ... This database is pretty tight, normalized, and indexed ...
(microsoft.public.data.ado)
filling a dataset with two tables using a single query
... Consider a SQL statement like this: ... In ADO, the following code will locate the record and if found, update both ... in two separate trips to the DB. ... Load the resultset as an untyped dataset or use a datareader. ...
(microsoft.public.dotnet.framework.adonet)
Re: Update on my problem
... end up as null by the time they get to a MDB database (via ADO). ... involving (Surprise! ... "Brian Bushay TeamB" wrote in message ...
(borland.public.delphi.database.ado)
Re: ADO Timestamps
... not worry about date and time format conversion if you use ADO. ... if you need to execute SQL statement all you need to do is to use Command ... If you declare datetime parameters using proper datatype then it ...
(microsoft.public.vb.database.ado)
Re: Updatable View with ADO and Trigger INSTEAD OF
... By default ADO/ADO.NET will generate INSERT SQL statement based on ... statements in ADO with the Command object to execute actual INSERT ... "Martino" wrote in message ... > Is there a vay to force ADO to generate insert for the view and not for ...
(microsoft.public.data.ado)