Re: [MSEide-MSEgui-talk] tmsesql

On 5/3/21 10:00 AM, mohamed hamza wrote: Hi there,    I  just installed mseide v5.2 with free pascal 3.2.  I have some problems with it. Please try the test.prj. In the main.mfm file, the 'size' property has changed / been renamed. open the main.mfm form if it is not open.  (opening it w

Re: [MSEide-MSEgui-talk] tmsesql

The main.mfm form should show.  You may get further error messages.  Read them and update as needed. You will also have to set a database (with needed tables and data)  for the connections component. Patrick ___ mseide-msegui-talk mailing l

Re: [MSEide-MSEgui-talk] tmsesql

Hi Patrick, I agree with you. But now tmsequery.controller.fields.count =0. BTW I had not this problem with 4.6 version. De : Patrick Envoyé : lundi 3 mai 2021 17:20 À : mseide-msegui-talk@lists.sourceforge.net Objet : Re: [MSEide-MSEgui

Re: [MSEide-MSEgui-talk] tmsesql

Hello Med and Pat. I have zero knowledge in MSEgui database. I did try the demo of Med + the instruction of Pat and it compiles. But it does not work because Firebird is not installed on my system. @Med: are you able to compile your demo + run with msegui 4.6 ? Because we did not touch to the

Re: [MSEide-MSEgui-talk] tmsesql

> @Med: are you able to compile your demo + run with msegui 4.6 ? With fpc 3.2.0 of course. Fre;D -- Sent from: http://mseide-msegui-talk.13964.n8.nabble.com/ ___ mseide-msegui-talk mailing list mseide-msegui-talk@lists.sourceforge.net https://l

Re: [MSEide-MSEgui-talk] tmsesql

>From Pat: > Search for "FIRST_NAME" and delete the 'size = 15' line below it. Should > be at lines 99 and 117 > There should be 2. Maybe totally not concerned but once you have done this, you may re-create the "size" field with the Object Inspector: See picture:

Re: [MSEide-MSEgui-talk] tmsesql

This sample works with Ver 4.6. and FPC 3.20. Med De : fredvs Envoyé : lundi 3 mai 2021 18:05 À : mseide-msegui-talk@lists.sourceforge.net Objet : Re: [MSEide-MSEgui-talk] tmsesql >From Pat: > Search for "FIRST_NAME" and delete the 'siz

Re: [MSEide-MSEgui-talk] tmsesql

Hello Med. > This sample works with Ver 4.6. and FPC 3.20. Ha, that is excellent news. Yesterday I spent many hours to try to install FireBird and MySql on my Linux 64 bit Debian machine. Without luck ;-(. Do you have some advices how to install those programs? For example, with the demo /

Re: [MSEide-MSEgui-talk] tmsesql

Re-hello Med. > This sample works with Ver 4.6. and FPC 3.20. I just try to compile your demo with mseide + msegui Ver 4.6. and FPC 3.20 but without luck, here is the error at compilation: msegraphedits.pas(126,19) Error: No matching implementation for interface method "getdefaultifilink:iifi

Re: [MSEide-MSEgui-talk] tmsesql

-MSEgui-talk] tmsesql Re-hello Med. > This sample works with Ver 4.6. and FPC 3.20. I just try to compile your demo with mseide + msegui Ver 4.6. and FPC 3.20 but without luck, here is the error at compilation: msegraphedits.pas(126,19) Error: No matching implementation for interface met

Re: [MSEide-MSEgui-talk] tmsesql

Hello Med. After a very hard fight I was able to install MySql on Linux 64 bit. Also here /mseuniverse/samples/db/simplemysql demo is working with fpc 320 and msegui 5.2. Are you able to make it work too? I had to create a test.sql database and a table using command line: $ mysql -uroot -pmypass

Re: [MSEide-MSEgui-talk] tmsesql

Re-re hello Med and others. Voila, I think that FireBird 3 is correctly installed. With your demo I can access employee database. But, sadly, when trying to set tmsesqlquery1.active := true there is that error message: Field 'EMP_NO' expected ftsmallint Actual: unknown. See picture:

Re: [MSEide-MSEgui-talk] tmsesql

Objet : Re: [MSEide-MSEgui-talk] tmsesql Re-re hello Med and others. Voila, I think that FireBird 3 is correctly installed. With your demo I can access employee database. But, sadly, when trying to set tmsesqlquery1.active := true there is that error message: Field 'EMP_NO'

Re: [MSEide-MSEgui-talk] tmsesql

Hello Med. > See tmsesql.controller.fields .The problem is there. OK, I will check it. > Try with (MseIde 4.6.3 Msegui 4.7.0 ) On Linux it is not possible to use MSEgui 4.7.O and fpc 3.2.0: they are not compatible. And I dont have a Windows machine to test. > Is the version 5.2 updated the

Re: [MSEide-MSEgui-talk] tmsesql

Hello Med. Here it works doing this: Edit tmsesqlquery1 with the Object Inspector. Select tmsesqlquery1.controller.fields.count and set it to 0. Then set tmsesqlquery1.active := true;

Re: [MSEide-MSEgui-talk] tmsesql

Re-hello Med. So, to resume, it seems that, like for the "size" problem, with MSEgui 5.2.0, if you import a old fb3 project, you have to first delete the controller.fields and then re-create it. Or delete the all the component and re-create it using msegui 5.2.0. I created a new project from scra

Re: [MSEide-MSEgui-talk] tmsesql

Hello Fred, But why fieldstype are unknown ? see joined png De : fredvs Envoyé : samedi 8 mai 2021 01:49 À : mseide-msegui-talk@lists.sourceforge.net Objet : Re: [MSEide-MSEgui-talk] tmsesql Re-hello Med. So, to resume, it seems that, like for the

Re: [MSEide-MSEgui-talk] tmsesql

Hello Med. What project are you using? With the last project I give, I get this: Here the last project I give: mse_fb3_new.zip Note that I di

Re: [MSEide-MSEgui-talk] tmsesql

Re-re...-re hello Med. OK, I think I get something. I just try now to load the project with MSEide and, indeed, there is "Unknown" fields. I was using ideU to load the project.

Re: [MSEide-MSEgui-talk] tmsesql

Med! Sorry, dont use the last release of ideU, it is the last commit that works. So, please wait a little bit, I check everything but we are near the goal. Fre;D -- Sent from: http://mseide-msegui-talk.13964.n8.nabble.com/ ___ mseide-msegui-talk m

Re: [MSEide-MSEgui-talk] tmsesql

Hello Med. I am lost. I cannot find what I did to make it work with ideU. Sadly I did not commit the change to git and stupidly I removed that working test directory. I have to do a break otherwise I will be completely crazy. I hope that I will remember what I did but now it is the black out.

Re: [MSEide-MSEgui-talk] tmsesql

Hello Med. I hope it is the last one. Fixed in last commit: https://github.com/mse-org/mseide-msegui You will need to recompile MSEide with those last msegui commit. After this, reload your project using last msegui and i

Re: [MSEide-MSEgui-talk] tmsesql

Hello Med. Released mseide-msegui 5.4.0 with the (I hope) DB field fixes: https://github.com/mse-org/mseide-msegui/releases/tag/5.4.0 You may use the binary of MSEide and source that are in the assets. I still cross my fingers. Fre;D -- Sent from: http://mseide-msegui-talk.13964.n8.nabble.c

Re: [MSEide-MSEgui-talk] tmsesql

: Re: [MSEide-MSEgui-talk] tmsesql Hello Med. Released mseide-msegui 5.4.0 with the (I hope) DB field fixes: https://github.com/mse-org/mseide-msegui/releases/tag/5.4.0 You may use the binary of MSEide and source that are in the assets. I still cross my fingers. Fre;D -- Sent from: http

Re: [MSEide-MSEgui-talk] tmsesql

Hello Med. Happy that it works! Thanks for your txt notes, I will study it tonight. By the way, feel free to complete your demo (with filters, search, commander, etc, ...) because I did not find any demo in mseuniverse that shows how to do with fb3 database. And then we can add your demo in mse

Re: [MSEide-MSEgui-talk] tmsesql

Hello Med and others. About the warnings of range error. It is about some strange use of enum by Martin. I would need some help to fix it. For example, this is used: Const de_afterapplyupdate = ord(high(tdataevent))+6; and a few later: dataevent(tdataevent(de_afterapplyupdate),0); // this,

Re: [MSEide-MSEgui-talk] tmsesql

Re-hello. About the error range warnings with enums. OK, I remember now how to fix it (there was discussion about this 2 years ago). The trick is to remove all the "extended members of a enum", like const extendedenum1 = ord(high(tdataevent))+1; extendedenum2 = ord(high(tdataevent))+2; end

Re: [MSEide-MSEgui-talk] tmsesql

Hello Med. > I have some notes and warning see joined txt. OK, fixed in last commit. Fre;D -- Sent from: http://mseide-msegui-talk.13964.n8.nabble.com/ ___ mseide-msegui-talk mailing list mseide-msegui-talk@lists.sourceforge.net https://lists.sour

Re: [MSEide-MSEgui-talk] tmsesql

Hello! Maybe the idea was to compile with range check error disabled. But Ord(High()) looks weird indeed. Not sure to understand what is the reason for extending enumerated types that way. Regards. Roland -- Sent from: http://mseide-msegui-talk.13964.n8.nabble.com/ ___

Re: [MSEide-MSEgui-talk] tmsesql

Hello all. > OK, fixed in last commit. NO, it was not ok and caused "Unknown" fields. So I reverted that commit to prior. And there are still now the warnings, sorry. I have to jump into it deeper and will do it asap. Fre;D -- Sent from: http://mseide-msegui-talk.13964.n8.nabble.com/ ___

Re: [MSEide-MSEgui-talk] tmsesql

Re-hello all. OK, I hope it is the good one. Fixed in last commit all warnings about range check in enums of DB units. Fre;D -- Sent from: http://mseide-msegui-talk.13964.n8.nabble.com/ ___ mseide-msegui-talk mailing list mseide-msegui-talk@lists.s