Devart Forums

pimentel_flores

Hello, There is a post from 2008 regarding the same issue http://forums.devart.com/viewtopic.php?f=28&t=13020

I'm running Unidac 4.6.12 For Delphi 2007

Everytime i do a uniquery.execute i see the below query being executed, and it is logged by mysql as an non optimal query, how to fix this, i need my app to run faster and seems that this query is causing performance issues.

also my tuniquerys cannot be static, they change the sql.text property on the fly so everytime they call different tables so i cannot set the keyfields static

# Query_time: 0.000588 Lock_time: 0.000149 Rows_sent: 0 Rows_examined: 422
SELECT cast('' as char(1)) TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, ORDINAL_POSITION POSITION, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH DATA_LENGTH, NUMERIC_PRECISION DATA_PRECISION, NUMERIC_SCALE DATA_SCALE, (case IS_NULLABLE when 'YES' then 1 else 0 end) NULLABLE, COLUMN_DEFAULT DEFAULT_VALUE FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'mq_gpojamco' AND TABLE_NAME = 'TABLENAME' ORDER BY TABLE_SCHEMA, TABLE_NAME, ORDINAL_POSITION;
# Query_time: 0.000588 Lock_time: 0.000149 Rows_sent: 0 Rows_examined: 422

pimentel_flores

Plash wrote:We'll fix this problem in the next build of UniDAC.

Hello. Did you fix this problem?
I'm running Unidac 4.6.12 For Delphi 2007

everytime i do a uniquery.execute i see the below query being executed, and it is logged by mysql as an non optimal query, how to fix this, i need my app to run faster and seems that this query is causing performance issues.

also my tuniquerys cannot be static, they change the sql.text property on the fly so everytime they call different tables so i cannot set the keyfields static

SELECT cast('' as char(1)) TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, ORDINAL_POSITION POSITION, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH DATA_LENGTH, NUMERIC_PRECISION DATA_PRECISION, NUMERIC_SCALE DATA_SCALE, (case IS_NULLABLE when 'YES' then 1 else 0 end) NULLABLE, COLUMN_DEFAULT DEFAULT_VALUE FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'mq_gpojamco' AND TABLE_NAME = 'TABLENAME' ORDER BY TABLE_SCHEMA, TABLE_NAME, ORDINAL_POSITION;
# Query_time: 0.000588 Lock_time: 0.000149 Rows_sent: 0 Rows_examined: 422

pimentel_flores

Hi, I upgrade my unidac version to the lastest, now the error message doesnt appear anymore,

i will put this new version in production and see how does this behave in full service. will let you know

pimentel_flores

Sorry for being late on replying,
I was assigned to other project but now will get back on this issue.

so far i think the issue is the refreshrecord call, i think this cannot be called after the commit.

will try removing this and will let you know

Code: Select all

               
uniquery.ApplyUpdates; 
uniquery.CommitUpdates; 
[b]uniquery.RefreshRecord;[/b]

pimentel_flores

Hi Unidac Team,

I just downloaded and installed the new 4.1.4 version of the unidac
and now my project is showing this kind of errors

Access violation at address 0062BAAB in module 'Project.exe'. Read of address 00000016

and

AddRefStr failed
(D:\Projects\Delphi\Dac\Common\Source\MemData.pas, line 7952)

and also this piece of code is not working anymore, it throws erros and cannot save information to my tables

Code: Select all

 
               uniquery.ApplyUpdates;
               uniquery.CommitUpdates;
               uniquery.RefreshRecord;

im using delphi 2007, unidac 4.1.4 with connection to mysql 5.1

pimentel_flores

Oh.. then how can i do a walk-around of this? i mean.. while you include this feature what can i do to implement this or something similar?

any sample?

thanks.

also do you have any possible date when this will be included?

Thanks

pimentel_flores

Hi team. is CustomConstraint property from Tfield supported in unidac?

Right now it is a very important property i need to migrate an old system to use unidac and mysql

If this feature is not supported yet please let me know when we can expect this, hope this will not take a long time.. it is really very important.

Thanks.

pimentel_flores

Hi Team.
Im using linux ubuntu 10 and mysql 5.5 all my table names are in lowercase

when using a master/detail there is a problem when establishing master field and detail field

Master Table : mtable
Master Field : id

detail Table : dtable
detail field : id

relation id = id

but when running on linux the query result from devart is MTABLE.ID = DTABLE.ID

i mean it makes it uppercase and then as you know in linux the tablename is case sensitive and so it throws an error saying that the MTABLE doesnt exist.

is there any way to solve this, is there any configurable parameter?

using the property SQLFilter doesnt work for me because using this there is no automatic asignation of the master value to the detail value.

pimentel_flores

hi Devart Team.

Im using unidac 2.70.0.11 for RAD STUDIO 2007 and mysql 5
and i have this issue, when executing the below insturuction

Code: Select all

insert into constructord (oid,va,vb) values ('xx','yyy',"  NEW ' ROOT ") ;

i get this error

Code: Select all

#42S22Unknown column 'new ' ROOT' in 'field list'

in the past i use to use the same rutine in and old version of your mysql vcl product without any issue,

is there a way to configure the unidac components to recognize the (") double quotes as string and not a column?,

im sure the error is rised by unidac because when i run the same command from the mysql console it runs without any problem
[/code]

pimentel_flores

Hi devart Team.

I had to reinstall all my dev environment but when trying to run my project using devart components i got the folowin message

Current DBMonitor version is out of date. Please update.

im using the version 2.70.0.11 on Rad Studio 2007
the version of dbmonitor is 3.0.3
and in the about window i see the line

DBMonitor -- not available.

how can i fix this??

the below is the information from delphi

Code: Select all

---------------------------
Error
---------------------------
Current DBMonitor version is out of date. Please update.
---------------------------
OK   Details <<   
---------------------------
[0865F0CF]{dac105.bpl  } Dbmonitorclient.GetDBMonitor + $47
[086617BD]{dac105.bpl  } Dasqlmonitor.TCustomDASQLMonitor.SetActive + $6D
[0865F659]{dac105.bpl  } Dasqlmonitor.TCustomDASQLMonitor + $51
[087C66DE]{unidac105.bpl} Unisqlmonitor.TUniSQLMonitor + $16
[21699533]{delphicoreide100.bpl} CompPalMgr.TComponentPalettePageItemDelegate.CreateComponent (Line 2482, "CompPalMgr.pas" + 2) + $7
[20D9613D]{designide100.bpl} ComponentDesigner.TComponentRoot.DoCreateComponent (Line 2308, "ComponentDesigner.pas" + 10) + $17
[20003DC4]{rtl100.bpl  } System.@FreeMem (Line 2699, "sys\system.pas" + 2) + $0
[20007A19]{rtl100.bpl  } System.@LStrArrayClr (Line 12266, "sys\system.pas" + 16) + $0
[2001DBE5]{rtl100.bpl  } Variants.@VarClr (Line 759, "sys\variants.pas" + 1) + $0
[20E497AA]{vclide100.bpl} IDERegIniPropSet.TRegistryPropSet.GetFieldData (Line 178, "IDERegIniPropSet.pas" + 41) + $8E
[2001DB63]{rtl100.bpl  } Variants.VarClearDeep (Line 715, "sys\variants.pas" + 3) + $1
[2001DB68]{rtl100.bpl  } Variants.VarClearDeep (Line 715, "sys\variants.pas" + 3) + $6
[2001DBDD]{rtl100.bpl  } Variants.@VarClear (Line 753, "sys\variants.pas" + 3) + $0
[2001DBE5]{rtl100.bpl  } Variants.@VarClr (Line 759, "sys\variants.pas" + 1) + $0
[20008BF1]{rtl100.bpl  } System.@VarClr (Line 15064, "sys\system.pas" + 1) + $0
[20008C7C]{rtl100.bpl  } System.@FinalizeArray (Line 15196, "sys\system.pas" + 62) + $0
[2171F3C6]{delphicoreide100.bpl} PasCppCmds.TDesignEnvironment.GetDesignerOptions (Line 566, "PasCppCmds.pas" + 14) + $1E
[2002F61E]{rtl100.bpl  } Classes.Rect (Line 1761, "common\Classes.pas" + 1) + $E
[20D9F326]{designide100.bpl} ComponentDesigner.TComponentRoot.CreateComponentPos (Line 5813, "ComponentDesigner.pas" + 26) + $22
[211DE97E]{vcldesigner100.bpl} VCLSurface.TVCLDesignerOleDropTarget.DropComponentStream (Line 4971, "vclsurface.pas" + 17) + $25
[211DE0CD]{vcldesigner100.bpl} VCLSurface.TVCLDesignerOleDropTarget.Drop (Line 4794, "vclsurface.pas" + 7) + $17
[211DE1F2]{vcldesigner100.bpl} VCLSurface.TVCLDesignerOleDropTarget.Drop (Line 4813, "vclsurface.pas" + 26) + $17
[20AC40FA]{coreide100.bpl} ToolFrm.TToolForm.BeginOleDrag (Line 1993, "ToolFrm.pas" + 47) + $2B
[20AC429D]{coreide100.bpl} ToolFrm.TToolForm.PaletteBeginDrag (Line 2028, "ToolFrm.pas" + 2) + $0
[20E963EA]{vclide100.bpl} IDECategoryButtons.TIDECategoryButtons.DoBeginDrag (Line 104, "idecategorybuttons.pas" + 3) + $A
[520B3DE5]{idectrls100.bpl} IDEWideCategoryButtons.TWideCategoryButtons.MouseMove (Line 1616, "IDEWideCategoryButtons.pas" + 24) + $9
[200069A8]{rtl100.bpl  } System.@CallDynaInst (Line 9162, "sys\system.pas" + 3) + $0
[2013BAA6]{vcl100.bpl  } Controls.TControl.WMMouseMove (Line 5343, "Controls.pas" + 8) + $1A
[20006A3F]{rtl100.bpl  } System.TObject.Dispatch (Line 9284, "sys\system.pas" + 8) + $0
[2013B20B]{vcl100.bpl  } Controls.TControl.WndProc (Line 5146, "Controls.pas" + 83) + $6
[2013EDEF]{vcl100.bpl  } Controls.TWinControl.IsControlMouseMsg (Line 7168, "Controls.pas" + 1) + $9
[2013631E]{vcl100.bpl  } Controls.FindControl (Line 2104, "Controls.pas" + 6) + $9
[2013F38A]{vcl100.bpl  } Controls.TWinControl.WndProc (Line 7304, "Controls.pas" + 111) + $6
[2013EAB4]{vcl100.bpl  } Controls.TWinControl.MainWndProc (Line 7073, "Controls.pas" + 3) + $6
[20040DD4]{rtl100.bpl  } Classes.StdWndProc (Line 11583, "common\Classes.pas" + 8) + $0
[20AC1F86]{coreide100.bpl} ToolFrm.TToolForm.PaletteHook (Line 1061, "ToolFrm.pas" + 19) + $1E
[20040DD4]{rtl100.bpl  } Classes.StdWndProc (Line 11583, "common\Classes.pas" + 8) + $0
[201D0259]{vcl100.bpl  } AppEvnts.TCustomApplicationEvents.DoMessage (Line 221, "appevnts.pas" + 1) + $C
[201611EC]{vcl100.bpl  } Forms.TApplication.ProcessMessage (Line 8102, "Forms.pas" + 23) + $1
[20161226]{vcl100.bpl  } Forms.TApplication.HandleMessage (Line 8121, "Forms.pas" + 1) + $4
[20161537]{vcl100.bpl  } Forms.TApplication.Run (Line 8219, "Forms.pas" + 20) + $3
[0042298E]{bds.exe     } bds.bds (Line 196, "" + 7) + $7

pimentel_flores

Hi Devart Team.
i have been thinking in how to make my application truly database independent over the dbms that already unidac support.
i have read the info about the unified sql structure and macros, but here is my question.
What about the stored procedure (and also functions and triggers etc..)?
as you know the stored procedures sintaxis between the dbms are different, does the unidac provides a common sintaxis to parse over the distinct data bases? i mean like the {fn } {oj } {if } {else} functions that arleady exists?
maybe something like

Code: Select all

{fn create procedure} spDemo {inv vID varchar(10)},{inv vMov varchar(100
{sp begin}
{declare vResult varchar(100)}

{set vResult} = select xresutl from demot where id = {vid} and mov= {vmov}

{sp end}

and when parsing to mysql could be like

Code: Select all

create procedure spDemo (vID varchar(10),vmov varchar(100))
begin
declare vResult varchar(100);
set vResult = select xresutl from demot where id = vid and mov= vmov
end/

And when parsing to SQL Server

Code: Select all

Create procedure spDemo 
@vID varchar(10),
@vmov Varchar(100).
As 
Begin
declare @vResult varchar(100),

select @vResult = xresutl from demot where id = @vid and mov= @vmov

end
GO

and so on with the other dbms

i hope to be clear,
Please suggest

pimentel_flores

It could be great if you support DB2 since the big firms like banks uses this DBMS,

pimentel_flores

As you might know Embarcadero has release the new version of delphi (2009), and it is already available for purcharse, so my question is, ¿Do you have plans to release the DAC support for this new version, if you do, when it will be ready for download?

Thanks and regards
Octavio

pimentel_flores

Hi i have this problem too, did you find the solution?

pimentel_flores

Hi, I'm very happy with the new release of the unidac, when do you plan to release the first stable version and do you have an idea of the price of this unidac?

will you have promotions for your customers to change to this version?

Thanks

Octavio..
www.x-symbian.com
Mexico.

Devart Forums

Search found 31 matches

TUniquery performing Index querys in every execution

Re:

Not able to replicate

Hi Devart Team

New Unidac 4.1.4 has serious bugs in table commit

Walkaround

CustomConstraint

Problem with Table names in lower case using LINUX

use of double quotes in UNIDAC mysql script

Current DBMonitor version is out of date. Please update.

UNIDAC and stored procedures

DB2

DAC Support for Delphi 2009

i have the same problem

First Stable release