LiveCode Forums.

I figured it out. Android doesn't support ODBC. I switched from MySQL to SQL server. This works just fine in wondows but not on android which is why I was confused. put revOpenDatabase("ODBC","DRIVER=SQL Server;SERVER=();DATABASE=<>;UID=<>;PWD=<>;Trusted_Connection=<>",,,) into tResult Does anyone k...

Hi all, not sure what I did. Nothing crazy in the code. Have had this app for 5+ years now but needed to point to a new server. As it is hard coded just for personal use I just updated the connection string. Now when I try to re- install it on my device using my device as a test target it seems to t...

bn, that's what I needed. Got it sorted.

My bad.. loop through every line and if anything grouped by item 1 (PL A572-50 3/8) has Plate Processor East in item 14, ensure everything in that group is East. In this example data there is one that is West and needs to be changed to East. Its part of Logic for routing material to the correct mach...

Need a little help with this one, Getting nothing returned. -- Split the lines into an array for easy manipulation split tData3 by return -- Initialize a dictionary to hold grouped lines by item 1 put empty into groupedLines -- Group lines by the first item repeat for each line currentLine in tData3...

I have not done anything with livecode yet, just using MySQL Workbench to get the query working first. I found that same stackoverflow and that's where I started but couldn't get it to work. I get that this may not be the best place for a MySQL question but the community is awesome. Screenshot 2022-...

I also changed it into a LONGBLOB

I tried this, didn't get an error but it doesn't do anything.

Is there a way for me to put a video file into a MySQL BLOB?

Does anyone know if there is a way to do this in livecode? A coworker of mine is super smart with VB and I am not. I need to convert what he is doing in livecode. I attached some screen shots. He is using a dll and classes, I've never done something like this in livecode. does anyone know if there i...

OMG, what a stupid mistake, thank you

I'm trying to keep the selected line after updating a datagrid. put the dgHilitedIndex of group "DataGridCutList" into cutlistLine --Update datagrid set the dgHilitedLines of group "DataGridCutList" to cutlistLine This works great until I sort the datagrid. After sorting and selecting line 1 (visual...

Nice thank you, that looks much cleaner and efficient.

There has to be a better way than this? replace " " with "," in tLine replace " " with "," in tLine replace " " with "," in tLine replace " " with "," in tLine replace " " with "," in tLine replace " " with "," in tLine replace " " with "," in tLine replace " " with "," in tLine replace " " with ","...

Thank you so much, that did the trick.