Comments by Member 11776570 (Top 61 by date)

okay and if i want to read inside the tag then, like below is the tag.

<hierarchicalloop loopid="2000A" loopname="abc efg" id="1" parentid="">

I need to read loopid and loopname value from it then what to do now ?

there are too mach SP for each tag, so SP call another SP and another SP call another. That the problem. Then all the table we merge into 1 table.

done now. I don't know is server is slow.
But now it is done.
Thanks for all the reply.

Nope there is no issue with table.
I can run simple below query and it provide me result for it

select * from STAFF1

when i below SP select query it gives me popup with this below msg

select * from STAFF_Test

Context : Statement :: Fetch
Message: isc_dsql_fetch failed.

SQL Message : -811
multiple rows in singleton select

Engine Code : 335544652
Engine Message :
multiple rows in singleton select
At procedure 'STAFF_Test' line : 15, col: 1

Nope still same issue is there look, but there is empty in result and i gives same error of multiple selecton

Preparing statement: select * from STAFF_Test
Statement prepared (elapsed time: 0.203s).
Field #01: STAFF_TEST.PERSONID Alias:PERSONID Type:STRING(500)
Field #02: STAFF_TEST.LEGACYROWID Alias:LEGACYROWID Type:STRING(500)
Field #03: STAFF_TEST.LASTNAME Alias:LASTNAME Type:STRING(500)
Field #04: STAFF_TEST.FIRSTNAME Alias:FIRSTNAME Type:STRING(500)
Field #05: STAFF_TEST.MINIT Alias:MINIT Type:STRING(100)
Field #06: STAFF_TEST.ACTIVESTATUS Alias:ACTIVESTATUS Type:STRING(100)
Field #07: STAFF_TEST.COLLOQUIAL_NAME Alias:COLLOQUIAL_NAME Type:STRING(500)
PLAN SORT ((STAFF1 NATURAL))
Parametros: 0


Executing statement...
Statement executed (elapsed time: 0.000s).
258 fetches, 0 marks, 0 reads, 0 writes.
0 inserts, 0 updates, 0 deletes, 29 index, 69 seq.
Delta memory: -232 bytes.
Total execution time: 59.065s
Script execution finished.

Below is working now but it has still error message of "multiple rows in singleton select", please can u let me know how it will resolved

SET TERM ^ ;



CREATE PROCEDURE STAFF_Test
RETURNS (personid varchar(500),
legacyrowid varchar(500),
lastname varchar(500),
firstname varchar(500),
minit varchar(100),
ACTIVESTATUS varchar(100),
COLLOQUIAL_NAME varchar(500)
)
AS BEGIN
SELECT distinct
STAFFID AS personid,
STAFFID AS legacyrowid,
replace (STAFFNAME, substring( STAFFNAME from 1 for (position(' ' in STAFFNAME))), '') as lastname,
substring( STAFFNAME from 1 for (position(' ' in STAFFNAME))) as firstname,
Staffinit as minit
,ACTIVESTATUS
,COLLOQUIAL_NAME
FROM STAFF1
INTO :personid, :legacyrowid,:lastname,:firstname,:minit,:ACTIVESTATUS, :COLLOQUIAL_NAME ;

DO SUSPEND;
END^
SET TERM ; ^

GRANT EXECUTE
ON PROCEDURE STAFF_Test TO SYSDBA;

Nope it is not working, it gives me this error.

Engine Code : 335544569
Engine Message :
Dynamic SQL Error
SQL error code = -104
Token unknown - line 7, column 7
DO

Okay i got your point. Sorry my mistake.
It has date this 2016-07-10 need to convert it to 2016-07-10 00:00:00 in this format.

I just need to convert this 2016-07-10 date format to like this 1943-11-05 00:00:00.000 one noting else. In PostgresSQL

I need to directly change it to datetime data type.

I have to convert it to datetime because data is convert from source system to destination system. So destination system has datetime data type in it.

I am using column inside that but still it is not working in RazorSQL and not in FlameRobin also.

This sentence "But it is not working due to return of table value." means the return table that i used it is not working in Postgres. I want that same function in Postgres nothiugn else.
Below is the sample data.
(A,A,A,C,C,C,C,C,A,A,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","")

Just i need to convert that SQL function to Postgres, so can't able to convert it. Please if you can convert it or make same function that works in postgres database.

No there is not any fixed number for CALLED, there are 1 or more than it in single records values of CALLED.

okay but then i have to split that data by ";" also

as i have done this

foreach (var callstrin in allstring)
{
var fields = callstrin.Split(new char[] { ';'} ,StringSplitOptions.None);
}

But still not getting proper data.

This error is occur now

The given value of type String from the data source cannot be converted to type datetime of the specified target column.

when i use this

DATE_FORMAT(STR_TO_DATE(dob, '%m/%d/%Y'),'%Y%e%c')

to store it in datetime datatype column.
Any suggestion for it.

Thanks that really works. Thanks a lot. I was just stuck into it. Already working from too many hours. Thanks buddy.

okay i got your point but we cant change the datatype, its client DB. So we have to convert it into datetime and stored that data into another database where it is date time datatype.

okay...

I have tried this 'select convert(datetime,column_name,121),* from [dbo].[Table_name]'. It gives me this error 'Arithmetic overflow error converting expression to data type datetime.'

But still i can convert that data i have try all the solution of your given link.
It is giving error like this 'Arithmetic overflow error converting expression'

Okay but I am using this in Visual Studio in .sql file.

ty u.

but if i want to know which table is updated or data is inserted then. Some thing will be there to check in oracle.

i have used this
select distinct
SUBSTRING([columnname], CHARINDEX(' ', [columnname]) +1,LEN([columnname])- CHARINDEX(' ',reverse([columnname]))) AS firstname

,substring([columnname],isnull(nullif(charindex(' ',[columnname],charindex(' ',[columnname])+(1)),(0)), charindex(' ',[columnname])),
case
when
charindex(' ', [columnname])=(0)
then
(0)
else
len([columnname])
end) as minit
,[columnname] as orignal_data
from [tablename]

But how i have used it but one name has onlu lastname & firstname.

Here i have not asked for the school name or to make fum of it. I just asked for the answer.

Yes, i got that error. There is no access in C:\ to make changes in the file of installed application, that's why it is giving the error.

when i store it in the string variable
string connection_string =ConStr.ToString();

Yes i have to do this only. if you have solution of SSRS then tell me.

sorry but i not understand your answer.

i have to show multiple reports in single report viewer.

Ok. I had done. Problem is solved. ty u for your feedback.

But i have to change from app.config file. this is not working.

If i want to add new rows in data grid view, but if data grid already has a data. So how can i add new rows without removing the previous one.

But it is not working, it is clearing the previous data only showing the new data in gridview. i wan to add new data at last in row of data grid view.

Ty u... Done...

{ SqlTransaction tran;
con.Open();
tran = con.BeginTransaction();
try
{


cmd = new SqlCommand("Insert_emp", con);

cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@firstname", SqlDbType.VarChar, 50).Value = obj.Firstname;
cmd.Parameters.Add("@lastname", SqlDbType.VarChar, 50).Value = obj.Lastname;
cmd.Parameters.Add("@address1", SqlDbType.VarChar, 50).Value = obj.Address1;
cmd.Parameters.Add("@address2", SqlDbType.VarChar, 50).Value = obj.Address2;
cmd.Parameters.Add("@city", SqlDbType.VarChar, 50).Value = obj.City;
cmd.Parameters.Add("@mobile_no", SqlDbType.BigInt).Value = obj.Mobile_No;
cmd.Parameters.Add("@email", SqlDbType.VarChar, 50).Value = obj.Email;

cmd.Parameters.Add("@created_by", SqlDbType.VarChar, 50).Value = obj.Created_By;
cmd.Parameters.Add("@created_date", SqlDbType.DateTime).Value = obj.Created_Date;
cmd.Parameters.Add("@modified_by", SqlDbType.VarChar, 50).Value = obj.Modified_By;
cmd.Parameters.Add("@modified_date", SqlDbType.DateTime).Value = obj.Modified_date;
cmd.Parameters.Add("@isactive", SqlDbType.Bit).Value = obj.IsActive;
cmd.Parameters.Add("@emp_id", SqlDbType.Int);
cmd.Parameters["@emp_id"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
tran.Commit();
int result = Convert.ToInt32(cmd.Parameters["@emp_id"].Value);
if (result > 0)
{
return result;
}
else
{
return -1;
}
}
catch
{
tran.Rollback();
throw;
}
finally
{
con.Close();
}

It is giving the error like this
ExecuteNonQuery requires the command to have a transaction....... command is in a pending location transaction.

ok

John but where to write this code. I have written in the event of gird Column Added. But when i double click on header it gives error to me, because i have written the code in cell double click event of grid.

But where to write this code. In which event of data grid view.

But you have added data manually. I have to add data from database.

In windows form.

ok...

But the problem is that, there in no error in other windows form. In other windows form it is working without the OTS namespace, but not working in product form.

not working it is check 9 digit only not 10 digit. i want to check 10 digit mobile no like this 9876543201

9876543214. this number i want to check but it shuold also check that it should be equal to 10 digits mendatory.

not working it is giving error, i have type mobile number in textbox.

it will work but at last there is empty value in combo box

Sorry but there is no use of session.

i want some data from form2, data is in gridview when form is loaded. i want that data from gridview in form1 but already i had done some codeing in that gridview on celldoubleclick event of that girview. just i want to set that when i go from form1 to form2 it just check if i am redirecting from form1. if yes, then it will get that data and redirect back to form1 and display that data. if i have directly open form2 then the second method of that grid shuold be run on celldoubleclick event.

now i get the solution. thank u for your feedback

not working i had done this only.
myform f=new myform();
f.showdialog();