[Ritesh]

We plan to make SQLyog multilingual in v4.3. Work on v4.3 will start in another 2 weeks (after we release v4.2).

[Ritesh]

Visual Query Builder and ER Diagramming tool are in our TO-DO list – the first beta with these features are expected in the first quarter of 2006

[Ritesh]

peterlaursen wrote on Sep 17 2005, 07:52 AM:

There is a problems with strings.  Does an empty cell mean NULL or empty string? 

It means empty string. You have to explicitely specify NULL if you want to put NULL value in a field.

[Ritesh]

This was never fixed 🙁

We dont consider any function/keyword in Insert/Update tab. We always generate simple quoted ' statement to insert value into the table.

[Ritesh]

Once this issue gets resolved, we need to put it in the FAQs 😀

[Ritesh]

As an addition, I would like to say that this option is not available in Create/Alter Table dialog of SQLyog. Currently, we dont support inbuilt MySQL functions for default value.

Maybe, I should put it in the TO-DO list of SQLyog <_<

[Ritesh]

Google language tool says:

“In the SQL Server I use the function getdate() in “defalt value” to return the current date and to define it as value standard of a field dates. How to make in the MySQL/SQLYog?”

I think he requires the MySQL function: date()

[Ritesh]

Can somebody tell me which language is that?

I used Google Language tool to convert the text from Spanish to English but it did not return any human understandable result (atleast to me).

[Ritesh]

Can we get temporary access to the Sybase database?

[Ritesh]

SQLyog uses Windows built-in Task Scheduler. For that matter you can use any 3rd party scheduler too.

BTW, can you provide us with screenshots so that we can exactly pinpoint the error?

[Ritesh]

I guess you are using HTTP Tunneling. If the data is not confidential then can you send me a backup of the table in concern?

BTW, which version of MySQL is being run at your host? You can get the version info by executing the query:

Code:

select version()

[Ritesh]

Are you able to extract data correctly using another ODBC application like Excel, MS Access? Basically, I want to know whether it is an issue with your ODBC driver.

[Ritesh]

sdozono wrote on Sep 13 2005, 03:17 AM:

[DATASYNC]

TgtPwd= ** ORIGINAL PASSWORD **

Do you have any reason for this?

Thanks in advance!

🙄

[post=”7141″]<{POST_SNAPBACK}>[/post]

Bug confirmed and fixed in v4.2 BETA 2 development tree.

[Ritesh]

peterlaursen wrote on Sep 13 2005, 12:37 PM:

And here comes a question that is also security related.

When SJA is running from a NT-based Client (NT, 2K or XP), I think there is no need that any user should be logged on.  The scheduler is a service in the OS, and runs even if no user is logged on.  The scheduled job must then run with “System” privileges.  In that case the computer executing SJA must be turned on and just showing the logon screen.  That is similar to the normal use of computers having Network Admin Software installed.  You log out when you leave it!

Anybody tried that with the SJA?

I can research on it myself, but no need to if anybody knows the answer allready!

[post=”7146″]<{POST_SNAPBACK}>[/post]

Using Windows Task scheduler, you can set all of these options. Once SQLyog creates the task you can configure the options that you want 😀

[Ritesh]

peterlaursen wrote on Sep 13 2005, 11:35 AM:

This reminds me …

There is an old user request pending that it should be an option NOT to fetch the password into Connections Manager.  When more people use the same PC it is not much help that PWs are encrypted in the .ini file as long as anybody just can run the SQLyog program and choose a connection from the drop-down box.

[post=”7145″]<{POST_SNAPBACK}>[/post]

This is already in the TO-DO list of SQLyog. We plan to fix it in v4.4 or v4.5.

[Author]

Posts