View Issue Details

IDProjectCategoryView StatusLast Update
0005972VALENTINA SERVERDatabasepublic2012-09-27 16:48
ReporterKirillAssigned ToIvan Smahin 
PriorityhighSeverityblockReproducibilityalways
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.InitClient()
  Valentina.DebugLevel = EVDebugLevel.kLogParams
  dim conn As new VConnection("localhost", "sa", "sa")
  
  try
    conn.Open()
    call conn.SqlExecute("DROP DATABASE IF EXISTS tttt")
    
  catch err As VException
    MsgBox str(err.ErrorNumber)
  end try
  Valentina.ShutDownClient
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.

Activities

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