Help - Search - Members - Calendar
Full Version: Set To Null/default Grayed Out?
Webyog Forums > SQLyog > Using SQLyog
mhirons
In both the Result and Table Data tabs, the right-click options Set to NULL and Set to Default are grayed out. I have verified that the fields support NULL/Default values. I can set the value to NULL with a simple sql statement, update table set field = NULL where uid = x.

I have an old version of SQLyog (5.21) installed on another computer and the Set to NULL/Default options work just fine.

Is this just a setting on my machine that I've unintentionally changed? Or was this feature accidentally removed? Or was it intentionally removed?

Using SQLyog 6.52 on WinXP

Thanks,
Matt
peterlaursen
'smart keywords/functions/defaults handling' must be enabled in 'preferences'.

If you set to NULL from the context menu of a cell the string "(NULL)" will simply by inserted in the grid. And if 'smart keywords/functions/defaults handling' is disabled what would insert the literal string '(NULL)' and not NULL. That is the reason that we 'grey out' if 'smart keywords/functions/defaults handling' is OFF.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2008 Invision Power Services, Inc.