LiveCode Forums

After doing some thinking about it I wonder if I have to allow the document to be opened up in a wordprocessing program instead of a field in order to keep its formatting....

Ok...I have been reading all the posts regarding submitting binary data to a blob field in a SQL database, and from what I can tell, I have been able to add binary data. The issue I am having, I think, is retrieving the original formatting of the binary data (font, color etc) when the data is being ...

im an idiot

hey guys sorry for the long delay but the forums were messed up on my end for a day....wouldn't allow me to log in....seems to be fixed now...anyhow, here is the crash log compressed the CORRECT way!

Well I guess If I was to have hundreds of thousands of records to query it could cause some latency issues with the program though...seeing that I am only going to have a few dozen messages at best at one time, querying the DB shouldn't be an issue...but I like your idea....

I'm going to give that a try....I'll let you know how it goes....thanks as always Simon

Simon...so you are saying that instead of checking the DB itself, I would be checking a txt file on the server instead? And then if the time is different in the text file on the server vs the local copy of the txt file held on the users system, THEN it would query the DB with the messages? Now about...

Hey! I just give what I get!

Ok I decided to go with the send in time option and all is working as expected. BUT there is a major crash when I attempt to query the DB using my home internet connection. I have no problems querying the DB using another internet connection, but when I connect with my home connection it crashes the...

Yes you are correct...The receiving nodes are checking for new messages over a given time period....much like a push for new messages on IOS....The send in time command is the next thing I am going to check out...I appreciate the link...Im going to check it out now...and thank you for the code...

Hi gentlemen....Thanks for taking the time to help....TRIGGERS! It is so funny you suggested using a trigger because right before I went to bed last night, I thought about triggers and looked it up online to see what they were....(I'm still learning about SQL obviously). I will give that a shot toda...

What is the best method for querying a db in a repeated time frame to check for changes in the tables? Currently I use a loop to query the database but it seems to hang and crash my program often. I just want to periodically check for changes while the program runs. I use a MySQL db on go daddy.com ...

Sorry for not responding quickly but been working....I actually figured out it was my router screwing things up...I haven't investigated why yet, but I'm going to work on it this week. I tried another internet connection and found all was working as expected...thanks for all the help! U guys rock!

now you know how I feel!!!! :P Well I am not having any luck here...I was able to connect to the server before they moved to Plex....I contacted support and told them what I was attempting and they said all should be good....just use the address along with the port number and I would be good to go.....

Hey Klaus....Yeah goDaddy has always allowed direct connect as far as I know...I changed the case and still no luck...I was wondering though....does LC support database types InnoDB and MyISAM? These are they types of DB I am using....