Search results for query: *

JRB, thanks for the testing technique. You guys are awesome! ;)

Mike, Thanks! I was thinking I had to change the address within VFP. I made the change on my comp's ODBC settings and all is working now. Thank you for you help. :)

Hi Mike. The problem is, I don't know where to look. I see a bunch of VFP files in a folder, but I dont know what each one does? I'm not familar with the various extensions. You said to look for the Control Panel / Administrative Tools. I need to be walked through... when I open up VFP, I...

Hi. I pretty much have no knowledge of VFP. A bunch of the queries are linked to SQL server tables and recently, the SQL server switched IP addresses. Now VFP can't connect to the SQL tables and I'm getting: Microsoft SQL Server Login Connection Failed SQLState:'01000' SQL Server Error...

Thanks everyone. Since there was only 1 instance of a duplicate record, I just used a DELETE statement to delete both the records and inserted one back. It worked!

Thanks. I'm new to this and I'm just trying to learn my way around. Where would I do the SQL for this type of function? Do I just open the original table (using Enterprise Manager) and type in the SQL there? And to make a duplicate table, is there an easy way to "copy and paste" the table or...

This is probably a stupid question to most of you and it doesn't deal with programming, but I couldn't find a place to ask this question dealing with SQL Server. In a table with 2 columns, I can't delete a duplicate row. For example: Column 1 Column 2...

Hmm, looks like my last reply didn't post. Maybe I hit preview instead of submit... Anyways, I finally figured out the problem. The computer that would not connect to the database was missing a System DSN. I checked the ODBC drivers and apparently forgot to look at the System DSNs. Thanks for...

I did not write any of the program, but do have access to it. When I look through the files, I do see a bunch of .dbf files. I'm pretty sure the data is being inputed to a SQL table through an intranet site written in ColdFusion. FoxPro is only used for reporting purposes. I'm guessing that...

Hi everyone, I know very little about Foxpro. I believe we are using v.6. The problem I'm encoutering comes when I try to run a .prg to execute a query. The error states "Cannot Connect to (name) Database". The database is on a different PC on the network. When I run the program on my PC, it...