I've had locate fail on numerous occasions even when locating on single
fields - cured by issuing a first before the locate

-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of Adrian Wreyford
Sent: 14 June 2006 17:49
To: IBObjects@yahoogroups.com
Subject: [IBO] Having problems with syntax for IB_Query.Locate on multiple
fields

Dear List

I have a table TEST with key field composed of two fields: identity and
surname.



I test if the record allready exists before inserting a new record.



I use:



IB_Query.Locate('IDENTITY;SURNAME','1004;FREEZER',[]) then

Edit ..

Else

Insert ..



The record 1004,freezer exists, but the locate does not locate it, and then
when inserting I get obviusly expected error violation of PK.



I know it has something to do with my locate syntax on multiple fields ..
first time I'm trying it on a compound PK.



Any suggestions?



Thanks in advance



Adrian



[Non-text portions of this message have been removed]




___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !
Yahoo! Groups Links






--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.8.4/363 - Release Date: 13/06/2006


--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.8.4/363 - Release Date: 13/06/2006