2. ASPRunnerPro General questions
  3. [SOLVED]  255 character limit when using oledb
This topic is locked
[SOLVED]

 255 character limit when using oledb

 		6/2/2010 9:40:29 AM
ASPRunnerPro General questions
S
 syren author

Has anybody got code for getting around the 254 character limit for text fields. I have a number of memo fields which will only save the 1st 254 characters.
worked great with ODBC.
Admin 6/2/2010

What database do you use? What's the field type?
To speed up the process post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program.
S
 		syren author 6/2/2010



What database do you use? What's the field type?
To speed up the process post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program.


the database is visual foxpro 9 and i'm using vfpoledb to access. The field type is memo but i understand that the oledb restricts the no of characters to 254.
C
 		clig 6/4/2010



the database is visual foxpro 9 and i'm using vfpoledb to access. The field type is memo but i understand that the oledb restricts the no of characters to 254.


Using the lastest driver for 9?
http://www.microsoft.com/downloads/details.aspx?FamilyId=E1A87D8F-2D58-491F-A0FA-95A3289C5FD4&displaylang=en
How are you defining these fields in ASPRunner?
S
 		syren author 6/4/2010

I am using the latest driver. The fields are memo fields and i'm using the text area type in the editor within asprunner
C
 		clig 6/4/2010



I am using the latest driver. The fields are memo fields and i'm using the text area type in the editor within asprunner


This is the ODBC how to - I haven't come across the oledb yet:
http://support.microsoft.com/kb/208208
S
 		syren author 6/5/2010



This is the ODBC how to - I haven't come across the oledb yet:
http://support.microsoft.com/kb/208208



Where would the best place be to put this type of code within ASPRUNNER