Looking for small change in mybuilder

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
GEswin
Posts: 186
Joined: Wed 03 Nov 2004 16:57
Location: Spain
Contact:

Looking for small change in mybuilder

Post by GEswin » Wed 30 Mar 2005 22:45

Whenever I do something in mybuilder addon, it generates always the SQL with the database name/table name in front of each field/table. Is there a way to setup so that it generates plain sql without putting the database name / table name in sentences ?

For example

Code: Select all

SELECT
  cibersms.directorio.idnumero,
  cibersms.directorio.nombre,
  cibersms.directorio.movilsms
FROM
  cibersms.directorio
WHERE
  cibersms.directorio.movilsms is not null
would result in:

Code: Select all

SELECT idnumero,nombre,movilsms
FROM directorio
where movilsms is not null
I have many situations where i have a database for each year, this results that SQL produced from MySQLBuilder AddOn has to be reedited everytime. Some setting to make this optional would be great :)

Thx

Guest

Post by Guest » Thu 31 Mar 2005 16:57

I'm also facing this issue.
Could you provide us an "Add Database Name before fields" property ?

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Fri 01 Apr 2005 06:08

We'll consider your suggestion but at the nearest time we are not planning to develop MySQLBuilder.

Post Reply