Instead of setting the queries to "Active := True" + then Closing them (I'm not sure what you want to do by doing it this way) try this instead: if (Query28.Active = True) then Query28.Close; if (Query26.Active = True) then Query26.Close; :-)
________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Arsen Khachatryan Sent: Sunday, 23 July 2006 16:57 To: [email protected] Subject: [delphi-en] Error creating cursor handle Hello dear friends, I have a code where doing two operations (One updating and then deleting) and in first time its worked corectly but in sime time when I want to do it second time it gives a error Error Creating cursor handle Any help please? Thanks a lot Here is a code Query28.Active :=true; Query28.Close; Query28.SQL.Clear; Query28.SQL.Add('Update ent.db'); Query28.SQL.Add('Set St = ''' + edit52.Text +''''); Query28.SQL.Add('Where Ref = '''+ edit53.text + ''''); Query28.ExecSQL; Query26.Active :=true; Query26.Close; Query26.SQL.Clear; Query26.SQL.Add('delete from ven where ref = ''' + edit53.text + ''''); Query26.ExecSQL; table1.Refresh; table3.Refresh; MessageDlg('Los cambios han realizado con exito',mtInformation,[mbOK], 0); edit53.Text :=''; edit52.Text :=''; --------------------------------- Do you Yahoo!? Everyone is raving about the all-new Yahoo! Mail Beta. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Something is new at Yahoo! Groups. Check out the enhanced email design. http://us.click.yahoo.com/SISQkA/gOaOAA/yQLSAA/i7folB/TM --------------------------------------------------------------------~-> ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/delphi-en/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
