Radicore Forum: Bug Reports » v 1.35 - Inconsistent SQL files

Home » RADICORE development » Bug Reports » v 1.35 - Inconsistent SQL files (Bug Report)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: v 1.35 - Inconsistent SQL files [message #1322 is a reply to message #1318]

Mon, 28 April 2008 15:12

AJM
Messages: 2382
Registered: April 2006
Location: Surrey, UK

Senior Member

If I do not specify the database name then someone complains, but if I put it in then someone else complains. Some people execute the script without specifying a particlar database name because they assume that the script will automatically switch to the correct database, and then complain that it doesn't work.

As it is not possible to know for certain if you are using a prefix with your database names, so the safest option is to leave out the "USE 'xxx';" statement completely. This will mean that everybody will be responsible for identifying the correct database name before executing each script.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

[Message index]

		v 1.35 - Inconsistent SQL files By: ljkbrost on Mon, 28 April 2008 12:51
		Re: v 1.35 - Inconsistent SQL files By: ljkbrost on Mon, 28 April 2008 13:29
		Re: v 1.35 - Inconsistent SQL files By: ljkbrost on Mon, 28 April 2008 13:39
		Re: v 1.35 - Inconsistent SQL files By: ljkbrost on Mon, 28 April 2008 14:05
		Re: v 1.35 - Inconsistent SQL files By: AJM on Mon, 28 April 2008 15:18
		Re: v 1.35 - Inconsistent SQL files By: AJM on Mon, 28 April 2008 15:12
		Re: v 1.35 - Inconsistent SQL files By: ljkbrost on Thu, 01 May 2008 01:08

Previous Topic:	v1.34 issue with audit_logging and getFieldspec_original
Next Topic:	v 1.35 - Relationship Calculated Field Escaping

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Sep 04 05:20:47 EDT 2025

Total time taken to generate the page: 0.01079 seconds