Harry Rogers

Thanks for this I've tried it on a Moto g7 power (Android 9) Using Chrome 84.04147.111 All appears to work as expected. Nice job.

I've been using Contabo vps for the past 4 months (4core 8GB,200GB). It's certainly the cheapest and performance has so far been fine - though not a heavy load. It's worth mentioning - they appear to do any required maintenance during normal (GMT) service hours - which has so far resulted in 2, 1 hour periods of inaccessibility - they do have multiple clusters of VPS which are serviced at different times though - and if you have more than one you can request to have them housed on separate and machines and/or in two different data centres - so you can ensure constant accessibility if you share data and apps across them. All support questions have been answered promptly. Note They don't provide any additional firewall in front of your machine as many other providers do.

Thanks very much for sharing this - it seems to work very well. What's the best way to block arriving data so that only specific source Ip addresses trigger a genuine ws.onmessage event? Many thanks

Thanks for sharing - nice example.

That's pretty cool - thanks for sharing

Great, glad to here its working for you. All the best

Sorry you misunderstand me. The main module holds the data set and the export component. the form 'frmSQLRes' has a button named 'btn2Excel' it's the onClick of that which is the code I showed above. Good luck

Hi I have used SMExportToExcel [the components 'about' gives ver 5.0 (b17)]. without issue. I just recompiled an old app (was xe5) using Xe8 and UniGui 1.70.0.1485. It still exports fine. The form with a UniDbGrid (whose dataset is on the MainModule) has a button: It simply sets the filename (from a procedure that gets the query details) on a SMExporttoXLS component that is on the MainModule, and runs the export. procedure TfrmSQLRes.btn2ExcelClick(Sender: TObject); var fname : string; begin fname := makeFilename('.XLS'); unimainmodule.SMExportToXLS1.filename := fname; unimainmodule.SMExportToXLS1.Execute; end;

This looks great - thanks for posting. On a Moto E4+ mobile (chrome 73.03683.75 Android 7.1.1) I never get a prompt to allow the camera and can't find a way to enable it, the site settings within the browser only provide the option to block camera or prompt for permission (which never happens)

Sorry - Not sure why that failed Here we go again https://tinyurl.com/ybezp8qr

Here is a fresh link https://tinyurl.com/GA-dload All the best

Thanks for that - Works perfectly. As always great support !

Thanks for the reply CurrPage = UniDBGrid1.DataSource.DataSet.RecNo div UniDBGrid1.WebOptions.PageSize + 1 That was my initial thought However my database returns the fixed natural order position with dataSet.Recno - not much use with filters and or indexes. I need currpage to enable the calculation of the 'effective Recno' .

Hi CurrRow returns the integer row number for the current page of a UniDbGrid and weboptions.PageSize gives the number of rows per page. How do I read the current page ? - so I can construct a record counter display. Thanks

Setting a form's AutoScroll property to true for a form that is larger than the browser screen size produces scroll bars when the form is maximised but when the form is displayed as a window there are none.