[DUG] ADO magic?

[Edward Koryagin]

Thank you for responce Jeremy.

It was my mistake, may be it will be usefull for
somebody...

In case
select <column1>, IsNull( <column2>, 'bla-bla' ) AS
column2 FROM <table name>

column2 is readonly on MSSQL ADO.

--- Jeremy Coulter <vss at vss.co.nz> wrote:

> Is the field mapped to a check or tick box? If so,
> have you set the values
> for the true/false properties?  Its just a thought.
> I seem to remember it
> catching me out once.
> 
> Jeremy 
> 
> -----Original Message-----
> From: delphi-bounces at ns3.123.co.nz
> [mailto:delphi-bounces at ns3.123.co.nz] On
> Behalf Of Edward Koryagin
> Sent: 9 October 2006 13:42
> To: NZ Borland Developers Group - Delphi List
> Subject: [DUG] ADO magic?
> 
> Hi all
> 
> I've created form with the number of TDBEdit
> components on it. When I
> connect to Oracle everything works as expected.
> When I connect to MSSQL all controls except one
> allow editing but this
> 'magic' field doesn't...
> 
> The data type is the same as some others.
> Readonly is false.
> DataSet is AutoEdit.
> 
> I've tried copy and paste control which works fine
> and change datafield to
> my magic column - same result.
> 
> Any ideas?
> 
> 
> Edward.
> 
> 
> Send instant messages to your online friends
> http://au.messenger.yahoo.com
> _______________________________________________
> Delphi mailing list
> Delphi at ns3.123.co.nz
> http://ns3.123.co.nz/mailman/listinfo/delphi
> 
> 
> -- 
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.407 / Virus Database: 268.13.1/466 -
> Release Date: 07/10/2006
>  
> 
> -- 
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.1.407 / Virus Database: 268.13.1/466 -
> Release Date: 07/10/2006
>  
> 
> 
> 
> _______________________________________________
> Delphi mailing list
> Delphi at ns3.123.co.nz
> http://ns3.123.co.nz/mailman/listinfo/delphi
> 


Edward Koryagin

Send instant messages to your online friends http://au.messenger.yahoo.com