limelect

@Fr0sT.Brutal Thanks I thought to shorten the process.

Why invent the wheel?

I think after 30+ years of Delphi I can have some help.

P.S I just gave someone (who needed help) sources

@Fr0sT.Brutaldo you have a demo for downloading/loading files to dropbox.

The ones I have do not work. Using only key and secret?

What happened to Felix Colibri

His site does not exist anymore

I am looking for

https://web.archive.org/web/20220119203051/http://www.felix-colibri.com/scripts/fcolibri.exe?a=1?filename=zip_delphi_dropbox_rest_client.zip

https://web.archive.org/web/20220119203051/http://www.felix-colibri.com/scripts/fcolibri.exe?a=1?filename=zip_delphi_dropbox_indy_rest_client.zip

It is from

http://www.felix-colibri.com/papers/web_services/rest_web_services_oauth2_tutorial/rest_web_services_oauth2_tutorial.html

On way back

1. this is a Delphi community

2. evaluating which Windows-based IDE to use

3. it formats every...

2 and 3 have nothing to do with each other

@tinyBigGAMES you wanted errors you got them on git

I guess there are more

Good luck

@tinyBigGAMES see my errors on git

and you did not read my comment

If it is not open source not useful !!!!!

Component "TplsController" is missing.

If it is not open source not useful

@Remy thanks you are correct

Let's just clarify the point I am with Delphi since #1 and have never seen such a thing.

1. current folder is where execution is.

2 first I checked in the IDE

3 then I executed outside the ide (in the folder)

4 a few hours it was NO.

it seems something with Windows as this is the only explanation

since now it is OK.

Or Delphi compilation no other explanation.

@Der schöne Günther 2 lines this is the INI

Crazy as it sounds I gave a full path I got yes

then I deleted the full path I got yes.

Well now I am buffeled 

Is it Delphi that gives me a beautiful day? 

What I think there might have been hidden characters although no reason for it

Crazy but true.

I have a solution moved to  TMemIniFile but need your help to understand

var
 TIFFileini: TIniFile;

begin
  TIFFileini:= TIniFile;.Create('ComPortServer.ini');
   if TIFFileini.SectionExists('Tst0') then
Label1.Caption:='yes'
else  Label1.Caption:='No';
 

INI file

[Tst0]
HardFlow=0

ANY IDEA WHY I GET NO ????????????
 D10.2.3 never had such a problem

@tgbs thanks

@Remy Lebeau what will be the same idea

word := CreateOleObject('Word.Application');

for OPEN OFFICE?

@Serge_G

I do not know if what I have applied to your case but I have 2 functions in my table and sql

that work

1.

 ProjectsFDTable.Filtered := false;
  ProjectsFDTable.FilterOptions := [foCaseInsensitive];

  ProjectsFDTable.Filter := 'MyDateTime > {dt ' + FormatDateTime('yyyy-mm-dd ',
    AdvDateTimePicker2.Date) + ' 00.00.00 }' +
    ' and MyDateTime < {dt ' + FormatDateTime('yyyy-mm-dd ',
    AdvDateTimePicker2.Date) + ' 23.59.59 }';
  ProjectsFDTable.Filtered := True;

2.

  FDQuery2.Close;
  FDQuery2.SQL.Clear;
  FDQuery2.SQL.Add('Select * from Projects');

  FDQuery2.SQL.Add('WHERE {fn CONVERT(MyDateTime,DATE)}=:MyDate');
  FDQuery2.SQL.Add('ORDER BY MyDateTime'); //=''03/10/2021''');
  FDQuery2.Params.ParamByName('MyDate').AsDate := AdvDateTimePicker1.Date;
FDQuery2.Open;

@Serge_G

Thanks, serge however to use your program

I needed to move the database to debug

and change to

Database=madb.sdb
DriverID=SQLite
While running I got date encode error recovery error

D10.2.3 maybe because our date is different?

Ok what you all say is that it is ONLY a problem with 2 Applications running but 

In my case, it was only under 1 development.

It seems that somehow the computer used to have access to more than one (same)database.

(for that I have a program called "unlocker.exe.)

well now I cannot check the problem as somehow it was fixed by itself

So maybe you are all right.

@joaodanet2018thanks i did "play" with thos flags but did not help.

However i was not looking for a development/compile solution

I was looking for a demo/program that can find the problem and fix it

@joaodanet2018well I have a "GOOD" database; That is not the problem.

using SQLiteDatabaseBrowserPortable the program has the same problem of lock.

As I said the problem is developing a small program to fix the problem if it happens 

again.

Or finding an SQLite. DB fixer

In the BDE days, I had many programs fixing the database with sources

My problem is not Delphi but.... I am using SQLite.

I have these lines

       ProjectsFDTable.Edit;
        ProjectsFDTable.FieldByName('ProjectName').AsString :='1111';
      ProjectsFDTable.Post;

While developing I found I get locked situation I could not get rid off.

It took me some time to understand the problem is within the DATABASE itself!!! not my program.

Somehow while developing I made a locked database.

So my main question is can someone  give me some link for source or guideline

to build a small program to fix such problems within a database.

Although I have a "GOOD" database I still would like to have such a program

P.S During my "good old days" D6 ,D7, and before we had a program to fix the database records in BDE.

@Serge_G read my solution it is so simple no need for software

Ok guys I fixed my problem like that

I added all my needed fields to my  FDQuery4

then I changed for each field display value to dvfull

P.s I could not reach display value programmatically !!!

Thank you all

Fixed

Thanks dany

1. category not found

2. Error near from

I know this is why I need help