Search results for query: *

Here's my 2 cents. I'm one of those dreaded part-time programers. In my office we use my 17 year old Clipper app on an XP network. I have ALMOST finished a 3 year re-write in Visual Foxpro. I now like FoxPro, but sometime wonder if I would have been better off to use Access. If you are going...

Alan232 I'm trying to grasp your problem. You need to lock out mEnable while VFP does read/writes. But you don't know when mEnable is going to do a read/write. You said flock() does not prevent mEnable from reading and writing, can you confirm that USE EXCLUSIVE by VFP stops mEnable? Jim...

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...

Ok, I'm embarassed. After working 2 days on this, then posting for help, I find the answer an hour later. I did not have good KEY FIELDS set in the view update criteria. I only had the IDNUMBER set. The TABLEUPDATE() works on all entries with the same KEYFIELDS. By adding TIMESTAMP to the KEY...

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...

Thanks Joseph I have a new machine that has XP PRO that I have not got setup yet. After I do, I'll try VPN on the XP PRO and report back Jim Rumbaugh

Mike Thank you very much for the explanation and advice. I know what to do now. Jim Rumbaugh

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...

Thanks Mike, I now see what you mean and I have a plan. I'll let you know how it goes. Jim Rumbaugh

Thanks FatSlug, that's good enough for me. I'll use another tool for the job. Jim Rumbaugh

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...

Nicola I am also finishing up on a small multi-user application written with VFP 8. I started with MSDE. I recomend looking at SQL 2005 Express. It is Microsoft's replacement for MSDE. In theory, there are a few places where you may prefer MSDE, but I'm leaving MSDE and going with SQL 2005...

Thanks to all of you for your help and suggestions. I ran the code at work where the backend is SQL 2005 Express. The code works as expected. I will now assume it is a MSDE problem. I'm still fresh at SQL pass through. It's a re-hash of my old FILELOCK routine. I had one case where I could...

Thank you all for your help. Here's the code as it stand's now. In the form INIT: which calls If I leave out "TOP 100", it works fine. If I put it in, I get the countdown to 10, then the message box with the AERROR() message: I think I'll try it at my other location and see if it happens...

Sewart I am not an experienced with MS SQL SERVER or MySQL. But just this week I ran across SQL 2005 Express. It is Microsoft's free version of SQL 2005. It is meant to replace MSDE, which is Microsoft's former free verion of SQL. I can tell you I got a lot further and faster with SQL 2005...