Jump to content

kabiri

Members
 View Profile  See their activity

  • Content Count

    60

  • Joined

  • Last visited

Posts posted by kabiri

  1. Posted

    17 hours ago, Brian Evans said:

    You could pass the password as a parameter to avoid any FireDAC string/macro processing. Use one of the ExecSQL overloads to get rid of the housekeeping lines. 

    
  qry.ExecSQL('ALTER LOGIN sa WITH PASSWORD = :PASSWORD',['newPASSWD'],[ftString]);

     

    Not work
      

    Project ChangeSQlPass.exe raised exception class EMSSQLNativeException with message '[FireDAC][Phys][ODBC][Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near '@P1'.'.

     

  2. Posted

    10 minutes ago, Brian Evans said:

    Your password strings as posted are infested with zero width non-breaking spaces at differing locations. 

    I didn't write my original password here and changed it.
    Then I realized that FD might not work properly if the password follows a specific pattern.

  3. Posted · Edited by kabiri

    I change the SQL Server password using the following command in Delphi,
    The connection string is to the master database and I am using Windows authentication.

     

    Quote

        try
          qry.Close;
          qry.SQL.Clear;
          qry.SQL.Add('ALTER LOGIN sa WITH PASSWORD = '+QuotedStr('My@Pass159753'));
          qry.ExecSQL;
        except on E: Exception do
          ShowMessage('Error : '+E.Message);
        end;
     

    But I can no longer log in to SQL Server using the sa user.

    When I execute this command in Management Studio, the password is changed and I can log in with sa.

    Quote

    ALTER LOGIN sa WITH PASSWORD = 'My@Pass159753'

    Delphi 11 + FireDAC + SqlServer 2014 sp2 express

     

    ----------Edit-----------

     

    I wrote the same code with ADO and it works perfectly.

     

     

    -----Edit-------

    Alright, I've noticed that this issue occurs when a specific pattern is used.

  9. Posted

    On 2/25/2024 at 1:11 AM, Dave Nottage said:

    You should not have to manually create missing folders. Even if you did, the files that the compiler needs would not be there. If there was a missing PrivateFrameworks folder, you may have to re-import the SDK using these steps:

    1. In the folder C:\Users\(username)\Documents\Embarcadero\Studio\SDKs, where (username) is the logged in user name, delete the relevant iPhoneOS SDK folder (e.g. iPhoneOS17.2.sdk)
    2. Delete the SDK from the SDK Manager in Delphi
    3. On the Mac, in the ~\PAServer\scratch-dir folder, remove any folders starting with cache-dir
    4. In Delphi, re-add the iOS SDK
    5. Repeat the steps mentioned earlier for importing Swift frameworks, ensuring that you also follow the manual step involving copying of folders.

    I followed the steps, it didn't make a difference, it gives an error

    [DCC Error] E2597 ld: file not found: /System/Library/Frameworks/AppTrackingTransparency.framework/AppTrackingTransparency

  13. Posted

    hi

    i update my mac to mac os 14 and xcode 15.2

    and add this frimworks

    Quote

    Accessibility
    Combine
    AdServices
    CoreMotion
    DataDetection
    UniformTypeIdentifiers

    but show this warning and error :

    [DCC Error] E2597 ld: warning: directory not found for option '-FC:\Users\hamid\OneDrive\Documents\Embarcadero\Studio\SDKs\iPhoneOS17.2.sdk\System\Library\PrivateFrameworks'

      ld: file not found: /usr/lib/swift/iphoneos/libswiftCompatibilityDynamicReplacements.a

    [DCC Fatal Error] F2588 Linker error code: 1 ($00000001)

     

    how to fix it?

  14. Posted · Edited by kabiri

    1 hour ago, Dave Nottage said:

    I have just noticed you have a version of Xcode that may not even have the Swift support mentioned earlier. Delphi 12 is able to use Xcode 15.1, so I suggest updating. If your Mac is too old to update macOS/Xcode, I suggest watching this part of this video.

    I'll take a look right now. I hope it helps. Thank you.

    ---Edit---
    I watched this webinar online, but I am not sure if it will be helpful. I will watch it again.

  17. Posted

    1 hour ago, Serge_G said:

    Ah, the "synch" one ! I never search for this one.

     

    In my mind you need at least to declare in your code 

    
 
    
    procedure ObserverToggle(const AObserver: IObserver; const Value: Boolean);
  protected
    function CanObserve(const ID: Integer): Boolean; override;

    Then check a unit like FMX.Listview.pas (searching 'observer') 

     
     EditLinkID,  PositionLinkID and  IteratorLinkID (from System.Classes) seems to be the keys

    Thank you
    I'll check it.

  18. Posted

    1 hour ago, Serge_G said:

    have a look at http://docwiki.embarcadero.com/RADStudio/Seattle/en/Tutorial:_Creating_LiveBindings-Enabled_Components
     

    in short, you need to declare these procedures and function in your component code 

    
    procedure ObserverToggle(const AObserver: IObserver; const Value: Boolean);
  protected
    function CanObserve(const ID: Integer): Boolean; override;                  
    procedure ObserverAdded(const ID: Integer; const Observer: IObserver); override;

    and do some register observable members
      

    If you read French, I wrote some tutorials (part I, part II)

    Thank you for your response. Yes, I have seen it. It just sets a property to receive information from livebinding. In the photo I sent, I do not want the position property to be added. I want the * option to be added.
     

    This photo :
    https://docwiki.embarcadero.com/images/RADStudio/Seattle/e/1/13/LBTTrackBar3.png

  19. Posted

    I have created a component for FMX. This component has an internal list. I want to fill this list with database values. (Using the livebinding method.)

    I have derived my component from (TPresentedControl, IItemsContainer).

    If I derive my component from stringgrid, everything works, but I don't want to do that. (My component is not similar to stringgrid.)

    I'm not sure, but I think I can do this with observer. But I don't know how.

    If you have a solution for this, I would appreciate your guidance.

     

     

×