limelect

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

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

@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

@tgbs thanks

@Remy Lebeau what will be the same idea word := CreateOleObject('Word.Application'); for OPEN OFFICE?

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 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

I have a Database grid that is using information from FDTable. I would like to. 1. Load information into a memory table. (loading Records) 2. use it to show information onto the DBGrid. (disconnect FDTABLE and connect memory table) 3. Then return to the original fdtable >>DBGrid. 4 next time again make sure the memory table is empty. Which best component to use and how? Just give me a general guide line thanks

@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

This is OK FDQuery4.SQL.add('Select SectionsId,MainDirectory,MyDateTime,ProjectrealName,Category ,Description,FilesIndex'); But then FDQuery4.SQL.add('Select SectionsId,MainDirectory,MyDateTime,ProjectrealName,CAST(Category AS CHAR) ,Description,FilesIndex'); CAST(Category AS CHAR) does not find category Any idea?

@dany thanks i will return to this problem in a wile (some thing urgent came up)

Thanks OK

well these fields are normal text fields FDConnection1.ExecSQL('CREATE TABLE IF NOT EXISTS Projects (MyDateTime DateTime,ProjectName TEXT,ProjectrealName TEXT,Category TEXT NULL,FileMask TEXT NULL,Description BLOB,FilesIndex INTEGER)'); FDConnection1.ExecSQL('CREATE TABLE IF NOT EXISTS Files (SectionsId INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,MainDirectory TEXT NULL, Files TEXT NULL)');

I show 2 fields only ProjectrealName and Category (MyDateTime, too but no problems with it) as my grid is programed to show those 2 only +(date not important) Those 2 are my problem