Solved

How to make a MS Access field 'Allow Zero Length' = true

Posted on 2004-09-10
6
335 Views
Last Modified: 2010-04-05
How to make a MS Access field 'Allow Zero Length' = true from delphi
in CREATE database dunction?
0
Comment
Question by:djuzoran
  • 3
  • 2
6 Comments
 
LVL 22

Expert Comment

by:Ferruccio Accalai
ID: 12025222
You mean a Text field?
If you do not specify nothing it is intended as it can accept zero length, otherwise it must be declared as Not Null

for example:

create table MyTable(MyField Text(10), //accept zero length
                               MySecondField(19) not null, //value is required
                               MyThirdField Integer);

0
 

Author Comment

by:djuzoran
ID: 12025233
So
MyField Text(10)

is not the same as

MyField Varchar(10) ?

0
 
LVL 22

Expert Comment

by:Ferruccio Accalai
ID: 12025267
Yes it's the same, btw forgot mi last comment, it's about required property, not zero length, sorry
0
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 

Author Comment

by:djuzoran
ID: 12025293
So what should i write for nullable and zero length column?

0
 
LVL 27

Accepted Solution

by:
kretzschmar earned 125 total points
ID: 12025329
0
 
LVL 22

Expert Comment

by:Ferruccio Accalai
ID: 12025346
Well i was looking at it at all but look at here also http://support.microsoft.com/default.aspx?scid=kb%3BEN-US%3BQ217156
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
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…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

743 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now