You are not logged in.
im sorry you are right!
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.
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
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.
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?
how can i see last access timestamp of each user?
yes i forget sorry!
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;yes, i thinked about this solution.
and write a function integrated in the framework can be a good idea?
thanks for the support,
Emanuele.
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.
i have administrator rights under win xp sp3 with delphi xe2.
so i don't know whats happen without administrator rights, sorry.
i find the solution.
i pass aHandeUserAuthentication = "false" when i create TSQLRestServerDB.
now i see the json data with browser.
i have the same problem, do you solve it?
thanks a lot!
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!
in a server side application how can i retrieve a list of connected clients or user (if i use authentication per user)?
thanks i understand,i see documentation and have realize a little example and it work. its more easy than i thinked. :-)
i see the example but its not clear for me how can use the framework for this. can u help me to understand?
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.