Hi.
I have a select command that work fine.
No duplicate values.
If i want to create a view i receive Btrieve error 5. Duplicate Key
Error, SQL State 1000.
I dont understand.
Anyone can help me ?
Btrieve 8.59.189.00


Thanks in advance.
Alessandro Zambonin

Create View RIWTE_vwRigFatt (IdFattura, Iva, EsenteIva, Conto, Costo )
as

SELECT FR.IdFattura, FR.Iva, FR.EsenteIva,
if(CC.ContoEsatto is null, PA.ContoGenerico, CC.ContoEsatto) as
Conto ,
Sum(FR.Quantita * FR.Prezzo) as Costo
Inner Join RIWTE_Parametri PA on PA.Id = 1
group by FR.IdFattura, FR.Iva, FR.EsenteIva, if(CC.ContoEsatto is
null, PA.ContoGenerico, CC.ContoEsatto)

What data types are the fields in question? If any of them are
"AutoInc" fields, then you will need to cast them to INTEGER data type
first.

Also, you may wish to patch to PSQLV8.7 (Service Pack 3) to take
advantage of any other bug fixes in the ewer patches.
Goldstar Software Inc.
Pervasive-based Products, Training & Services
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Chicago: Pervasive Service & Support Class - 11/12/2007 ***


hotzambo (AT) cheapnet (DOT) it wrote:



--