Jump to content

johnp

uniGUI Subscriber
 View Profile  See their activity

  • Posts

    90

  • Joined

  • Last visited

  • Days Won

    2

 Content Type 

Posts posted by johnp

    Booking Schedule Appointment App

    in Jobs

    Posted

    I am interested in buying source or have someone co-develop a uniGUI Booking Schedule Appointment App that would work for service industries whereas clients can make appointments online.  Let me know what you can do or offer. Prefer something that is for most parts developed in already in the works that can be demonstrated. English speaking skills are essential. I am semi-retired and am not wanting to spend full time on this on my own. I will reply by a private message to anyone of interest.

    John P.

    Canada

    Upgraded to 64 bit, now cannot create exe.

    in General

    Posted

    Well, silly me, that seem to fix that issue. I have been away from Delphi projects for awhile. I am a registered user running with uniGUI 1.90.0.155. Although I may have to update or renew. 

    I was hoping I can work with both 32 and 64 bit on the same machine under Delphi  Do I have to create separate library paths? It seems I can only compile 64 bit under Delphi.  Is it possible to install unGUI and create both 64 and 32 bit apps on one machine.?

    Thanks

    John P. .

    Upgraded to 64 bit, now cannot create exe.

    in General

    Posted

    I have recently ungraded to a 64 bit machine for my uniGUI  development. But now on my application I get this error below when I try to create and exe. Under the advice of another post,  I did change my Project-Options-Building-Delphi Compiler-MS Compiler as I thought I saw suggested,  it did compile but cannot run.  

    ''Bad unit format: 'C:\Program Files (x86)\FMSoft\Framework\uniGUI\uIndy\uIdBaseComponent.dcu' - Expected version: 34.0, Windows Unicode(x64) Found version: 34.0, Windows Unicode(x86)''.

    Also wanting to be able to compile both 32 and 64 bit versions. I am running Delphi 10.4 under Windows 10 64 bit.

    Any help to safely configure or lead me that way without breaking is appreciated.

    John P.

     

     

    Second application slow to load

    in Deployment

    Posted

     

    Hello,

    I have been using uniGUI well over 5 years now. I am pleased with what it has done for me and my customers. I have two applications that worked quite well on one machine as a sole server. One program runs a delivery order system for customers and the other is a manifest and reporting system for drivers. With the implementation of Hyperserver, my second driver application has become very slow to load once it gets passed the login. It takes over 30 seconds to show and load the next form and sometimes not at all, but works fine once it is loaded. I use DBISAM for a database as I have for years.

    I have stripped down all I can and have tried various Hyperserver configurations making sure there are no port conflicts. I have made sure I am running the same runtime libraries. I have removed my anti-virus programs for testing with the same results. I was wondering folders for creating nodes could be an issue. Oddly the issue is only with my second driver application, which is basically the same and worked good before. I am currently running in stand alone server mode for testing. Same results on testing with three different servers.

    I am looking any insight that might help me out, especially with Hyperserver.

    Thanks

    John P.

    Track Information Systems - Canada

     

     

    Edit input mask: how to use?

    in General

    Posted

    I am wondering if there are any examples of input masks, and maybe further explanation of the uniEdit properties that someone can provide. I am trying to create an input mask for a Canadian postal code, which I cannot seem to get to work using  L9L-9L9 as an example that uses alpha and numeric values. I am using uniGUI version 1.90.0.1543. 

    John P

    DBISAM - Database Connectivity

    in General

    Posted

    I seem to have resolved my issue. I had to make sure that my autosession name was set to true, and set my session and tables to be active on my main form to allow the login I created . I do have my session component in the data module that I created as suggested. 

     I may have not been calling my session tables to be active soon enough. I had to give a bit of time (sleep 2000) to allow the table I needed to login to open.  I also removed the private directory  setting on my server module since the private directory property no longer exists in recent versions of DBISAM. 

    Also, somehow in the process,  one of my DBISAM databases as defined by the DBISAM server utility, did not contain the defined table list that I needed when I copied over to a different machine under the database name I was using, even though the tables physicaly existed, which likely was the main problem.  Not sure how I lost those settings from the DBISAM server utility.  An oversight on my part if that makes sense. 

    John P. 

    DBISAM - Database Connectivity

    in General

    Posted

    On 11/1/2019 at 10:17 AM, Fred Montier said:

    I just recently upgraded my DBISAM and uniGIU. The DBISAMSession component no longer has a PrivateDir property. I am wondering if you or anyone else is still using DBISAM. I have my session in my datamodule as I always had where it worked before, and as you suggested. For whatever reason I am not able to connect to or open my tables as I could before. I would really hate to abandon DBISAM as it has been flawless for me in other apps, especially in some pretty intense client server applications that I created.  I am wondering if you or anyone else can list the property settings for the session component as you may have along with any location to make the session active. 

    John

     

    On 11/1/2019 at 10:17 AM, Fred Montier said:

    Hi There...

    I also use Dbisam and there is a lot of issues that need to be addressed for it to work/adapt to uniGUI. And these issues do not  produce  the same behavior of other database such as those using Firedac or Zeos described on unigui's manual.

    1- Make the connection in your datamodule. Not in ServerModule or MainMondule.  I know that is against the unigui's manual instructions but trust me, they are not talking about Dbisam anyways. It never work for me using mainmodule to connect the database, servermodule is even worst.  There is a simple reason: Dbisam works generating name sessions to db connections , if set to AutoGenerate, you get some issues that I never found solutions. But if you set AutoGenetares in DataModule, "no problemo amigo". If you set fix session name, also no problems. But in MainModule, only works with fixed names.  But when the second user login in , you have violation at the name space level since dbisam uses session unique names per app and ignores dbisam "websession" handler.

    2- Dbisam generates session handlers per form (a new session at every form, does not matter if you gonna use it or not). That's is the difference. Whether you use the Tdbisamsession or not, they are always there. You can reuse other session from another form and there is no problems with it.

    3- Set the Session privatedir property to Server Temp Folder. That is paramount ! Of course that depends how you handle your temp queries (if disk). For large database, I strongly suggest that you use disk and save temp data to the temp dir.

    4- An Advice: Create a "main" datamodule where you connect and defines session privatedir (ops, privatedir, then connect/Open DB). Then declare the unit's name  in uses clause of other datamodule for reuse. This way you won't have to reopen the db at every form and the same session  can be used in every table or query. That makes everything "smooth and operational". I usually do that with the form uses in the login form. Then it becomes my MainDataModule. You should do it at the OnCreate event in the "MainDataModule" form and then forget about in other datamodule since the db is already open and configured.

    DBisam session is not related to uniGUI (web)session. But one messes up with the other, hence the problems.

     

     

     

    SM Report Designer & Rave Reports

    in General

    Posted

     

    Has anyone used SM Report Designer by Scalabium Software with uniGUI for reports and generating PDFs?  What about Rave Reports ? I have use Fast Reports in the past. Because of tighter budgets I am forced to look at other lower cost options when upgrading Delphi versions and all the 3rd party tools, which for me is becoming too costly for all the tools I use.

     

    John P.

    DBISAM - Database Connectivity

    in General

    Posted

    I would think it just two lines of code for my DBISAMSession1 Remoteuser Remotepassword properties that I tried to add to the servermodule that gave me an error. I am using a datamodule with my project with all DBISAM components and don't have them on my mainmodule, or perhaps there is another error altogether. I tried three different backups that worked before.

    Sorry, I don't have a sample, just my project, which is quite large. Can you just provide a sample of lines of code I could try?  I tried to put my DBISAMSession component on the server as mentioned before with the same result.  I will try maybe to come up with a sample to test the login and connection. If it works for you, could you just provide just a few more details. In the meantime I will try to create a sample but will take a few days as I am more than busy. I do get a connection in the IDE when I set my session property active to true in the IDE, but again when I deploy it DBISAM prompts for a user name and password server side that it did not do before, which the credentials also do not work even though they are correct.

    My other regular client server apps works fine with the same login methods on the same computer.

    Thanks,

    John

    DBISAM - Database Connectivity

    in General

    Posted

    I tried to add my session and the credentials to the server module with the same results. Can you provide a sample as you are suggesting? I have other client server database applications using the same DBISAM dataset without error, so I don't think it is a DBISAM issue.

    Thanks,

     

    John

    DBISAM - Database Connectivity

    in General

    Posted

    Hello All

    I have a DBISAM application that reads credentials from the RemoteUser and Remote Password properties of a DBISAM  client-server session. This has worked very well for many years with UNIGUI version 0.99.95.1303.  I recently migrated the application to a new Windows 10 Pro computer, and at the same time upgraded to DBISAM 4.48 build 6. It was running on a Windows 10 Pro system before. I also have been away from all of this for a couple of years since everything was working so well.

    The issue I am having is that I get a  DBISAM 11287 error. It seems the credentials I use with setting RemoteUser or RemotePassword with Uni edit boxes that I have always used in the app will no longer work, and will not work when the login window pops up to enter the user name and password from the application. My other client server applications that access the same DBISAM database works fine on a Windows 10 machine. Otherwise the application seems to load fine. There seems to be something gone wrong in the translation with the login to the database, which I am not sure where the issue is.

    The other issue is that the DBISAM login dialog box pops up on the server side since the application cannot use the data to log in as I have, and even if I try to enter credentials on the server access is denied with again the DBISAM 11287 error when my UniGui appplication is running.

    Any insight will be appreciated. I am looking both here and asked DBISAM (Elevate Software) for support to try to figure this out.

    On another note.  It would be nice if we maybe had a forum for Database Connectivity.

    John Postnikoff, Canada

    Edit Mask

    in General

    Posted

    I am wondering if it is possible to mask in this format as an example. S7T1A6.  This is an example of a Canadian postal code that I use with the same position of characters and numbers.  I know as an alternative I could have a separate edit box for each character or number and then validate and join to get the correct format on entry.  Just looking to see if there is an easier way.

     

    John P.

    Mobile - UnimDBSelect

    in uniGUI Mobile

    Posted

    Questions for use.

    1. UnimDBSelect on a query.

    a). First the records do not seem to tag or go to the record of a selected item from the UnimDBSelect list.
    It tried two ways to add to my UnimDBSelectlist.

    I checked the autoadd properety as true. The autoadd property does not add all records at once.
    Onlty if I nagivate through each record one at a time with a navigaor then it will add to the UnimDBSelect list.


    B. I tried to add items to my UnimDBSelect as below wih the same result that once poplulated it does not seem
    to match or tag to the record after a selection is made.

    UnimEdit3.Clear;
      DataModule.QryNameList.Filter:= 'Receiver LIKE ''%'+UnimEdit3.Text+'%''';
     while not DA3DataModule.QryRoutes.Eof do
     begin
     UnimList1.Items.Add(DataModule.QryNameList.FieldByName('Lastname').AsString);
     DataModule.QryNameList.refresh;
     end;

     

    What is the best way to populate?  Do I have to create code to tag a record from a UnimDBSelect list and query?


    2. The size of EXe seems to has nearly tripled in size with adding mobile components to my application. From 9mb to 26mb  Why is it so big, or can I configure the use of the librarys differently?


    3. What is the flex property on dbedits?
     

     

    Fast Reports - Issue

    in General

    Posted

    Thanks for the tips and insight. I knew there was something disrupting the data connection but it is beyond me to figure out. Looks like we may need some updated docs and examples for Fast Reports or any other option.  Maybe Farshad and others such as yourself can help with further tweaking these issues in due time. PDF reports are a crutial requirement for me. It is so great the you are willing to share your your tips to help resovle.

     

    Thanks

     

    John P.

    Fast Reports - Issue

    in General

    Posted

    I believe this has to do with the grid or data source. I am running my grid on a tabbed page, which I know was a issue in the past. I also tried different groupings and sort orders in my SQL clauses. Sometimes data from my query would not show on the grid, which I know was correct. I also made sure I had grouping turned off on my grid as that seemed to cause some problems as I tried to get working.

     

    Again here once I started from scratch I could get my queries working but not reports. It almost seems like a table with some null values in columns may had something to do with it or data is cached and not clearing but I could not verify.

     

    My PDF report prints without data and one record per page. I did a test in native Delphi and it works. I have not tried to revert back to a previous version, which I would rather not do in case of some other corruption.

    Fast Reports - Issue

    in General

    Posted

    I am wondering if anyone is using FastReports with DBISAM or any other DB. I seem to have a problem with creating a new report. I cannot get data to display into the bands of the reports. I can get data to show on the page but not in a master or detail band. Pages will print with my titles one page per record without data if set to first and last records, and only one page if set to current record. Just cannot see data and why one page for every record.

     

    I did create a uniGUI web application where I have to show and print only one record as a PDF. That has worked great for months as it prints on the page of the report without bands.  I seem to be having a problem when I try to create a report to print multiple records using bands. I am not sure if this is new or something just not possible with uniGUI.

     

    I did have some issues back in Dec. where data was not showing on second grids on tabbed pages but that was resolved. I am not sure if this is related.

     

    Hoping someone can  help on this. I have all my report components in my datamodule. I am using Delphi XE, DBISAM 4.40  uniGUI .99 Fast Reports 4.13 and Windows 7 Ultimate.

     

    Thanks,

    John P.

×
×
  • Create New...