=Ivan=
Čuven
- Učlanjen(a)
- 15.12.2003
- Poruke
- 227
- Poena
- 620
Da li neko moze da mi kaze zasto Ova stored procedura uvek vraca prazan query bez obzira na parametar dept ? U pitanju je Interbase 5.5 server i Delphi aplikacija. Napominjem da kada iz Interbase iSQL-a napravim statički kveri on radi .
Connect "nedjo:c:\Ivan\test.gdb" USER SYSDBA PASSWORD masterkey ;
SET TERM !! ;
CREATE PROCEDURE LIKE2 (dept VarChar(20))
RETURNS (DepNo Integer, Depart Char(25))
AS
BEGIN
FOR SELECT * from DEPARTMENT
WHERE Department LIKE : dept
INTO : DepNo, : Depart
DO
SUSPEND;
End !!
Na primer:
Select * from Like2 ('"%o%"')
Ovo Vraca prazan upit a u tabeli postoji vise slogova koji imaju "o" u datom polju.
Connect "nedjo:c:\Ivan\test.gdb" USER SYSDBA PASSWORD masterkey ;
SET TERM !! ;
CREATE PROCEDURE LIKE2 (dept VarChar(20))
RETURNS (DepNo Integer, Depart Char(25))
AS
BEGIN
FOR SELECT * from DEPARTMENT
WHERE Department LIKE : dept
INTO : DepNo, : Depart
DO
SUSPEND;
End !!
Na primer:
Select * from Like2 ('"%o%"')
Ovo Vraca prazan upit a u tabeli postoji vise slogova koji imaju "o" u datom polju.
Poslednja izmena:
