Hi EE
I have a customer table in sql with a customerid field that I have set as the primary key. What i want is when I add a new record using the Delhi DBNavigator it autoincrements that fi...
Hi Experts,
I am using a TADOTable component.
In my database table I have a TDateTime field.
My idea is to filter all rows for a given date range by using the Filter property.
How woul...
I have been installing the BDE Administrator using an install shield program setup
for me (I have never setup a Install Shield Program)
Now on a Windows 2007 Server service pack 1 I get an i...
I am having a problem inserting a record using TADOQuery in Delphi 5. The query is open and active (the associated datasource state is in dsBrowse) when I try to perform the insert:
wit...
Dear Experts,
I am in a hurry to get a prototype app up and running and therefore this question:
In SQL 2005 Express I have created a demo database with a test table.
As a result I have...
Hi
New to Delphi & programming.
Using Delphi 7 / Access db(2003) / ADO query / Jet 4.0 conn.
sDateEdit1 & 2 are AlphaSkin versions of Delphi DateTimePicker input fields, on a User Query for...
Hi, I want to find out if the account nummer is correct. Following code worked perfect, but on a certain number, it gave me an exception.
737-0250120-97
DIVISION OF 7370250120 by 97 : rest...
I know how you can filter records of a column using the built in filters.However I would like the grid level to be filtered when I open it.Is there a way to do it ?
Hi Experts,
I have created a demo db and table in SQL 2005 Express for testing purposes.
My primary key field is set to a 'uniqueidentifier' data type.
Will this field auto increment on...
My version is 5,01
Thanks
Hey all,
Trying to install Firebird with Zeos, so far so good. But when adding a ZConnection and setting Connect to True, I get the following error "Requested Database Driver was not found"...
I developed a program using borland delphi that use SQL Server database.
As a part of my program, i need to backup and restore the database.
I have the TDBGrid control and several fields for inserting new records on the form. I'm using ADO for data manipulating. There is also the button named Insert which OnClick event must insert ...
Dear Experts,
I am involved with project where we will implement edi messaging software at our local vehicle manufacturers. This is quite a large project and I need to have the best advise ...
Hi Experts,
I got a funny error using TADOQuery in Delphi 7.
Please see attached screenshot.
Please advise.
I'm trying the following code
adoquery1.First;
///delete from table all records of those who have scored under 10 at any time
While not AdoQuery1.eof do begin
If adoquery1...
Hello,
trying to access an Exchange Server with Delphi 2006 using ADO. (TADOConnection)
Which OLE DB-Provider I have to select ?
Short sample aould be helful.
JStoffy
Hi experts,
I have the following code and it is working fine with normal Query component from delphi
Query1.ParamByName('username').AsString:=Edit1.Text;
Query1.ParamByName('passwo...
My Delphi application uses ADO to connect to Sql Server Express 2005 on a Windows Server 2003 in a local network. Since i migrated from delphi 7 to delphi 2009 i get an exception when i try to...
I need a simple procedure that will take a recently sorted single field MS Access file (ADOTable1.Sort := 'FieldName ASC';) and copy its contents into an array. (The Delphi help menu is provin...
Dear Experts,
I am unable to do a filter search usign Interbase's TIBDataset component.
With normal ADO I would do something like this:
Please advise.
Hi guys,
How do I get the newly added records primary key when inserting a record?
I am using TBetterADODataset with LockType ltBatchOptimistic since I wanted to post the records to the db...
Hi All,
I have 2 app who connect to the same SQL database.
Both applications is connecting 100% on my local environment.
But when published to our testing server one of the apps gives the...
Dear Experts,
I am using an ADOQuery which will return dynamic field names.
Is there not a routine that can automatically build the fields for me?
Something similar to what the TDBGrid ...
I have created a database like program in the language pascal / delphi. The program has been working yesterday, until today, when I started it, an error message appeared . is not a valid in...
