Search results for query: *

Dear Folks, I am experiencing this fatal error since I have got my new PC at work. This is a brand new Dell machine with Windows XP Professional installed on it. I am using VFP 9.0 and I am getting this error regardless of what I am doing. Some times, I get this error while modify command a...

Again, it depends what version of FoxPro Ross is using. If it's 2.6 or earlier version then all you need to do is to make sure that you call the procedure getdate before APPEND FROM command in your code. Otherwise Mike's answer stays valid. Thanks

Here you go SELECT tabl1.pers_code, tabl2.event_cat FROM table1 as tabl1, table2 as tabl2 WHERE tabl1.event_code = tabl2.event_code GROUP BY tabl2.event_cat, tabl1.pers_code ORDER BY tabl1.pers_code It will be slow if you have a lot records in these tables.

Thank you much Mike. I had this solution in mind but SQLCONNECT failure is not necessarily because of not having DNS on that machine. There can be many other reasons like SQL Server is down or User ID has been changed or deleted or password changed etc. I just wanted to be more specific about...

Hi everybody, I am pulling data from SQL Server 7.0 in my VFP application. I need to add a functionality in my VFP application to check if the computer on which this application is installed has an ODBC connection (DNS) created for SQL Server. If it does not have it, it should be created...

Very interesting. Thanks a lot.

Thanks to everybody for the valuable information you provided here. I am still confused that when I have date information in Microsoft Excel and I convert every column as a text, why does Excel give serial # 60 to 2/29/1900? As you know that Excel starts assigning serial # to each date starting...

Does anybody know why Visual Foxpro not recognize year 1900 as a leap year?

Hi Folks: I am having problem in reading XML file using VFP 8.0. I used XMLAdapter class to load XML file and schema file. It does not display list of tables in the XMLTable list. XML file contains Items and attributes. If somebody has worked on such files please let me know how I can import...