View Issue Details

IDProjectCategoryView StatusLast Update
0005972VALENTINA SERVERDatabasepublic2012-09-27 16:48
ReporterKirill PekarovAssigned ToIvan Smahin 
Status resolvedResolutionfixed 
Product Version5.0 
Target VersionFixed in Version5.0 
Summary0005972: DROP DATABASE IF EXISTS throw exception
DescriptionHere is simple RB code:
database "tttt" is on the server.

Sub Open()
  Valentina.DebugLevel = EVDebugLevel.kLogParams
  dim conn As new VConnection("localhost", "sa", "sa")
    call conn.SqlExecute("DROP DATABASE IF EXISTS tttt")
  catch err As VException
    MsgBox str(err.ErrorNumber)
  end try
End Sub

Here is VServer log:
Thu Sep 27 2012 13:43:21.543000 (TID 1256): (UID 1464) I_SqlConnection ' ' SqlQuery 'DROP DATABASE IF EXISTS tttt'.
Thu Sep 27 2012 13:43:21.664000 (TID 1256): (UID 1464) ERROR 0x82517: Database with name "tttt" must be opened or created before operation.
TagsNo tags attached.


There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2012-09-27 10:48 Kirill Pekarov New Issue
2012-09-27 10:48 Kirill Pekarov Status new => assigned
2012-09-27 10:48 Kirill Pekarov Assigned To => Ivan Smahin
2012-09-27 10:57 Kirill Pekarov Description Updated View Revisions
2012-09-27 16:48 Ivan Smahin Status assigned => resolved
2012-09-27 16:48 Ivan Smahin Fixed in Version => 5.0
2012-09-27 16:48 Ivan Smahin Resolution open => fixed