Postgresql locate

[lao]

Hi,
i have a problem with postgresql and unidac.
this is the script for create table:
CREATE TABLE mytableone
(
datetimes timestamp without time zone NOT NULL,
codemodule character varying(150) NOT NULL,
CONSTRAINT pk_date_module PRIMARY KEY (datetimes, codemodule)
)
WITH (
OIDS=FALSE
);
ALTER TABLE mytableone
OWNER TO postgres;

insert into mytableone values('06/15/2011 02:28:47 AM','GC_Injector_HP_5890_3240G19047-B');
insert into mytableone values('06/27/2011 01:51:33 PM','GC_Injector_HP_5890_3240G19047-B');

and i try to execute this code:
uniquery1.close;
uniquery1.IndexFieldNames:='datetimes,codemodule';
uniquery1.Open;
if not uniquery1.Locateex('datetimes;codemodule', VarArrayOf([('06/15/2011 02:28:47 AM'), 'GC_Injector_HP_5890_3240G19047-B']), [])
then showmessage('first one not found');
if not uniquery1.Locateex('datetimes;codemodule', VarArrayOf([('06/27/2011 01:51:33 PM'), 'GC_Injector_HP_5890_3240G19047-B']), []) then showmessage('second one not found');


i have a message 'first one not found';
if uniquery1.IndexFieldNames:=''
no problem

my regional options for dates is : MM/dd/yyyy
and for time: hh:mm:ss
i try with unidac 5.1 and 5.2 and delphi 2007
i try with locate and locateex.
i try with interbase no problem.
regards,
sorry for my english...
Lao

[AlexP]

Hello,

Thank you for the information. We have reproduced the problem and will investigate the reasons for such behaviour.

[lao]

hi,
i think the problem apear when we have 2 fields in the key and the last field have more than 1 identical value.
I need to use that in production, please when you found the solution, can you explain me what i need to change( i have the sources of undidac).
Thanks
Regards,

[lao]

Hi,
Happy new year...
Have you some news for this problem?
Regards

[AlexP]

Hello,

We will fix the problem till the next release

[lao]

Hi,
Do you have any date for the next release?
Regards,

[AlexP]

Hello,

We plan to release the new version next month.

[stlcours]

Hi, Alex

Can you see my question:
http://forums.devart.com/viewtopic.php?f=28&t=28653

Thanks very much!!

[AlexP]

Hello,

I have answered you in http://forums.devart.com/viewtopic.php?f=28&t=28653

[lao]

Hi,
Did locate problem has been solved?
if yes, please can you send me the correction to apply to my unidac src?
We need to implement this very quickly.
Thanks

[AlexP]

We have fixed the problem. I can send you the fixed method by e-mail. Please specify an e-mail to which I can send the modifications

[lao]

Hi Alexp
thank you for your response.
you can send me the method at:
[email protected]
regards,

[AlexP]

We have added quite a lot of changes, therefore send your license number to alexp*devart*com - and I will send you a fixed version

[lao]

Hi AlexP,
i send you my license number,
thanks

[AlexP]

I have sent you a letter with the fixed version.