#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2013
    Posts
    1
    Rep Power
    0

    Firebird popup windows on script


    Hi,
    I want to enter data for data1 and data2 manualy by keyboard when i running script.
    It it posiible to do this on firebird?

    SELECT
    ZAMOWIENIA_NAGLOWEK."id_zamowienia",
    ZAMOWIENIA_SZCZEGOLY."id_linii",
    ZAMOWIENIA_SZCZEGOLY."numer_konta",
    ZAMOWIENIA_NAGLOWEK."typ",
    ZAMOWIENIA_NAGLOWEK."data_zamowienia",
    ZAMOWIENIA_SZCZEGOLY."data_dostarczenia",
    ZAMOWIENIA_SZCZEGOLY."data_wydania",
    TABLE_STATUS."status"
    FROM
    ZAMOWIENIA_NAGLOWEK
    INNER JOIN ZAMOWIENIA_SZCZEGOLY ON (ZAMOWIENIA_NAGLOWEK."id_zamowienia" = ZAMOWIENIA_SZCZEGOLY."id_zamowienia")
    INNER JOIN TABLE_STATUS ON (ZAMOWIENIA_SZCZEGOLY."id_statusu" = TABLE_STATUS."id_statusu")
    WHERE
    ZAMOWIENIA_NAGLOWEK."id_zamowienia" = ZAMOWIENIA_SZCZEGOLY."id_zamowienia" AND
    ZAMOWIENIA_SZCZEGOLY."id_statusu" = TABLE_STATUS."id_statusu" AND
    ZAMOWIENIA_NAGLOWEK."data_zamowienia" BETWEEN 'date1' AND 'date2'
    ORDER BY
    ZAMOWIENIA_NAGLOWEK."data_zamowienia",
    ZAMOWIENIA_SZCZEGOLY."id_linii"
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2006
    Location
    Plovdiv. Bulgaria
    Posts
    226
    Rep Power
    13
    if you describe them in the script as parameters i.e with ":" before their names, some tools like IBExpert will ask you for the values before executing the SQL code.

IMN logo majestic logo threadwatch logo seochat tools logo