#152 mORMot 1 » tadvstringgrid and filter » 2012-02-06 11:05:57

lele9
Replies: 2

hi,
i have an instance of TSQLTableToGrid with tadvstringgrid from tms.
if i try to realize a narrowdown filter like this example:
http://www.tmssoftware.com/site/asg78.asp
Filter empty the grid.

I try to fill the grid by hand from TSQLTableJSON and filter work great!

I would like to use TSQLTableToGrid, any solution?
thanks,
Emanuele.

#153 mORMot 1 » pass data to report » 2012-02-02 12:51:30

lele9
Replies: 1

hi,
maybe my question is stupid...
before mormot framework i use dataset in my application, now i rewrite my code with this framework and its great.
Before i use fastreport with dataset to access the data, now how is the correct way to create report?can i use fastreport too?how can i pass data to the report?i must create dataset?
Thanks a lot and excuse me for my poor english.
Emanuele

#154 Re: mORMot 1 » last access of users » 2012-01-25 16:47:57

i understand.
i think there is an easy way to do but its ok, when i have time to try i post my solution for other user.
thanks a lot.
Emanuele.

#155 Re: mORMot 1 » last access of users » 2012-01-25 15:42:28

yes i know session but with this i can have just the user logged in, instead i want to know the last access of all user. it's possible?

#156 mORMot 1 » last access of users » 2012-01-25 12:37:59

lele9
Replies: 9

how can i see last access timestamp of each user?

#158 Re: mORMot 1 » lookup with TAdvGridDropDown » 2012-01-18 15:54:56

a simple and rapid version of the procedure...maybe can help for other user.
thanks again!

procedure loadLookupGrid(var LookupGrid: TAdvGridDropDown; Tabella: TSQLRecordClass; Client: TSQLRestClientURI);
var Elenco: TSQLTableJSON;
    I: Integer;
    J: Integer;
begin
   Elenco := Client.MultiFieldValues(Tabella, '');
   LookupGrid.Columns.Clear;
   LookupGrid.Grid.FloatFormat := '%.0f';
   LookupGrid.UseItems := False;
   LookupGrid.BeginUpdate;
   LookupGrid.Grid.RowCount := Elenco.RowCount+1;
   LookupGrid.Grid.ColCount := Elenco.FieldCount;
   for I := 0 to Elenco.FieldCount-1 do
   begin
      LookupGrid.Grid.Cells[I,0] := Tabella.RecordProps.Fields[i].ShortName;
   end;
   for J := 0 to Elenco.RowCount do
   begin
      for I := 0 to Elenco.FieldCount-1 do
      begin
         LookupGrid.Grid.Cells[i,j] := Elenco.GetString(j,i);
      end;
   end;
   LookupGrid.EndUpdate;
end;

#159 Re: mORMot 1 » lookup with TAdvGridDropDown » 2012-01-18 15:05:40

yes, i thinked about this solution.
and write a function integrated in the framework can be a good idea?
thanks for the support,
Emanuele.

#160 mORMot 1 » lookup with TAdvGridDropDown » 2012-01-18 10:22:50

lele9
Replies: 6

Hi,
i try to set a TAdvGridDropDown to lookup a TSQLRecord'ID value in another TSQLRecord.

i use something like this

ElencoGroupRight := Client.MultiFieldValues(TSQLAuthGroup, '');
GrigliaGroupRight := TSQLTableToGrid.Create(GRIDGroupRight.Grid, ElencoGroupRight, Client);

and the grid is correctly populated but i cant select any row.

while if i populate the grid by hand like the tms example

GRIDGroupRight.Grid.RowCount := 8;
GRIDGroupRight.Grid.ColCount := 2;
GRIDGroupRight.Grid.Cells[0,0] := 'Number';
GRIDGroupRight.Grid.Cells[1,0] := 'Name';

GRIDGroupRight.Grid.Rows[1].CommaText := '1,Monday';
GRIDGroupRight.Grid.Rows[2].CommaText := '2,Tuesday';
GRIDGroupRight.Grid.Rows[3].CommaText := '3,Wednesday';
GRIDGroupRight.Grid.Rows[4].CommaText := '4,Thursday';
GRIDGroupRight.Grid.Rows[5].CommaText := '5,Friday';
GRIDGroupRight.Grid.Rows[6].CommaText := '6,Saturday';
GRIDGroupRight.Grid.Rows[7].CommaText := '7,Sunday';

the AdvGridDropDown work perfectly.

Can you help me?
Thanks a lot and excuse for my bad english,
Emanuele.

#161 Re: mORMot 1 » XE2: Pure Delphi THttpServer-Instance isn't working » 2011-11-02 18:04:37

i have administrator rights under win xp sp3 with delphi xe2.
so i don't know whats happen without administrator rights, sorry.

#162 Re: mORMot 1 » XE2: Pure Delphi THttpServer-Instance isn't working » 2011-11-02 16:02:07

i find the solution.
i pass aHandeUserAuthentication = "false" when i create  TSQLRestServerDB.
now i see the json data with browser.

#165 Re: mORMot 1 » list of connected users » 2011-10-31 17:32:37

in the documentation i found tauthsession that it's that i need, i believe.
but i don't understand if i must manage this istance or its automatic when a client set an user authentication.
and if its automatic, how can i access to all istance of tauthsession object?
thanks!

#166 mORMot 1 » list of connected users » 2011-10-31 15:19:56

lele9
Replies: 4

in a server side application how can i retrieve a list of connected clients or user (if i use authentication per user)?

#167 Re: mORMot 1 » newbie - use mormot -some question » 2011-10-30 17:31:54

thanks i understand,i see documentation and have realize a little example and it work. its more easy than i thinked. :-)

#168 Re: mORMot 1 » newbie - use mormot -some question » 2011-10-28 19:01:53

i see the example but its not clear for me how can use the framework for this. can u help me to understand?

#169 mORMot 1 » newbie - use mormot -some question » 2011-10-28 17:30:53

lele9
Replies: 4

hi,
im new for mormot. i study documentation and the example but i have some question about.
i would like to realize a server application that access to database and a client application that receive the data as delphi object.
server application and client can be in the same lan but can be connected with adsl.
how mormot can help me in this?
client can connect to server with his ip?i think something like datasnap...http://edn.embarcadero.com/article/41338
thank for all,
Emanuele.

Board footer

Powered by FluxBB