Re: [sqlite] newbie command line question sqlite3

[Denis Crowther]

Hi,

Try

DELETE FROM ticket WHERE ticket.FIELDNAME =102


Regards
Denis

On 08/22/2008 09:02 AM, jojobo wrote:

 hello.
 I am not a coder so I aplogise for my naivety. I am using TRAC with a sqlite
 db called trac.db
 
 I have the commanline sqlite3.exe in the same folder as the .db and need to
 now manipulate the db to manually remove a corrupt record.
 
 Once opened sqlite2 shows:
 
 sqlite
 
 I need to know the commnad / string / line to remove remoce the effected
 ticket (record) from the ticket table.
 
 Can someone please help me with the terminogoly?
 
 I tried: .tables to show trables but nothing happens
 I tried DELETE FROM ticket WHERE 102 
 
 I think I am missing the boat here...is there an easy way to show the tables
 / database as text so I can manually remove problem?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Creating a Database from RealBasic code

[Denis Crowther]

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