Search found 5 matches

by will_harrison
Tue Jan 01, 2013 8:16 pm
Forum: Databases
Topic: Manipulating a large CSV file (beginner question)
Replies: 9
Views: 9698

Re: Manipulating a large CSV file (beginner question)

Happy New Year! I've made some progress. I exported out my database from MS-Access and was able to create a SQLite database using a Firefox SQL database manager. Now I will go back to my code and see if I can open and not get the revdberr. Yes, I'm using the revDataFromQuery. Here is the code segmen...
by will_harrison
Sat Dec 29, 2012 11:22 pm
Forum: Databases
Topic: Manipulating a large CSV file (beginner question)
Replies: 9
Views: 9698

Re: Manipulating a large CSV file (beginner question)

Yes, it is in a Access database and could stay there instead of exporting out to a csv or other txt file. I'd like to do open it on a Windows or Mac. My first task is to open it up and then search for a partnumber. I could send a sample script that I've written already to open and then get the data....
by will_harrison
Sat Dec 29, 2012 1:55 am
Forum: Databases
Topic: Manipulating a large CSV file (beginner question)
Replies: 9
Views: 9698

Re: Manipulating a large CSV file (beginner question)

I got off trace for a few months with other projects and am back on this task. Now I clearly realize that a ODBC link will be a better choice. Do you agree?

Will
by will_harrison
Wed May 18, 2011 9:59 pm
Forum: Databases
Topic: Manipulating a large CSV file (beginner question)
Replies: 9
Views: 9698

Re: Manipulating a large CSV file (beginner question)

Thanks for your response to my question. That helps immensely. I did another look at how my data file is formatted. It is actually a text file (.txt) with a ~ delimiter. I can export the data with a different delimiter but I don't think that will matter. The file consists of records that have a prod...
by will_harrison
Mon May 16, 2011 6:45 pm
Forum: Databases
Topic: Manipulating a large CSV file (beginner question)
Replies: 9
Views: 9698

Manipulating a large CSV file (beginner question)

Hi, I've signed up to the seminar to learn LiveCode for enterprise deployment of iPad applications. My first is an app that allows sales people to search a large price list to create a request for quote with a customer. the database for the pricelist exist as a CSV file of about 160,000 individual p...