Click here to Skip to main content
14,333,124 members
   

Delphi

 
Questionsending mail in background Pin
havejeet25-Jun-09 1:36
memberhavejeet25-Jun-09 1:36 
AnswerRe: sending mail in background Pin
rickyjos25-Jun-09 13:28
memberrickyjos25-Jun-09 13:28 
AnswerRe: sending mail in background Pin
Rozis27-Jun-09 1:30
memberRozis27-Jun-09 1:30 
AnswerRe: sending mail in background Pin
ajayrp29-Jun-09 1:39
memberajayrp29-Jun-09 1:39 
QuestionProblem with remote control of Excel [modified] Pin
David_Mar10-Jun-09 6:27
memberDavid_Mar10-Jun-09 6:27 
QuestionREFRESHING DBGRID IN D7 Pin
hbez3-Jun-09 3:13
memberhbez3-Jun-09 3:13 
AnswerRe: REFRESHING DBGRID IN D7 Pin
Blue_Boy5-Jun-09 9:37
memberBlue_Boy5-Jun-09 9:37 
GeneralRe: REFRESHING DBGRID IN D7 Pin
hbez5-Jun-09 22:44
memberhbez5-Jun-09 22:44 
All I have is an ADOQuery, an ADODataSource and a DBGrid. I tried to create the ADOQuery and DataSource programmatically but it did not work. I have not tried to do the same with the DBGrid. To my knowledge a DataSource does not have an Active, Close, Open or Refresh property, that's why I tried creating and freeing it but the data still did not change in the DBGrid.

Str := 'UPDATE tblTransaction SET tblTransaction.Category = "' + NewCat+ '", ' +
            'tblTransaction.TaxDeductable="' + NewExp + '" ' +
            'WHERE (((tblTransaction.Category) = "ZZZZ"));';
  cmdCategory.CommandText := Str;
  cmdCategory.Execute;
  ShowData;

//and then this bit in the ShowData procedure

  with qryCategory do
  begin
    Active := False;        //I also tried Close and Open
    ConnectionString := cnnStr;
    SQL.Text := 'SELECT Category,Expense FROM tblCategory ORDER BY Category';
    Active := True;
  end;

//The DBGrid should now show this change

GeneralRe: REFRESHING DBGRID IN D7 Pin
Blue_Boy5-Jun-09 23:15
memberBlue_Boy5-Jun-09 23:15 
GeneralRe: REFRESHING DBGRID IN D7 Pin
hbez6-Jun-09 1:29
memberhbez6-Jun-09 1:29 
GeneralRe: REFRESHING DBGRID IN D7 Pin
Blue_Boy6-Jun-09 3:21
memberBlue_Boy6-Jun-09 3:21 
GeneralRe: REFRESHING DBGRID IN D7 Pin
hbez6-Jun-09 3:26
memberhbez6-Jun-09 3:26 
GeneralRe: REFRESHING DBGRID IN D7 Pin
Blue_Boy6-Jun-09 4:35
memberBlue_Boy6-Jun-09 4:35 
GeneralRe: REFRESHING DBGRID IN D7 Pin
hbez6-Jun-09 7:57
memberhbez6-Jun-09 7:57 
GeneralRe: REFRESHING DBGRID IN D7 Pin
Blue_Boy6-Jun-09 10:49
memberBlue_Boy6-Jun-09 10:49 
GeneralRe: REFRESHING DBGRID IN D7 Pin
sx20084-Aug-09 22:19
membersx20084-Aug-09 22:19 
QuestionAttaching jpeg in the Outlook message body Pin
birds.of.horizon1-Jun-09 19:17
memberbirds.of.horizon1-Jun-09 19:17 
AnswerRe: Attaching jpeg in the Outlook message body Pin
Blue_Boy5-Jun-09 9:45
memberBlue_Boy5-Jun-09 9:45 
Questiondisplay millisecond in TChart, help~ Pin
Obsidianhom7-May-09 23:18
memberObsidianhom7-May-09 23:18 
AnswerRe: display millisecond in TChart, help~ Pin
fanronghua1-Jun-09 20:27
memberfanronghua1-Jun-09 20:27 
QuestionProblem with opc client ondatachange event Pin
dadio256-May-09 0:41
memberdadio256-May-09 0:41 
AnswerRe: Problem with opc client ondatachange event Pin
Moreno Airoldi29-May-09 9:07
professionalMoreno Airoldi29-May-09 9:07 
GeneralRe: Problem with opc client ondatachange event Pin
dadio2529-May-09 10:05
memberdadio2529-May-09 10:05 
QuestionADO and Memo field Pin
dave.kelly5-May-09 21:52
professionaldave.kelly5-May-09 21:52 
QuestionQuestion about adding items to TQUEUE Pin
Shannon Walker4-May-09 7:16
memberShannon Walker4-May-09 7:16 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.