Search results for query: *

The link says this works for VFP 9. I have VFP 6.

All I know is I don't see any way to convert JSON to a dbf or csv so it's worthless at this point. I'm telling my company to stay away from it. Stick with SQL or Oracle if it's related to data. Once again, if JSON was so great, they would have an easy way to convert it.

JSON may be important for the web but so far it's horrible to use. Once again, I can't even do something basic like pull the data into a dbf or csv file. Thanks for the comment but it does not help me solve the problem. If JSON was so good, they would have a way to convert it to a csv file...

Hi, I am trying to pull JSON data from the cloud. My goal is to get the data to a dbf for analysis. So far I can pull the data into a Foxpro memory variable. It's a huge memory variable with each record enclosed in {} with field header and field detail separated by a colon and each record...

SUCCESS!! I was able to locate the needed odbc driver for Access accdb format. Here is a link to it. https://www.microsoft.com/en-US/download/details.aspx?id=13255 I Downloaded the file, installed it, added a new DSN for that Access database to the list of odbc DSN's.... then tested and it...

Hi Olaf, Agreed. The FoxPro side is a piece of cake. Finding a DSN driver that works with an accdb format is where I am currently stuck.

I 100% blame Microsoft. They eliminated things we've been doing for 20+ years now and the only explanation is so they can sell newer software. Have you noticed how they degraded the Task Scheduler in Win 10? Even Microsoft people had no idea what Microsoft had done. Regardless, I just got it...

Hi Mike, yes Access can export to dBase III and it pulls fine into FoxPro. I setup an External Data, Saved Exports in Access and that's when I saw they use an Outlook task to automate it.... but it still requires someone to manually execute the task (when Outlook reminds them it's due)….. so...

Hi Olaf, your level of programming is far above mine. I am very good with FoxPro but have limited knowledge when to comes to pulling data from different data sources. The access database I need to pull from is located in C:\Programs\Coolant\Cool.accdb and the table I need to pull is called...

Hi Mike, yes I thought about that. Actually tested exporting it to a dbf and it pulls fine into FoxPro. The problem is I don't see an easy way to automate this. Access allows me to save the export definition but the only way to automate it is through an Outlook task....and that requires the...

The Access version we have is a normal Office installation. It's just a stand alone database with an accdb extension. There are no passwords or user ids'. I don't need to recreate the entire database but rather just pull data from one of the tables. It's a simple table with 4 fields (1 date...

I Need To Pull Data from a Table in Access into a FoxPro table or cursor. I've researched online and cannot find any info for this. Has anyone been able to accomplish this?

Hi Mike, I took what you had and modified it slightly to give what I need. Here is the final code I used. ADIR(laFiles, "G:\Projects\Departments\Sandvik\Export\MCGages.csv") mdate= laFiles(3) && save date to mdate Thanks so much for your help.

Hi Mike, When it executes the ADIR line it gives an error saying laFiles is not an array. I am using Microsoft Visual FoxPro 6.0.

I am trying to obtain the create and/or modified date for a file in a specific directory using FoxPro commands. "dir G:\Projects\Departments\Sandvik\Export\MCGages.csv to file Timtest" creates a text file with the filename but does not have any information about the create/modify date. I've...

Hi Guys, Treating the SQL statement as a memory variable worked. I could not get TEXT ENDTEXT to a memory variable to work so just did a normal store and it worked fine. Griff, Olaf, Mike, atlopes, vernpace YOU GUYS ARE AWESOME!!! Thank you much for the tips. mserver, muser, mpass, msql...

Griff, yes YEARNO is a numeric. I've used FoxPro since the 90's back when the first MS Dos for FoxPro came out. Double quotes work great for it BUT it's a whole different animal trying to use SQLEXEC.

PRODUNIT is a Character field. M is one of the acceptable string/values in that character field..... it could be any letter or number Bombs out means it returned no records but should have returned records. Ie, it executes the command without displaying an error on the screen during...

Atlopes, I think you misread what I originally stated. When the where clause says: where MTLTYPE=01 AND YEARNO>=2018 it works fine and returns 77,154 records..... BUT When the where clause says: where MTLTYPE=01 AND YEARNO>=2018 AND STOCKID=M AND PRODUNIT=M it returns nothing...… ie, it...

Hi Guys, Neither of those solutions work. Griff, M is not a memory variable. Mike, STOCKID and PRODUNIT are both character fields BUT MTLTYPE is also a character field. MTLTYPE works fine without quotes but none of them work if I use single or double quotes. I notice FoxPro does create the...