Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. hotzambo

    SQL STATEMENT CASE

    Hi. Another problem... I try to use sql statement case. case when col = 1 then 'aaa' else 'bbb' end This is not supported in Pervasive ? Any replacement ? Thanks. Alessandro Zambonin from Ravenna, Italy !!!
  2. hotzambo

    Problem Creating view Pervasive 8

    Thanks for all. Alessandro
  3. hotzambo

    Problem Creating view Pervasive 8

    Third part application. 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
  4. hotzambo

    Problem Creating view Pervasive 8

    Hi. No i have only file, fields and index. Alessandro
  5. hotzambo

    Problem Creating view Pervasive 8

    Oh, no. 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
  6. hotzambo

    Problem Creating view Pervasive 8

    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...

Part and Inventory Search

Back
Top