[sqlite] Creating a Database from RealBasic code

[Thomas E. Wright]

This should be simple but does anyone know how to create a new database from
within realbasic code?  I try to shell out using the shell command but it's
not liking that too much and there seems to be no create database function
for sqlite.

  Dim s As Shell
  s= New Shell
  f = GetFolderItem("")
  appPath=f.AbsolutePath
  'appPath=app.ExecutableFile.Parent.AbsolutePath
  msgbox appPath
  
  #if TargetWin32
    
    s.execute "sqlite3.exe testdatabase.db"
    's.execute "dir "
  #endif
  
  If s.errorCode = 0 then
    msgbox "done."
  else
    MsgBox "Error code: " + Str(s.errorCode) + chr(13) + s.result
  end if


I get:

Error code -2 "Shell time out."


_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users