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!

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

    Source control for pervasive? (git)

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

    Camel Case...?

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

    Basic SQL: Add column to select statement (ie value from another table)

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

    Basic SQL: Add column to select statement (ie value from another table)

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

    Left Outer join returning "Unknown Error -19"

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

    Left Outer join returning "Unknown Error -19"

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

    Left Outer join returning "Unknown Error -19"

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

Part and Inventory Search

Back
Top