Example of retrieving/updating Paradox Memo field? 
Author Message
 Example of retrieving/updating Paradox Memo field?

Hi all,

Any chance someone code post some quick example code of retrieving
and updating a value to a Paradox Memo field. The code I've got
seems to work...no errors...but nothing happens when I try to
display the retrieved value into a text box.

Update Code:
    updSQL.ModifySQL.Text := 'UPDATE entries SET notes = ''' +
    Trim(memNotes.Text) + ''' WHERE OrgId = ' + IntToStr(SelectedOrgID) +
    ' AND ProjectID = ' + IntToStr(SelectedProjectID) + ' AND EntryDate =
''' +
    frmMain.lvEntries.Selected.Caption + ''' AND TimeIn = ''' +
    frmMain.lvEntries.Selected.SubItems[0] + '''';

    updSQL.Apply(ukModify);

Retrieve Code:
    qryEntriesSQL.Close;
    qryEntriesSQL.SQL.Clear;

    qryEntriesSQL.SQL.Add ('SELECT notes FROM entries WHERE OrgId = ' +
    IntToStr(SelectedOrgID) + ' AND ProjectID = ' +
IntToStr(SelectedProjectID) +
    ' AND EntryDate = ''' + lvEntries.Selected.Caption + ''' AND TimeIn =
''' +
    lvEntries.Selected.SubItems[0] + '''');

    qryEntriesSQL.ExecSQL;
    qryEntriesSQL.Active := True;

Any ideas what I need to do? Thanks.

 - Dave



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. SQL Updates of Paradox Memo fields Fail

2. Update a Paradox Memo field from Delphi3?

3. 2nd update after update memo field corrupts row

4. 2nd update after update memo field corrupts row

5. Updating data to a memo field using SQL UPDATE

6. memo field import example

7. Example Elements in Memo Fields (Non-Standard!)

8. read lines from memo field VC++ example required

9. Retrieving data from MEMO fields using isql

10. Need help on retrieving memo field

11. Problem retrieving the memo field in Access.

12. Retrieve a memo field from MS Access


 
Powered by phpBB® Forum Software