Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium



Posted on 2003-03-30
Medium Priority
Last Modified: 2010-04-04
I am using Delphi 6 and Microsoft Jet 4.0 OLE DB Provider to get a connection to a “.mdb-database”. The SQL-statement “create table testtable (textfield VarChar(10) NOT NULL)” creates a new table with the textfield ‘textfield’. It is not allowed to put a NULL-value in this field. But it is also not allowed to put an empty string in this field. The setting allowzerostring is false. How can I change this setting, so that empty strings are accepted? (I am using the ADO-components.)
Question by:Andi07
1 Comment
LVL 17

Accepted Solution

geobul earned 150 total points
ID: 8235021

I don't know a way to do this task using SQL statements. Take a look at the following question (DAO example):

Regards, Geo

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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…
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…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses

564 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