Search found 6 matches
- 05.05.2010, 08:11
- Forum: 6.6 - stable
- Topic: problem with TZStoredProc
- Replies: 4
- Views: 529
solved partially ...
I thing the problem is in procedure TZAbstractRODataset.SetStatementParams, specially this part: if Param.IsNull then begin Statement.SetNull(I + 1, ConvertDatasetToDbcType(Param.DataType)) end else begin case Param.DataType of ftBoolean: Statement.SetBoolean(I + 1, Param.AsBoolean); ftSmallInt: Sta...
- 05.05.2010, 07:28
- Forum: 6.6 - stable
- Topic: problem with TZStoredProc
- Replies: 4
- Views: 529
problem with TZStoredProc
Hi everyone, I am usеing ZEOSDBO-6.6.6-stable. I am trying to set a param of TZStoredProc with this code: TZStoredProc.ParamByName('MyDATE').asString:= ''; this generates Conversion error. In the firebird stored procedure, parameter 'MyDate' is of type Timestamp. The same problem i have with integer...
- 17.03.2010, 14:55
- Forum: Firebird
- Topic: TZSQLProcessor
- Replies: 4
- Views: 1015
- 17.03.2010, 14:21
- Forum: Firebird
- Topic: TZSQLProcessor
- Replies: 4
- Views: 1015
thank you for replay :) but i cant understand how to create stored procedure at runtime yet statement: CREATE PROCEDURE NPOD_INSERT ( PODIME VARCHAR(50) ) RETURNS ( PODID DOUBLE PRECISION ) AS BEGIN PODID = GEN_ID(GEN_PODID,1); INSERT INTO NPOD (PODID,PODIME) VALUES (:PODID,:PODIME); SUSPEND; END^ o...
- 17.03.2010, 12:38
- Forum: Firebird
- Topic: TZSQLProcessor
- Replies: 4
- Views: 1015
TZSQLProcessor
Hi, i have a problem with CREATE PROCEDURE statement: ZSQLProcessor.Script.Clear; ZSQLProcessor.Script.Add('CREATE PROCEDURE NPOD_INSERT ( PODIME VARCHAR(50) ) RETURNS ( PODID DOUBLE PRECISION ) AS BEGIN PODID = GEN_ID(GEN_PODID,1); INSERT INTO NPOD (PODID,PODIME) VALUES (:PODID,:PODIME); SUSPEND; E...
problem
Hi, when i am trying to connect to database from LAN i receive this message: "Cannot attach to a servise manager". Software writen with IBX is workin fine on this LAN. Help me pleese!