Search results for query: *

Hello, I'm running a VFP 8 app. with a database having a connection to SQL Server DB and various views. The current forms DE contains no tables. When I 'Set Step On' in the form, the debugger opens and immediately a 'File Open' dialog is shown. Even if i select a table, the dialog persists...

Hi, We are running a VFP 7 application on our LAN and over citrix as well. Over LAN, the app. runs without any problem when I 'Add' and 'Save' a record. But over Citrix, when a new record insert is triggered by the 'Save' buttons click, the control goes back to the Citrix main window (Internet...

Hi, Our application is developed in XP, VFP8 and with the database in SQL server. We built the 'Setup.exe' using Installshield Express 5.0. When we run try to install the app. on a Win95 or Win98 PC we get the following error: The wizard was interrupted before MACS could be completely...

Hi, I'm using MS-Access as my back-end & the app. is in VFP8. The application's set Date is British. Current date is "02/09/2004" When I run the following code: lnRes=SQLEXEC(Handle,"Insert into LastDone (UpdatedOn) VALUES ("+"#"+DTOC(DATE())+"#)") In Access, UpdatedOn is populated with...

Hi, I've created a VBA Script in an MSAccess mdb. Module name: PBProcs Function in this module: PbFunc function have no parameters. The front-end is VFP and I need to run this function PBFunc from the VFP app. I've tried the following: 1. SQLEXEC(Handle, "Execute PbFunc") 2. SQLEXEC(Handle...

I hope: 1. I'm posting in the right forum. 2. this is not a repeat. The following method can be used to format an Excel output: Copy the output file to Excel. Open the Excel file and record as many macros you want in Excel to do the required formatting. Create a table (xlStuff.dbf) with a memo...

Hello, This is the code in my Main Form's init event: _SCREEN.Visible = .F. This.Show() READ EVENTS CLEAR EVENTS and this in the 'Exit' button's Click event: nResponse=MESSAGEBOX('Do you want to quit this application?',4+32,'Confirm action') IF nResponse=6 CLEAR EVENTS ELSE RETURN ENDIF...

I've created a VFP 8.0 app. with the database in SQL Server. I'm running SQL Server 8.0 and the client will be using the MSDE (less than 5 users on the client). I suppose I can just copy the mdf and ldf files as well as the .dbc, .dcx and .dct (containing the views) to the relevant folder on...

Hi, The VPN is on a 2MB SDSL line and the VFP exe resides here. The client has a 20:1 512KB ADSL line. Connecting and launching the Exe takes extremely long. Could someone please advise the possible areas that can be tweaked to make the loading of the EXE faster? Thanks and Regards, Rajesh

Hi Fox-gurus, We have a VFP 7 application where it is mandatory that all input be in English. On one of our sites, the user has a Chinese input tool (Richwin) installed on the PC and is getting an error message Collating sequence 'PINYIN'is not found'. Please advise whethere there is any...

Hi all, Due to data storage and security issues, we are planning to convert an existing VFP app. to VFP front end and SQL server backend. I would like to know the issues that are to be taken into consideration for this upsizing. I tried upsizing the existing data to the MS Sql server that ships...

Hi, We run an application with 6 tables in a DBC. The cdx of just one table ('Vendors') keeps getting corrupted off and on. (There are no triggers in the dbc for any of the tables.) The structure of the table: VENDOR Character 40 PHONE Character 15 FAX Character 15 EMAIL...

Hi all, I've a situation where I have to present data in a grid in the form of a data+subdatasheet. E.G.) Customers and Orders Given a Customer, the first column of the grid should hold the '+' symbol clicking on which all orders belonging to this customer are listed in the subsequent rows...

I am not able to access vfp help both from the menu as well as the command window. But, if i try to run the chm from windows explorer it works fine. In vfp, Tools | Options | File locations| Help File points to the correct path and file (C:\program files\microsoft visual foxpro 7\foxhelp.chm)...

Hi gurus, I have a grid on my form with its recordsource pointing to a cursor. The cursor is populated by an sql statement based on the user selected id in a combo box. In the double-click event of every column and every column's control, I've inserted code to activate a form. In the...

Hi VFP-gurus, I have an application which functions as a viewer (only). The data for this application is imported on a daily basis. The application checks for available import files in a particular folder, imports and updates various tables. For importing, I want to open the database and...

Hello all, I am unable to find why I'm getting this error :-( "Data Type Mismatch" All my tables and views are in the DE. I'm using the navigation bar (with Save/revert buttons) in the form. When I click on save, I get this error, but the data gets saved properly. When I go to the...

Created a view in View designer. Generated a prg using GenDbc to get the view code and modified the prg. Deleted the view from the DBC and recreated it thru' this prg. Created a form with the view in the DE, a grid using this view and buttons to add & delete records. In Form Init: Set...