Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. vlukes

    UPDATE & ?

    I try it..., perfect :) Thanks.
  2. vlukes

    UPDATE & ?

    So, please, help me... I want to use question mark in UPDATE (in 4GL) - for example: ... LET text = UPDATE qwerty SET col01 = ?, col02 = ?'; PREPARE prp01 FROM text; EXECUTE prp01 USING 'sl01', 'sl02'; ... Fajn, so, how can I replace table name ("qwerty") by question mark (UPDATE ? SET...)...
  3. vlukes

    SELECT & VARIABLE

    Thanks !!!! Code is READY... :) :) :)
  4. vlukes

    SELECT & VARIABLE

    Sorry, database name is mystake. Database name is "xyz" for together samplas...
  5. vlukes

    SELECT & VARIABLE

    Thanks, but DUAL is ready in Informix... This Informix code (without "t") is ready: DATABASE xyz; DEFINE actual_date DATE, t CHAR(10), x CHAR(10), text CHAR(1000); MAIN LET t = 'qwerty'; LET text = 'SELECT CURRENT'|| ' FROM dual' CLIPPED...
  6. vlukes

    SELECT & VARIABLE

    In Oracle (OK, code is ready): declare actual_date date; t char(10) := 'qwerty'; x char(10); begin select sysdate, t into actual_date, x from dual; dbms_output.put_line(actual_date||' '||x); end; --------------------------------- In Informix 4GL (error: 201): DATABASE...
  7. vlukes

    SELECT & VARIABLE

    Thanks, but I do not understant...: "t" is VARIABLE name, no TABLE name... This is sample in Oracle: declare actual_date date; t char(10) := 'qwerty'; begin select sysdate, t into actual_date, t from dual; dbms_output.put_line(actual_date||' '||t); end; /* result: 10.03.08...
  8. vlukes

    SELECT & VARIABLE

    Thanks, but "t" is VARIABLE, no table name...
  9. vlukes

    SELECT & VARIABLE

    Please, help me... I have this code - in Oracle: declare t char(10) := 'qwerty'; begin select t into t from dual; dbms_output.put_line(t); end; OK, code is ready, but I want use this code in Informix 4GL and there is problem: DATABASE MyDtb; DEFINE t CHAR(10), c01...

Part and Inventory Search

Back
Top