Re: [sqlite] Bug with sqlite3_column_decltype?

2004-10-26 Thread Gerhard Haering 
On Tue, Oct 26, 2004 at 03:58:07PM +0200, George Ionescu wrote:
> [...] I have the following table definition:
> 
> CREATE TABLE [Orders] ([OrderID] AFFINITY INT, [CustomerID] AFFINITY
> VARCHAR(5))

Where did you get this interesting syntax with AFFINITY from?

-- Gerhard
-- 
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?
A: Top-posting.
Q: What is the most annoying thing on usenet and in e-mail?


signature.asc
Description: Digital signature

Re: [sqlite] Bug with sqlite3_column_decltype?

2004-10-26 Thread Clay Dowling 

George Ionescu said:
> CREATE TABLE [Orders] ([OrderID] AFFINITY INT, [CustomerID] AFFINITY
> VARCHAR(5))

>
> AFFINITYINT,[Cu

Try this instead:

CREATE TABLE Orders (OrderID int, CustomerID varchar(5));

That should give you something closer to the expected results.

Clay

-- 
Lazarus Notes from Lazarus Internet Development
http://www.lazarusid.com/notes/
Articles, Reviews and Commentary on web development