I have a foxpro data table having files name and fname. Now i want to create a foxpro form having text box on it  and i press a alpha bates key from keyboard like A all the name starting with a will listed for making selection and when i press second key b all the name stared with ab will be listed and so on.   Is it possible please help

I had to reinstall Windows 7 and Access 2013 and now I cant find my ODBC drivers to Link with Foxpro from Access?

Examples

I have a number of old word documents that I need to migrate to pdf but first I need to save them as DOCX but I want to save them without the Encryption password (which I have).

Anybody know how to do this?

I have a foxpro v9 memo field and i want to update that in oracle table blob field
Below sample code

--Open foxpro table
lcAlias = Sample.dbf
Use Sample.dbf

-- read memo field
lcBin = &lcAlias..blobdata

--convert to Blob
pcBin =  CAST(lcBin as Blob)

--Connect oracle
odb = sqlstringconnect("Driver={Oracle in OraClient11g_home1};Dbq=XXXXX;")
lcSQLString = "UPDATE oracletable SET m_blob = " + pcBin + " where id = 1;"
lresult=sqlexec(odb, lcSQLString, "Result")
IF lresult>0 THEN
   messagebox("yes")
ELSE
  *-- Collect error info
  AERROR(laErr)
  *-- Display error info on the screen
  DISPLAY MEMORY LIKE laErr
  *-- or save the error info into text file
  LIST MEMORY LIKE laErr TO FILE SQLError.txt
ENDIF
=SQLDisconnect(odb)

Am getting below error message - might be becoz i didnt pass the single quotes for pcBin
[Oracle][ODBC][Ora]ORA-00972: identifier is too long

If i put quotes for pcBin, foxpro prg hang at sqlexec
lcSQLString = "UPDATE oracletable SET m_blob = '"+ pcBin +"' where id = 1;"
lresult=sqlexec(odb, lcSQLString, "Result")

Tried below code, then also it freeze
lcBin = &lcAlias..blobdata
CURSORSETPROP("MapBinary",.T.,0)
lcSQLString = "UPDATE oracletable SET m_blob = '"+ lcBin +"' where id = 1;"
lresult=sqlexec(odb, lcSQLString, "Result")

Hi Experts


Could you point a way (if it's possible) on how to install an automation component (.OCX) during a NULLSOFT instalation?

For the system correctly work this operation is needed:

REGSVR32  C:\Windows\System32\comdlg32.ocx

Is it possible to make it automatic?

Thanks in advance.

Hi Experts

Could you point the better way to encrypt/ decrypt a text file content "on the fly" by using VFP?

Thanks in advance.

Hi Experts

Could you point the better way to mantain long texts vinculated to a VFP line register?

Using a word file with OLE ? or a traditional FPT - is it possible to have a small text editor called inside the app?

Then the text must to be used in a report.

Thanks in advance.

I have built a program to insert data into a number of Word documents.  The insertion points are identified with bookmarks.  Most of the bookmarks are related to Word text fields or empty areas in the document.  The data values are inserted as text with statements like this:

                        oDocument.Bookmarks.Item(cBookmarkName).Range.Text = "TextValue"

However, on one form some of the entry fields are defined as Word checkboxes.  The statement above doesn't work because Word checkboxes apparently won't accept text strings.  I've also tried inserting 0 and 1, as well as variations of "true", such as .t., <true>.  Is there some other value and/or property that can be used to mark a Word checkbox as true from a VFP program?

FoxPro  FoxPro 2.6
I have a customer Master with Code & Name Fields. While entering data through Input screen I will type customer name and the program will go on filtering the name of the customer from the Master Data File and when I press Enter Key it will select the exact record from the master with Code. If there is any program in foxpro 2.6 kindly mail me at felixdaniel1575@gmail.com

Hi Experts


Accordingly with

Truncated:

Correctly previewed:

Thanks in advance