• Re: Errors when testing the TMySqlServer class of the mysql.lib lib

    From Enrico Maria Giordano@21:1/5 to All on Fri Mar 17 23:40:51 2023
    DQoNCklsIDE3LzAzLzIwMjMgMjM6MzMsIHJlaW5hLi4uQGdtYWlsLmNvbSBoYSBzY3JpdHRv Og0KDQo+IEVucmljbywNCj4gDQo+IFRoZSBlcnJvciBpcyB0aGUgZm9sbG93aW5nOg0KPiAN Cj4gICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgIEVycm9yIEJBU0UvMTA2NiAgQXJndW1lbnQgZXJyb3I6IGNvbmRpdGlvbmFs IEFyZ3VtZW50czogKCBbIDFdID0gVHlwZTogTiBWYWw6ICAgICAgICAgIDApICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIEVycm9yIGF0IC4uLjogKGIpVE1Z U1FMU0VSVkVSOkNSRUFURVRBQkxFKDE0MTkpIGluIE1vZHVsZTogdG15c3FsLnByZyAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIENhbGxlZCBm cm9tIDogVE1ZU1FMU0VSVkVSOkNSRUFURVRBQkxFKDE0MjcpIGluIE1vZHVsZTogdG15c3Fs LnByZyAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgIENhbGxlZCBmcm9tIDogTUFJTigxMDUpIGluIE1vZHVsZTogVEVTVC5QUkcNCj4gDQo+ IC8vIHJldHVybnMgTk9UIE5VTEwgaWYgZXh0ZW5kZWQgc3RydWN0dXJlIGhhcyBEQlNfTk9U TlVMTCBmaWVsZCB0byB0cnVlDQo+ICAgTE9DQUwgY05OIDo9IHt8IGFBcnIgfCBpaWYoIExl biggYUFyciApID4gREJTX0RFQywgaWlmKCBhQXJyWyBEQlNfTk9UTlVMTCBdLCAiIE5PVCBO VUxMICIsICIiICksICIiICkgfQ0KDQpDaGVjayBpZiBhU3RydWN0WyBpIF0gaXMgYW4gYXJy YXkuDQoNCi0tIA0KRW5yaWNvIE1hcmlhIEdpb3JkYW5vDQoNCmh0dHA6Ly93d3cuZW1hZ3Nv ZnR3YXJlLml0DQpodHRwOi8vd3d3LmVtYWdzb2Z0d2FyZS5pdC9lbWdtdXNpYw0KaHR0cDov L3d3dy5lbWFnc29mdHdhcmUuaXQvc3BlY3RydW0NCmh0dHA6Ly93d3cuZW1hZ3NvZnR3YXJl Lml0L3Rib3NnDQoNCg==

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From reinaldohf@gmail.com@21:1/5 to All on Fri Mar 17 15:33:03 2023
    Enrico,

    The error is the following:







    Error BASE/1066 Argument error: conditional Arguments: ( [ 1] = Type: N Val: 0)
    Error at ...: (b)TMYSQLSERVER:CREATETABLE(1419) in Module: tmysql.prg
    Called from : TMYSQLSERVER:CREATETABLE(1427) in Module: tmysql.prg Called from : MAIN(105) in Module: TEST.PRG

    // returns NOT NULL if extended structure has DBS_NOTNULL field to true
    LOCAL cNN := {| aArr | iif( Len( aArr ) > DBS_DEC, iif( aArr[ DBS_NOTNULL ], " NOT NULL ", "" ), "" ) }

    I don't know how to resolve this error.

    Thank for your help

    Reynaldo Henrique

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From reinaldohf@gmail.com@21:1/5 to All on Fri Mar 17 16:15:41 2023
    // returns NOT NULL if extended structure has DBS_NOTNULL field to true LOCAL cNN := {| aArr | iif( Len( aArr ) > DBS_DEC, iif( aArr[ DBS_NOTNULL ], " NOT NULL ", "" ), "" ) }
    Check if aStruct[ i ] is an array.

    I checked it: it is a array, that is ok.

    Reynaldo.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Enrico Maria Giordano@21:1/5 to All on Sat Mar 18 09:48:50 2023
    Il 18/03/2023 00:15, reina...@gmail.com ha scritto:

    // returns NOT NULL if extended structure has DBS_NOTNULL field to true
    LOCAL cNN := {| aArr | iif( Len( aArr ) > DBS_DEC, iif( aArr[ DBS_NOTNULL ], " NOT NULL ", "" ), "" ) }

    Check if aStruct[ i ] is an array.

    I checked it: it is a array, that is ok.

    Can I reproduce the error here? Please not that I have never used that lib.

    --
    Enrico Maria Giordano

    http://www.emagsoftware.it
    http://www.emagsoftware.it/emgmusic
    http://www.emagsoftware.it/spectrum
    http://www.emagsoftware.it/tbosg

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From reinaldohf@gmail.com@21:1/5 to All on Sat Mar 18 04:28:50 2023
    Enrico,

    Can I reproduce the error here? Please not that I have never used that lib.
    I tested "c:\xharbour\contrib\mysql\tests\test.prg"
    If you don't have the lib, I can send it to you.
    If you don't have "test.prg", I can send it to you.

    Reynaldo Henrique

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Enrico Maria Giordano@21:1/5 to All on Sat Mar 18 12:51:40 2023
    Il 18/03/2023 12:28, reina...@gmail.com ha scritto:

    Can I reproduce the error here? Please not that I have never used that lib.

    I tested "c:\xharbour\contrib\mysql\tests\test.prg"
    If you don't have the lib, I can send it to you.
    If you don't have "test.prg", I can send it to you.

    Yes, please, send me all that is required to compile and run the sample.
    I need to reproduce the problem.

    --
    Enrico Maria Giordano

    http://www.emagsoftware.it
    http://www.emagsoftware.it/emgmusic
    http://www.emagsoftware.it/spectrum
    http://www.emagsoftware.it/tbosg

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From reinaldohf@gmail.com@21:1/5 to All on Sat Mar 18 08:37:13 2023
    Yes, please, send me all that is required to compile and run the sample.
    I need to reproduce the problem.

    Enrico,

    Please check your email.

    I build the lib using hbmake -elx mysql.bc
    I build the test.exe using hbmake -ex test.bc

    Thanks for your help.

    Reynaldo Henrique

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Enrico Maria Giordano@21:1/5 to All on Sat Mar 18 17:20:16 2023
    Il 18/03/2023 16:37, reina...@gmail.com ha scritto:

    Yes, please, send me all that is required to compile and run the sample.
    I need to reproduce the problem.

    Enrico,

    Please check your email.

    I build the lib using hbmake -elx mysql.bc
    I build the test.exe using hbmake -ex test.bc

    I have never used (nor have) hbmake. Can you build everything is
    required to compile the sample and send it to me, please?

    --
    Enrico Maria Giordano

    http://www.emagsoftware.it
    http://www.emagsoftware.it/emgmusic
    http://www.emagsoftware.it/spectrum
    http://www.emagsoftware.it/tbosg

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From reinaldohf@gmail.com@21:1/5 to All on Sat Mar 18 14:23:32 2023
    Enrico,

    I have never used (nor have) hbmake. Can you build everything is
    required to compile the sample and send it to me, please?
    It is not necessary, because I worked hard and fixed all the bugs that the classe had. ;)
    I use only hbmake.exe para compilar meus fontes, extremely ease to use it.
    But I will send everyting I did, just for you test the classes.

    Thanks for your all attention.

    Reynaldo Henrique

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From reinaldohf@gmail.com@21:1/5 to All on Sat Mar 18 16:03:44 2023
    Enrico,
    I have never used (nor have) hbmake. Can you build everything is
    required to compile the sample and send it to me, please?
    It is not necessary, because I worked hard and fixed all the bugs that the classe had. ;)
    I use only hbmake.exe para compilar meus fontes, extremely ease to use it. But I will send everyting I did, just for you test the classes.

    Thanks for your all attention.
    Please check you email.
    I sent everyting you need for you testing the classes.

    Thanks for your attention.

    Reynaldo Henrique

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Enrico Maria Giordano@21:1/5 to All on Sun Mar 19 00:12:36 2023
    Il 19/03/2023 00:03, reina...@gmail.com ha scritto:

    Please check you email.
    I sent everyting you need for you testing the classes.

    Thank you. I will try to compile it. I have not received it yet.

    --
    Enrico Maria Giordano

    http://www.emagsoftware.it
    http://www.emagsoftware.it/emgmusic
    http://www.emagsoftware.it/spectrum
    http://www.emagsoftware.it/tbosg

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Enrico Maria Giordano@21:1/5 to All on Sun Mar 19 00:11:04 2023
    Il 18/03/2023 22:23, reina...@gmail.com ha scritto:

    I have never used (nor have) hbmake. Can you build everything is
    required to compile the sample and send it to me, please?

    It is not necessary, because I worked hard and fixed all the bugs that the classe had. ;)

    Great! So you do not need my help anymore, right?

    --
    Enrico Maria Giordano

    http://www.emagsoftware.it
    http://www.emagsoftware.it/emgmusic
    http://www.emagsoftware.it/spectrum
    http://www.emagsoftware.it/tbosg

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From reinaldohf@gmail.com@21:1/5 to All on Mon Mar 20 04:38:09 2023
    Enrico,

    Please check you email.
    I sent everyting you need for you testing the classes.
    Thank you. I will try to compile it. I have not received it yet.

    I tested all classes of mysql! Now they are working fine.
    The dbf2mysql.prg now is working as well.
    Now I have a hard work to do, I want start to migrate my app from dbf into mysql.

    Thanks for all your attention!

    Reynaldo Henrique

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Enrico Maria Giordano@21:1/5 to All on Mon Mar 20 14:03:56 2023
    Il 20/03/2023 12:38, reina...@gmail.com ha scritto:

    I tested all classes of mysql! Now they are working fine.
    The dbf2mysql.prg now is working as well.
    Now I have a hard work to do, I want start to migrate my app from dbf into mysql.

    Great! Do you have a list of fix so I can update the SVN?

    --
    Enrico Maria Giordano

    http://www.emagsoftware.it
    http://www.emagsoftware.it/emgmusic
    http://www.emagsoftware.it/spectrum
    http://www.emagsoftware.it/tbosg

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Enrico Maria Giordano@21:1/5 to All on Tue Mar 21 20:42:40 2023
    Il 20/03/2023 14:03, Enrico Maria Giordano ha scritto:

    I tested all classes of mysql! Now they are working fine.
    The dbf2mysql.prg now is working as well.
    Now I have a hard work to do, I want start to migrate my app from dbf
    into mysql.

    Great! Do you have a list of fix so I can update the SVN?

    Sorry, it is not good. You have used a very old source code:

    /*
    * $Id: tmysql.prg 9494 2012-06-24 07:20:41Z andijahja $
    */

    The latest is:

    /*
    * $Id: tmysql.prg 10069 2014-12-11 08:28:08Z zsaulius $
    */

    --
    Enrico Maria Giordano

    http://www.emagsoftware.it
    http://www.emagsoftware.it/emgmusic
    http://www.emagsoftware.it/spectrum
    http://www.emagsoftware.it/tbosg

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From reinaldohf@gmail.com@21:1/5 to All on Tue Mar 21 14:31:43 2023
    Sorry, it is not good. You have used a very old source code:

    /*
    * $Id: tmysql.prg 9494 2012-06-24 07:20:41Z andijahja $
    */

    The latest is:

    /*
    * $Id: tmysql.prg 10069 2014-12-11 08:28:08Z zsaulius $
    */

    Could you send the last for me?

    Reynaldo Henrique

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Enrico Maria Giordano@21:1/5 to All on Tue Mar 21 23:12:03 2023
    Il 21/03/2023 23:09, Enrico Maria Giordano ha scritto:

    Just sent to your private email.

    This is the complete latest xHarbour source code:

    http://www.xharbour.org/files/download/windows/xhb10269_src.zip

    From this page:

    http://xharbour.org/index.asp?page=download/sources

    --
    Enrico Maria Giordano

    http://www.emagsoftware.it
    http://www.emagsoftware.it/emgmusic
    http://www.emagsoftware.it/spectrum
    http://www.emagsoftware.it/tbosg

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Enrico Maria Giordano@21:1/5 to All on Tue Mar 21 23:09:38 2023
    Il 21/03/2023 22:31, reina...@gmail.com ha scritto:

    Sorry, it is not good. You have used a very old source code:

    /*
    * $Id: tmysql.prg 9494 2012-06-24 07:20:41Z andijahja $
    */

    The latest is:

    /*
    * $Id: tmysql.prg 10069 2014-12-11 08:28:08Z zsaulius $
    */

    Could you send the last for me?

    Just sent to your private email.

    --
    Enrico Maria Giordano

    http://www.emagsoftware.it
    http://www.emagsoftware.it/emgmusic
    http://www.emagsoftware.it/spectrum
    http://www.emagsoftware.it/tbosg

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From reinaldohf@gmail.com@21:1/5 to All on Tue Mar 21 14:30:00 2023
    Em terça-feira, 21 de março de 2023 às 16:42:41 UTC-3, Enrico Maria Giordano escreveu:
    Il 20/03/2023 14:03, Enrico Maria Giordano ha scritto:

    I tested all classes of mysql! Now they are working fine.
    The dbf2mysql.prg now is working as well.
    Now I have a hard work to do, I want start to migrate my app from dbf
    into mysql.

    Great! Do you have a list of fix so I can update the SVN?
    Sorry, it is not good. You have used a very old source code:

    /*
    * $Id: tmysql.prg 9494 2012-06-24 07:20:41Z andijahja $
    */

    The latest is:

    /*
    * $Id: tmysql.prg 10069 2014-12-11 08:28:08Z zsaulius $
    */
    --
    Enrico Maria Giordano

    http://www.emagsoftware.it
    http://www.emagsoftware.it/emgmusic
    http://www.emagsoftware.it/spectrum
    http://www.emagsoftware.it/tbosg

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From reinaldohf@gmail.com@21:1/5 to All on Tue Mar 21 15:26:17 2023
    Enrico,

    Just sent to your private email.
    This is the complete latest xHarbour source code:

    http://www.xharbour.org/files/download/windows/xhb10269_src.zip

    From this page:

    http://xharbour.org/index.asp?page=download/sources
    --
    I download the sources and tmysql.prg gives the same error.

    Error BASE/1066 Argument error: conditional Arguments: ( [ 1] = Type: N Val: 0)

    Error at ...: (b)TMYSQLSERVER:CREATETABLE(1419) in Module: tmysql.prg
    Called from : TMYSQLSERVER:CREATETABLE(1455) in Module: tmysql.prg
    Called from : MAIN(138) in Module: DBF2MYSQL.PRG

    Try to test there,

    Reynaldo Henrque

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Enrico Maria Giordano@21:1/5 to All on Wed Mar 22 09:21:47 2023
    Il 21/03/2023 23:26, reina...@gmail.com ha scritto:

    I download the sources and tmysql.prg gives the same error.

    Yes, I know, but you have to apply your fixes to the updated source
    code, not to an older one. Otherwise, I cannot update the SVN with an
    older source code, sorry.

    Try to test there,

    I wish I could, but I cannot test it here as I haven't MySQL installed.

    --
    Enrico Maria Giordano

    http://www.emagsoftware.it
    http://www.emagsoftware.it/emgmusic
    http://www.emagsoftware.it/spectrum
    http://www.emagsoftware.it/tbosg

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From reinaldohf@gmail.com@21:1/5 to All on Tue Mar 28 06:12:42 2023
    Enrico,

    Could you provide me with a link to full updated xharbour sources?
    Because my fonts are old.
    I already provided it:
    Il 21/03/2023 23:09, Enrico Maria Giordano ha scritto:
    Just sent to your private email.
    This is the complete latest xHarbour source code:

    http://www.xharbour.org/files/download/windows/xhb10269_src.zip


    Thank you very much.

    Reynaldo Henrique

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From reinaldohf@gmail.com@21:1/5 to All on Tue Mar 28 05:25:40 2023
    Enrico,

    Yes, I know, but you have to apply your fixes to the updated source
    code, not to an older one. Otherwise, I cannot update the SVN with an
    older source code, sorry.

    Enrico,

    Could you provide me with a link to full updated xharbour sources?
    Because my fonts are old.

    Thanks,

    Reynaldo Henrique

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Enrico Maria Giordano@21:1/5 to All on Tue Mar 28 14:38:03 2023
    Il 28/03/2023 14:25, reina...@gmail.com ha scritto:

    Yes, I know, but you have to apply your fixes to the updated source
    code, not to an older one. Otherwise, I cannot update the SVN with an
    older source code, sorry.

    Enrico,

    Could you provide me with a link to full updated xharbour sources?
    Because my fonts are old.

    I already provided it:

    Il 21/03/2023 23:09, Enrico Maria Giordano ha scritto:

    Just sent to your private email.
    This is the complete latest xHarbour source code:

    http://www.xharbour.org/files/download/windows/xhb10269_src.zip

    From this page:

    http://xharbour.org/index.asp?page=download/sources

    --
    Enrico Maria Giordano

    http://www.emagsoftware.it
    http://www.emagsoftware.it/emgmusic
    http://www.emagsoftware.it/spectrum
    http://www.emagsoftware.it/tbosg

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)