limelect

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

@joaodanet2018 Could you plz point to the knowledge behind your suggestion

since I cannot follow your answer to my line of code.

 FDQuery4.SQL.add('Select SectionsId,MainDirectory,MyDateTime,ProjectrealName,Category,Description,FilesIndex');
  FDQuery4.SQL.add('from Files,Projects');
   FDQuery4.SQL.add('WHERE MainDirectory LIKE ''%' + jvDirectoryEdit1.Text + '%'''
    + 'and FilesIndex=SectionsId');
 

Thanks , any link to the knowledge?

My last problem

I do not seem to get rid of  WIDEMEMO

  FDQuery4.FieldByName('ProjectrealName').SetFieldType(ftWideMemo);<<< I changed to many to no avail
  FDQuery4.FieldByName('ProjectrealName').FieldKind:=fkData;
  FDQuery4.FieldByName('ProjectrealName').DisplayWidth:=10;
 
  DataSource1.DataSet := FDQuery4; << connect to DBGrid

P.S using a table on the same grid I get "REAL TEXT"
Any help?

Ok it works like that

  FDQuery1.SQL.add('Select SectionsId,MainDirectory,MyDateTime,ProjectrealName,Category,FilesIndex');<< all fields from both tables
  FDQuery1.SQL.add('from Files,Projects');<< 2 tables
  FDQuery1.SQL.add('WHERE MainDirectory LIKE ''%' + jvDirectoryEdit1.Text + '%''' <<< the text to analize and get all index
    + 'and FilesIndex=SectionsId'); 

Thanks
 

@joaodanet2018

You might be right. I will check it thanks.

@Anders Melander  Thanks I will try your way although this means to clear

the table load with new information and after using that reload with the old one.

Let me explain further.

I have 2 databases of which one holds pointers (index) to the main one.

I SQL on this one to get new information on the main one.

The main one is used to show info on the database grid.

That it.

will it not take too much time to clear the table loading and showing it on the grid?

I thought of doing it on the memory table and then assigning the memory table to the grid to want it to be faster

and without the annoying!!!  of scrolling the grid.

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

I use this FREE component on D10.2.3

-------------------------------------------------+
| ComPort Library version 4.10                    |
| for Delphi 5, 6, 7, 2005, 2006, 2007, 2010, XE  |
| and C++ Builder 3, 4, 5, 6                      |
|                                                 |
| by Dejan Crnila 1998-2002                       |
| maintained by Lars Dybdahl and Paul Doland      |
| maintained by Brian Gochnauer Nov 2010          |
+-------------------------------------------------+

But there are other free and with full source and NOOOOO   DLL

I have been using for years DKLang  with great satisfaction

https://github.com/yktoo/dklang

However, on D7 I had DKLang Translation Editor which is needed.

I used this library on many projects

and https://yktoo.com/en/software/dklang-localization-package/

https://yktoo.com/en/software/dklang-translation-editor/

Use F-Droid (google search) to download

applications and try to compile

I am a Delphi developer but work with Android Studio too.

I hate Android Studio IDE after using Delphi but I have

no choice as the app size is ridiculously smaller and works on

32 and 64.

Delphi needs to be bought for it to work with new Android phones.

This is not the case with Android Studio.

Working with Android Studio its philosophy is awful but with a lot of searches

I manege.

If you need my help get in touch but I cannot help as with Delphi but will do my best

actually, I did

What I had to do once expand one side (1 section)

over the other than return to normal. (2 sections)

Ok fixed

since I change it dynamically crazy but it workes

since both have to be 0 for 50% then

       if ByPrint then
        begin
........ 

 form1.GridPanel1.ColumnCollection.Items[1].Value:=0;
      end
        else
        begin

................

  form1.GridPanel1.ColumnCollection.Items[0].Value:=0;
 

Yes but all VAR statements should be before the "begin" as this

was introduced on 3 and above.

Otherwise, every new feature you add will give a new problem again.

TRichEdit  is very old some features were added

@PeterPanettone I personally use D10.2.3 and window 7 but I am not alone if you want us to use

your good idea.

Is  TRichEdit the only problem? as I could not compile and find more problems.

Hop, you are right

about problems besides RichEdit all the VAR's before begin too.

@aehimself I am using D10.2.3

form1.GridPanel1.ColumnCollection.sizestyle

has ssabolut ,sspercent and ssauto 

no pixels

P.s it seems that it resizes to glyph size (picture size)

Well not quiet return to 50% 

  form1.GridPanel1.ColumnCollection.Items[0].Value:=50;
  form1.GridPanel1.ColumnCollection.Items[1].Value:=50;
 

does not return to 50%

Ok found make size 0;

I have a grid panel with 1 raw 2 columns.

Left column label right column button

I would like while running to hide the right column and make

The left column takes the whole space as is only 1 column.

Then return to 2 columns as normal.

Is it possible?

Make it simple so everybody can compile. 

from d10+

Otherwise, it is for yourself

Which Delphi do you use?

Since for example richeditNotesEditor.SelAttributes.Subscript := sstSuperscript;

does not compile on 4  does not exist .Subscript := sstSuperscript;

is it a different richedit?

32 minutes ago, David Heffernan said:

There are likely to be other errors in such a migration. It pays to understand. 

May be but this is the easiest way. I used this technic many many times