zoran

  • zoran replied to the topic Error in 5.18 in the forum kbmMW 4 years, 9 months ago

    No. I reverted to 5.16. This is in D 10.4.2. When I have the time I’ll try it in D 11 (which I’m not using yet – waiting for the next 1-2 patches)

  • zoran started the topic Error in 5.18 in the forum kbmMW 4 years, 10 months ago

    Hi Kim

    After installing 5.18 I get this error when my client app tries to login into the server (either service or standalone):

    Error reading kbmMWCustomService.PixelsPerInch: Property PixelsPerInch does not exists (SERVER)

    In 5.16 and previous versions I did not have this problem.

    Regards

    Zoran

     

  • … from C:kbmMWSource.

    I didn’t try to install D104 packages.

    Zoran

  • zoran started the topic Comment: add this path to Delphi in the forum kbmMW 5 years ago

    Besides adding paths for source, ciphers, compression and hashes in kbmMW 5.16.0 you need to add

    C:kbmMWSourceSocket

    to Delphi lib paths.

    Zoran

  • zoran replied to the topic Async calls in the forum kbmMW 5 years, 1 month ago

    Hello Everyone

    Found the solution. It’s a simple TDictionary list of RequestIds and callback procedures. Upon return from query/service in kbmMWTCPIPIndyMessagingClientTransport1AsyncResponse event I check RequestId against this list and, if found, execute corresponding callback procedure.

    If any of the fellow kbmMW-ers is interested I can send…[Read more]

  • zoran started the topic Async calls in the forum kbmMW 5 years, 1 month ago

    Hi Kim

    kbmMW allows me to do async queries and async service requests. Return results of all async requests are processes in kbmMWTCPIPIndyMessagingClientTransport1AsyncResponse event.

    It’s easy if I have one form and one query/service. My problem is multiple forms and multiple queries/service-requests in each form.

    Is there an easy technique…[Read more]

  • zoran started the topic Install error in the forum kbmMW 5 years, 4 months ago

    Hello

    Am I the only one who gets this install error ‘Undeclared identifier’?

    unit kbmMWCustomConnectionPool;

    function TkbmMWCustomSQLRewriter.FieldDefs2FieldNodes(const AFieldDefs:TkbmMWFieldDefs):TkbmSQLFieldNodes;


    fn.Default:=nil; <=== undeclared identifier

    There is fn.DefaultValue declared and if I change it in few places it…[Read more]

  • zoran started the topic Kim, please… in the forum kbmMW 5 years, 4 months ago

    Hi Kim

    I know you have no or little time.

    Please visit kbmMemTable forum. Top 2 posts are about problem with new kbmMemTable 7.91.

    I had to reverse to the previous version of kbmMW and kbmMemTable release. So did some other users.

    Thank you.

    Regards

    Zoran

     

  • Looks like 79100 has some problems. I had to revert back to older versions of kbmMemtable and kbmMW (post FindKey problem below).

    Unfortunately Kim doesn’t have enough time to visit this forum 🙁

    Zoran

     

  • zoran replied to the topic Findkey problem in the forum kbmMemTable 5 years, 5 months ago

    In debugger after

    mt.IndexFieldNames:= ‘Age’;
    mt.IndexName := ‘ix_Age’;

    both fields are still empty (?).

  • zoran started the topic Findkey problem in the forum kbmMemTable 5 years, 5 months ago

    Hi Kim

    At design time I populate FieldDefs and IndexDefs. All other settings are default. In code I have:

    mt.IndexFieldNames:= ‘Age’;
    mt.IndexName := ‘ix_Age’;

    mt.FindKey([2]);  //there is a row with Age=2.

    Here I get error: ‘There must be at least one field.’

    This started happening with kbmMemTable 7.91.0.

    All my production programs…[Read more]

  • Hi Kim
    I hate to be pain in the neck. I did EXACTLY what this article says (triple checked it) and my client cannot connect to the server (message ‘Connection lost.’).

    I guess my .cnf file has some wrong […]

  • zoran replied to the topic Scheduler question in the forum kbmMW 6 years, 3 months ago

    Scheduler.Run(procedure(const AScheduledEvent:IkbmMWScheduledEvent)
    begin
    v := DM.kbmMWPooledSimpleClient1.Request(‘SVC_Common’, ‘1.0’, ‘GetLookupTable’, [‘all’]);
    AScheduledEvent.Data := v;
    end
    )
    .SynchronizedAfterRun(
    procedure(const…[Read more]

  • zoran started the topic Scheduler question in the forum kbmMW 6 years, 3 months ago

    Hi Kim

    In OnShow event of my main form I have the following code:

    v:= DM.kbmMWPooledSimpleClient1.Request(‘SVC_Common’, ‘1.0’, ‘GetLookupTable’, [‘all’]);
    RefreshLookupAll_LoadTables(v);

    And it works ok. I would like to do it in a thread, but this code doesn’t work:

    Scheduler.Run(procedure
    begin
    v :=…[Read more]

  • Forget it.

    It’s Delphi’s handling of Timestamp column. Both server and client use regional (local) FormatSettings to process Timestamp column, so different regions cause this error.

  • kbmMW 5.10.20 Ent, Firebird 3.0.5, Delphi 10.3.3

    In a table I have TIMESTAMP column. If I read that table from the client in the same Region as server all is ok. If I read the same table where client is in the different region than server, I get error message ‘Could not parse SQL TimeStamp string’.

    In another words if server is in US and client…[Read more]

  • After some more testing I found out that PrepareForData can be replaced with qry.Open.

    Some accents are lost with this code:

    qry.Close;

    //qry.Open;

    qry.AllData := v;

    but if I uncomment the second line, all works fine.

  • Hi Kim

    In my client I had:

    qry.AllData := v;

    When I add in front of it

    kbmMWBinaryStreamFormat1.PrepareForData(False, False);

    all works fine.

    Thank you.

  • Hi Kim

    I have table with string field containing characters with accents. When I run query from the client I get everything ok. If I call a service, read same data and return .AllData to the client, some of the accented letters loose accent. For example Š, Đ are returned as expected, but Č and Ć are both returned as letter C.

    On the server sid…[Read more]

  • Hello Kim

    I have the following code to load image into table:

    ms: TkbmMWMemoryStream;

    qryTemp.Query.Text := ‘update SYSSETUP set Sys_Image=:img where Id=1);
    qryTemp.ParamByName[‘img’].LoadFromStream(ms, ftBlob);
    qryTemp.Execute;

    It works as expected when I use kbmMWTCPIPIndyServerTransport, but if I use kbmMWTCPServerTransport it fails…[Read more]

  • Load More