Jump to content

Henry Olive

Members
  • Content Count

    207
  • Joined

  • Last visited

Community Reputation

4 Neutral

Recent Profile Visitors

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

  1. Henry Olive

    Split String

    Thank you SO MUCH Serge
  2. Henry Olive

    Split String

    Thank You Sherlock, SwiftExpat Thank You SO MUCH Peter
  3. Henry Olive

    Split String

    Good Day, MyCode in Database = VARCHAR(20) MyCode could be (120 or 250) like 3 digit Integer, or (200.001 or 600.010) there is a dot between numbers, or (500.005.0010 or 100.010.1500) there are 2 dots between numbers I need to Increase MyCode by 1 that is if MyCode = 100 then requested result = 101 if MyCode = 300.001 then requested result = 300.002 if MyCode = 600.005.0010 then requested result = 600.005.0011 How can i do that ? Thank You
  4. Henry Olive

    FB-3 SELECT WHERE

    Thank you SO MUCH Stano, Serge, Pat
  5. Henry Olive

    FB-3 SELECT WHERE

    Good Day, My Table : ID...TNAME..TDATE................INVNO 1......AA...........01/06/2022 2......BB............01/06/2022.........22 3......AA...........02/06/2022.........33 4......AA...........10/06/2022.........44 Requested Result : ID....TNAME.....TDATE..................INVNO 1........AA.............01/06/2022 4........AA............10/06/2022..........44 Lets say today = 13/06/2022 (dd/mm/yyy) and i want to show TNAME='AA' and INVNO IS NULL (Whatever TDATE is ) **or** INVNO IS NOT NULL but TDATE >= 03/06/2022 ( All 10 Days old records ) My Sql : SELECT * FROM MYTABLE WHERE TNAME IN ('AA') and (TDATE >= (SELECT MAX(TDATE) FROM MYTABLE ) - 10 or (X.INVRNO IS NULL)) with above Sql i dont see ID=4 record (Its INVNO is not null BUT Its Date is just 3 days old, that is i should see it ) Thank You
  6. Henry Olive

    FB-3 Get Connected Clients IP Numbers

    Thank You SO MUCH Serge, for very useful informations
  7. Henry Olive

    FB-3 Get Connected Clients IP Numbers

    Thank you so much Vandrovnik In server machine Ethernet Proporties both TCP/IPv4 and TCP/IPv6 CHECKED If i uncheck TCP/IPv6 ( Just TCP/IPv4 checked ) then i cannot connect My App (Rejected Remote Interface error)
  8. Henry Olive

    FB-3 Get Connected Clients IP Numbers

    Good Day, FB-3,09 Super Server Delphi 10,3 TCP/IP FB FAQ says, If you wish to do it from SQL, you need to use Firebird 2.1 at least, and it's monitoring tables. The relevant table is MON$ATTACHMENTS which provides a lot of useful information like user name, IP address, connection state, remote process name (so you can see which application user is using), etc. then i tried below Sql but i cant see any IP Adress select MON$REMOTE_ADDRESS from MON$ATTACHMENTS Above query's result is like below ( No IP Number ) MON$REMOTE_ADDRESS --------------------------------------- fe80::2554:878:750b:852f%5/50222 fe80::9037:f453:60b:b6b9%5/52029 Thank You
  9. Henry Olive

    FB3 - FDBackUp

    Good Morning Serge, Thank you so much
  10. Henry Olive

    FB3 - FDBackUp

    Good Day, Is a backup operation with FDBackUp safe during all users use the program ? Also when i backup with FDBackUp, BackUp File's size same as actual database Is that normal ( No compress ) ? Thank You
  11. Henry Olive

    ExtractFileDir

    Thank you SO MUCH Uwe
  12. Henry Olive

    ExtractFileDir

    Good Day, My Program Folder = 'C:\MyApp\Data\MyData.FBD' // if it is LOCAL else it is \\Mysrv\c\MyApp My Exe File is in 'C:\MyApp' (Local) or \\Mysrv\c\MyApp I know how can i get ExeFolder which is C:\MyApp or \\Mysrv\c\MyApp but I Just need to get **MyApp** part of the folder w/o C:\ or \\Mysrv\c\ How can get it ? Thank You
  13. Henry Olive

    Time Between

    I changed MyTime to TTime and now my code works. Thank You SO MUCH Mark, Uwe
  14. Henry Olive

    Time Between

    Eventhough the time is between 20:30 21:00 below code doesnt work if ((MyTime >= BackUpStart) and (MyTime <= BackUpEnd)) then i check MyTime, BackUpStart, BackUpEnd all of them are correct when debugging if ((MyTime >= BackUpStart) then // this works but both with BackUpEnd doesnt work
  15. Henry Olive

    Time Between

    Thank You Mark, dm.SettingBACKUPHOUR = Varchar(5) and the value = '20:30'
×