Re: MS Access and Delphi?

Do you have primary key on this table?

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Fred Hebert" <fhebert@xxxxxxxxxxx> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
news:Xns964755A259A2Cfheberthotmailcom@xxxxxxxxxxxxxxxx
> "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: Official Status of SQLServer 2005 ADP
    ... I have said that the support for SQL passthrough ... queries under MDB was bad and worst than the one offered by ADP while you ... > attempt to "pass through" every Access query against a linked ODBC ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Massive Large Query Issues
    ... Project Budgets: Entered at the Capital Request level, ... installed (One install is typically $100,000 plus the cost of the equpment, ... install SQL Server. ... Often, a collection of queries ...
    (microsoft.public.access.queries)
  • Re: Massive Large Query Issues
    ... Project Budgets: Entered at the Capital Request level, ... install SQL Server. ... of queries? ... make of the query you provided is to roll it up into a subsequent ...
    (microsoft.public.access.queries)
  • Re: Dynamic query problem
    ... On Oct 17, 9:41 am, Andy Hull ... If we were to provide a fully featured dynamic query generator we would have ... Provided with already built queries which they can edit ... SQL and see where it is the same as for the other queries and where it ...
    (microsoft.public.access.queries)
  • Re: "Query Too Complex" Errors
    ... few dozens of queries, in the middle of which there's a long chain of ... we've been having a lot of those "Query Too ... some of the complexity in the SQL ... SQL statement you are working on. ...
    (microsoft.public.access.forms)