[DUG] Problem with IDENT_CURRENT and adoquery delphi 6

[Neven MacEwan]

  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

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