Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003

    Red face Unanswered: Pervasive SQL And Clarion Problems !!

    Hi all,

    I just started using Pervasive SQL with Clarion 5.5, but i got some errors, when the application tries to create a table who contains a string(1000) field, returns me the following error: "Maximum column length exceeded".

    Now, when i try to export from Pervasive to Clarion this table using LongVarChar for the string(1000) field, Clarion don't recognize this data type.

    What data type can i use for big strings(1000 or more chars)?

    Thanks for your help.

    Rafael Sotelo
    SCSI S.A. de C.V.
    Tel. 616-25-27

  2. #2
    Join Date
    Dec 2001
    Provided Answers: 6
    Pervasive.SQL has a limit of 255 characters in fixed length string fields. To create anything longer, you'll need to use LongVarChar. If Clarion can't recognize the LongVarChar, you'll need to go back to Clarion to get them to fix it.
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    I do not answer questions by email. Please post on the forum.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts