Search results for query: *

Hello All, I have a VFP program that will dump some data to an XLS file. When I open the XLS files all of the Dates are set to DD-MM-YY format which causes excel to read the field as a text field instead of a date field. When I export the data to a CSV file the dates look correct and are...

I have a simple form project that will take a value and use that to do some SQL statements. I am trying to check the textbox to make sure there is a value actually present in the textbox after the "go" button is pushed. In the code of for the click event of the button I have some code to execute...

I have built an EXE that will pull some data and put the data into some text boxes. I use this small exe to help make changes where I need to by updating some tables on my own, then recheck the values. The problem I am encountering is that when I update the tables and check the exe again the old...

first off I want to thank everyone here for helping me out so much in the past few months. I am attempting to build a suite of tools to help me with my job. I am very thankful for the help. I have created a small program that uses 1 single form to execute 3 SQL queries and put the result of the...

I have an interesting scenario: I need to update the bottom or top record of a group of records that are exactly the same. (not my design, legacy software that is on its way out). I can't seem to find the correct logic in SQL to do this. I either update all of them or none of them. Is there a...

Newbie question: How do I access the data in VFP 9.0 from the following SQL? SELECT SUM(reinsprem) AS CurrVal FROM reinstrn WHERE date >= DATE(2017,08,01) AND Policy Like PolNum AND code NOT like 'MBR1' INTO CURSOR A1 All I need to do is get the returned value of CurrVal in the cursor A1...

I have been attempting with VFP 9.0 to parse a tab-delimited file. The file contents look like this: Policy 1 LocNum 1 Address 1 City 1 State 1 Zip 1 Policy 2 LocNum 2 Address 2 City 2 State 2 Zip 2 Policy 3 LocNum 3 Address 3 City 3 State 3 Zip 3 Policy 4 LocNum 4 Address 4 City 4 State 4 Zip 4...

Hello again everyone, This is a FoxPro beginner question. I have data that I am pulling from one directory via a select statement, I need to push this data into a table into a different directory. Is there a resource somewhere that would show me how to accomplish this? I can use the cursor and...

I am new with FoxPro 9.0 (I know it is antiquated but it is what we have here at my new job) I am attempting to create a query that will show all of the records from one table (Types) and the count of the occurrences on from another table. It sounds to me like a simple Left OUTER Join but the...