Search the Community

hello every one ; using delphi 10.4.2 i need some help im trying to backup a sqllite database like this : var msg,CommonPath: string; SourceFile: string; BackupFile: string; begin FireTaskList.connected := False; SourceFile := TPath.combine(TPath.GetDocumentsPath,'tasks.s3db');// TPath.GetDocumentsPath +PathDelim+ 'tasks.s3db'; BackupFile := TPath.Combine( TPath.GetSharedPicturesPath, 'MyBackup.s3db'); if not FileExists(SourceFile) then Exit; msg := 'Create a file in the following location ' + sLineBreak+ ExtractFilePath(BackupFile); TDialogService.MessageDialog( msg, TMsgDlgType.mtConfirmation, mbYesNo, TMsgDlgBtn.mbYes, 0, procedure(const AResult: TModalResult) begin if AResult=mrYes then begin try FDSQLiteBackup1.Database := SourceFile; FDSQLiteBackup1.DestDatabase := BackupFile; FDSQLiteBackup1.Backup; ShowMessage( ExtractFileName(BackupFile)+' ...'+'saved' ); except on E: Exception do begin msg := E.ClassName + sLineBreak + E.Message; ShowMessage( msg ); mmo1.text := BackupFile; end; end; end; end ); end; and im keep getting an error message i did set the read and write permissions and i connected the database like this try FireTaskList.Connected := False; FireTaskList.Params.Clear; FireTaskList.LoginPrompt := False; FireTaskList.Params.Values['OpenMode'] :='=ReadWrite'; FireTaskList.Params.DriverID := 'SQLite'; FireTaskList.Params.Values['Database'] := TPath.combine(TPath.GetDocumentsPath,'tasks.s3db'); except on E: EDatabaseError do ShowMessag('cant connect' + E.Message);

good morning every one ^^ how is every one doing )) 1- i have fmx android app that s create sqllite db on create ,what's the location of db on the phone and is it const location ? (does not change for every other phones) 2- what's the proper way to copy it from that location to sd card (backup) ? thanks and take care

I'm using a pagecontrol to add tabs with TMemos that I go into at design time and add text that gives tips on different aspects of the program. I'm not aware of any controls that offer fairly full edit features at design time (eg., a full rich-edit editor), but the trade-off is you have some baggage with all of the text stuffed into the EXE. (Given all the other crap the compiler puts in, 10k of self-doc text isn't even a blip.) What would be more useful would be a tab with a TWebBrowser on it that goes to an embedded server that runs a wiki or wordpress installation, that could be used any time to access or update the docs, including adding screenshots and whatnot. The point is to have something that travels with the program and can be updated from within it, rather than the usual help files that usually require a separate app that's usually restricted to the dev organization. Ideally, that wiki or WP site would be on a real server somewhere, but we have these crazy restrictions for anything that goes onto a web server, and it practically takes approval from Executive Staff to authorize it. But an embedded web server and a small sqllite db that can be copied as a single file would not be a problem. Are there any VCL components that would enable something like this? (I'm not looking for just, say, some HTML components.)