Jump to content

Jasonjac2

Members
 View Profile  See their activity

  • Content Count

    54

  • Joined

  • Last visited

Everything posted by Jasonjac2

  1. Jasonjac2
    @Lars Fosdal starting to loose the will :-(. But I have enabled FD logs and also enabled ODBC logs. I don't think ODBC logs gives me data being returned, so I can't have a smoking gun for Sage being the culpret. I will post each of the tests below as separate posts for clarity I think. I have pulled out bits from the logs, I am happy to supply you with the logs if they make any more sense from you. There will be a conclusion at the end. Post1 - single row SageExportTest20230303_11_1_32Bit 08_1507.wasexe 20230308_1537 Demo 11U1 32 Bit.txt 08/03/2023 15:38 List ODBC 08/03/2023 15:38 Connect 08/03/2023 15:38 Select select invoice_number, invoice_type, ITEMS_NET, ITEMS_TAX, ITEMS_GROSS from Invoice where invoice_number = 1 Copy to Clipboard INVOICE_NUMBER INVOICE_TYPE ITEMS_NET ITEMS_TAX ITEMS_GROSS 1 Product Invoice 1123.04 191.63 1314.67 Correct ITEMS_GROSS 499603908269 15:39:20.543 >> Fetched [Row=0] 4499604064212 15:39:20.559 . Column [N=1, Type=SLONG, Size=10, Len=4, Data=1] 4499604221005 15:39:20.574 . Column [N=2, Type=CHAR, Size=60, Len=15, Data='Product Invoice'] 4499604377054 15:39:20.590 . Column [N=3, Type=DOUBLE, Size=15, Len=8, Data=1123.04] 4499604533425 15:39:20.606 . Column [N=4, Type=DOUBLE, Size=15, Len=8, Data=191.63] 4499604688718 15:39:20.621 . Column [N=5, Type=DOUBLE, Size=15, Len=8, Data=1314.67] 4499604688873 15:39:20.621 << Fetched [Row=0] 4499604845731 15:39:20.637 . ENTER SQLFetch HSTMT 0x06D7CD48 From Logs: 4499602502605 - > 4499605626273
  2. Jasonjac2
    Unidirectional = same. As @Lajos Juhász says, you can't hook up grid OR in fact issue a fdQuery.savetofile it would appear. I had to cobble together a copy to clipboard for my test. I can confirm that D11Upd1 32 bit on Sage V28 using unidirectional still exhibits the same behaviour. And on the example where I select 2 x rows using an OR, the actual value in the column that is wrong is actually the value in the very last entry in the whole table. i.e. it shouldn't even be part of the resultset. I will try once with the logging turned on and see what it gives me. Will it give me all the data being pulled back from down the pipe? Are there any good / great articles / white papers / books on FD that are better than Google + docwiki?
  3. Jasonjac2
    Looks like you can't "savetofile" for a unidirectional query. As I can't hook up to a grid, I was hoping to just saveToFile <filename>, JSON to keep it simple.
  4. Jasonjac2
    Repeatable in Save V28 demo data, About to test with Unidirectional as suggested by @Lars Fosdal. Any other tests Lars?
  5. Jasonjac2
    10.4.2 32 bit exhibits the same on the Demo Data for Sage v29. Next to check Lars, setting unidirectional. Also, any others to try? In my tiny example, I let the fields be created dynamically due to user provided SQL. Do you think anything about mappings etc could be the cause? Thanks for the article. I think right now, it is probably a bit deep for me, but I will read as I am going to have to become a FD expert at some pioint. I am about to have to break off and work out how to get the data a different way and process it, e.g. -> excel and process it using Delphi to get the user what they want. I need to make it reproducible on different DB's with difference V of Delphi, raise a QP (my colleague says 0 point raising with Sage as they will say "it works with Excel and we don't support Delphi"). I have a colleague who is going to test on V28 & V29 using my code - recompiled in D11.2
  6. Jasonjac2
    64 bit exhibits the same issue. Do you think that encoding / language / locale issues are likely. Just to reiterate the problem in its simplest form: select one invoice by invoice number and the numbers look right. Select multiple invoices (2) and some of the fields get incorrect values (same column same value) and it is repeatable.
  7. Jasonjac2
    That is my next check - we don't use any 64 bit apps onsite, so hadn't even thoughts about it, so just built a 64 bit version and going to create a 64 bit DSN now. Thanks for the thought. In terms of reporting to EMBT - which is bottom of my priority list prior to getting the data I need, I think it will be tricky as the current use case is Sage specific as I only have a sage example.
  8. Jasonjac2
    A long shot and completely related to my other post about d11-update-1-firedac-odbc-to-sage-returning-wrong-data. If I could make the original connection open then all would be good. Basically when I try and connect to the DB in my old app, I get a generic error. I have turned on ODBC logging, which didn't help. Knowing someone else has it working would mean it was worth trying to get to the bottom of that problem, rather than trying to track down a potential bug in D11. TIA JAC.
  9. Jasonjac2
    Thank for the additional info, as you say, it won't be applicable here as I am doing the select from the ODBC source to Sage, not via Excel and it isn't a format issue.
  10. Jasonjac2
    @brian Thank - I didn't realise they were hooked up. They really shouldn't make any difference until the TClientDataset has opened, but I totally get your point and will do another test.
  11. Jasonjac2
    @Brian Evans actually I am pretty sure the value gets "stuck", i.e. the data for that column for ALL rows is then the same, but not for all columns. I mean, that value is actually found in another row. The string columns and a lot of other columns all seem to have the correct data, but there are a bunch of them that break. Initially I thought I was breaking some kind of record for 125 columns or whatever Sage returns, but reducing it to a simple 4 column and 4 rows is enough to break it. I just need to see if it is reproducable on anyone else's set up and then try and report it to EMBT. Actually I hope it is something I am doing wrong, maybe in the connection settings, i.e. just setting the Driver to ODBC, setting DSN, username and password is about all I do. I attached the code in my second post ...zip if you want to take a look.
  12. Jasonjac2
    Sorry, @programmerdelphi2kI know you are trying to be helpful, but it isn't the selection of the rows. Somehow the TField.data is becoming corrupt. For Invoice_number 99 you get 2 different values for FOREIGN_INVOICE_NET FOREIGN_INVOICE_NET="1300" (Actually -5.83 if selected via excel & ODBC or using the specific Where clause) select Invoice_number, FOREIGN_INVOICE_NET where invoice_number = 99 returns different data for Invoice Number 99 than select Invoice_number, FOREIGN_INVOICE_NET where invoice_number <=99 i.e. if you goto the invoice_number = 99 row, the field FOREIGN_INVOICE_NET has a different value.
  13. Jasonjac2
    It all connects OK and I get data. Did you look at the youtube clip I recorded above? TClientDataset - ignore that, it is a not relevant now I have got it down to the minimum set up to reproduce.
  14. Jasonjac2
    I have now built in D11 Upd1 and D11.3 32 bit and both exhibit the same issue. As we only have one Sage install, I could do with seeing if anyone can reproduce.
  15. Jasonjac2
    Thanks for the input. I am getting data, just the wrong data, i.e. not what is in the column, so I think I am way past connection strings etc. This is about a select that returns different field values depending on the number of rows returned, i.e. highly looks like a bug in D + FD+ ODBC.
  16. Jasonjac2
    very basic source. This was built to 32 bit release. It should hook up to any 32 bit ODBC DSN, but I'm especially interested in Sage V29 to see if it is just me. If you are familiar with FD & ODBC, then I would love for you to look at the app, in case I am doing something silly (like a boolean BreakNumbers = true!!) SageExportTest20230303.zip
  17. Jasonjac2
    Hi, I have an immediate need to create folders, files and then create links and passwords for MS OneDrive for Business. I also have a pet project idea for drilling into OneNote. I have briefly looked at the MS Graph API for this and googles stack overflow, MS forums, GITHub. I have definitely not exhausted my time on this, BUT before committing to it I need to ensure I know how much effort it will be to get up to speed and pull together any resources. So: - is anyone driving MS Graph from Delphi (10.x (I am on the latest)). - can you share any code examples - Any Gotchas - Can you point me at any good resources or repos? For the primary usecase - based on some driver file / data I need to: - create a folder structure - not on the PC, but straight to Sharepoint (office 365) / OneDrive for business - upload files - create links & passwords to the folder that can be shared via e-mail (link via e-mail, password via another mechanism) -- these would be given to external intended recipients - probably about 75 folders, between 20 & 500 files in each, probably zipped for convenient download Secondary - to be able to report / track shares on folders, for audit - be able to track access - be able to cancel the shares - be able to tear it all down OneNote Project - I'll cover that another time. TIA if you are still reading. Regards Jason.
  18. Jasonjac2
    Thanks misc_bb, I only just re-found this. I was wondering if anyone else had any more experience now (a few months later). I am about to start again on it I think. Regards,
  19. Jasonjac2
    Hi, I'm doing a talk this week (15th Feb 2022) for the ukDeveloper group www.ukdevgroup.co.uk as requested by a member. It is about using the IBX components and implicitly Interbase & Firebird. I couldn't find any information about which versions of IB & FB the D11 version of IBX played well with and if there are any gotchas. Does anyone have any input / insight into any of this? Thanks in advance. Jason.
  20. Jasonjac2
    Ah yes, I had forgotten about that. So (stating in case my assumption is wrong), FireDAC won't let you do a remote TCP connection to IB or FB. IBX will allow that and is available in Pro (Sorry, I'm on Enterprise and so not sure what is in the Pro). I know a couple of our members (www.ukdevgroup.co.uk) were upset when the CS add-on pack went away. I did think that EMBT may have brought it back, but I don't think it is going to happen. Regards, JAC.
  21. Jasonjac2
    Thanks and all noted. The talk wasn't pitching IBX as the best solution. I like it for its simplicity wrapping InterBase and Firebird, but FireDAC has some pretty amazing features and rich support for a lot of back ends. Thanks all again for your input.
  22. Jasonjac2
    The talk went well (I think).
  23. Jasonjac2
    Hi Serge, thanks for replying. I didn't understand: "why is the FDPhysFBdriver is not compatible is to me largely incomprehensible" - do you mean it doesn't work at all or on certain versions of FB? FB on android - I wasn't sure that people were doing this - which version did you use? Thanks Jeff - I hadn't looked into the bowels of IBX and didn't realise you had a level of abstraction in there for constants etc. Your last line makes me realise I need to spend more time keeping up with developments on IB & FB! Thanks for the vote of confidence in them.
  24. Jasonjac2

    Delphi 11 first look issues

    Jasonjac2 replied to rudy999's topic in General Help

    You have to rename or change the registry for the topics.chm, in the download it is Alexandria_??.chm.
  25. Jasonjac2

    Delphi 11 first look issues

    Jasonjac2 replied to rudy999's topic in General Help

    I dowloaded: Offline CHM Help (Updated: 24th of September 2021) Offline Libraries CHM Help (Updated: 11th of October 2021) unzipped and put in the location (C:\Program Files (x86)\Embarcadero\Studio\22.0\Help\Doc) Pressing F1 still brings up Sydney and it didn't replace "Topics.chm" etc. If I double click it it still has:
×