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...
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 unable to do a filter search usign Interbase's TIBDataset component.
With normal ADO I would do something like this:
Please advise.
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...
We are running interbase 7.5 and loaded it onto a Vista machine. The interbase was loaded in a directory c:\borland\
When we use the BDE to connect to the GDB file and enter username and p...
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...
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
