Call Post
Edward Koryagin
--- On Fri, 14/1/11, Marshland Engineering marshl...@marshland.co.nz wrote:
From: Marshland Engineering marshl...@marshland.co.nz
Subject: [DUG] Sql query
To: delphi@delphi.org.nz
Received: Friday, 14 January, 2011, 12:49 PM
I'm viewing a SQL query in a dbgrid
Try QToDo.Requery.
Cheers,
Laurence Bevan
From: delphi-boun...@delphi.org.nz [mailto:delphi-boun...@delphi.org.nz] On
Behalf Of Marshland Engineering
Sent: Friday, 14 January 2011 12:50 p.m.
To: delphi@delphi.org.nz
Subject: [DUG] Sql query
I'm viewing a SQL query in a dbgrid. When
...@delphi.org.nz [mailto:delphi-boun...@delphi.org.nz] On
Behalf Of Marshland Engineering
Sent: Friday, 14 January 2011 12:50 p.m.
To: delphi@delphi.org.nz
Subject: [DUG] Sql query
I'm viewing a SQL query in a dbgrid. When I add a record to the source db and I
run QToDo.Refresh it does not include
Rather than doing a Refresh you could do an Open and a Close. If you do
this you probably want to store what record you are on
id := QToDo.FieldByName(id).AsInteger;
QToDo.Close;
QToDo.Open
QToDo.Locate('id', id, []);
substituting id for whatever your primary key is. Not elegant but
better
Hey Naven
My problem got solved
i actually missed soemthign in where clause i have added the option called
aprove date in it and it fetched the record in 10 minutes time
Thanks so much for ur time in replying to my mail
Regards
Vik
On 5/8/08, Vikas... [EMAIL PROTECTED] wrote:
Hi Naven
Hi Naven
thanskf ro the reply
please find the query below
SELECT top 100 percent convert(varchar,a.approvedate,112) as [date],
rtrim(a.accountnumber)+replicate(' ',16-len(rtrim(a.accountnumber))) as
accountnumber,
dbo.Get_Value(accountname,100)
Vikas
Can you post the text of the query?
Basic Pointers
1/ Add indexes for ther foreign keys (these can allow duplicates)
2/ Restrict the result set (I assume you dont want the query to return
10 million rows)
3/ use ansi join syntax
N
Hi
I have an query related to an sql sever 200o
in store procedure
Have a nice day
Regards
Leigh
www.smootharm.com
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Neven MacEwan
Sent: Thursday, May 08, 2008 6:04 PM
To: NZ Borland Developers Group - Delphi List
Subject: Re: [DUG] sql query issue
Vikas
Can you
Hi
I have an query related to an sql sever 200o using delphi 5. Not sure if
this is the right palce to ask it. Still i belive may be soemone can help me
in this
I am creating a store procedure.
In that i am fetching the information on the basis of join between two
table.
say table 1 and
Hi All
Can anyone suggest a good open source
(prefdelphi)SQL Query Builder, Sort of Like a
cross between the MS SQL One (visual linking, field picking)
without the clumsy Access type
literal where clause input (and the ability to order) with
acolumn 'browse data' and paste value ala
: Neven MacEwan [mailto:[EMAIL PROTECTED]]
Sent: Monday, 2 April 2001 23:27
To: Multiple recipients of list delphi
Subject: [DUG]: SQL Query Builder
Hi All
Can anyone suggest a good open source (pref delphi) SQL Query Builder, Sort
of Like a
cross between the MS SQL One (visual linking, field
[Reply]
Sergey Orlik's Open QBuilder (OQBuilder)
http://www.geocities.com/SiliconValley/Way/9006/index.html
Kind Regards
Gary
At 23:31 on 2/04/2001 you wrote
To :
CC :
From: Neven MacEwan, [EMAIL PROTECTED]
Hi All
Can anyone suggest a good open source (pref delphi) SQL Query
Struan Judd wrote:
INSERT INTO table1 ( field11, field12 )
SELECT field21, field22 FROM table2
Hi Struan, I just tried the following in database desktop (again a
paradox table):
INSERT INTO CalcMethod ( ConfigurationID, Object, Attribute, Method,
Description )
SELECT 1,
Mark Derricutt wrote:
Unfortunately I get "Type Mismatch in Expression", I assume this is
possibly due to attempting to hardcode the value of ConfigurationID. If
I run the SELECT portion on its own it works ok, but returns 1 as 1.0
Ok, looking in my "SQL for Dummies" book I found I can get
[SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Monday, 15 March 1999 10:15
To: Multiple recipients of list delphi
Subject:[DUG]: SQL Query...
Is it possible to do an "insert into" query and supply a series of
values from a "select from" query?
I
]
CJN Technologies LtdPhone: +64 (9) 415 4796
All opinions mine only Mobile: +64 (21) 685 335
-Original Message-
From: Mark Derricutt [mailto:[EMAIL PROTECTED]]
Sent: Monday, 15 March 1999 10:15
To: Multiple recipients of list delphi
Subject: [DUG]: SQL Query
16 matches
Mail list logo