Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

string

Former Member
0 Likes
448

how can I store a string field (user input) in a database table (r 4.6c)?

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
434

Just remember the maximum length a single field in a DB table can be defined to is 255, hence you will have to guess the maximum length the user can enter and create those many number of fields of length 255 in your DB table and then break up the data when updating in DB from string and reverse, build back the string when retrieving from DB.

2 REPLIES 2
Read only

Former Member
0 Likes
435

Just remember the maximum length a single field in a DB table can be defined to is 255, hence you will have to guess the maximum length the user can enter and create those many number of fields of length 255 in your DB table and then break up the data when updating in DB from string and reverse, build back the string when retrieving from DB.

Read only

Former Member