>I have created a web site which gets numerous details of the user using ASP. I have created a suitable database using VFP6.0 and everything seemed to be OK. I have since tested thoroughly and have noticed that whenever I write any details to the database the insert-sql statement doesn't work when one of the strings I am appending into the database is quite long. The thing is the field that this long string is being inserted into is a memo field and I thought these were pretty large.
>
>The string in question is about 100 characters long.
>
>Is it the sql statement that is limited in size or is the mem field the culprit, can someone help?
Hi Jamie,
No, a VFP memo field itself can take a lot more than 100 characters. This is not the problem.
I will assume you are issuing a statement like:
INSERT INTO table FIELDS (...) VALUES (...)
An alternative to such a statement would be to use memory variables, or MEMVARS. Assign the values of your captured data to variable matching your table fieldnames. For example, if you had a field called "Firstname" your memory variable would be "m.firstname", and so on for all of your field in the table, including the memo field. Once you have them all created and populated, you can issue the simple insert statement:
INSERT INTO table FROM MEMVAR