Advertisement

1 - 10 of 43 containing alltags:("tadoquery") (0 seconds)
Hi, ADOPwdQuery.FieldByName('Name').AsString if i try this it returns the field but with a lot of space after the name it returns exactly the amount of charecters in the field - name. so my...
Zones: Delphi ProgrammingDate Answered: 07/04/2000 Grade: B Views: 0
I write a class inherit from TAdoQuery. In this class, I add a property to TAdoQuery's parameters object, but this property is cann't show in Object inspector,why?????
Zones: Delphi Programming, ...Date Answered: 12/24/2003 Grade: A Views: 0
what is the syntax of checking if the current queryfield  is an integer, double, a string or a Date/time? I use an MSAccess database pseudocode: for i := 0 to FieldCountForMyQuery if Query.f...
Zones: Delphi ProgrammingDate Answered: 01/27/2004 Grade: A Views: 0
hi, i'm using delphi5, connecting to MS SQL Server 2000. when i set my TADOQuery to CursorLocation=clUseServer, CursorType=ctDynamic i can make a very fast query that represents a huge number...
Zones: Delphi ProgrammingDate Answered: 06/06/2006 Grade: C Views: 0
hi i have a problem with TADOQuery, i made a Query in my form like this : var SQuery:TADOQuery;      SDataSource;TDataSource; begin   SQuery:=TADOQuery.create(nil);   SQuery.connection:=my...
Zones: Delphi ProgrammingDate Answered: 06/19/2006 Grade: A Views: 0
Hi there, I got this statement SELECT * FROM sites WHERE stitle LIKE %:S0% but when I run it, I always get the error Parameter :S0 not found. If I do SELECT * FROM sites WHERE stitle=:S...
Zones: Delphi ProgrammingDate Answered: 09/15/2006 Grade: A Views: 0
Hello Guys, I have a dbgrid with a dbcheck in it, when I give a double click on the field, it checks or unchecks the field, it depends on the state of my field. My problem is that after cha...
Zones: Delphi ProgrammingDate Answered: 02/14/2007 Grade: A Views: 0
I have a programatically made TAdoQuery.  I want to do something when the BeforePost event is triggered.  How do I do this since I don't have it on my form?
Zones: Delphi ProgrammingDate Answered: 09/25/2007 Grade: A Views: 0
I'm getting a Syntax error when trying to run the SQL Query with TADOQuery. I don't know hwat I'm doing wrong. Here's the code: ADOQuery1.SQL.Add('select * from products where (Price) <= "' +...
Zones: Delphi ProgrammingDate Answered: 10/05/2007 Grade: A Views: 0
How can I close a TADOQuery which query result is empty(o record)? My program(mssql 2000;windows 2000 server; Delphi5 sp1): tbLogin is a TADOQuery component.      tbLogin.SQL.Text:=Format...
Zones: Delphi ProgrammingDate Answered: 02/04/2002 Grade: A Views: 0