Re: [sqlite] SQL sintaxe

2009-05-02 Thread John Machin
On 2/05/2009 9:13 PM, Ernany wrote: > Hello John, > > I have 2 tables ("pcprod" and "pcdesc"). I´d like to *add *in my application > "MARCA" and "DESCR". > > This code is VB2005 .NET. How do I write SQL??? You already have columns named "descr" and "marca" in the "pcprod" table. You need to add

Re: [sqlite] SQL sintaxe

2009-05-02 Thread P Kishor
On Sat, May 2, 2009 at 6:13 AM, Ernany wrote: > Hello John, > > I have 2 tables ("pcprod" and "pcdesc"). I´d like to *add *in my application > "MARCA" and "DESCR". > > This code is VB2005 .NET. How do I write SQL??? http://www.google.com/search?q=sql+tutorial > > Thanks a lot > > Ernany > > > '

Re: [sqlite] SQL sintaxe

2009-05-02 Thread Ernany
Hello John, I have 2 tables ("pcprod" and "pcdesc"). I´d like to *add *in my application "MARCA" and "DESCR". This code is VB2005 .NET. How do I write SQL??? Thanks a lot Ernany '*** Dim dr As Data.SQLite.SQLiteDataReader Dim Bd

Re: [sqlite] SQL sintaxe

2009-05-02 Thread John Machin
On 2/05/2009 4:21 PM, Ernany wrote: > Hello, > > CREATE TABLE [pcprod] ( > [codigo] NVARCHAR(20) NOT NULL ON CONFLICT ABORT PRIMARY KEY, > [descr] NVARCHAR(40), > [marca] NVARCHAR(20), > [codigoint] NVARCHAR(20), > [preco] NUMERIC(5, 7), > [preco2] NUMERIC(5, 7)); > > > > CREATE TAB

[sqlite] SQL sintaxe

2009-05-01 Thread Ernany
Hello, CREATE TABLE [pcprod] ( [codigo] NVARCHAR(20) NOT NULL ON CONFLICT ABORT PRIMARY KEY, [descr] NVARCHAR(40), [marca] NVARCHAR(20), [codigoint] NVARCHAR(20), [preco] NUMERIC(5, 7), [preco2] NUMERIC(5, 7)); CREATE TABLE [pcdesc] ( [codigo] NVARCHAR(20), [qtde] NUMERIC(5, 6),