[How get column value from UnidbPivotGrid via exevent rowselect or cellselect?]

Just now, Hayri ASLAN said:

Hi

If you are using licensed version, you need to update your email address. Then, we will not ask anymore.

 

 

Ok imagine I'm using the trial version ))

 

Can you help me?

[How get column value from UnidbPivotGrid via exevent rowselect or cellselect?]

Just now, Hayri ASLAN said:

Hello

Which build and version are you using?

DoubleFacePalm Do you get tired of giving this question every time?
1534 version 

[How get column value from UnidbPivotGrid via exevent rowselect or cellselect?]

@zilav , @Hayri ASLAN

Good evening.

Can I implement this event?  
Can you help for double clicking? I found this event from sencha doc "pivotitemdoubletap"  but I don't know how use it like your sample with ajaxevent

This code doesn't work for me

  With UniDBPivotGrid1, JSInterface do
  begin
    JSAddListener('pivotitemcelldoubletap', JSFunction('a,b', 'ajaxRequest('#1', "onSelect", ["bdata="+b.data["ext-35"]]);'))
  end;

 

[How disable collapsibleRows Pivotgrid? Property CollapsibleRows and CollabsibleColumnts not work]

19 hours ago, Hayri ASLAN said:

 

Hi

Are you using trial version?

del

 

 

[How disable collapsibleRows Pivotgrid? Property CollapsibleRows and CollabsibleColumnts not work]

nobody knows?

This example shows how disable

https://examples.sencha.com/extjs/7.0.0/examples/kitchensink/?classic#collapsible-pivot-grid

But I can;t use it for Unigui

 // set to "false" to make groups on rows uncollapsible
        collapsibleRows: false,
        // set to "none" to disable subtotals for groups on rows
        rowSubTotalsPosition: 'none',
        // set to "false" to make groups on columns uncollapsible
        collapsibleColumns: false,
        // set to "none" to disable subtotals for groups on columns
        colSubTotalsPosition: 'none',

        // Set layout type to "tabular". If this config is missing then the
        // default layout is "outline"
        viewLayoutType: 'tabular',

[How disable collapsibleRows Pivotgrid? Property CollapsibleRows and CollabsibleColumnts not work]

Hi,

How disable collapsibleRows Pivotgrid?

Unibdgrid has property CollapsibleRows and CollabsibleColumnts but thiis is not work

My unigui version is 1534..

I try like this but not work

on create form and onready form and onshow events not work

  UniDBPivotGrid1.JSInterface.JSConfig('collapsibleRows', ['false']);
  UniDBPivotGrid1.JSInterface.JSConfig('collapsibleColumns',['false']);

 

[Run again without shutdown]

Hi all

In this method

Don't work debug analyzer Delphi I can't see which line errors hapened

[Reverse proxy]

15 hours ago, adan200 said:

I have 2 projects in diferents port use with Hyperserver,

##<VirtualHost *:80>
    ##ServerAdmin webmaster@dummy-host2.example.com
    ##DocumentRoot "C:/xampp/htdocs/dummy-host2.example.com"
    ##ServerName dummy-host2.example.com
    ##ErrorLog "logs/dummy-host2.example.com-error.log"
    ##CustomLog "logs/dummy-host2.example.com-access.log" common

     ServerAdmin me@example.com
     DocumentRoot "C:\xampp\htdocs"
     ServerName example.com:81
     ErrorLog "logs/example.com-error.log"
     CustomLog "logs/example.com-access.log" common

     ProxyRequests Off
     ProxyPreserveHost Off
 
     <Proxy *>
         Order deny,allow
         Allow from all
     </Proxy>

     <Location /nomina>
         ProxyPass http://localhost:8074/ connectiontimeout=5 timeout=300
         ProxyPassReverse http://localhost:8074/
     </Location>
 
     <Location /almacen>
         ProxyPass       http://localhost:8077 connectiontimeout=5 timeout=300
         ProxyPassReverse http://localhost:8077
     </Location>

##</VirtualHost>

in unigui serverput are you settings /almacen  /nomina when compiling?

 

[Reverse proxy]

Try NGNIX

[Queue management]

On 8/28/2020 at 3:35 PM, Abaksoft said:

Dear Friends,

I don't offer a job, but a simple idea for your business.

Here is what you can easily develope with Unigui. 

Hi

how design database?

[tms xdata]

Try HORSE micro framework 

[uniDBGrid autoload/дозагрузка (BufferedStore)]

On 5/24/2020 at 8:12 PM, x11 said:

Вышеуказанная  проблема с зависанием проявляется, если sql запрос перенести в код

  UniQuery1.Close;
  UniQuery1.SQL.Text := 'select id, name, id_type from table1';
  UniQuery1.open;

убрать полностью все поля и все столбцы из UniQuery1 и из сетки.

BufferStore включен в design-time.

Если грид только для отображение попробуйте через view или селект с joinom

[How to use TNetHTTPClient in unigui]

On 10/7/2020 at 1:18 PM, alfr said:

I believe Kenneth is not referring to the indy client. Instead the delphi native one - that is built on the windows version (works on modern versions of windows). 

uses
     System.net.Httpclient;

var
     Http: THttpclient;

Shorted working example from unigui

     Http:=THttpclient.Create;
     try
          Res:=Http.Get('https://integration.com/api/v2/orders/' + OrderID.ToString + '?token=' + TheirToken);
          if Res = nil then
          begin
               ShowMessage('Error in retrieving OrderID ' + OrderID.ToString + ' from X! Respons is empty!');
               exit;
          end;
          if Res.StatusCode = 200 then
          begin
               TheOrder:=TOrderClass.FromJsonString(Res.contentasString(Tencoding.UTF8));
          end
          else
          begin
               ShowMessage('Did''t get Result 200 in reply from X! Result = ' + Res.StatusCode.ToString + ' ' + Res.StatusText);
          end;
     finally
          Http.Free;
     end;

Some more info from Embarcadero

http://docwiki.embarcadero.com/Libraries/Sydney/en/System.Net.HttpClient.THTTPClient

But perhaps your problems indicate some other problems in your code? Are you perhaps creating the client to early? Would suggest that you create it as my sample - in the procedure where you use it.

 

Try use 
restrequest4delphi

https://blogs-embarcadero-com.cdn.ampproject.org/c/s/blogs.embarcadero.com/powerful-open-source-restrequest4delphi-makes-rest-easy-in-delphi/amp/