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.

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.

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.

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.

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.

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

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.

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,

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.

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.

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.

The talk went well (I think).

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.

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

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:

Thanks, I have used the Graph API helper in their online dev tools, which is great at testing out API calls, but still haven't managed to invest the time to build out any Delphi code for it. Hi thanks for the input, when did you look at the MS Docs? I found the API explorer app pretty good, just not put the effort into getting hooked up to the point of being able to issue commands and interpret the results.

You star - I don't know how I missed the FibPlus Repo. See "Later section" Update - I started this a couple of days ago and forgot to post: While I have a hiccup with The Delphi Parser (1), I thought I would try and split the problem into: JVCL / JCL - Just get that installed (2) CnWizards - Just get that installed (3) BDE & IBX (as I am hoping the Delphi Parser will sort almost all of that for me) FibPlus - Hoping to use the Delphi Parser, but need to know what needs translating Everything else (1) - Raised on Friday PM, so not a negative thing as I know the Author is very responsive, so expect to get that sorted when he is back in work (2) JVCL / JCL - had a strange one with the debug library paths confusing the compiler and pointing to the older version that was installed with Tokyo - not sure if something got dragged over with the upgrade, but meant I: refreshed my memory about the order that paths are used; cleaned my paths up a bit. (3) CnWizards - strange, the compiler directive doesn't seem to be working in 10.4 .... Some time later....... 27th August... I actually installed the BDE & BDE components in D10.4 and forked the FibPlus Repo. This isn't to continue with either in 10.4, but means I can move all migration effort to the 10.4 machine and not worry. To this end I have brought the project up in the IDE and realised I also use : 2 components I wrote, a TVersionControl and WPTools from WPCubed. Still planning on the scripted migration. Thanks for your time and hope this might help someone else some day. I'll try and do another update over the weekend. Regards, JAC

Hi, OK, cool, "FIBPlus are available in more or less recent version." - where is this, I could only find a reference on: https://shareappscrack.com/fibplus/?token=75016374 which worried me a bit as it looks like a crack site. BDE - I actually installed the BDE a while back, but don't think the VCL components actually exist, so I agree.... completely dead 🙂 " Ansi=>Unicode transfer" - in practical terms, I am not sure what this is going to mean to me. Another issue is the system is still on Dialect 1 of an old version of FB. I need to work out the migration path for that also, but I thought to get it all over to latest Delphi and then worry about that. So Devrace aren't operating anymore, so would you stick with FIbPlus or migrate away? I don't see many dev's using it or a lot of recent hits regarding it, so worry that the ongoing maintenance for me might be high - but I would be keen to know if there is a group of dev's still using it. I loved FIB & FIBPlus by the way and have excellent memories of meeting up with Serge (sp) and Marina at the FB Conference. Regards & keen to get your input. Thank you for taking the time to reply. "The Delphi Parser" is a 3rd party tool that has scripts for converting Delphi code, so the classic is BDE -> FireDAC, it is more than refind and it understands context and the author can tweak the system to add new types of conversion for the .pas and .dfm. It is interesting stuff and I think much needed. Historically it has been out of my price range, but recently there have been promotions and the author is doing a webinar with EMBT this week I think.

Hi, Sorry Fr0sT.Brutal I didn't explain the background very well. I was hoping that someone had done some work on migrating FibPlus code to a supported data access platform and at the same time was sharing my thoughts on migrating my 300K+ lines of code from D7 to D10.4. See (*) notes at the bottom. Update: While I have a hiccup with The Delphi Parser (1), I thought I would try and split the problem into: JVCL / JCL - Just get that installed (2) CnWiazrds - Just get that installed (3) BDE & IBX (as I am hoping the Delphi Parser will sort almost all of that for me) FibPlus - Hoping to use the Delphi Parser, but need to know what needs translating Everything else I took the simplest part of the system that I could get to compile in isolation and all the dependent units (basically the logging into the database and the datamodule that does the auditing, but required about 4 more units), got it compiling under D7, then moved to D10.4. Of course, without FIbPlus, it didn't compile, so I went back and forth creating Mocks by: 10.4 Attempt to Compile Take the error (undeclared class / property / method), goto the line and copy the exact line Go back to D7, find the line, ctrl click to the declaration, record the unit, etc Go back to 10.4 and create the stubb in the correct unit. Repeat until compile. This has left me with about 8 new units that mirror the declaration of the missing classes, but with no actual code. It compiles and of course, I can't view the DFMs in the designer as there are none of the fibplus components installed in D10.4. Of course, there could be lots of component properties stored in the .dfm's that doesn't exist in the code, so even though it now compiles, it won't run as the first property it finds as is streams the .dfms in is going to stop it. So next up was to use GExperts component to code back in D7 to pull in the different types of FIB+ components in and copy these to some extra unit in my new 10.4. Did this and got those to compile, so in my FibPlus mock units I have things like this: TpFIBDatabase = class(TFIBDatabase) public DatabaseName : String; Connected : boolean; DBParams : TStrings; SQLDialect : Integer; procedure close; procedure open; public // dfm Only DBName : String; DefaultTransaction : TFIBTransaction; Timeout : integer; DesignDBOptions : TDesignDBOptions; WaitForRestoreConnect : integer; end; So next up: work out what these should map onto in FirDAC Then either teach Delphi Parser to convert to FireDAC OR inherit these components from the suitable FirDAC components and add in mapping code. Oren of The Delphi Parser and it looks like is happy to give me a hand / work out the mapping with some examples. I realise there aren't any questions in this one, but I searched and searched and couldn't find any real help with the FIBPlus migration, so these notes may be of some help to someone, sometime. I'll post another update when it compiles and actually accesses the data! Have a good week all. (1) Delphi Parser- Raised on Friday PM, so not a negative thing as I know the Author is very responsive, so expect to get that sorted when he is back in work Had contact with the Author over the weekend and managed to get a conversion done, which is great. Now I need time to see how well it managed BDE -> FIREDAC conversion. (2) JVCL / JCL - had a strange one with the debug library paths confusing the compiler and pointing to the older version that was installed with Tokyo - not sure if something got dragged over with the upgrade, but meant I: refreshed my memory about the order that paths are used; cleaned my paths up a bit. (3) CnWizards - strange, the compiler directive doesn't seem to be working: