FoxPro

10K

Solutions

1

Articles & Videos

4K

Contributors

Visual FoxPro (VFP), and its predecessor FoxPro, is a data-centric, object-oriented, procedural, database programming language and IDE from Microsoft last released in 2007 that still has some active use due to its low cost of deployment and fairly rapid development. In 2008, Microsoft released a set of add-ons for VFP's xBase components to allow interoperability with various Microsoft technologies. It allows data processing against its native file-based data tables or database servers such as SQL Server.

Share tech news, updates, or what's on your mind.

Sign up to Post

Examples
0
More Than Just A Video Library
More Than Just A Video Library

Train for your certification. Learn the latest DevOps tools. Grow your skillset to do better work.

At Linux Academy, we release new training modules every week so you'll always be up to date on the latest tech.

Delete command
0
i have two table and same colums and students seatno are also same but table have not one column fullfill it is blank i want to murge that one column which is not fullfill so i want help that how i marge that column in same seatno
0
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?
0
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")
0
I know very little about Foxpro (9), but I can get around in it and understand the basic principles.
All I need is to export a database to a CSV file then set that up on task scheduler (to run every night) with an .exe or .bat.
I would need as much detail as possible, but I'll understand it quickly.
No form is needed - just simple export statements, but as I understand it, they have to be run inside FoxPro.
0
How do I import data from the Horizontal grid into a visual FoxPro table?  The Horizontal grid view is attached below as well as the prg. code.  Some of the Horizontal grid cfld fields contain group data.  The cfld fields should not contain a lot of data, for example, each cfld field contains the item#, qnty, and description.  There should be a cfld for date, quantities, and descriptions.

The Horizontal grid should look like this below inorder to match the fields in the Ldy2 table:
Cfld1 is date field
cfld2 is a qnty field that should be named Blktamtin
cfld3 is description field that should be named Blankets
cfld4 is another qnty field that should be named shptamtin
cfld5 is another description field that should be named Flat Sheets
cfld6 is another qnty field that should be name shtbtamtin
cfld7 is another description field that should be name Fit Sheets
cfld8 is another qnty field that should be name sprdamtin
cfld9 is another description field that should be name Spreads
cfld10 is another qnty field that should be name btamtin
cfld11 is another description field that should be name Bath Towels
cfld12 is another qnty field that should be name bstamtin
cfld13 is another description field that should be name Bea Shop Towels
cfld14 is another qnty field that should be name pcmatin
cfld15 is another description field that should be name Pillow Cases
cfld16 is another qnty field that should be name wcamtin
cfld17 is another description field that should be …
0
WHEN I AM USING AN ACCOUNTING PACKAGE IN VISUAL FOXPRO,  MY PRINTER HP 1018 PRINTS ONLY 55 LINES . HOW CAN I CHANGE THIS TO 66 LINES?
0
Hi Experts,
I got the Requirement like to reverse engineer the Fox pro source Files. But it has number of File extensions like .DBF .FPT .FRT .FRX .FXP .LBT .LBX .LCX .MNT .MNX .MPR .MPX .PDF .PJK .PJT .PJX .PRG .PXT .SCT .SCX .TIF .VCT .VCX .DLL How can i reverse engineer all these files, and when gone through some tools it only allow free tables .dbf files those are created model but its empty.Can i know what is difference between Visual fox pro , fox pro database and foxpro Tables.In which Data modeling tool i will do all these file reverse engineering?
Plz help me its urgent for me.
Thanks in Advance.
0
Is it possible to open a book in my Kindle library from a FoxPro application? If so, how?

On a different note: Is the last version of FoxPro still available as a part of MSDN subscription?

Thank you.
0
Tutorials alone can't teach real engineering
Tutorials alone can't teach real engineering

So we built better training tools.

-Hands-on Labs
-Instructor Mentoring
-Scenario-Based Tests
-Dedicated Cloud Servers

All at your fingertips. What are you waiting for?

I AM TRYING TO USE ESC/POS COMMAND FOR EPSON PRINTER IN VFP 9 TO CHANGE PRINTER SETTINGS SUCH AS BOLD,PITCH ETC. BUT NOTHING SEEMS TO WORK.

CAN ANYONE HELP

SUNIL GUPTA
315-7270445
0
Hi Experts,

I need a copy of Microsoft "Visual FoxPro 6.0" to run either in XP mode or if it works on Win7 64 bit would be better can someone please advise safest place to obtain please?

Reason: I have a client who had a custom made program written for his business and he still likes to use it as it contains all his previous years financials, I have built him a new PC and need to move it but he does not have a copy of Fox Pro and I cant seem to locate one.

thanks.
0
cannot mark a record for delete in vfp9
0
I purchased vfp8 some while ago after creating many exe programs from compiled foxpro 2.6 for DOS.   I need to run foxpro in windows (7) to access usb  (mainly since no modern computers/printers have parallel ports now).   I have converted most of my programs to run in vfp8  (SQL not OOP) with no problems.   Vfp8  creates a stand alone (exe) program  with no problems but when I run it all I get is a blank screen with no reaction from the keyboard.  The task Manager shows the program running.  I can only think I have omitted or added something to create this situation.  Having scanned the web for answers which have not solved my problem such as the "read" command being replaced by "read event" I am at a loss to know what to do.   Can you please help me?
0
VFP 9.0SP2 Word 2012

VFP hangs and then fails with with "error code 0x80080005:Server Execution Failed" when executing the line " loWord = CREATEOBJECT("Word.application")"

Worked in Word 2003.

Assistance appreciated

Code:
---------------------------------------------------
 LOCAL loWord, lcName, x, y
LOCAL loRange, loTable
#DEFINE wdCollapseEnd 0

* Start an instance of Word and open a document
loWord = CREATEOBJECT("Word.application")
DOEVENTS FORCE
0

FoxPro

10K

Solutions

1

Articles & Videos

4K

Contributors

Visual FoxPro (VFP), and its predecessor FoxPro, is a data-centric, object-oriented, procedural, database programming language and IDE from Microsoft last released in 2007 that still has some active use due to its low cost of deployment and fairly rapid development. In 2008, Microsoft released a set of add-ons for VFP's xBase components to allow interoperability with various Microsoft technologies. It allows data processing against its native file-based data tables or database servers such as SQL Server.

Top Experts In
FoxPro
<
Monthly
>