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 <ne...@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@delphi.org.nz > Admin: http://delphi.org.nz/mailman/listinfo/delphi > Unsubscribe: send an email to delphi-requ...@delphi.org.nz with Subject: > unsubscribe > > > > _______________________________________________ > NZ Borland Developers Group - Delphi mailing list > Post: delphi@delphi.org.nz > Admin: http://delphi.org.nz/mailman/listinfo/delphi > Unsubscribe: send an email to delphi-requ...@delphi.org.nz with Subject: > unsubscribe > -- vikas
_______________________________________________ NZ Borland Developers Group - Delphi mailing list Post: delphi@delphi.org.nz Admin: http://delphi.org.nz/mailman/listinfo/delphi Unsubscribe: send an email to delphi-requ...@delphi.org.nz with Subject: unsubscribe
