supposedly i have this table:
Code:
ID Value 1 22 1 17 2 14 2 01 2 55 3 20 4 36 4 40 4 51 4 38
Code:
ID Value 1 17 2 01 3 20 4 36
nexusbr
Last Activity: Aug 11 '10, 06:09 PM
Joined: Dec 13 '07
Location:
-
Perform a select statement to get lower values by id
Hi,
supposedly i have this table:
and i want to select those records only:
which means that i need the lowest values... -
Wow, excellent!!!
i just had a little trouble with NULL values, but it's fixed with a CASE WHEN clause..
and i'm using the first solution.
thank you very much brother. -
Need help to perform this action in sql.. see description inside.
Hello there,
here is the scenario.
i have 3 tables, like the following
...Code:[TABLE 1: PRODUCTS] [CODPROD],[ NAME] 1 , PROD1 2 , PROD2 3 , PROD3 [END OF TABLE 1] [TABLE 2: SALES_X] [CODPROD], [AMT] 1 , 3 2 , 1 3 , 1 2 , 5
-
THanks!!!!! it worked!!
:)Leave a comment:
-
SQL doubt..
Code:Table1: Produtos Codprod, Descricao 1 , Product One 2 , Product Two
Code:Table2: Ped_det codprod, codprod2, etc etc 1 , 2 2 , 1
...Code:select b.descricao as "Código_1", b.descricao as "Código_2", quant as "Qtd", tam as "Tamanho", preco as "Preço", borda as "Borda",
-
DBF to FIREBIRD converter
Hello all..
i developed a dbf to firebird converter.
its very simple, not bugfree, and suits my needs, therefore may not work for you, but you can still use it as a start point.
the project is attached to this post..
feel free to post doubts, edit the code, redistribute, republish, do whatever u want.
ps: the language is pt-br... -
Ok...
Problem Solved..
Sorry For taking your time.. it was my mistake..
the column name 'user' was conflicting with the firebird system, making it thinks i was trying to access the database with a different user...
thx for the help.Leave a comment:
-
oh.. wait.. the same error happened on ibexpert also.. now i guess its a little easier to find out.. let me check it..Leave a comment:
-
Yes, the string is valid.
no, the line is correct.
SYSDBA is the name of the user connected to the database.
the sql statment is correct, unless i'm blind..
i'm kinda lost here... never happend such a thing before..
it does not even step into the while loop.. the error could be on second tick.. but no..Leave a comment:
-
VB.NET-APP Strange Error Inside.
Hello all..
here is the scenario:
I Have a fully working vb.net 2005 app and firebird..
everything is perfectly, except this little function:
...Code:dim dr, dr1 as FbDataReader dr = reader("select * from net_saldo where b.codigo=" & user) If dr.Read() Then dr1 = reader("Select out,pc from net_ac where user=" & user) -
please, i'm still with that problem..Leave a comment:
-
well..
have you tried a :
passwordchange. dispose()
passwordchange. close()
?Leave a comment:
-
no, it returns all records that match the where clause.
i use similar sql statements in other parts of the code and they work perfectly, only that one is not working, or taking too much time to complete. (i have waited for more then 5 minutes and nothing happened)...Leave a comment:
-
try to use this statement instead:
me.close()
glLeave a comment:
-
VB.NET(APP) - SQL problem
Hello all,
i have Vb.net 2005 and firebird working perfectly.
everything works fine, but this sql command:
update y010new set cot_cus = (select cotacao_wrk2.pr ecoc from cotacao_wrk2 where cotacao_wrk2.co digo = y010new.codigo) where exists (select cotacao_wrk2.pr ecoc from cotacao_wrk2 where cotacao_wrk2.co digo = y010new.codigo)
i've tried this on Ib Expert and it hang up forever, just like...
No activity results to display
Leave a comment: