Thanks for the reply
Here, I am just passing a dynamic query as parameter from application to stored procedure. There is no stored procedure calling another stored procedure
sujathaeeshan
Last Activity: Aug 30 '12, 08:39 AM
Joined: Feb 4 '08
Location:
-
sujathaeeshan started a topic Error in executing single dynamic query that has multiple SQL statementsin DB2Error in executing single dynamic query that has multiple SQL statements
Hello,
The single dynamic query has multiple SQL statements.
for ex:
@query="DELETE FROM TABLE L.TAB1 WHERE COL1='VAL1' ;
DELETE FROM TABLE L.PTR1 HERE COL1='VAL1' ;
DELETE FROM TABLE L.ITR1 WHERE COL1='VAL1' ;"
The stored procedure that executes this statement in SQL server looks like
ALTER PROCEDURE [dbo].[TABEXECUTE]
(
@query ntext... -
Replace logic is required
Hello,
The string column value looks like as below. Each value has a size of 15 withing a string
'2.2020 30 4.0000'
The column value should match with user input as below. The result should show equal when it is compared. Currently, it results not equal since it is a string comparision. The last digit '0' needs to be ignored for decimal values.
'2.202 30 ... -
Can you please give an example ...
for the selected alphabet it has to loop through the data for matching rowLeave a comment:
-
How to select or highlight data grid row
Hello all,
I want to highlight or select data grid row based on first letter of first column in data grid with keyboard.
Just by pressing the key of first letter of the column ,it has to highlight the respective row.
For example,
RST 1000 FFF
FGH 2000 JJJ
KLP 3000 KKK
FST 4000 GGG
grid will be having 4 rows like this,if user prees F then it has to highlight... -
Not able to see the last tree view node
Hi ,
I am working on C#.net.
I am not able to see the last tree node after scrolling the tree view scroll bar at the very first time after loading the view.
Only after the explore of 2nd node from last, i am able to see the last node...
Thanx for your replies.... -
Group box control Tab Focus problem
Hi,
I am having 3 buttons and Group box control having only one child Grid control...3 buttons n groupbox are child controls of VIEW
I am having tab indexlike Groupbox(0),Gri d (child contorl) as(0),
then for 3 buttons like 1,2,3....
But I have written like
private void DataGrid_KeyDow n(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Tab)
... -
sujathaeeshan started a topic how to set font for grid column header which is being a control of Groupbox controlin Visual Basichow to set font for grid column header which is being a control of Groupbox control
Hi All,
I am doing UI design(form design modifications) not programmaticall y.
I am facing problem while appplying font to Data grid column .
Here i am placing Data Grid within GroupBox.
When i apply the Group box text font as Arial and bold
this formatting applies to all controls which is placed inside the group box.
But when i try to change the font as MsSanserif and Regular at ColumnheaderDef aultCell... -
sujathaeeshan started a topic how to set font for grid column header which is being a control of Gropbox controlin .NEThow to set font for grid column header which is being a control of Gropbox control
Hi All,
I am doing UI design(form design modifications) not programmaticall y.
I am facing problem while appplying font to Data grid column .
Here i am placing Data Grid within GroupBox.
When i apply the Group box text font as Arial and bold
this formatting applies to all controls which is placed inside the group box.
But when i try to change the font as MsSanserif and Regular at ColumnheaderDef aultCell... -
Hi,
I used your approach
But its displaying like
LegalEntityOwne r:Legal Entity 1
LegalEntityName :Legal Entity 1
LobName:Line Of Business 1
LegalEntityOwne r:Legal Entity 1
LegalEntityName :Legal Entity 1
LobName:Line Of Business 2
Its not showing the Formula Details......
Please can you tell me how to display the formula detailsv that belongs to corresponding...Leave a comment:
-
Hi,
Just provide the &Open Details at the text property of the button.
while running the form if u fired Alt+O ,it automatically fires the function of button(open details)-- which opens another form.
Regards
sujiLeave a comment:
-
how to compare xml elements within root using xslt
hi all,
here is xml file.....
<root>
<Xmltype>
<owner NAME="Legal Entity 1"></owner>
<LegalEntity NAME="Legal Entity 1"></LegalEntity>
<lob NAME="Line Of Business 1"></lob>
<Formula>A</Formula>
<Formula>B</Formula>
</Xmltype>
<Xmltype>
<owner NAME="Legal... -
How to seed or increment NEWID() value
Hi all,
Newid() which creates a unique value of type uniqueidentifie r.
Is there any possibolities for seeding or incrementing the NEWID() value.
For example:
create table cust(cust_id uniqueidentifie r NOT NULL
DEFAULT newid(),cust_na me varchar(60) NOT NULL)
For insertion example:
INSERT cust (cust_id, contact_name) VALUES (newid(), ' ABC ' )
INSERT cust... -
How to seed or increment NEWID() value
Hi all,
Newid() which creates a unique value of type uniqueidentifie r.
Is there any possibolities for seeding or incrementing the NEWID() value.
For example:
create table cust(cust_id uniqueidentifie r NOT NULL
DEFAULT newid(),cust_na me varchar(60) NOT NULL)
For insertion example:
INSERT cust (cust_id, contact_name) VALUES (newid(), ' ABC ' )
INSERT cust... -
SDLC
Software Development Life CycleLeave a comment:
-
hi,
Its DataGrid
Thannx
sujathaeeshanLeave a comment:
-
How to make grid colums as noneditable by users
Hi all,
Is there any functions or built-in property values exist that shoudn't allow
the coumbo box or grid colums to edit.It has to show only the existing values
which is stored in coumbo box or grid colums.
plzz help me out of this query... -
How to provide shortcut keys for controls like text box,button
Hi all,
I need to provide shortcut keys for controls like text box and buttons etc...
That is i dont want to go for tabspace or mouse click for perticular controls..
By having shortcut keys i need to go for specifeid controls(textbo x,button)...
Is there any way to provide shotcut keys for controls.....or built in property values.....
could any anoe help me out of this query... -
How to provide shortcut keys for controls like text box,button
Hi all,
I need to provide shortcut keys for controls like text box and buttons etc...
That is i dont want to go for tabspace or mouse click for perticular controls..
By having shortcut keys i need to go for specifeid controls(textbo x,button)...
Is there any way to provide shotcut keys for controls.....or built in property values.....
could any anoe help me out of this query... -
How to make grid colums or combo box as noneditable by users
Hi all,
Is there any functions or built-in property values exist that shoudn't allow
the coumbo box or grid colums to edit.It has to show only the existing values
which is stored in coumbo box or grid colums.
plzz help me out of this query...
No activity results to display
Leave a comment: