SQLite Manager - Browser - Editor + Deep SQL
Windows/UTF-8 only.
www.sqlight.com
Four query views.
Transactions supported.
Table Edit
- complete editing flexibility. No limitation how a table is arranged for
editing as long as Primary Key present.
- Lookup List
- Save Queries
- Save Defalut Query
- Ditto Columns
- Dupe Rows
- Save Table View Layout
Data Manager
Schema
- Tables
- Indexes
- Views
- Triggers
Tables
- Create
- Rename
- Drop
Index
- Create
- Rename
- Drop
Columns
- Add
- Drop
- Rename
- Reorder - change column order
- Redefine - completely redefine columns - (type, collate, default, not
null, unique, check)
Blob Data
- Edit blobs as if a local file - Excel®, Word®, Photoshop®, etc...
Deep SQL
- BLOB-stored SQLite databases
Work on blob-stored SQLite databases - down to any level. DB stored in
Row/Column of parent, that's stored in Row/Column of its parent, that's
stored in Row/Column of its parent, etc...
www.sqlight.com/features/deep-sql.html
This appears to be the only SQLite browser actually designed for editing
tables.
Most (all the ones I've found) restrict you to editing tables in the
original creation order.
SQLight supports editing any single table query (use WHERE, use ORDER BY) as
long as the Primary Key is present.
"SELECT rowid,Cat,Sub,Item,Brand,Name,Dscrpt,Price,Sale,OnSale FROM Products
WHERE OnSale='Y' AND Price>20 ORDER BY Cat,Sub,Item,Brand LIMIT 300"
This query can be edited.
www.sqlight.com
StanDurham
sd (at) sqlite DOT com
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
From Mon 31 Jul 2006 14:26:23 -0600
Return-Path: <realbasic-nug-bounces at lists dot realsoftware dot com>
X-Original-To: listarchive at realsoftware dot com
Delivered-To: listarchive at realsoftware dot com
Received: by xmail.realsoftware.com (Postfix, from userid 1037)
id 3EC718F5CD0; Mon, 31 Jul 2006 13:26:56 -0700 (PDT)
X-Spam-Checker-Version: SpamAssassin 3.1.1 (2006-03-10) on realxserve.local
X-Spam-Level:
X-Spam-Status: No, score=-2.4 required=4.5 tests=AWL,BAYES_00,NO_REAL_NAME
autolearn=no version=3.1.1
Received: from lists.realsoftware.com (lists.realsoftware.com [209.198.132.125])
by xmail.realsoftware.com (Postfix) with ESMTP id 046268F5CC7;
Mon, 31 Jul 2006 13:26:51 -0700 (PDT)
Received: from lists.realsoftware.com (localhost [127.0.0.1])
by lists.realsoftware.com (Postfix) with ESMTP
id 6193A13E73AD; Mon, 31 Jul 2006 15:26:37 -0500 (CDT)
X-Original-To: realbasic-nug at lists dot realsoftware dot com
Delivered-To: realbasic-nug at lists dot realsoftware dot com
Received: from swarthymail-a4.dreamhost.com (sd-green-bigip-61.dreamhost.com
[208.97.132.61])
by lists.realsoftware.com (Postfix) with ESMTP id 61F8A13E739F
for <realbasic-nug at lists dot realsoftware dot com>;
Mon, 31 Jul 2006 15:26:32 -0500 (CDT)
Received: from [66.116.103.197] (unknown [66.116.103.197])
by swarthymail-a4.dreamhost.com (Postfix) with ESMTP id EBAE9129A8E
for <realbasic-nug at lists dot realsoftware dot com>;
Mon, 31 Jul 2006 13:26:31 -0700 (PDT)
Date: Mon, 31 Jul 2006 14:26:23 -0600
From: joe at strout dot net
To: REALbasic NUG <realbasic-nug at lists dot realsoftware dot com>
In-Reply-To: <200607291456 dot 54504 dot rb at flippingdades dot com>
X-Mailer: VerEx Email Gateway
Content-type: text/plain;
Content-transfer-encoding: 7bit
Message-Id: <20060731202631 dot EBAE9129A8E at swarthymail-a4 dot dreamhost dot
com>
Subject: Re: Non-ascii file names or Shell Command workaround
X-BeenThere: realbasic-nug at lists dot realsoftware dot com
X-Mailman-Version: 2.1.2
Precedence: list
Reply-To: REALbasic NUG <realbasic-nug at lists dot realsoftware dot com>
Sender: realbasic-nug-bounces at lists dot realsoftware dot com
Errors-To: realbasic-nug-bounces at lists dot realsoftware dot com
On Jul 29, 2006, at 19:56 UTC, D Jungk wrote:
I'm using the Linux IDE, RB2006r3.
What i need to do is display a list and open text files with Spanish names.
With this code:
Dim f as FolderItem
f=GetOpenFolderItem("????")
If f<>nil then
StaticText1.text=f.name
Else
StaticText1.text="Nil"
End If
when I select a file with no non-ascii characters, I see the file name appear
in the window. If I select a file with e.g. ñ or é in the name, I see "Nil".
If GetOpenFolderItem on Linux is returning Nil for any file contaning non-ASCII
characters in its name, I'd say that's a nasty bug. Do you have a feedback ID
for it?
Best,
- Joe
--
Joe Strout -- joe at strout dot net
Verified Express, LLC "Making the Internet a Better Place"
http://www.verex.com/
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
|