Thank you. You are right, it is type I am looking for.
Have a super one!
Merv
Timothy A. Sawyer wrote:
> You're asking for the column type, not the value. If you open the database
> with sqlite3 there is a command that you can use that shows the SQL commands
> that created the table. The .help f
On Mon, Oct 06, 2008 at 10:57:22PM -0400, Merv scratched on the wall:
> Hi
>
> Will someone please tell me how I can retrieve the value of a column,
> i.e. is if integer or varchar etc.
> I am accessing an unknown file.
If you have an unknown SQLite database file you're trying to poke
around
On 10/6/08, Merv <[EMAIL PROTECTED]> wrote:
> Hi
>
> Will someone please tell me how I can retrieve the value of a column,
> i.e. is if integer or varchar etc.
> I am accessing an unknown file.
typeof(X)
http://www.sqlite.org/lang_corefunc.html
> Have a super one!
>
> Merv
> __
You're asking for the column type, not the value. If you open the database with
sqlite3 there is a command that you can use that shows the SQL commands that
created the table. The .help functionality is very descriptive though the
actual command escapes me at the moment.
Hope this helps
--O
4 matches
Mail list logo