Problem with Cursor Handling

try to set your parameter before Active := True

Thanks martinlind I set all my parametrs before I set Active to true but the error mesage is stil there

Thanks in advance

you have to make a SELECT statement, else you have to use ExecSQL insted

Working with cursors normally mean that it's a select-query.

Have you tried opening the Param-dialog for the Query-component and set the datatype to the corresponding types? This has sometimes helped med (inserting dates and datetimes).

Generally we would like som more information before letting our brains sink into the problem.

A code snippet would be very helpfull.

It worked martinlind I replaced Open; to ExecSQL and worked perfect

Thank you very much

Thank you

remember to close question