1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
  2. Donation with Paypal!!!

    Go to your paypal account and send directly donation to [email protected]

    1 month - 10 $ - Standart VIP

    6 months - 20 $- Standart VIP

    1 year - 30 $- Standart VIP

    2 years - 50 $- Standart VIP

    Gold member for life - 150 $- Standart VIP

    High Vip (Standart VIP include) group please send PM or email to [email protected] for info

    After Donation please send email to [email protected]

  3. Donation Ways 2020


    Paysend
  4. Telegram

  5. Delphifan Magazine
Dismiss Notice

Donation with Paypal!!!

Go to your paypal account and send directly donation to [email protected]

1 month - 10 $ - Standart VIP

6 months - 20 $- Standart VIP

1 year - 30 $- Standart VIP

2 years - 50 $- Standart VIP

Gold member for life - 150 $- Standart VIP

High Vip (Standart VIP include) group please send PM or email to [email protected] for info

After Donation please send email to [email protected]

Dismiss Notice
For open hidden message no need write thanks, thank etc. Enough is click to like button on right side of thread.

How to put \\ string in code.

Discussion in 'Delphi Help&Requests' started by Yaber, Mar 3, 2015.

  1. Yaber
    Offline

    Yaber DF Member

    Hi all.

    Delphi 7 prof.
    Database: Postgresql
    Component: ZEOSDBO-7.1.4

    I'm writting software and I get problem with that

    [...code...]
    SQL.Add(' ORDER BY NULLIF(regexp_replace(nbofinvoice, E'\\D', '', 'g'), '')::int ');
    [...code...]

    Field nbofinvoice is a string and consist number of invoice: IN/1/02/2015

    [Error] Main.pas(198): Illegal character in input file: '\' ($5C)

    How can I put that string (E'\\D',) in deplhi code - that SQL ?

    Thanks for any help.
    All The Best from Yaber
     
  2. Yaber
    Offline

    Yaber DF Member

    I found solution

    SQL.Add('ORDER BY NULLIF(regexp_replace(faktura, E''\\D'', '''', ''g''), '''')::int');
     

Share This Page