[mr slim]

Thanks for the detailed reply, Ritesh. As it turns out, I had done what you suggest. So it must be that some of my information is wrong. Maybe the SQL server is, as you suggest, at a different IP address than the SSH host server. This is a virtual server account. Though, for what it's worth, the mysql command line is available from a subdirectory of the home directory I log into.

I don't have access to the hosting account, but I'll try to get it and see what I can find out.

Thanks again for the thoughtful response.

[mr slim]

Thanks for the clarification, shadow.

[mr slim]

Quote:

SQLyog's insert/update window does not allow functions to be used, but it's an admin tool rather than an end-user-data-entry tool.

Webyog may choose to change this characteristic or not, but I wouldn't be so quick to rationalize it away with semantics. I'm very pleased with this product, intend to continue to use it and look forward to seeing its future development. But this is a shortcoming, not a strength, regardless of what adjective one chooses to say what kind of tool it is.

I hadn't realized that MySQL doesn't take functions as a default. Thanks, shadow, for pointing that out. No reason why SQLyog must do what the database doesn't (though having a useful feature never hurts), but in the case of a function in the insert/update window, it fails to execute something that the database supports. I think it would be a realistic and welcome addition for at least that much to be supported.

Again, I say this constructively as a happy user.

[mr slim]

I'm wondering the same thing. It doesn't seem to take a MySQL function even when entered in a field in the F8 or F11 insert data windows. I see in the history window that when I use the NOW() function in a field in an insert/update data window, that SQLyog puts the function in quotes. For example assuming the field 'theDate' has a datatype of datetime:

insert into `abc`.`test` ( `the_id`, `name`, `theDate` ) values ( NULL, 'abc', 'NOW()' )

Since the function is seen as a string, it does nothing. If I copy and paste the the SQL line into the SQL window and remove the quotes from the function:

insert into `abc`.`test` ( `the_id`, `name`, `theDate` ) values ( NULL, 'abc', NOW() )

the NOW() function is executed and the date is inserted into the relevant field as it should be. But it would be nice to know how to or to be able to do this from within the insert data windows themselves. And also to set default values based on functions, as Lance wants to do.

[mr slim]

Turns out I had a release candidate where this problem occurred. The official 3.63 release is fine and the wizard works as it should.

Thanks for the help.

[mr slim]

target version:

mysql Ver 12.22 Distrib 4.0.16, for Win95/Win98 (i32)

source version:

4.0.15-standard

source server: Apache/1.3.29 (Unix)

[mr slim]

Upon exectuing the command from the command line, the following prints to the console:

SQLyog Job Agent Version 1.2

Copyright © Webyog. All Rights Reserved.

Sync started at Sat Nov 29 00:24:15 2003

Then the sja crashes and no more happens. Running from the command line with 3.63 RC1, there is no problem and all prints to the screen as it should.

Excuse the discrepancy in my posts. Before I said that nothing happened at all. It likely crashed then, too.

I'm running Win XP Pro SP1

[mr slim]

I will do that as soon as I can, probably sometime within the next 24 hours and get back to you here.

[mr slim]

I'll email a small db I created that crashes on my machine, Ritesh. It's not the same one I was working with, but it crashes just the same.

[Author]

Posts