Solved

ADO and Autoinc

Posted on 2004-08-18
2
292 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
  • 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

685 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