Search results for query: *

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

Ok that work´s fine! 1)And if I want do so something like this? Select f1,f2,f3 from tab1 where f1 = ( select max(f1) from tab1 where f4 > 0 ) Can somebody help me with the sintax, in Oracle this works fine but in Informix doesn´t work. If I write this down, does it retrieve the...

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...

Hi, You can try this at prompt c4gl -o name_of_exec name_of_source.4gl RP

I get the variables from a file like this: file ->> 1|0|0|1234567890|001|256| The position 4 of the file = 1234567890 char xpto[30]; strcpy (xpto, tokens[3]); strncpy ( var3_4, xpto+2, 2); Thats how i get value for var3_4 and var1_2 RP

Hi, By that, if true is 0 and false is 1 then I'm doing this : note that var3_4 = 01 if (strcmp(var3_4,&quot;00&quot;) != 0 ) (...) The != should validade both < and > but it didn't seem to work right. What i want to do is as condition for situations where var3_4 is not equal to...

Hi, I want to validate some data and i'm using this var1_2=00 var3_4=01 !strcmp(var1_2,&quot;00&quot;) - validate that var1_2 is equal to 00 How do i do the oposite ? strcmp(var3_4,&quot;00&quot;) !=0 it seems to work wrong. thanks RP

If concerns to anyone the correct use is: DISPLAY field USING &quot;<<<<<<&&quot; the number of <<<<< is based on integer 9 smallint 5 and the key is the &quot;&&quot; who forces data to be displayed. Bye

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 (...)...

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