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 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...
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...
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...
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...
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...
Just installed SQL Server 2005 express from Microsoft.
Everything working fine ... (apart from a stupid thing that you can not import your database...
I had to do it from Access).
My questi...
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...
I am using a tADOTable connected to a bdgrid to display the contents of the table. I want to implement a search so the user can enter a partial value that can be contained ANYWHERE in a field ...
Hi Experts,
I got a funny error using TADOQuery in Delphi 7.
Please see attached screenshot.
Please advise.
I'm opening mdb files as:
AdoConnection1.ConnectionString := 'Provider=Microsoft.Jet.OLEDB.4.0;'+'User ID=Admin;Data Source='+DBPath+';Mode=Share Deny None;'+'Persist Security Info=False;'...
Hello Experts!!!
I need to execute a command by ADOQuery.ExecSQL. I need it to work in async mode.
How can I recognize the ExecSQL method finishes its execution?
e.g.: as the "Open" met...
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 unable to do a filter search usign Interbase's TIBDataset component.
With normal ADO I would do something like this:
Please advise.
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.
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 ...
I am an all microsoft shop but a vlient broght in an old app that has a borland bde database. Is there any delpphi or borland utility or shareware or odbc driver i can download to take a peek ...
I have a stored procedure in Firebird that returns two parameters:
CREATE PROCEDURE OPDUTY_LOGON_LOGOFF_TIME(
INDIVIDUAL_IDENT CHAR(6) CHARACTER SET ASCII,
QUEUEEVENT_IDENT BIGINT)
R...
Dear Experts,
I have 2 TDBGrid components.
The 1st one must display master table records and the second one displays detail table records
for the selected row in the master table.
qOrder...
oracle, delphi
i have to data filed named, firstname and lastname. i want to combine this two field as one .
e.g
firstname and lastname as name how??
Dear Experts,
1. How can I determine the Primary Key of a row after I have inserted it with a TIBQuery?
2. If #1 is NOT possible then, how can I get the generator name of a given table?
I am using Delphi 3 with QuickReports 2.0k.
I am trying to print mailing labels. I have my report template laid out, and linked to a datasource, etc.
I have dropped several QRDBText com...
Hi,
have a problem, I have created a connection to web service that sends me back offical current exchange rates. I get back the results that I have to import into a mySQL database, the res...
I am gettiing the following error:
'Row cannot be located for updating. Some values may have been changed since it was last read'
while using code that has worked for me in the past.
...
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
