What does work mean It means if I issue an "Update programs set notes = 5000 character string" I don't get an "Unrecognized statement" error back from the provider. It would have required me to reference the DTS objects and learn those on top of the FoxPro intricacies. NET (internally) so I chose not to go that direction. I will test and see if it WORKS for my situation tomorrow. Condescending responses are really unnecessary. Many of the forum answers don't address the question, but instead like to state things like "why are you using an Insert". Notes.Value = memoContent // Got via another var just for clarityįirst, let me say thank you for actually issuing an answer to the question. Using (StreamReader sr = new StreamReader(file2read)) Get an existing text file to put into VFP memo field string "C:\Program Files\Microsoft Visual Studio\Vfp98\VFP6FAQ.txt" first parameter added (empID) is for emp_id, 2nd (firstName) is for first_Name and so on. (emp_id,first_name,last_name,notes) values (, ,, ) It's their position that provides mapping Parameter name only helps to developer. Note that unlike MSSQL, VFP parameters are not named but positional. OleDbCommand cmd = new OleDbCommand(strSQL,cn) OleDbCommand cmdInit = new OleDbCommand( "set null off",cn) but instead fill them with empty values if default is not specified First send "set null off" command to VFP so it wouldn't error for missing fields OleDbConnection cn = new OleDbConnection( strCon) String strSQL = "insert into employee (emp_id,first_name,last_name,notes) values (, ,, )" String strCon "Provider=VFPOLEDB Data source=C:\ Program Files\Microsoft Visual Studio\MSDN\2001OCT\ 1033\SAMPLES\VFP98\ data\Testdata.dbc" Here is a sample (again this shows VFPOLEDB works): using System You asked for VBScript but I want to add that you could also use OpenRowSet(). 255 limit only applies to string variables. FYI 255 is not memo nor string limit in VFP. %> As you see there were CursorType,location,locktype setttings that were working. You want a simple VBScript:) OK here you go (don't tell me that this don't actually works, it does- ASP code) First Name"
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |