[DUG] Problem with IDENT_CURRENT and adoquery delphi 6

[Vik Vasudev]

HI Neven

Yeah thats right, But you can fetch the value using
adoquery.fields[0].asstring

well i even tried S*ELECT IDENT_CURRENT(‘Client_Accountdetail’) as
DummyValue   but it dint worked either*

On Tue, Aug 24, 2010 at 4:18 AM, Neven MacEwan <neven at mwk.co.nz> wrote:

>  Vik
>
> just a thought but try giving the column a name as both '*SELECT
> IDENT_CURRENT(‘Client_Accountdetail’)*' and *select max(column name) from
> table *would return un-named columns
>
> HTH
> Neven
>
> Hello everyone,
>
>  Good morning,
>
>  I am facing a small problem while using ident_current feature using
> adoquery.
>
>  with AdoAccountQuery do
> begin
>  close;
> sql.clear;
> sql.text := '*SELECT IDENT_CURRENT(‘Client_Accountdetail’)*'
> open
> end;
>
>  it gives an access violation in open statement.
>
>  I tried this using select max(column name) from table it still gives the
> error
>
>  how ever when i try select * from table it works fine
> I know i may sound dump here but it just not seems to work for me correctly
>
>  regards
> Vik
> --
>
>
> _______________________________________________
> NZ Borland Developers Group - Delphi mailing list
> Post: delphi at delphi.org.nz
> Admin: http://delphi.org.nz/mailman/listinfo/delphi
> Unsubscribe: send an email to delphi-request at delphi.org.nz with Subject: unsubscribe
>
>
>
> _______________________________________________
> NZ Borland Developers Group - Delphi mailing list
> Post: delphi at delphi.org.nz
> Admin: http://delphi.org.nz/mailman/listinfo/delphi
> Unsubscribe: send an email to delphi-request at delphi.org.nz with Subject:
> unsubscribe
>



-- 
  vikas
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserver.123.net.nz/pipermail/delphi/attachments/20100824/cfeafe1e/attachment-0001.html