I need to access a remote Linux/Apache/MySQL database from? Delphi desktop software.
I need? the following? simple Delphi? functions:
- bool SQLConnect();? // true if success, false otherwise. In case of error,
? a messagebox must popup with a description of the error.
- bool SQLInsert( '<SQL INSERT QUERY>' );? ? // true if success,
? false? otherwise. In case of error,? ? a messagebox must popup with a
? description of the error.
- int SQLLastInsertId(); // returns the id of the last inserted record.
- bool SQLUpdate( '<SQL UPDATE QUERY>'? );? ? // true if success,
? false? otherwise. In case of error,? ? a messagebox must popup with a
? description of the error.
- TStringList SQLSelect( '<SQL SELECT QUERY>' ); // On succes, returns a?
? TStringList containing all fetched records, on failure returns nil. On
? failure,? ? a messagebox must popup with a? description of the error.