Re: Query raises AccesViolation on DesignTime



Sorry
I'm using Delphi 5 with the UpdatePack1 and the AdoUpdate (UpdatePack2)
MS SqlServer 2000

Thanks


"JamesG" <jgarza@xxxxxxxxxx> escribió en el mensaje
news:429b7c83@xxxxxxxxxxxxxxxxxxxxxxxxx
> I try to set the sql propertie in a TADOQuery, and when activate raises an
> AccesViolation and Delphi close.
>
> The error happend because i have some select inside main select, but why
??
>
> Is it an ADO bug ?
> This is the query
>
>
> select
> cve_lar
> ,cve_cta
> ,lin
> ,(select des from invlin where cve=iar.lin)as [LinNom]
> ,s_lin
> ,(select des from invsli where cve=iar.s_lin)as [SliNom]
> ,fam
> ,(select des from invfam where cve=iar.fam)as [FamNom]
> ,s_fam
> ,(select des from invsfa where cve=iar.s_fam)as [SfaNom]
> ,marca
> ,moneda
>
> from inviar iar
> where iar.art='1949'
>
> I'll try to assign the by code on runtime.
>
> thanks
> James G.
>
>


.



Relevant Pages

  • Re: question to Bill Todd and community / ADODB Unit in D7 Enterprise
    ... Delphi 7 Pro and Enterprise. ... is destroying the TADOQuery instance after every use. ... still see memory slowly increasing in preformance monitor. ...
    (borland.public.delphi.database.ado)
  • Re: the dbgrid will be uneditable
    ... only sqlserver tables and the program running in delphi can generate that ... >>if using tadoquery and sql to join two tables,the dbgrid will be ...
    (borland.public.delphi.database.ado)
  • Re: TADOQuery parameter error
    ... Delphi 7, ... I got inconsistent runtime error of parameter not found on some TADOQuery ... I got the compilation error above. ...
    (borland.public.delphi.database.ado)
  • Re: TADOQuery parameter error
    ... Delphi 7, ... I got inconsistent runtime error of parameter not found on some TADOQuery ... I got the compilation error above. ...
    (borland.public.delphi.database.ado)
  • Preventing SQL Injections ?
    ... Does delphi's TADOQuery prevent SQL Injections when using parameters? ... does Delphi check the input from EditGameName.Text when it ... Skybuck. ...
    (borland.public.delphi.database.ado)