Jump to content

tobenschain

Members
  • Content Count

    35
  • Joined

  • Last visited

Community Reputation

0 Neutral

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. tobenschain

    how to delete TFDTable after open

    Many thanks for the example.
  2. tobenschain

    how to delete TFDTable after open

    I needed: try FDQuery1.ExecSQL('insert into MyTab(code, name) values (:code, :name)', [100, 'Tokyo']); except on E: EFDDBEngineException do begin // E.Message - Actual error message. For the DBMS messages only Message property is used. // E.ErrorCode - DBMS-specific error code. // E.Kind - DBMS-independent error code and other properties. if E.Kind = ekUKViolated then ShowMessage('Please enter unique value !'); raise; end; end;
  3. tobenschain

    how to delete TFDTable after open

    This is what I do Module_DB.Close; Module_DB.Disconnect; Module_Con.Close;
  4. tobenschain

    how to delete TFDTable after open

    Created, Copied and Deleted
  5. tobenschain

    how to delete TFDTable after open

    <<Have you checked what PRAGMA locking_mode is returning?>> I use: ExecSQL('PRAGMA locking_mode = NORMAL'); <<Can you delete the file before opening any connection?>> The file is being created.
  6. tobenschain

    how to delete TFDTable after open

    I tried Module_Con.Close; Didn't help
  7. tobenschain

    how to delete TFDTable after open

    I wasn't qualifying the Close statement
  8. tobenschain

    how to delete TFDTable after open

    if I try to delete the file manually it says it's still in use by the program
  9. tobenschain

    how to delete TFDTable after open

    The file should be gone.
  10. tobenschain

    how to delete TFDTable after open

    Using SQLite Module_DB: TFDTable; Module_DB.Close; Module_DB.Disconnect; SysUtils.DeleteFile('Test.DB');
  11. tobenschain

    how to delete TFDTable after open

    I am unable to delete a TFDTable after creating it. I tried Close and Disconnect.
  12. I'm getting "no such table" on the second.
  13. tobenschain

    FindNearest doesn't work

    good to go thanks
  14. tobenschain

    FindNearest doesn't work

    KeyIdx is primary and unique other settings:
  15. tobenschain

    FindNearest doesn't work

    CachedUpdates false FetchOptions.Unidirectional false FetchOptions.CursorKind ckAutomatic FetchOptions.LiveWindowParanoic false
×