![]() My goal is to open this db, grab records and display them in a list, and allow a user to add more records to the db for later use. I actually already have an sqlite db I’ve created from a larger mysql database. So I’m at a loss how this is truly useful? I really want to be able to do decent sql queries (which sqlite3 supports) such as “select * from table1” or “select name, date from table1 where amount > 100”. I verified this by trying out sqlitebrowser ( ) which won’t open the db at all. It opens, but there are no records since there are no tables. What’s even more, after creating a new database with the example Applescript, sqlite3 doesn’t even think it is a valid database. ![]() I guess the expectation is a script would just keep creating records? Then when I later want to use these records I would increment through them all, searching for the record I want by looking at a particular field? ![]() It appears the Data Events Suite doesn’t even support tables at all. However, this is different from a typical SQL database in that there was no table created. Your example creates a record, and adds fields. This may actually be a problem with the “Data Events Suite” implementation itself. and an SQL editor for writing queries and statements to execute against the SQLite database and many more features. It also provides an SQLite browser for showing all tables, views, triggers, etc. However, I’ve found some… difficulties… with the example code. With RazorSQL, users can create new or edit existing SQLite databases. Information obtained from users, and repositories. Thank you very much for the info, that’s much more than I could find anywhere. The SQLite database query tool provided by RazorSQL includes such features as a custom SQLite database browser tailored to SQLite, an SQL editor with SQLite specific features and syntax highlighting, custom SQLite visual tools, and SQLite specific database administration tools. mac os x : PROGRAMMING LANGUAGE :c++ C : USER INTERFACE :x windows win32 : mac os x : cocoa : Attribution.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |