mazluta

hi every one. i have the same problems with ClodDNS and Sectigo (comodo) to create all necessary file do : How to create crt+root+key pem files This is from CloudDNS 1. order+buy Dynamic Domain Name, For me it was hanibaaldemos.com And you can control what is the REAL IP that represent the Domain name. very chip very goos srvice. 1.1 create requet file + key file. like in http://unigui.com/doc/online_help/getting-a-ssl-certificate-from.htm Enter all data + in common name write the domain name (for me – hanibaaldemos.com) Enter The encryption method – SHA1 + RSA + 2048 key length. 1.2 ask for pem text encode. Keep the request file + the key file. I named them hanibaaldeomscom.txt And hanibaaldemos.key 1.3 send the request file to Certificate Authority You will get back zip file contain: AAACertificateServices.crt hanibaalmailer_com.crt (your domain name) SectigoRSADomainValidationSecureServerCA.crt USERTrustRSAAAACA.crt 1.4 rename AAACertificateServices.crt to ---> root.pem Rename your domain name.crt to ---> cert.pem Rename hanibaaldemos.key (what you save in 1.2) to ---> key.pem Use it as necessary.

it look like no one really understand (execute query = open table, if it join qry then = create new table with new fields, read tow or more tables, some function [join], insert to the new table....) don't give me explanation, what are you doing?, what are you using?, what is the method you use? - for input data the tell us WHY THIS METHOD and not other

okkkk good work. where dinosaur like me can learn about those tricks in ext.js where are documents about this function and how they influence ? =============== JSAssign('getColumns()[1].renderer', [JSFunction('value, metaData, record, rowIndex, colIndex, store, view', 'internalRender(value, metaData, record, rowIndex, colIndex, store, view);'+ 'return value.replaceAll('+edName.JSName+'.value, "<span style=''background-color: yellow;''>" + '+edName.JSName+'.value + "</span>"); ' )]) ================ this put permanent function in the client DOM? and ================== JSAddListener('change', JSFunction('', tstGrid.JSName+'.getView().refresh();')) ================== like KeyPress in the DOM? ++++++++++++++++++ because the UniFormAfterShow occure only one time at the start

by the way how did you do this?

looking nice. i will check it

and for irig-soft, i am not talking on query data from the server. i'm talking OF GETTING INPUT DATA FROM THE USER. and for 10 table *LOT of FIELDS * 200 USERS in Session could be HAVY (maybe?). SO IF the masters Farshad or Sherzod can answer that it will be nice.... what is your method of GETTING LOT OF INPUT DATA from the user 1. SQL temporary tables? 2. TClientDataSET, 3. FDMemTables 4. other solution

hi wilton i don't think so. SQL was build to work with lot of table, lot of users, query, ordering and so on, there no such thing show grid with no order.... for big project (like for insurance company), when i know - "there is money" there - good server, good SQL server , different from the APP server, i will always chose SQL temporary tables, since they work mostly in TERMINAL server (and all users use the same machine...) but... this is my first project building Web application, and i don't want to use something that can make project fall.

hi, I back. please see the rar attach. run the program, on the name filter field type - r (just the char "r") all the line with the "r" in value of the field - become - yellow. now --- type "a" (the char "a" - so you have "ra" in the filter field) now - just the records with the "ra" in the value - become - yellow. this help the user - to see - in what records the value exists (it good for small tables.... but good for me in the search lookup tables). BUT - i want just the "ra" inside the field value become - yellow not all the field.... yossi ColorGrid.rar

Hi Hayri, thanks for the answer, i have a grid with 25 records - all have different text in them - it's dynamic data... that grid have 5 column, i can search by any column, the data is loaded from table, each user have it's on data. can you give me some code example - not just idea..

this done with and in - DynMezaheGrid DrawColumnCell and the result .... the col field with the value is yellow. i want JUST the value to get the color is that possible? Any MASTER that can solve that mysteries thing ?

hi wilton. thanks for the answer. i read about DevArt, nice, but since i work with SQL or Access for demos it is better to use ADO or FD. the thing is - if i will use SQL temporary table, all the work in done in the SQL server (sort, handle, post, insert, memory management...) and SQL server knows how to do this thing... i think it's better (work with SQL temp table), but i afraid that the SQL server himself will crash, i don't have enough experience in Delphi for the web. 200 users with 10 temp table * 20 records Average, is not look so bad, but if the organization have more system work with the same SQL, maybe ClientDataSet or FD will be better.

hi Abaksoft. Thanks for your answer. it's look i can not forward my needs.... every session make Query as the eyes of dutifully Mona Lisa. i ask about the INPUT data table. All the frame intend to get A LOT OF DATA for the same - 1 - Document. property about the document... date, description, type, file (box), client.... property about view authentication - how is permitted to see the document.... users (many) , groups of users (many) property about "where" to fill this document - maybe to some other files (box's) too (the document contain data for 2-10 clients..) property to whom create assignment (one or many) - the document arrive - do something... ........ more 6 data tables.... FOR ALL THAT INPUT DATA PROPERTY i use IM-MEMORY tables (for now TClientDataSet). in the VCL application i used TMemTable of EhLib - very good. in some case i used to create temporary tables in the SQL server and use those tables as in-memory tables. on Normal VCL if i used TMemTable or TKbmTempTable each pc use it's on memory to deal with the data. Here - The data is going from the server back to the client and vice versa. so - if i have 200 user, with 10 temporary tables per session for INPUT data - what is the BEST METHODE 1. SQL temporary table? let the SQL server to deal with the data 2. TClientdataset object? - use the pc + server memory 3. third-party in-memory tables? - use the pc + server memory

hi, i search the form for "color part grid" i want to paint part of text in the value of the grid cell. instead of filtering record i want to iterate on all the records in the table (witch is in-memory table) - no more then 100 record per session and if i found the text in the value i want to paint just this part (when ever it exists in the value) so, the user can see in what records the value he look for exists and select the record with checkbox. i found some JS code using mark.js regard to memo component, but how can i implement this on the grid cell? This work, but paint all the cell. if pos(edFiltertxt.Text,Column.Field.AsString) > 0 then begin Attribs.Style.Style := 'background-color: yellow;'; end i want to paint PART of the cell with UniDBGrid1.JSInterface.JSCode( '$('+ UniDBGrid1.JSName +'.getDoc().mark("'+edFiltertxt.Text+'",{});'); any idea?

what do you mean AdoQuery... i have dbgrid. it depend on DataSource MyTblSrcDS this DataSource Depend on MyTblSrc wich is in-memory table........... --->> what dose MyTbl Is 1. SQL temporary table? 2. clientdataset object? 3. third-party in-memory tables?

hi irigsoft thank for your answer. but this not what i meant. the problem is not "the unique name of the table..." ========= if i have 200 users and this form have 10 in-memory tables, the the server have to deal with 2000 in-memory tables. if i use SQL temp methode, like Create table #ClientTemp fld1 fld2... the application wil use the AdoDataset name. but sql will give any CREATE its on name and all good. but what is the best practice - to use ClientDataAet as temp tables or create SQL temp table and let SQL to handle it ? should we use SQL, OR CLIENTDATASET or some thing else?

well.... farshad... sherzod... How do you build temp in-memory tables in your applications... in the bible, book of judge chapter 9: see what I'm doing and quickly do the same... so let learn from you guys...

i would like to here from experience users... or those with knowledge... what is the best way to use in-memory tables. i have form that contain 8 tabs, each tab hold some "group" data to enter, check, sort.... NO 1 - AdoDataSet in ReadOnly Mode for look up, select, check existing. NO 2 - TClientDataSet as In-Memory table to help user fill all data related to Indexind Document... some of the data is 1:1 relation (1 document - some property)... some of 1:N relation (list of users / groups with authentication permission) ... what in-memory table beside of clientdataset can be used? who is the prefer one? even if it cost... remember i use ADO as connection to SQL database. if i use SQL memory table as (create #dbTemp....) and 200 users are working simultaneity which method will use less memory in the server? i also have to sort data in memory table by user demand. ASC and DESC. need advised....

hi looking at GridLookUpField demo when i select capital and then press "Enter Key" the following error raise how to fix this problem?

i just move the update to OnBeforeDestroy and it work fine 😀😀

on server module i set AutoCoIntitilaize to True i have adoConnection with cmUnknown on Mode property i use AdoDataset with simple command 'select.... where.... the DataSet found 1 records. then i change the state of the record to Edit (GeneralQry.Edit;) but the state become INSERT ??? - WHY ????? the fields name is Empty ('') the value of the Key Field is Empty (even it found by that key) ??? on the post - the ADO raise exception 'cannot insert new record with null value on user_code field... i tried the connection and build new one.... NADA. i tried remove the AdoDataSet and build new one.... NADA. this update happen in the destroy event of the MainModule.

nice. thanks

if i call : form.showmodal(callback). and the call back identifay the form and the result, can i Always take the "call back data" from the form public area? (in desktop the form wait for close [mrOk,mrCancel....]...)

Hi mhmda this is not good for security reason.....

that good too. so one can catch the ctrl-f5 (like Mohammed suggest) , write cookie to identify the CTRL-F5 , and "ON-LOAD-APP" check if this COOKIE exists... delete the cookie...

good