Problem Creating view Pervasive 8
Problem Creating view Pervasive 8
(OP)
I all.
I have this problem.
command...
create view vistamom (NumFattura, Data, importo, Causale, contropartita)
as
SELECT F.NumFattura, F.Data, F.Importo1 as importo, F.Causale1 as causale, '1' as contropartita
FROM RIWTE_Fatture as F
WHERE F.Importo1 is not null AND F.Importo1 <> 0 AND F.Categoria = 'Libera'
Error reported.
The table has index on NumFattura, Data
The table is empty
When the table is compiled no duplicate rows are in.
Please Help.
Thenka Alessandro Zambonin
---
****************************************************
ODBC Error: SQLSTATE = S1000, Native error code = 0
Unable to create table vistamom.
The record has a key field containing a duplicate value(Btrieve Error 5)
create view vistamom (NumFattura, Data, importo, Causale, contropartita)
as
SELECT F.NumFattura, F.Data, F.Importo1 as importo, F.Causale1 as causale, '1' as contropartita
FROM RIWTE_Fatture as F
WHERE F.Importo1 is not null AND F.Importo1 <> 0 AND F.Categoria = 'Libera'
Some error(s) encountered while executing SQL statement(script).
I have this problem.
command...
create view vistamom (NumFattura, Data, importo, Causale, contropartita)
as
SELECT F.NumFattura, F.Data, F.Importo1 as importo, F.Causale1 as causale, '1' as contropartita
FROM RIWTE_Fatture as F
WHERE F.Importo1 is not null AND F.Importo1 <> 0 AND F.Categoria = 'Libera'
Error reported.
The table has index on NumFattura, Data
The table is empty
When the table is compiled no duplicate rows are in.
Please Help.
Thenka Alessandro Zambonin
---
****************************************************
ODBC Error: SQLSTATE = S1000, Native error code = 0
Unable to create table vistamom.
The record has a key field containing a duplicate value(Btrieve Error 5)
create view vistamom (NumFattura, Data, importo, Causale, contropartita)
as
SELECT F.NumFattura, F.Data, F.Importo1 as importo, F.Causale1 as causale, '1' as contropartita
FROM RIWTE_Fatture as F
WHERE F.Importo1 is not null AND F.Importo1 <> 0 AND F.Categoria = 'Libera'
Some error(s) encountered while executing SQL statement(script).
RE: Problem Creating view Pervasive 8
What happens if you change the name of the view?
What happens if you run the SELECT by itself? Does it work?
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com
RE: Problem Creating view Pervasive 8
I have not already this table.
I have read some post about this before write my post.
Select run ok.
I have not the possibilities to create any view.
I have tried with other table, but the result is ever the same.
Compatibility is 6.5.
Thanks.
More help ?
Alessandro
RE: Problem Creating view Pervasive 8
If so, then the problem is in your database. You might have a bad entry in the DDFs. Do you have a VIEW.DDF?
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com
RE: Problem Creating view Pervasive 8
No i have only file, fields and index.
Alessandro
RE: Problem Creating view Pervasive 8
CODE
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com
RE: Problem Creating view Pervasive 8
Esatto from Esa of Rimini.
I have checked tables and all not passed.
Only tables created by me have passed test.
This is the first time i use pervasive sql....
:(
Alessandro
RE: Problem Creating view Pervasive 8
There's not much else that can be done.
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com
RE: Problem Creating view Pervasive 8
Alessandro