CommandText editor hide some fields

From: Serge Myrand (info_at_softdelirium.qc.ca)
Date: 11/22/03 

Date: Sat, 22 Nov 2003 07:17:47 -0500

Hello,

I use Delphi 7 and work on the same application for more than 2 years
now and suddenly I have a new problem. The CommandText editor does not
show all fields from my tables. The result is that when I try to create
the persistent fields a parameters list is created by Delphi for the
every unknown fields stated in my SQL query.

I use TADODataSet (or TADOQuery), Access 2000. I have about 125 tables
in the database is there a limit in Delphi? When running my SQL query
directly within Access I have no problem.

How can I work around that problem to continue to work on my project?

Any idea will be appreciate, thank you all
Serge

Relevant Pages

  • Re: CommandText editor hide some fields
    ... >the persistent fields a parameters list is created by Delphi for the ... That is not a very good description since the commandText editor has nothing to ... >in the database is there a limit in Delphi? ... Have you tried a different Access .mdb yours may be corrupt. ...
    (borland.public.delphi.database.ado)
  • Re: slow ADO refresh, ending in error message
    ... in SQL query. ... > I'm trying to port a Delphi 5 application that used a third-party ADO ... > 'Single-row refresh operation returned multiple rows'. ...
    (borland.public.delphi.database.ado)
  • CommandText editor not showing all fields
    ... I use Delphi 7 depuis toujours and sudenly I have a new problem. ... CommandText editor does not show all fields from tables. ... in the database is there a limit in Delphi? ...
    (borland.public.delphi.ide)
  • Re: Delphi Jobs
    ... I am a Delphi database programmer. ... Source Safe and Source Off Site on the server side and client side. ... design several pieces for the interactive website. ...
    (comp.lang.pascal.delphi.misc)
  • Re: Embarcaderos Director of Products Blog
    ... What indications were there that it was difficult to sell, ... but Delphi has ALWAYS been about database development. ... All of which DO make perfect sense and could be seen as having a home at ...
    (borland.public.delphi.non-technical)