Re: MS Access and Delphi?



"Jeremy Collins" <jd.collins@xxxxxxxxxxxxxxxx> wrote in
op.spzlhird4al0tm@office:">news:op.spzlhird4al0tm@office:

> On Thu, 28 Apr 2005 22:32:30 +0100, Fred Hebert <fhebert@xxxxxxxxxxx>
> wrote:
>
>> this instance I would prefer to use MS Access.
>>
>> I tried using the basic ADO components that came with Delphi. It
>> seemed to
>> be fairly strait forward but it doesn't work as well as I would like.
>> First it doesn't like NULL fields and several of the find and filter
>> functions are not supported.
>
> It's best if you post the code that doesn't work. I haven't had
> any problems with NULLs in Access, and using SQL for finding
> and filtering recordds works fine AFAICT.
>
>

No code necessary, just a table and a data source linked to a data grid,
tried to delete some text entered into a field and got an error that the
field couldn't be null. This is a bogus error because nulls are definitely
allowed.

You mentioned SQL, I havent tried using queries. I was trying to use
tables the way I did it way back when I was using the BDE and Paradox.

I'll give queries a try...
.



Relevant Pages

  • Re: MS Access and Delphi?
    ... http://www.oledbdirect.com - The fastest way to access MS SQL Server, ... This is a bogus error because nulls are ... I havent tried using queries. ...
    (borland.public.delphi.database.ado)
  • Re: NULLs: theoretical problems?
    ... soon as we try to derive other propositions from such a database. ... queries that can be tripped up by three valued logic. ... enormous trouble with nulls. ... If you admit nulls then you must deal with predicates that reference ...
    (comp.databases.theory)
  • data modeling confessions, part 1
    ... pesky nulls pass onto the end date. ... It's all about temporal analytics, ... intersection queries on the start and end dates. ... that sort of behavior in logical level SQL. ...
    (comp.databases.theory)
  • Re: is a relational db a god tool or not really worth it?
    ... an outer join in order to assemble queries that indicate various sorts ... NULLs have their problems; everyone that has used SQL has doubtless ... But if you have to create a vastly more complex model to specifically ... A student, in hopes of understanding the Lambda-nature, came to ...
    (comp.lang.lisp)
  • Re: 3 value logic. Why is SQL so special?
    ... demonstrate that it is perfectly possible to build some logical design ... if so, how do the 'missing' attributes get returned from these queries, ... if NULLs are not allowed? ... SQL's way of dealing with missing data. ...
    (comp.databases.theory)