Clarion And Pervasive SQL Problems

sagat77 · Oct 17, 2003

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 · Oct 17, 2003

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 · Oct 21, 2003

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.

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!

Clarion And Pervasive SQL Problems

sagat77

Programmer

ShankarJ

Programmer

vpos

Programmer

Similar threads

Part and Inventory Search

Sponsor