I have a client asking about their VFP app with a SQL backend database being able to import/export data from SalesForce (www.salesforce.com).  I am wondering if anyone has suggestions on how to best go about making these tasks work, using 3rd party tools or otherwise?

try
            {
                var cdxExpressions = new List<CDXExpression> {
                new CDXExpression { expression = "ENTRY_DATE", name = "cdx_p1"},
                new CDXExpression { expression = "LOSS_PD", name = "cdx_p2"}
            };

                string strCon =
                    @"Provider =vfpoledb;Data Source=C:\DBF_files_Folder\20180921\" + tableName + ".DBF"; // TestDataBase1.DBF";
                OleDbConnection con = new OleDbConnection(strCon);
                OleDbCommand cmd = con.CreateCommand();
                con.Open();
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.CommandText = "ExecScript";

                var myCode = "use " + tableName + " exclusive\n" +
                      string.Join("\n", cdxExpressions.Select(e => $"index on {e.expression} tag {e.name}")) +
                      "\nuse";

                cmd.Parameters.AddWithValue("code", myCode);
                cmd.ExecuteNonQuery();
                con.Close();
            }
            catch (Exception ex)
            {

            }
C# -

Code above used VFPOLEDB driver. This driver should be installed on machine explicitly.
When I put my WPF application on common drive and ask users to access it, they also got to install VPFOLEDB. Is there a other than installing this MSI on all client machines.
Tried using JET OLEDB. It gives an error saying 'Cannot execute a Select Query'.

try
            {
  …

I have a Visual FoxPro program running. it uses a local cursor engine.
To use the program from home, people use a VPN solution (openVPN)

Using this, we have poor performance.
We use lines with a 200mbit down and 50 mbit upload speed.  (vendor = Telenet Belgium)

The database has a traffic of 100mbyte totally  during a complete session, so it should fly.
However: on a 100Mbit network it works realtime. response times are very low.

Using openVPN, response times are like minutes.
The internet connection is real fast. So OpenVPN is what slows us down.

I put send and receive buffers to 0 in both server and ws config file. This fastenes the systyem up, but far..  far from enough.

There must be other settings to speed openVPN traffic up. But what can I do?

I have a foxpro table with sequence 55,56,57,59,60,70,70,71,72,73,74,74,75.76. Will like to reset the numbers to have a uniform sequence like
55,56,57,59,60,70,71,72,73,74,75,76,77.78. i have tried a loop program that increments by 1 for every record loop but to no avail. it skips reset the similar numbers

can some assist me please

I will appreciate

descendex.zipdescendex.zip0
down vote
favorite
I am having a problem with seeks not working on descending indexes key values.

I set up my DBE as follows:

SET COLLATION TO AMERICAN Dbeload( "ADSDBE", .F. ) DbeSetDefault( "ADSDBE" )

// FOXCDX compatibility - .CDX/.FPT DbeInfo( COMPONENT_DATA , ADSDBE_TBL_MODE, ADSDBE_CDX ) DbeInfo( COMPONENT_ORDER, ADSDBE_TBL_MODE, ADSDBE_CDX )

// Use server rights not user rights DbeInfo( COMPONENT_DATA, ADSDBE_RIGHTS_MODE, ADSDBE_IGNORERIGHTS )

I am connecting through an ADS data dictionary and the tables were added using the FoxPro (DBF/CDX) driver (not the Visual Foxpro driver.)

The indexes are created through ADS.

I have an index that puts empty dates first followed by descending dates then ascending IDs as:

 descend(If(empty(date),’99999999’,dtos(date))+id
Whenever I do a seek as either dbseek(descend(‘99999999’)) or dbseek(descend(dtos(dMyDate))) the seek goes to EOF or the proper record (date does exist) is not found properly.

I have the character set set to ANSI for both systems and the collation to Engl.(Amer) in both.

I've attached a sample program, table and other information in case anyone wants to take a look.

Hi Experts

Could you point what is preventing vfpcompression.fll to be used in a VFP9 project running under Windows10?

Accordingly to:


The same .fll perfectly runs under Windows 7

Any workaround?

Thanks in advance

Using ODBC I am trying to redirect a VFP app to new SQL 2016 database.  If I use Windows Authentication the app will run as desired.  If I use the preferred SQL Server Authentication the ODBC connection is made and tests successfully, but when trying to run the VFP app I'm continually getting SQL Server Login dialog box popup.  I have confirmed the SQL server is set to Mixed Authentication Mode.

0
down vote
favorite
I am able to use the ODBC drivers (Microsoft's and other providers) with Visual FoxPro Database. I am able to execute Select & Insert statements using the ODBC Drivers but not able to use Create/Update/Drop table using the ODBC Drivers. I am able to create a table using Visual FoxPro IDE but would like to do it using ODBC Driver.

Any help is appreciated.

Hi All:
I have a program that reads a table using a DO..WHILE loop. For each record, there is code that copies a filename (of a BMP file) that is in a field to a temp file using a COPY FILE statment. The temp BMP file is then used on a report, and the report is run for each record. If I run the source code, the COPY FILE statements and the reports are correct but when the EXE is run, only one COPY FILE statement seems to happen and the same picture appears on every report. The client using the EXE discovered the problem. Everyone is using Windows 7.
Any ideas would be appreciated.
Thank you,
Cathie
NYC