LiveCode Forums

I am using a cloud database through Amazon Web Services. I've already checked and had Amazon check their side. They don't show any connectivity issues and I can run it through MySQL Workbench just fine, I just can't get it to run through livecode.

I've been struggling with lost connections on long queries going back to a MySQL database. The database connection is fine (from the database side); internet connection is good, but for some reason Livecode only lets the DB query run for about a minute before it records revdberr,Lost connection to M...

....I figured it out. The lockmessages function was turned to true before the "set dgtext" line which was preventing the line from executing properly. I'm not sure if I'm saying this correctly, but after a few hours of going through each line of code that was the problem. I turned the lockmessages o...

I have similar problems when I try to run queries from MYSQL through livecode using "revExecuteSQL" and "revDataFromQuery". I thought about running the a stored routine as mentioned by zaxos before, but I wasn't sure how to get the information back to livecode once it has run on the database side. I...

I have a data grid named "Delays_List" which I copied from a card where the data input (tab limited information from a database query) fills out the grid. Below is my code, but for some reason it will not work on this card. (I have three data grids in the stack, this is the only one on this card). T...

What I did above didn't work. I'm not familiar with SQLite command line. I will have to research that. Right now my computer is running through a very lengthy line by line import. I'll test the idea on a different machine and see if that works.

@SparkOut Are you referring to the doing something like this?
where the theFilePathIni is a variable containing the selected file name.

@Sparkout You mentioned importing into SQLITE. Let me clarify, I've only had luck inserting 1 line at a time. Is there an import file function like MySQL's LOAD DATA function? If so, that would be handy. I don't have any experience with sqlite and a file that large, but could you try importing to a ...

File was delivered as a CSV. At present I'm going through the file manually and splitting it up into manageable sections of data to import to either SQLITE or MySQL depending on if SQLITE can handle that amount of data on this machine. I would prefer a local database to a remote one as it will make ...

Does HeidiSQL have an advantage over MySQL Workbench for importing these kinds of files? I've tried using the LOAD DATA LOCAL INFILE function to import the file a numerous occasions with no luck.

I am using Amazon RDS for my MySQL Server. I'm not familiar with ssh access. I do not have local access to the server. It is remote. File size roughly 3.5G as perviously noted. I attempted to open the file on the windows portion of my Mac, but it was too large for excel, access, and NotePad. Only Te...

I have a large file 10,000,000+ records roughly 3.5 Gigs. It is in CSV format. I need to import it into a database for analysis, however I can't seem to work with it. The file is too large to copy and paste into excel due to record limitations (without splitting some way). I've tried importing direc...

Since I already had something set up for importing data into a SQLite db, I was hoping to avoid recreating a more sophisticated system for the storage. The initial test data is only a few Megs. Enough just to make sure the import would work. The initial dump is 3.3G. My machine is running 16G of RAM...

There is a button for selecting the file (if I recall correctly, I modeled this after demonstration on the livecode website). on mouseUp answer file "A text file" If it <> "" then put it into theFilePath put URL("file:" & theFilePath) into field "Content" else --no file was selected, or cancel was p...

I've been working on some analytics for a project I'm involved in. I've been using test data up until this point and everything has been working fine. I just received the data for the project and it's pretty large 3.3G in .csv format. I went to start an import into the SQLite database that I set up ...