This ASP does not format the memo field text. Back in FoxPro 2.6 and earlier versions, controls were placed within. Scroll to the right in the browser to see all of the data for the memo field. The page should show the Id and Memo1 fields from the memotest.dbf table. You should now be able to access this Active Server Page from your Web browser.Create the following file in a text editor, such as Notepad:.The following code can be used to do this:ĬREATE TABLE memotest FREE (id C(5), memo1 M) Create a table in Visual FoxPro with a character field named ID and a memo field named Memo1.
SCROLL IN FIELD FOXPRO 2.6 DRIVER
It also assumes that the Visual FoxPro ODBC driver is installed on the computer running IIS. The steps below assume that Microsoft Internet Information Server (IIS) is available and that the reader is familiar with serving Active Server Pages with it. Note that it calls the AppendChunk method of the memo1 field object in a loop to append in 254 characters at a time. It uses ADO to add a new record and place data in the id and memo1 fields. It assumes that there is a table named memotest.dbf in the e:\vfpdata directory. The following Active Server Page can be used to demonstrate. The AppendChunk() method of a field object can be called in a loop to place over 254 characters in the memo field of a table. This same technique cannot, however, be used with the Visual FoxPro ODBC driver.ĪDO can be used with an Active Server Page or with Microsoft Visual Basic to go through the Visual FoxPro ODBC driver. INSERT INTO memotest (id,memo1) VALUES ("0001",lcmemodata) For example, the following code can be used to insert a record into a table named memotest.dbf: In Visual FoxPro, you can insert a record into a table with a memo field and place over 254 characters of data into the table with no special commands.