Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Btrieve > Btrieve Error 5...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 957 of 1008
Post > Topic >>

Btrieve Error 5 on Create View

by hotzambo@[EMAIL PROTECTED] Sep 24, 2007 at 12:28 AM

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
>From RIWTE_FattRec FR left outer join RIWTE_CorrConti CC
ON FR.Codice = CC.Codice
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)




 2 Posts in Topic:
Btrieve Error 5 on Create View
hotzambo@[EMAIL PROTECTED  2007-09-24 00:28:20 
Re: Btrieve Error 5 on Create View
"Bill Bach" <  2007-09-28 08:03:49 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Fri Jul 4 18:39:53 CDT 2008.