Jump to content

Nathan Wild

Members
  • Content Count

    51
  • Joined

  • Last visited

Community Reputation

3 Neutral

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. I have had issues before with master/detail relationships with FireDAC. Here is my situation: RadStudio 10.1-Berlin, connecting to Pervasive SQL via ODBC (although I have had similar problems with MSSQL-Native, and Access via ODBC. Master dataset is a simple TFDMemTable with a few fields, the important one being an invoice number named "InvNmbr". Detail dataset is an equally simple TFDQuery . In this case I only need ONE field in the query If I set the detail query SQL to a simple single-table "SELECT InvNmbr, TaxAmount1 FROM XTOTAL WHERE InvNmbr=:INVNMBR;", set MasterSource to my FDMemTable's datasource and set MaterFields to 'InvNmbr', I get the error in the subject line. HOWEVER, if I get the detail query SQL to include a join on two related tables (which returns an identical recordset) "SELECT XMASTER.InvNmbr, TaxAmount1 FROM XMASTER INNER JOIN XTOTAL ON XMASTER.InvNmbr=XTOTAL.InvNmbr WHERE XMASTER.InvNmbr=:INVNMBR", and set the MasterSource/MasterFields the same way, it works properly?! I am at a loss to explain this? Of note: - There is only the one parameter so why is FireDAC even messing about with a parameter #2? - I thought maybe the InvNmbr field and INVNMBNR parameters might be muddling things, so I tried fully qualifying it in the single table query (as "XTOTAL.InvNmbr") and it does the same thing. - In my ODBC database the XMASTER and XTOTAL tables are both keyed on InvNmbr, and one matching record per InvNmbr exists in each table. Code that does not work: fdqStatementMaster.SQL.Text := 'SELECT XTOTAL.InvNmbr, TaxAmount1 FROM XTOTAL WHERE XTOTAL.InvNmbr=:INVNMBR;'; fdqStatementMaster.MasterSource := dsCustomerStatement; fdqStatementMaster.MasterFields := 'InvNmbr'; fdqStatementMaster.Open(); Code that does work: PrepTempQuery(fdqStatementMaster, 'SELECT XMASTER.InvNmbr, TaxAmount1 FROM XMASTER INNER JOIN XTOTAL ON XMASTER.InvNmbr=XTOTAL.InvNmbr WHERE XMASTER.InvNmbr=:INVNMBR'; fdqStatementMaster.MasterSource := dsCustomerStatement; fdqStatementMaster.MasterFields := 'InvNmbr'; fdqStatementMaster.Open(); I am baffled and frustrated and will be extremely grateful for a nudge in the right direction.
  2. Nathan Wild

    Capturing Console Output

    Thanks! This is exactly what I recalled seeing. It is not in MY GetIt though? I suppose you are right, not sure why I even bothered with GetIt!? Either way, the solution that David pointed me to, above will work nicely. Thanks!
  3. Nathan Wild

    Capturing Console Output

    Thank you. This is a much more elegant solution to what I was after. Cheers!
  4. Nathan Wild

    Capturing Console Output

    I thought I remembered seeing a component or library in the GetIt repo that was devoted to running console commands and capturing their output? It was called "DOSBox" or something along those lines? I can not seem to find anything there now, or online. Am I crazy or does something like this already exist?
  5. Nathan Wild

    ICS FTP with TLS

    Hmm... It looks like it is using the libss1-1_1.dll supplied with ICS... I was l expecting it to require libeay32. All good now, thanks to everyone who helped out.
  6. Nathan Wild

    ICS FTP with TLS

    Update: I was able to get the OverbyteIcsXferTst aplication working and have implemented the mechanics of it in my own application. It build fine and seems to be correct but I'm getting an exception due to missing libeay32.dll. I understand this is part of the SSL layer and I'm sure I can find this DLL somewhere. What I am curious about is why their test application runs without this error and mine won't? Thought I would reply here in case someone with more Overbyte experience can chime in, Thanks to everyone who has offered assistance so far.
  7. Nathan Wild

    ICS FTP with TLS

    Progress... With a little fiddling, the sample application will log on succesfully! Still can not transmit files though. I am getting a PORT command error. 17:06:42:299 > PORT 192,168,0,108,218,81 17:06:42:351 < 500 Illegal PORT command. 17:06:42:352 Upload Failed: 500 Illegal PORT command.
  8. Nathan Wild

    ICS FTP with TLS

    Interesting... I grabbed it right from the site yesterday and it was version 858. I see there is a version 864 there that I somehow managed to miss. I will look into this sample application and let you know how I fare. Thank you so much!
  9. Nathan Wild

    ICS FTP with TLS

    Thanks very much for the suggestion. This demo application does not appear to be in the samples provided with ICS? There is an FtpDemos\OverbyteIcsFtpMulti and SslInternet\OverbyteIcsSslFtpTst... The latter seems to be what I'm after, I just don't know what to tell it do. I am able to connect, but I'm getting and error like '500 Illegal PORT command.' or '522 Data connections must be encrypted.' (active and passive mode respectively).
  10. Nathan Wild

    Random Access Violation?

    Indeed... having the address is nice, except it's an address inside someone else's code 😞 And yes, I did look on the Pervasive logs. Nothing at all of any use. The PvSQL DLL is not catching this exception either. So frustrating!!
  11. Nathan Wild

    Random Access Violation?

    Update: I pulled the last working version of my application out of version control and rebuilt it with Berlin (previous was Seattle). The original Seattle build works fine on the affected computers. The new build - with no changes other than rebuilding it in Berlin - exhibits the same access violation. Any idea what could have changed that would trigger this exception in a 3rd party DLL?
  12. Nathan Wild

    Random Access Violation?

    Yes, I have tried this. Connections to the same ODBC datasource using ADO components work fine. It is only with FireDAC for some reason?
  13. Nathan Wild

    ICS FTP with TLS

    I am trying to upload files to an FTP server that uses explicit TLS. I have the connection working just fine in WinSCP with the encryption set to "TLS/SSL Explicit encryption". I am not sure how to accomplish this using ICS or Indy components (both appear to support this). Either I'm missing something or there does not appear to be very much in the comprehensive documentation department for ICS. If anyone here has experience with the ICS TsslFTPClient component can give me a nudge in the right direction it would be much appreciated.
  14. Nathan Wild

    Random Access Violation?

    Yes, I have tried this. Connections to the same ODBC datasource using ADO components work fine. It is only with FireDAC for some reason?
  15. Nathan Wild

    Random Access Violation?

    Agreed... I am just not sure how to approach debugging an access violation that is coming from an external library like that 😞
×