Search found 30 matches

by Steve
Mon Aug 21, 2017 4:53 pm
Forum: Databases
Topic: copying between databases
Replies: 10
Views: 2391

Re: copying between databases

Terrific ... thanks much.

Sincerely,

Steve Alessi
by Steve
Sat Aug 12, 2017 3:18 pm
Forum: Databases
Topic: copying between databases
Replies: 10
Views: 2391

Re: copying between databases

Structure and content.

Steve
by Steve
Fri Aug 11, 2017 8:50 pm
Forum: Databases
Topic: copying between databases
Replies: 10
Views: 2391

Re: copying between databases

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
by Steve
Fri Aug 11, 2017 4:41 pm
Forum: Databases
Topic: copying between databases
Replies: 10
Views: 2391

Re: copying between databases

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
by Steve
Thu Aug 10, 2017 5:02 pm
Forum: Databases
Topic: copying between databases
Replies: 10
Views: 2391

Re: copying between databases

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 ...
by Steve
Thu Aug 10, 2017 2:40 am
Forum: Databases
Topic: copying between databases
Replies: 10
Views: 2391

copying between databases

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...
by Steve
Tue Jun 23, 2015 9:16 am
Forum: Rich Media
Topic: player not working in windows
Replies: 15
Views: 4074

Re: player not working in windows

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...
by Steve
Mon Jun 22, 2015 1:17 pm
Forum: Rich Media
Topic: player not working in windows
Replies: 15
Views: 4074

Re: player not working in windows

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
by Steve
Mon Jun 22, 2015 8:00 am
Forum: Rich Media
Topic: player not working in windows
Replies: 15
Views: 4074

Re: player not working in windows

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.
by Steve
Sun Jun 21, 2015 9:45 pm
Forum: Rich Media
Topic: player not working in windows
Replies: 15
Views: 4074

player not working in windows

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...
by Steve
Fri Jun 13, 2014 2:35 pm
Forum: Databases
Topic: simultaneous multiple database access
Replies: 6
Views: 1778

Thanks very much

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,...
by Steve
Wed Jun 11, 2014 6:07 pm
Forum: Databases
Topic: simultaneous multiple database access
Replies: 6
Views: 1778

Re: simultaneous multiple database access

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...
by Steve
Mon Jun 09, 2014 2:42 pm
Forum: Databases
Topic: simultaneous multiple database access
Replies: 6
Views: 1778

Re: simultaneous multiple database access

Terrific! Can you give me a brief LiveCode example?

Thanks,

Steve Alessi
by Steve
Mon Jun 09, 2014 9:25 am
Forum: Databases
Topic: simultaneous multiple database access
Replies: 6
Views: 1778

simultaneous multiple database access

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 ...
by Steve
Tue Sep 03, 2013 5:26 pm
Forum: CGIs and the Server
Topic: special fonts with server delivery of stacks
Replies: 0
Views: 1182

special fonts with server delivery of stacks

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...

Go to advanced search