Search results for query: *

Just a quick tip for fellow newbies. Working with grids and remote views, I've been struggling with displaying .NULL. values. Today I had a .NULL. date value in a grid that I could not get to go away no matter what I typed into the NULLDISPLAY property. I found a Microsoft tip that said you can...

I am using VFP8. My back end is SQL Express. Here is the problem. The TABLEUPDATE() deletes ALL of the records of the remote view from the SQL backend while only the selected record is removed from the remote view on the client machine. I verified this by using SQL Server Management Express...

I know XP Pro can be a VPN Server. What has me confused, is that my XP Home machines allow me to set up for an incoming VPN connection. The setup screens look like the screenshots I have seen for XP Pro. It acts like it wants to work. I am getting feedback from the "server" like, "name and...

I'm still trying to get a handle on remote "handles". From the VFP8 HELP I read: To obtain a handle, you request a connection to the data source using the SQLCONNECT( ) or SQLSTRINGCONNECT( ) function. If the connection is successful, your application receives a connection handle for use in...

The remote views that my laptop accesses from my server at home, do not want to work with my server at "work". If I try to BROWSE a defined remote view I get the error "Conectivity Error:[Microsoft][ODBC Drive Manager] Data source name not found and no default driver specified". I realize that...

I am using VFP 8 I am using MySQL 5.0 I am using the MySQL ODBC 3.51.12 I can connect to and run a remote view from MySQL. But when I run the upsize wizard, the saved conection does not show up on the list of conections unless I select ALL ODBC conections. Then I get an error saying "SERVER...

When converting my data files to SQL with the upsizing wizard, there is an option called NULL MAPPING. The four options are: 1)general field overrides 2)general and memo fields override 3)all fields override 4)default settings I am trying to understand the differences of these options. If I...

I am using VFP8 I am writing an application with MySQL 2005 as the backend. I am using some SQL PASS THROUGH functions. My question has 2 parts. First, To use the functions I need a connection handle. Is the preferred way to create a connection handle at the beginning and use it throughout the...

I just hacked out why I could not upsize a table with the UPSIZING wizard in VFP8. I thought it was NUL date values causing the problems. No, it was a field name. A field was named CURRENT to hold the dollar value currently due. After renaming the field to NOWCURRENT, I can upsize it with no...

I am using VFP 8 MSDE is the back end remote data. I am trying SQL pass through. This code works but I get 25,000 + names. thisform.connectionhandle = SQLCONNECT( "DonnaSQL") thisForm.tempcursor = "ListOfNames" SQLEXEC( thisform.connectionhandle , ; "SELECT lname , fname, mname, idnumber...

I am using VFP 8.0 I am developing a client- server applicaction. MSDE is the backend. I have about 20 tables to upsize to SQL. I've hacked at it until all but one table transfers. This Patient_Info file fails to transfer records due to an error. If I upsize only the Patient_Info file, the...

I am using VFP 8.0. I am developing a client-server application. The server is MSDE. I have determined that the upsizing wizard does not like my empty date fields. I have learned that the large date range is from about 1756 to 9999. I get the idea that 01/01/1901 is the most common default value...

This is a newbie question. I am developing a Visual Foxpro Database (VFP) program. I am trying to use MSDE and a SQL database instead of the native VFP database files. I have installed MSDE on two machines with XP HOME. I can access and create files on each machine localy, with MSDE. I have...

I'm still addapting to the concept of local/remote views. The multi-user app that I am develpoing in VFP 8, will eventually be used on a WAN. I am trying to prevent errors from 2 people accessing the same IdControlNumber at the same time. I have a situation where TABLEUPDATE() on a base table...

I am using VFP8.0. I am using a LOCAL VIEW. After editing an existing form with data, I have a button called SAVE. It does a : TABLEUPDATE( 0 , .T. ) REQUERY("MyTableView") If you leave the form by pressing ESCAPE or closing the form before pressing the SAVE button, it does...

I have form that displays a work schedule in a grid from a cursoradpter. After doing the command : REPORT FORM schedule The form no longer responds to commands to look up a new date. In debug I saw that most of the properties of the form object had been erased and the cursoradpter was no...

I need some basic concept explained. I have been asked to modify an aplication. It has been compied into multple EXEs with one module calling the next. I am having trouble getting it to run from the command prompt. I believe I need to recompile before my changes are seen, or the path...

I have 2 programs made with Clppier 5.2e. Both have run for many years. They have run on my XP-HOME machine with no problems. But I just now intalled the SP-2 upgrade. I now get a windows error box: 16 bit MS-Dos Subsystem The NTVDM CPU has encoutered an unhandled exception. Choose 'Close'...

I am using FVP8. I am visually creating my second user defined class. It is a form. I can create the object with : oForm = CreatObject('MyForm') I can add values to it with: oForm.MyItems.value = "MyInfo" But I can't figure out how to make the form appear. It has NOT worked to say: DO FORM...

I have just written my first CLASS with VFP8. When it is finished, it will manage the printing of a HCFA1500 insurance form. Here is a stripped down version of what I wrote: DEFINE CLASS Hcfa1500 AS Custom COMPANYNAME = '' COMPANYADDRESS1 = '' COMPANYADDRESS2 = '' COMPANYCITY = ''...