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 TouchToneTommy 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: *

  • Users: ruimgp
  • Content: Threads
  • Order by date
  1. ruimgp

    Rownum

    Hi all, How can I include a rownum (to return only the defined rownum) in a Informix query? Thanks in advance RP
  2. ruimgp

    Select from a subquery

    Hi all, I want to do something like this select f1,f2,f3 from (select c1,c2,c3 from tab2 ) But it does not work I´ve done this way Select f1,f2,f3 from tab1 where EXISTS (select f1,f2,f3 from tab1 ) and it works, but when i cross diferent tables are the results realible ? What i...
  3. ruimgp

    Hi, I want to validate some da

    Hi, I want to validate some data and i'm using this var1_2=00 var3_4=01 !strcmp(var1_2,"00") - validate that var1_2 is equal to 00 How do i do the oposite ? strcmp(var3_4,"00") !=0 it seems to work wrong. thanks RP
    • ruimgp
    • Thread
    • Replies: 5
    • Forum: C
  4. ruimgp

    DISPLAY USING

    Hi, I want to display some information from a CURSOR but i get a lot of spaces, how do i eliminate these blanks ? example DEFINE rec_C1 RECORD field1 LIKE table.field1, (integer) field2 LIKE table.fiedl2, (smallint) field3 LIKE table.fiedl3 (datetime year to second) END RECORD (...)...
  5. ruimgp

    Trim , Lpad

    Hi I want to select trim or lpad some values of integer type I do select trim(field) or select lpad(field, 10, " ") and i come up an error. Can somebody hep me with this sintax? thank u

Part and Inventory Search

Back
Top