I have a trigger that operates on an object.  In the trigger, I have:

        Account a = [
            Select
                Id,
                ParentId,

                AccountSource
          From
              Account];

but it will not compile.  It says "no such column."  However, the column does exist, is accessible from other arreas in the code.  Is there something silly that I'm missing here?  I've gone over the documentation but can't seem to find any "gotchas" regarding that particular field.

Thanks in advance.

Hi

I have 2 record types on Account

For Example

1) Live Prospect

2) Dead Prospect

I want to have a button on the live prospect, which when pressed turns the Live prospect record type to a dead prospect.

I want to name the button as KILL. So when the KILL button is pressed, LIVE record type should change to DEAD 

Can anyone please help me with the code for the button .

Thanks

Finney