I'm facing an awful performance issue.
I create a READWRITE cursor (say fTmpDumCursor) over 100,000 records &
Indexed in the init event of the form.
Also I've a grid on the form and it's populated by a physical table (say

In the SQL query analyzer you can script an existing table and the analyzer
will create a code listing of the table.  Then later you can run that code
and it will create the table with or without data.  Is there something
similar to this in VFP?  I have a table in one application ...

I'm probably missing something obvious here, but there seems to be no
function to easily concatenate a date value and a time string into a
DateTime field or memory variable?
I can construct it, but hope I'm missing something obvious

I need help about a query that doesn't work, with "Statement is not
allowed in interactive mode".
It is a query that correctly works with only an insert in the loop,
but it doesn't work with the second insert statement (insert into

I am able to pull data from a SQL server using a simple select statement with
the SQLEXEC in VFP.
I am trying to select only a few records from the SQL server database into
new fox table.

I have build a form with dataenvironment having 3 tables
I have placed navigation button from txtbtns
Now when we run the form data is displayed from cursor1
I have also placed button group so when we select option 2 it should pull

          I use "select * from table_A". Then I want to update the
the record match some criteria. So
How can I do that?

Our team is a unique producer of quality fake documents.
We offer only original high-quality fake passports, driver's licenses, stamps
and other products for following countries:
USA, Australia, Belgium, Brazil, Canada, Finland, France, Germany, Israel,

    I've just about completed my application and I'm preparing to
send out some demo copies which will hopefully be followed by some
sold licensed versions.  Naturally my concerns are with limiting the
duration of the use of the demo to a month or two and securing the

I'm calling a form by using a
button which is in a grid column.
Grid's RecordSource is "Alias1"
In the loading form Init event there is a SELECT command to select Alias2

*----------------------------------------------------------------------------
* Grid in VFP6 work just fine but in VFP9 make me crazy.....
*
* Thousand of code have to modify in my project.

ok, i have a weird problem and for the life of me i cant figure out what the
heck is going on
i have 2 cursors. lets call them orders1 and 2
initially they are identical

I have a report without an explicit reference to the variable _pagetotal
Are there any example on how to set this:
ReportListener.TwoPassProcess=.t.
How can I create the object "ReportListener"?

I'm sending an FRX report to a PDF file using FRX2ANY.  I've
prepared a BMP image to use as a watermark in the report to certify
that the PDF has legitimately been produced by the software and the
results in the report were not tampered with.  I found that I couldn't

I have Windows XP SP3, VFP 9 SP1.
The printer is dot matrix. The paper is endless pre-printed with some form
format A5 with width 210mm and with perforation at each 148mm.
How can create Report for this paper? In Page Setup there is also offered A5

Statement:
Import FROM "C:\Accounts.RPD" TYPE RPD
Produces error "Field Store_Name is read only" and fails to convert the
file.

How do I loop through the fileds of my table in dbase III

Has anybody ever encountered the error "Record is in use by another user"
when you're the only one in the system? The record in question was obviously
locked by myself since I'm the only one in the system yet I get this error
like there's somebody else on the system who locked ...

hi...
i'm trying to fetch data from mysql 4.0 with myodbc 3.51.
currently using vfp8.
i fetch tables using cursoradapter and fill property CursorSchema

Hola a todos. Necesito saber como puedo declarar y utilizar la funcion api
GetOpenFileName en Visual FoxPro. Gracias.

I know this is a VB forum, but my question pertains to VFP. I am trying to
stop a ListView from redrawing itself as I am inserting 3000 ListItems.
However, the following code does not prevent it from redrawing. Can you
Help?

 

How to declare Abstruct Class in VFP?

 i need to write a program to record down the material information within a
product, some product contains 3 materials, some contains 5 materials, number
of materials within a product is decided by user,  and each material have
their own different information to record. (it's about ...

Muchos problemas de rendimiento y seguridad de tu computador son causados por
virus maliciosos, la mejor forma de combatir esto es tener instalado un
Antivirus reconocido y actualizado en tu computador
Descarga gratis Antivirus en:

When I'm trying to install my application on user machine, I got the
following error :
"Unable to register the DLL/OCX:RegSvr32 failed to register with exit
code 0X3"

As far as I know, we can do cascade delete by referential integrity.
How can I build referential integrity during runtime ?
Saying clearly, how can I write multi-table delete SQL in VFP like in
MySQL ?

I am running under Vista 32-bit Ultimate SP2.  I have deleted Java folder and
contents.  I have deactivated all startup items and non-Microsoft services &
rebooted.  I have uninstalled Norton (NIS2009) & rebooted.  I have tried
everything suggested by Microsoft support.  Java ...

I currently have a FoxPro program that gets customer information from QB Pro
2006 and also creates transactions that can imported into QB Pro 2006.  It
uses the "QBXMLRP.RequestProcessor" interface.
My customer wants to upgrade to QB Pro 2009.  Does anyone know if this will

While working on converting Fox-DOS application to VFP 9.0, I am
running into this error via one of the program file (.prg) at the
source code line
go_comm = Createobject("MSCOMMLIB.MSCOMM")