Clarion And Pervasive SQL Problems

[sagat77]

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.


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

http://www.solucionesyconsultoria.com

 

[ShankarJ]

I do not how Pervasive handles it but in MS-SQL if you want to have a string field more that 8000 bytes then I would define a TEXT field on the Database and use CSTRING in Clarion.

Also the equivalent of varchar is CSTRING not STRING.

 

[vpos]

Hi,

I think that Pervasive.SQL limits the length of a string to 254 caracters (??). Maybe you could try using a group :

PervasiveTable FILE,DRIVER('Scalable'),CREATE
Record RECORD,PRE()
TheLongString GROUP
Part1 STRING(250)
Part2 STRING(250)
Part3 STRING(250)
Part4 STRING(250)
END
OtherField1 LONG
OtherField2 LONG
OtherField3 LONG
OtherField4 LONG
END
END

Valery.