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 strongm 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: *

  • Users: billiard
  • Content: Threads
  • Order by date
  1. billiard

    SELECT within IF or within CASE ...WHEN ...THEN

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

    Btrieve Error 22

    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 ?
  3. billiard

    New database failure 7011:Insufficient access right for the operation

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

    Arrays - Pervasive SQL v10.3

    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

Part and Inventory Search

Back
Top