LiveCode Forums

Terrific ... thanks much.

Sincerely,

Steve Alessi

Structure and content.

Steve

Hi Ghettocottage!

The "same server" copying, which MaxV helped me with, is a regular thing, for doing backups. Copying to a different server is an occasional thing, when setting up a new user who has a different server. I will try your solution for that.

Thanks,

Steve Alessi

Hi again MaxV, Thanks very much. Yes, that works great for me, when both databases are on the server. But sometimes I'm working with databases on different servers. I guess in that situation I'll have to use export and import with phpMyAdmin. Thanks very much for your help. Sincerely, Steve Alessi

Hi MaxV, I’m still a little uncertain about what syntax worked for you. Let’s say I have two databases: “database1” with ID number 1 and “database2” with ID number 2, and the table name is the same, “tablename”, in each database, I try this: revExecuteSQL 1 , “INSERT INTO database2.tablename SELECT ...

Hi Everyone, I need to copy a MySQL database table from one database to another database. Because LiveCode's revExecuteSQL command uses a database ID number and allows just ONE database ID number, as in the following syntax: revExecuteSQL DatabaseID, "QueryString" I cannot see any way to copy a tabl...

Greetings, Yes, it is beginning to look like it is the Codec that causes the player to fail. Even though the same Codec works on some cards and not others, when I use a more standard and less compressed Codec, the players work on all cards. The "offending" codec is one intended for mobile devices. T...

Hi Klaus,

Yes, QuickTime is installed on the Windows computers. And per your previous question, the audio files are all .wav files. But as I pointed out earlier, they DO work about half the time. It is an oddly intermittent (though consistent) problem.

Sincerely,

Steve

Hi Klaus,

Thanks. Generally I have dontuseqt set to FALSE. I just pointed out that I had tried "true" and it made no difference.

Steve A.

Greetings everyone, I'm struggling with a strange audio player problem. I'm running LiveCode files from a server. So I have an application (.app for Macintosh, .exe for Windows) that goes to source code stack on a server. I'm working in LiveCode 6.7.5. I cannot use versions 7 or 8 because of changes...

Hi Splash21, Thanks very much! That worked for me inside a revExecuteSQL command. I guess I should have tried it, because it is standard mySQL syntax. But because the revExecuteSQL command refers to a database connection number, I assumed you could only operate on one database at a time. Apparently,...

Hi Splash21, Sorry ... I was not clear in my question. I know how to grant permissions. What I don't know how to do is refer to two databases in one statement. For example, in MySQL you can do this: CREATE TABLE database1.newtable LIKE database2.oldtable -- which refers to two different databases IN...

Terrific! Can you give me a brief LiveCode example?

Thanks,

Steve Alessi

MySQL allows you to copy a table from one database to another with this type of format: CREATE TABLE database1.newtable LIKE database2.oldtable INSERT database1.newtable SELECT * FROM database2.oldtable The syntax database.table allows one to specify a table of a particular database, so you can use ...

I have programs using special foreign language fonts (e.g., Turkish) that work fine when published for Windows (i.e., a standalone is created) ... but when I put the source code on a server (in order to "go to" the program from another Windows standalone) the special foreign language fonts appear to...