Jump to content
uniGUI Discussion Forums


uniGUI Subscriber
  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by mierlp

  1. Hi In the attachment a simple example how to send a sms text message. In this example is use www.bulksms.com for sending my sms messages but you can have you're own one if you want. Every sms provider has his own url for sending messages, in this case you see the url from bulksms. So in you're own case you have to see the documentation of the sms provider. Most sms providers have also mail-to-sms, but for me this is a simple low-cost solution to create you're own 2FA. Regards Peter SendSMS.zip
  2. mierlp


    Hi You need a Windows VPS server for you database and uniGui runtime + application. https://www.bluehost.com/hosting/vps https://www.bluehost.com/hosting/vps https://www.strato.nl/server/vps-windows/ There are some difference between the vps hosting companies regarding CPU, Memory, Harddisk and BandWidth/Traffic BlueHost offers 1 TB bandwidth and others are unlimeted Also see this thread http://forums.unigui.com/index.php?/forum/12-hosting/
  3. mierlp

    Structure large project (ERP)

    Hi I use mysql server with devart component. Easy to host and built mirroring. I have a out 30 customers using the application and every customers has own database environment. Every database environment has via own database backup/restore possibility which we manage. Using a SQL script it is easy to update or change tables. Yes hou have to do it several times but thats easy to automate. But restoring database for one customer can be tricky when eveything is in 1 environments. See also https://digitalguardian.com/blog/saas-single-tenant-vs-multi-tenant-whats-difference
  4. mierlp

    Structure large project (ERP)

    Hi Dominique I had the same situation in a vcl desktop situation years ago. I started with different modules and functionality in .dlls. Based on the subscription the user get extra functionality. After a year a build all functionality in one .exe because sometimes functionality of a .DLL or a part was needed in a other part of the software. Not in the beginnen because the design was completed but after a year new functionality was needed. Sure it can be done but you have to design you program in small pièces. Now i put procedures or functions in datamodules so i can call them when needed and linked to the forms or modules where user can have subsriptions for. This is the way i build my unigui programs. I m also interestet how other members deal with this and learn from it.. so i hope more members will share there experiance Regards peter
  5. mierlp

    SMS Code Works In Exe But Not DLL Application

    Hi The example from drBob is very old..try my example where i use also a sms provider bulksms and messagebird You have to use the provided api link from you provider. I didn't try it using it as a .dll http://forums.unigui.com/index.php?/topic/11892-here-an-example-for-sending-sms/
  6. mierlp

    Resize field width

    See the mockup for illustration for what i need. See attachment when I make the following adjustments: - set uniFieldContainer2.Layout = fit - place a uniFieldSet on unFieldContainder2 with the fields - Result = they will be resized BUT edit2 and edit3 will be below each other instead of side by side
  7. mierlp

    Resize field width

  8. mierlp

    Resize field width

    Yes Edit2 and Edit3 have to be next to each other, not below
  9. mierlp

    Workaround for dblookupcombobox

    Hi Dominique I don't know if your Listsource contains only 1 field or 2 fields where the 2nd is unique. You could then show 2 fields instead of 1 field in your dblookupcombobox. You can enter multiple fields with your Listfield, separated by a ; Another alternative could be to create a calculated field and display it in your Listfield
  10. mierlp

    Resize field width

    When you set LayoutConfig.width and a % that works, see attachement But what's not working is the fields next to each other and will be placed below each other. Maybe it's not possibel to put them next to each other ?
  11. mierlp

    Resize field width

    Hi A very simple testcase attached. In the menu click 'Show frame2'. You see 2 uniFieldcontainers, both are resizing when the form is resized The next step is that the Edit fields also resizes in width, so they must be a percentage compared to the uniFieldContainer2 uniEdit2 and 3 must be stay next to each other Regards Peter TestCase.zip
  12. mierlp

    MyDac replacing FireDac for MYSql connection

    Hi First use the myConnection component. For testing click the right button and choose for CONNECTION EDITOR. Now set server, port, username, password, database and click DIRECT. I put the myConnection on the MainModule. Then you can use a datamodules with TQuery components and set tMyQuery.Connection to the TMyConnection component. In code it's about the same: myConnection.Server :=''you're ip address''|; myConnection.port= 3306; myConnection.Username := 'username'; myConnection.Password := 'password'; myConnection.Database :='databasename'; myConnection.Connect;
  13. mierlp

    Doubt Optical Reader

    Hi Like Abaksoft i use many barcode readers without any problem. The Ctrl-J i think is a barcode reader setting. Reset you're barcode reader or set it to the correct country code. A simple test, enter manual the number in the edit field and hit the enter key to see what happens. If searching is going well, than it's a setting in you're barcode reader. Typing the value is the same as what you do with scanning without the extra characters If it has the same behavior maybe you have some code in the onkeydown or something else
  14. Hi The forum website is very slow..also searching... and if found and move to next page...it takes about 10-15 seconds for next page. Not my internetspeed
  15. mierlp

    Forum, seaching and next page ver slow

    Yes a major improvement
  16. mierlp

    Row select marks the selected cel

    Hi Sherzod THanks...one question...how can i keep the dot line for the whole row
  17. Hi When i set in a dbgrid the option: - RowSelect = True - AlwaysShowSelection = True and i click on a row why will be the cel selected instead of complete row...see image. Am I missing something (which is Always possible ?
  18. mierlp

    Forum, seaching and next page ver slow

    Hi Well...that certainly helps..think about 50% faster...thanks
  19. Hi, My application contains around 90 tables for lookup use. Because I do not want to put this in a menu - it is getting too large, I want to do this in a database.The user sees a dbgrid with 2 columns: - table name as I would in the menu, for example, Type Payment - explanation in the form of a short sentence When the user double clicks on a line, the screen must be opened.In the database I save: - FormName (formTypePayment) or frmTypePayment (file name) - how to open 'show' or 'showmodal' So the form is already part of the application and normally I would call it FormTypePayment.show as follows How can I do this based on the data in the database?
  20. mierlp

    How to Print a Local Printer in unigui?

    Hi Ron, How does 'regulard DB polling to see if there is something to be printed.' working to print a document with a local printer.? Regards Peter
  21. i need to pas the string of the datasebase field showform (it can be show of showmodal) to the FORM. But something like this is not working Form.+table.fieldbyname('howtoshowform').asString; or Form+'.'+table.fieldbyname('howtoshowform').asstring; or with quotedStr(table.fieldbyname('howtoshowform').asString i can do something like this but there must be a more elegant way if table.fieldbyname('howtoshowform').value = 'show' then form.show else form.showmodal
  22. Hi Hayri The code works great ...but is there a way to use the show or showmodal also from database. Every records contains the formname and the way how to show the form, this is a string field How can i use: Form.+table.fieldbyname('howtoshowform').asstring; that it will show the form
  23. mierlp

    Cannot Assign a Nil to a TFont

    Hi For some reason i got this message but can't figure out where and how to found out where/which form/font or wherever this should be. Running the apps in VCL mode it's not a problem but when i use my browser then the message appears, see attachment. Regards Peter
  24. Hi, Is in not possible to copy text to the clipboard using: dbmemo.SelectAll dbmemo.CopyToClipboard Regards Peter
  25. mierlp

    Here an example for sending SMS

    New upload SendSMS v.0.2.zip