Thanks Denis. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Denis Crowther Sent: Tuesday, April 22, 2008 10:54 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Creating a Database from RealBasic code
Hi Thomas, No need to shell out, you create from within the realbasic application. I'll pluck some example code and email it to you. Regards Denis On 04/23/2008 12:44 AM, Thomas E. Wright wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users