clear1140
Last Activity: Jul 19 '10, 09:19 AM
Joined: Sep 6 '07
Location:
-
how to fix delphi dbgrid dropdown list problem
I have a DBgrid and one column is a look up to a table. When the the drop down list is envoked and when the form is being resized or moved around, the list will still be shown at the same spot where it first was envoked. I don't know what seems to be the problem. -
thank you so much. Am getting what u mean and somehow i knew this was gonna be the answer. Thanks for the WITH (NO LOCK) option, i have never used that before... -
Would using a table variable be efficient?
We divided our tables from table zone_a, ..._b, ..._c to zone_z, these tables have the same attributes. We have divided this tables in this way so that any data that is under zone_a would only be on it's specific table, and the same with the other remaining table. Since per table holds thousands of data per day we have decided it to be designed this way and also hoping to reduce lock up of tables everytime a user accesses the table.
... -
Apologies accepted.... but still i dont know what function to use... :(...Leave a comment:
-
i tried to use the eval function but it seems that MSSQL does not recognize the functionLeave a comment:
-
I hope this could help
SELECT a.School, a.Semester, a.Grade, a.Campus,
(SELECT COUNT(Status)FR OM StudentResult WHERE School = a.School AND Semester = a.Semester AND Grade = a.Grade AND Campus = a.Campus AND Status = 'Accepted')
AS NoofAccepted,
(SELECT COUNT(Status)FR OM StudentResult WHERE School = a.School AND Semester = a.Semester AND Grade = a.Grade AND Campus = a.Campus AND Status...Leave a comment:
-
retrieving a string into mathematical expression
Good Day!!!
Is it somehow possible to retrieve a string and then convert it into a mathematical expression? for example i have this string '14200 * 5' and then i want to convert this into a mathematical formula so that i could get the result of it which is 71000
Thanks.... -
i'm no expert but i guess all you have to do is create a procedure for this...Leave a comment:
-
thanks it really helped!!
But i too got another solution. I simply put the resulting rows into a cursor and it works even better than my previous code. Thanks for reminding me that there is a better way... THANK YOU!!!...Leave a comment:
-
thanks for the code but still it doesn't work, i should have made my message clear... you see i've got this table..
--table---
trial_clear(num ,def,def2,def3)
--these are the existing values--
1st row (NULL,q,NULL,NU LL)
2nd row (NULL,w,w,NULL)
3rd row (NULL,e,e,r)
4th row (t,NULL,y)
5th row (q,w,NULL)
you see what i was supposed to do is update this table, assigning the num value...Leave a comment:
-
if else statement inside a where clause
Good day!!
I was wondering if it is possible to put an if else statement inside a where clause of an sql statement... you see i would like my update statement to do this:
update trial_clear set num = @count2 /* @count2 is a integer passed*/
where
if (select top 1 def from trial_clear where num is NULL) is NULL
def is NULL
else
def = @def /*given... -
Hey ck9663......... thanks a lot....... it really works.......... ... thank you!!!!!!!!!!!...Leave a comment:
-
Ms Sql
Can anybody help me about this??
I'm new from using the MS SQL and i need a function/procedure/trigger.......
there is this function from Delphi (FormatCurr) that I used to create a new record id
....FormatCurr( '0000000000',Tq ry.FieldByName( 'BudgetNo').AsI nteger+1....... ...
but then i want to make the same thing in MS SQL but i dont know what function to used so instead i did this dumb coding...
No activity results to display
Leave a comment: