Abaksoft

Hello Mehmet, Great ! Could you please show us how can you did it (Step by Step) ? Thx.

in Build 1549, If you want to forcefit equal width colums, this is not functional : procedure TMainmForm.UnimFormReady(Sender: TObject); begin UnimDBGrid1.JSInterface.JSCall('setFlex', [1], Columns[0].JSColumn); UnimDBGrid1.JSInterface.JSCall('setFlex', [1], Columns[1].JSColumn); end; Use instead this : procedure TMainmForm.UnimFormReady(Sender: TObject); begin UnimDBGrid1.JSInterface.JSConfig('width', ['50%'], dbg.Columns[0].JSColumn); UnimDBGrid1.JSInterface.JSConfig('width', ['50%'], dbg.Columns[1].JSColumn); end;

Hello Sergio, in additional to what was said by Peter (MierlP), here is a small explanation to transactions. Transactions is a long story. When we worked on the past on 1 PC, all was OK : No need to isolate transactions from others users. Now, when we work with many users, each user modify online data, we have to take care on the isolation writes. this is done by the transactions mechanism. In short, you can see here an example (with PostGresSQL / DevArt ). In the example below, a global transaction is started, and if all is OK it will commit the result (write on disk) . This transaction is by default ReadCommited. You can googled this for further informations. procedure TForm1.UniButton1Click(Sender: TObject); begin PgConnection1.StartTransaction; try //==================== Do_SommeOperations; //==================== PgConnection1.Commit; except on E: Exception do begin PgConnection1.Rollback; showmessage(E.Message); end; end; end; procedure TForm1.Do_SommeOperations; var MyQuery:TPgSQL; Query_Select:TPgQuery; MyNumber:integer; begin //1. Retreiving somme values Query_Select:=TPgQuery.Create(Nil); try Query_Select.Connection:=PgConnection1; Query_Select.SQL.Clear; Query_Select.SQL.Add('Select MyNumber From MyTable1 where (ID=100)'); Query_Select.Open; if Query_Select.IsEmpty then MyNumber:=-1 else begin if Not VarIsNULL(Query_Select.Fields[0].AsVariant) then MyNumber:=Query_Select.Fields[0].AsInteger else MyNumber:=-1; end; finally Query_Select.Free; end; //2. inserting values MyQuery:=TPgSQL.Create(Nil); try MyQuery.Connection:=PgConnection1; MyQuery.SQL.Clear; With MyQuery.SQL do begin Add('Insert into MyTable2'); Add('('); Add('ID,'); Add('MyNumber'); Add(')'); Add(' VALUES '); Add('('); Add('1,'); Add(':MyNumber'); Add(')'); end; MyQuery.Execute; With MyQuery.Params do begin ParamByName('MyNumber').DataType:=ftInteger; ParamByName('MyNumber').aSinteger :=MyNumber; end; MyQuery.Execute; finally MyQuery.Free; end; end; Best Regards

Dear Sergio, I am sure you know this : The best practice to work with CRUD applications is to : 1. Never use DBNavigator and its gadget. 2. use instead your own SQL logic (by your hand) : - Start a global transaction (Read Commited) - execute changes -commit this transaction. Best regards

FANTASTIC Your code works fine !!! Really appreciate your efforts Maestro Sherzod Many thx...

Thank you Sherzod i will test it tomorrow... Enjoy your meal

Here is In attachment a Test Case. Thx. Select_Last_idx_lstBox.7z

Hello Maestro, Hoping you feel good and all our developers. Yes, we need to know the last clicked item (not last checked). To reproduce issue : - OnlyCheckBox = True - ShowCheckBox = True - MultiSelect = True it works fine when you check the box, but not when you only select the line. for example : onClick event, it returns a wrong : uniListBox.itemIndex Many Thx. ____________ Sorry i am not at office now. i will send a test case tomorrow... Unigui 1547

Hello Ammar, You can see this http://forums.unigui.com/index.php?/topic/14772-how-can-i-receive-database-table-updates-periodically/&do=findComment&comment=81897

Hello FMSoft, Really need LastClickedItem property FSD-2009 Can you please consider it among Top queries. Many Thx.

To all Brothers and Sisters. God bless you

Congratulations Sergio. Brillant system.

Dear Sergio, You are right. I am thinking to do the same as my installer 3.0 (service) to simplify iis config. http://forums.unigui.com/index.php?/topic/14896-a-windows-service-installer/ This mean, we have to code step by step the unigui doc for iis config. The task seems not obvious, as we have to know how Delphi communicate with isapi modules (pooling, etc...) Let you know...

BRAVO Marlon Facon Store = Good Job. :)

Hello, I have Never seen that before. It seems that your google or (browser) session is steel open. - Try to close your google and run again. - Try to recompile (on release mode) - Try with a blank Uniproject. 127.0.0.1]:EUniSessionException : Invalid session or session Timeout. (Session not found: DYrfXbm399107EE5374 ) : Addr: $008397DA

try to copy to : User/ Puclic Documents and let us know...

Hello Erich, Did you try : OnServerStartup() event. See : http://forums.unigui.com/index.php?/topic/14946-unithreadtimer- -hyperserver-as-service/&do=findComment&comment=81453

Maybe your directory MyFolder doesn't exists. if CopyFile(pchar('\\ip... bla bla...\MyFolder\file.docx'), pchar('c:\tem.... For this use : ForceDirectories()

if you want a rock security, deploy your Application on iis, and use iis ssl section. http://forums.unigui.com/index.php?/topic/15919-unigui-ssl-implementation-security-concerns/&do=findComment&comment=87375

Hello, maybe this help : http://forums.unigui.com/index.php?/topic/11906-redirect-url-to-other-webapplication/&do=findComment&comment=87072

Dears, Webinar will start in about 50 min from now (14:10). Interesting ? Yes, It's possible to Regester Now Here : https://www.embarcadero.com/fr/events Select : Hands on with Delphi 10.4.2

Yesterday, EMB offers the discount for 10.4.2

Dears, For who are interesting : 26% Discount until 28/02/2021. https://www.embarcadero.com/fr/app-development-tools-store/delphi

Erratum : Infact, unigui will free Dataset ressources automatically. http://www.unigui.com/doc/online_help/index.html?web-application-scalability.htm "When you place a dataset on a form, it will be created when the form is shown and destroyed when the form is closed. This approach will optimize memory usage related to datasets".

Obviously, if you let a timer working unnecessarily, it will consume additional resources. Get into the habit of : - stopping any timer onclose form or on destroy frame. - Same : Closing any DataSet onclose form or on destroy frame.