Hi there,
I have a project where I am creating views on an existing pervasive (v13) database. My friend is at the same to working on the same project, remotely. Obviously he needs to be able to get the latest version of any given view. Is there a way to put these views into source control? (eg...
Good morning,
Is there perhaps a function in pervasive where I could convert a string to camel case? That is,
Original: HELLO MARY WHITE
becomes: Hello Mary White
I've searched the Pervasive 13 manual and did not find anything... just trying my luck in case I missed it.
As always, thank you.
Not to worry thank you, I found the answer!
SELECT AutoNumber,DDAte,Amount*(-1) as Amount, (select CoName from LedgerParameters) as Company
FROM LedgerTransactions LT
WHERE DDATE >= DATEFROMPARTS(2019,01,01)
AND LT.AccNumber IN
(select distinct AccNumber FROM LedgerMaster)
ORDER BY ddate...
Hi there,
I need to add a 4th column to my current select statement on LedgerTransactions. This fourth column is the company name which is obtained from (select CoName FROM LedgerParameters). There are no shared columns between these two tables for me to do a join. For a better explanation...
Hi Mirtheil,
Goodness I am not sure what is going on. I tried implementing your solution, but still, I get "Unknown Error -19". If you get a moment, could I ask you to create the below and see if it works for you?
SELECT DR.Ref, DR.Amount, DM.AmountMatched
FROM DebtorReceivables DR LEFT...
Hi Mirtheil,
Thank you very much for your replies. In answer to your questions:
- What tool are you using to run the query?
PSQL Control Centre 13.30.035
- Is there anything else in the error?
No, only the error message I give above (in a popup window)
- Does the sample query work against the...
Hello,
I am following the Left Outer Join example as demonstrated by Table_32 on page 154 of the pervasive v13 manual. Namely, the expression they give is: SELECT * FROM Emp LEFT OUTER JOIN Dept ON Emp.DeptID = Dept.DeptID
To avoid confusion, I have named my tables in the same manner. And this...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.