Clarion And Pervasive SQL Problems
Clarion And Pervasive SQL Problems
(OP)
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
www.solucionesyconsultoria.com
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
www.solucionesyconsultoria.com
RE: Clarion And Pervasive SQL Problems
Also the equivalent of varchar(n) is CSTRING(n) not STRING(n).
RE: Clarion And Pervasive SQL Problems
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.