MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
Course Of The Month
7 days, 13 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
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.
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
1 Comment
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?
Anybody know how to do this?
Hi Experts
Could you point how to programatically force a grid to present the first row content?
After a grid line deletion it presents the last line content at the top of the grid, obligating to click in the cursor top advance arrow to get the first line in top position.
Thanks in advance.
Could you point how to programatically force a grid to present the first row content?
After a grid line deletion it presents the last line content at the top of the grid, obligating to click in the cursor top advance arrow to get the first line in top position.
Thanks in advance.
Hi Experts
Does a VFP app correctly runs on a wifi network?
I'm not certain I read here that it's not a good choice, since errors arises. The only option is by cable.
Could you clear?
Thanks in advance.
Does a VFP app correctly runs on a wifi network?
I'm not certain I read here that it's not a good choice, since errors arises. The only option is by cable.
Could you clear?
Thanks in advance.
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={
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-009
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",
lcSQLString = "UPDATE oracletable SET m_blob = '"+ lcBin +"' where id = 1;"
lresult=sqlexec(odb, lcSQLString, "Result")
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={
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-009
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",
lcSQLString = "UPDATE oracletable SET m_blob = '"+ lcBin +"' where id = 1;"
lresult=sqlexec(odb, lcSQLString, "Result")
Hi Experts
Could you point how to correctly use vfpencryption71.fll ?
The "in general" strategy I planned is:
When an user logs the app with password and read a record it's automatically decrypted to be readed - just the record.
During the CRUD - the line remains decrypted.
After the register is encrypted and saved.
Is it a correct approach?
Reading the examples that came with the library, it's not very clear to me the encryption/ decryption operations:
Encryption:
1. Define a key (that could varies depending on the encryption method adopted)
2. Encrypt the value and save.
Decryption:
1. Give the user the decryption key when login the app.
2. Every CRUD operation will use the key to decrypt what is needed.
Is it OK?
Could you give me an example on how to do this ? (you could use whathever encryption/decryption method as you desires)
Sorry so basic doubts.
Thanks in advance.
Could you point how to correctly use vfpencryption71.fll ?
The "in general" strategy I planned is:
When an user logs the app with password and read a record it's automatically decrypted to be readed - just the record.
During the CRUD - the line remains decrypted.
After the register is encrypted and saved.
Is it a correct approach?
Reading the examples that came with the library, it's not very clear to me the encryption/ decryption operations:
Encryption:
1. Define a key (that could varies depending on the encryption method adopted)
2. Encrypt the value and save.
Decryption:
1. Give the user the decryption key when login the app.
2. Every CRUD operation will use the key to decrypt what is needed.
Is it OK?
Could you give me an example on how to do this ? (you could use whathever encryption/decryption method as you desires)
Sorry so basic doubts.
Thanks in advance.
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\comdlg
Is it possible to make it automatic?
Thanks in advance.
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\comdlg
Is it possible to make it automatic?
Thanks in advance.
Hi Experts
Could you point what's needed to run a vfpcompression.fll under Windows 8?
I downloaded a fresh new vfpcompression.fll
Tryed to register it like it is a .dll (no success)
It used to run perfectly under Win7.
A similar issue is occuring with vfpencryption71.fll too...
Any workaround ?
Thanks in advance
Could you point what's needed to run a vfpcompression.fll under Windows 8?
I downloaded a fresh new vfpcompression.fll
Tryed to register it like it is a .dll (no success)
It used to run perfectly under Win7.
A similar issue is occuring with vfpencryption71.fll too...
Any workaround ?
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.
Could you point the better way to encrypt/ decrypt a text file content "on the fly" by using VFP?
Thanks in advance.
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.
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.
Webinar: Aligning, Automating, Winning
Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.
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.
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.
Hi Experts
Could you point a VFP code to quit an Excel instance that could be trapped in PC before to start an Excel automation process to generate a sheet?
During an Excel automation sometimes a variety of errors occurs I guess due an Excel instance to be oppened even it's not visible- only with "task manager". If it's manually closed, things go easier. The worst, sometimes a sheet file couldn't be eliminated because it's trapped by Excel and an Excel instance doesn't even appear at "Task Manager"...
Very cahotic things occur also... a date column from nothing changes the mask from dd/mm/yyyy to mm/dd/yyyy in a column from a line to the subsequent (?!)
I'm really reconsidering the use of Excel automation from VFP. It seens errors dificult to deal appears.
Thanks in advance.
Could you point a VFP code to quit an Excel instance that could be trapped in PC before to start an Excel automation process to generate a sheet?
During an Excel automation sometimes a variety of errors occurs I guess due an Excel instance to be oppened even it's not visible- only with "task manager". If it's manually closed, things go easier. The worst, sometimes a sheet file couldn't be eliminated because it's trapped by Excel and an Excel instance doesn't even appear at "Task Manager"...
Very cahotic things occur also... a date column from nothing changes the mask from dd/mm/yyyy to mm/dd/yyyy in a column from a line to the subsequent (?!)
I'm really reconsidering the use of Excel automation from VFP. It seens errors dificult to deal appears.
Thanks in advance.
Hi Experts
How to configure an Excel object column in VFP to present a value in this format:
-1.234,56 (decimal point is comma)
Thanks in advance!
How to configure an Excel object column in VFP to present a value in this format:
-1.234,56 (decimal point is comma)
*-- Example that doesn't fit what I need.
oSheet.Columns("C").NumberFormatLocal = "$0.00_ " &&add decimal place 0.00
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(c
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?
oDocument.Bookmarks.Item(c
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?
I've got a grid object in which some of the columns can be edited and others can't. I'd like to be able to mark which columns are which by means of colour, greying the BackColor where a column is Read-only.
I can do this quite happily for the columns, but when I come to tackle the Header objects, it appears that nothing that I do by way of assigning .BackColor= makes any difference.
I can only assume that this property is locked in some way.
Any suggestions as to what I'm doing wrong?
I can do this quite happily for the columns, but when I come to tackle the Header objects, it appears that nothing that I do by way of assigning .BackColor= makes any difference.
I can only assume that this property is locked in some way.
Any suggestions as to what I'm doing wrong?
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
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
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 …
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 …
Hi Experts
A VFP report that is perfectly presented in a PC is truncated at right side when in a laptop, accordingly to:
What could be done to make it correctly run in laptops?
Thanks in advance.
A VFP report that is perfectly presented in a PC is truncated at right side when in a laptop, accordingly to:
What could be done to make it correctly run in laptops?
Thanks in advance.
Resolve Critical IT Incidents Fast
If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.
Hi Experts
Do you know how VFP runs under Windows 8?
I ran an executable, amazingly a feature related to oleTreeView simply didn't worked out.
Thanks in advance.
Do you know how VFP runs under Windows 8?
I ran an executable, amazingly a feature related to oleTreeView simply didn't worked out.
Thanks in advance.
I have a foxpro DBF file that I need to modify. I need to run a modify statement where any records in "CLASS" that equal "shop", cost is set to 0.000. I am running visual foxpro 9. Any advice wil be appreciated.
Capture.PNG
Capture.PNG
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?
Hi Experts
Could you point how to programatically configurate the columns of an Excel spreadsheet - dimensions and cells format
before it is generated by VFP?
Thanks in advance.
Could you point how to programatically configurate the columns of an Excel spreadsheet - dimensions and cells format
before it is generated by VFP?
Thanks in advance.
Hi Experts
I'm planning to use MS OneDrive as the directory to .DBF files, configuring the local VFP .exe to access it for CRUD.
Have you tested it, would it work out?
Thanks in advance.
I'm planning to use MS OneDrive as the directory to .DBF files, configuring the local VFP .exe to access it for CRUD.
Have you tested it, would it work out?
Thanks in advance.
fatal error : Exception code= C0000005 @
error log
file: Z:\\VFP9Rerr.log
Called from - pos.loadline.line 0 ( )
Called from - pis. grid1. colpart_part_no.keypress line 0 ( )
Called from - rman line 0 (z:\rman.exe)
please how can we fix this
currently running a retail store pos software and that error occurs when trying to scan an item for sales
error log
file: Z:\\VFP9Rerr.log
Called from - pos.loadline.line 0 ( )
Called from - pis. grid1. colpart_part_no.keypress line 0 ( )
Called from - rman line 0 (z:\rman.exe)
please how can we fix this
currently running a retail store pos software and that error occurs when trying to scan an item for sales
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
