Search results for query: *

I program for my own small business use. I have a VFP 7 program that has been and is currently running for 15 years successfully with a SQL 2008 then 2016 backend. It has been on the same 8 PCs all this time. 1 pc as the sql server and the others as clients. I made a copy of the data and...

I am using FVP8 frontend SQL Express 2005 backend The program has run successfully for 5 years on many XP machines. I have installed it for the first time on a Windows 7 machine. The ODBC connection tests good through the Windows ODBC Open connection Manager, but when I launch my program I get...

I have 8 computers on a LAN using XP home connecting to SQL EXPRESS 2005 on a machine using XP Pro. The setup has worked for over 5 years. A router plugs into the 24 port Dell switch. The router is to allow internet access. We need to set up a VPN and installed a new router. Once the router is...

I am using FVP8 as front end SQL Express 2005 is back end. I have about 60 remote views. It is time to modify the Tables via SQL Express. In the past, if I change the tables, the remote views will no longer work, nor can I access the views to modify them via the IDE. Any suggestions on a good...

I am using VFP 8.0 I am using remote views I am using SQL 2005 as the backend If I edit a record and do a TABLEUPDATE( .t. , .t. ), everything is OK. But if I edit it a SECOND time and do a TABLEUPDATE( .t., .t. ). The record : 1)is marked as deleted in the grid 2)dissappears if I click on...

I have 2 tables. One is a ledger of payments made per patient ID#. The other is services done for the patient with the doctors name and date of service. I need to sum up the ledger payments and assoiciate those payments with the last doctor to do a service.(the last doctor to see the patient...

I am using VFP 8.0 REMOTE VIEWS SQL EXPRESS 2005 I have a grid with about 200 items listed. There is one group of 10 items that generate an "UPDATE CONFLICT" when I try to change their data. I'm stumped. Any suggestions?? Thanks Jim Rumbaugh

I'm looking but I can not find an answer. I need to "place an order" via a web browser, Internet Explorer. I would like my app to enter the info. Can this be done? If so, where do I look for instructions? Jim Rumbaugh

My front end is Visual Froxpro 8.0 My Backend is SQL EXPRESS 2005 I retrieve the table names with : SELECT name, type FROM sysobjects WHERE type = 'U' Once I have the table name I need a list of the KEY FIELDS for that table to make a local updateable cursor. Any suggestions are...

I am using vfp8.0 I am trying to send an order via email i am using code I found MSDN VFP forum I can send the email. here is the code loConfig = CREATEOBJECT( 'CDO.Configuration' ) loMsg = CREATEOBJECT( 'CDO.Message' ) WITH loMsg .Configuration = loConfig .TO =...

I am using FVP8 My top level form PT_INFO calls form LIST _SERVICES LIST_SERVICES calls SERVICE_INFO. If while the SERVICE_INFO form is active, I call MySCHEDULE, I get an error when MySCHEDULE tries to close PT_INFO. Let me add that closing PT_INFO causes LIST_SERVICES and SERVICE_INFO to...

I am using VFP8. I am setting BREAKPOINTS visually, by clicking the "gray left margin" and placing a red dot where I want the break. My problem is that the code will not break out every time. My most common experience is for it to break the first time I run it, but never again. Am I missing...

I want a count of all the different services done. This works OK. SELECT service1 as serv1 , COUNT( service1 ) as howmany FROM MyDatabase GROUP BY service1 ORDER BY service1 But each record has a place for 6 services to be entered, I.E. service1, sevvice2, ….. service6. ( I humbly ask...

I am using VFP 8 with MS SQL EXPRESS as a remote backend I have been troubleshooting a slow TABLEUPDATE(). It is a table of charges, payments, balance, and date. I have reduced the time of the TABLEUPDATE() from 110 seconds to less than 1 second. Here are 4 pseudo-code examples of what I...

After about 4 years, maybe 5, I now consider my application finished. Thank goodness I don’t do this for a living, I’d go broke. I want THANK the MANY PEOPLE that made this possible. I have found TEK-TIPS to be the best resource on the web. I am greatly thankful for all the help I have been...

I am new to XML I am using VFP8. I am looking into sending orders to a vendor via XML. My vendor has supplied me a sample of an XML file that he receives from other customers. I can successfully generate a XML file from a local cursor via the CURSORTOXML() function. I can then regenerate a...

I have table of amounts paid during the day. The following will give me a list of daily totals select date , sum(paid) from ledger group by date order by date Is there a way I can get a list of Monthly or Annual totals? Thanks in advance. Jim Rumbaugh

I am using VFP 8.0 as a front end I am using SQL 2005 Express as a backend I am using remote views. My question is : What is the best way to display info from multiple tables, but only add info to one table? I would like to display information from multiple tables on my form. An example is...

I am using VFP 8.0 for the front end. I am using SQL 2005 Express for the back end. During development I had multiple connections defined. I want to change it to one connection definition, but before removing old connections, I need to redefine the old connections linked to my remote views. I do...

I am using FVP8 I am converting my 15 year old Clipper program to VFP. I use the KEYPRESS event to trap for keyboard control of my forms. If I set the forms ShowWindow property to TOPLEVEL, I can trap for the F10 key. If I set the forms ShowWindow property to SHOW IN TOPLEVEL, the F10 key is...