Terrific ... thanks much.
Sincerely,
Steve Alessi
Search found 30 matches
- Mon Aug 21, 2017 4:53 pm
- Forum: Databases
- Topic: copying between databases
- Replies: 10
- Views: 8275
- Sat Aug 12, 2017 3:18 pm
- Forum: Databases
- Topic: copying between databases
- Replies: 10
- Views: 8275
Re: copying between databases
Structure and content.
Steve
Steve
- Fri Aug 11, 2017 8:50 pm
- Forum: Databases
- Topic: copying between databases
- Replies: 10
- Views: 8275
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
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
- Fri Aug 11, 2017 4:41 pm
- Forum: Databases
- Topic: copying between databases
- Replies: 10
- Views: 8275
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
- Thu Aug 10, 2017 5:02 pm
- Forum: Databases
- Topic: copying between databases
- Replies: 10
- Views: 8275
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 ...
- Thu Aug 10, 2017 2:40 am
- Forum: Databases
- Topic: copying between databases
- Replies: 10
- Views: 8275
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...
- Tue Jun 23, 2015 9:16 am
- Forum: Multimedia
- Topic: player not working in windows
- Replies: 15
- Views: 11453
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...
- Mon Jun 22, 2015 1:17 pm
- Forum: Multimedia
- Topic: player not working in windows
- Replies: 15
- Views: 11453
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
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
- Mon Jun 22, 2015 8:00 am
- Forum: Multimedia
- Topic: player not working in windows
- Replies: 15
- Views: 11453
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.
Thanks. Generally I have dontuseqt set to FALSE. I just pointed out that I had tried "true" and it made no difference.
Steve A.
- Sun Jun 21, 2015 9:45 pm
- Forum: Multimedia
- Topic: player not working in windows
- Replies: 15
- Views: 11453
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...
- Fri Jun 13, 2014 2:35 pm
- Forum: Databases
- Topic: simultaneous multiple database access
- Replies: 6
- Views: 5459
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,...
- Wed Jun 11, 2014 6:07 pm
- Forum: Databases
- Topic: simultaneous multiple database access
- Replies: 6
- Views: 5459
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...
- Mon Jun 09, 2014 2:42 pm
- Forum: Databases
- Topic: simultaneous multiple database access
- Replies: 6
- Views: 5459
Re: simultaneous multiple database access
Terrific! Can you give me a brief LiveCode example?
Thanks,
Steve Alessi
Thanks,
Steve Alessi
- Mon Jun 09, 2014 9:25 am
- Forum: Databases
- Topic: simultaneous multiple database access
- Replies: 6
- Views: 5459
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 ...
- Tue Sep 03, 2013 5:26 pm
- Forum: CGIs and the Server
- Topic: special fonts with server delivery of stacks
- Replies: 0
- Views: 2482
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...