Solved

ADO and Autoinc

Posted on 2004-08-18
2
294 Views
Last Modified: 2010-04-05
I am using MQ SQL and Access tables. In MS-SQL, I use the identity clause with a LongInt to allow for autoincrementing. When I use Access, I use the AutoInc datatype.

I would like to use either Access or MS-SQL tables from within my program. However, the datatypes are stored differently within the form. Depending on the database used, one is stored AutoInc and the other is LongInt.

Is there anyway to rectify this problem? (i.e. can I make Delphi think they are both LongInt without losing the AutoInc capability?)
0
Comment
Question by:CalvinDay
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 13

Accepted Solution

by:
BlackTigerX earned 250 total points
ID: 11836576
you can treat both of those ase LongInt in your Delphi code
0
 
LVL 13

Expert Comment

by:BlackTigerX
ID: 11836610
AutoInc field is actually defined as:

TAutoIncField = class(TIntegerField)
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Suggested Courses
Course of the Month6 days, 5 hours left to enroll

626 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question