Search results for query: *

I am writing a SELECT script in Pervasive 10.3 I need the logic to have a SELECT within an IF or CASE tried the statements below but that does not seem to work. Once I do any of the two below my SELECT select fewer rows. CASE WHEN a.Item = 1 THEN ( SELECT ISNULL(SUM(o.Amount),0) FROM...

How do I make sure the DDFs are correct and accurately describe the data files? When I insert a record do I have to assign values to all fields in a table?

In Pervasive 10.3 my INSERT script gives error Pervasive.Data.SqlClient.Lna.k: [LNA][Pervasive][ODBC Engine Interface][Data Record Manager]The data buffer parameter is too short(Btrieve Error 22) How do I fix this ?

A different Database works. I repeated my sequence of event and got same error as before. On initially creating the database I have On Database Options Bound [no tick] Create dictionary files [tick] Relational Integrity Enforced [tick] When I save and go back to the database properties and...

Yes it was working but now gives error 7011 Nothing updated except if pervasive updated by itself from the net Since problems started the log file is not updating See my attachmenthttp://files.engineering.com/getfile.aspx?folder=9122c024-596d-4f71-9862-ae4ecc9c9b8e&file=pvsw.txt

I installed Pervasive v10.3 and of the two options 1. Application 2. Service I installed pervasive as an application. The folder exists and user has full rights to c:\Pastel12\Bill I have been able to create dsn in pcc but all of a sudden I start having access issues

I am getting the same error "New database failure 7011:Insufficient access right for the operation" in the following environment: 1. Windows 8.1 Pro 2. Pervasive.SQL 10.3 Workgroup 3. Standalone PC I have run a registry cleaner application, uninstalled and re-installed Pervasive. I have...

I need to create a one dimensional array with 6 integer cells, load them with number then sort in descending order. Help please, as well as show me manuals on Pervasive Programming language syntax tutorials