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...
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,"00") != 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,"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
If concerns to anyone the correct use is:
DISPLAY field USING "<<<<<<&"
the number of <<<<< is based on
integer 9
smallint 5
and the key is the "&" 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, " ") and i
come up an error.
Can somebody hep me with this sintax?
thank u
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.