Search found 110 matches

Go to advanced search

by sajith
Mon Jun 01, 2009 6:21 am
Forum: FiveWin for Harbour/xHarbour
Topic: Calling Function
Replies: 3
Views: 556

Re: Calling Function

Dear, Anser & Rao
Many thanks for ur reply ur code works fine.My problem is solved
Regards,
sajith
by sajith
Sat May 30, 2009 11:28 am
Forum: FiveWin for Harbour/xHarbour
Topic: Calling Function
Replies: 3
Views: 556

Calling Function

Hello,can Some Help me Iam populating Menu frm Database(Mysql).In the Action event iam getting the Form Name + Appending the "( )" to call perticular form For Example if the formname is "Wage" iam appending "( )" to get "Wage()" to call that function .Here iam...
by sajith
Sat May 09, 2009 10:47 am
Forum: FiveWin for Harbour/xHarbour
Topic: Problem in ADODB.Command
Replies: 20
Views: 2783

Re: Problem in ADODB.Command

Many thanks for ur kindness ,
I have attached the problem to ur mail ,plz view as per ur convenience
Regards,
Sajith
by sajith
Sat May 09, 2009 10:25 am
Forum: FiveWin for Harbour/xHarbour
Topic: Problem in ADODB.Command
Replies: 20
Views: 2783

Re: Problem in ADODB.Command

Many thanks,
Still the same problem

Regards,
Sajith
by sajith
Fri May 08, 2009 9:15 am
Forum: FiveWin for Harbour/xHarbour
Topic: Problem in ADODB.Command
Replies: 20
Views: 2783

Re: Problem in ADODB.Command

Many thanks Anserkk,nageshswaganpati for ur gorgeous support, Half the problen is solved with ur reply,now my problem is how to assign a value to Outputparameter frm FiveWin //Procedure DROP PROCEDURE IF EXISTS yy.Sp_Job5; CREATE PROCEDURE Sp_Job5(IN Ename varchar(25),In Job varchar(25),OUT Jcode v...
by sajith
Fri May 08, 2009 8:52 am
Forum: FiveWin for Harbour/xHarbour
Topic: Problem in ADODB.Command
Replies: 20
Views: 2783

Re: Problem in ADODB.Command

Many thanks Anserkk,nageshswaganpati for ur gorgeous support, Half the problen is solved with ur reply,now my problem is how to assign a value to Outputparameter frm FiveWin //Procedure DROP PROCEDURE IF EXISTS yy.Sp_Job5; CREATE PROCEDURE Sp_Job5(IN Ename varchar(25),In Job varchar(25),OUT Jcode va...
by sajith
Wed May 06, 2009 6:04 am
Forum: FiveWin for Harbour/xHarbour
Topic: Problem in ADODB.Command
Replies: 20
Views: 2783

Re: Problem in ADODB.Command

Many thanks,

yy.`Sp_Job1` here yy is database name amd Sp_job1 is the procedure name .it comes
automatically when we tried to create procedure(Template) from mysql.i changed the
procedure name as sp_job2 still no effect.If u have any code sample can u kindly share wih me.

Regards,
Sajith
by sajith
Tue May 05, 2009 11:33 am
Forum: FiveWin for Harbour/xHarbour
Topic: Problem in ADODB.Command
Replies: 20
Views: 2783

Re: Problem in ADODB.Command

Many thanks, Still not working ,even error msg is not showing Try oCommand:=CreateObject("ADODB.Command") oCommand:ActiveConnection:=oCon oCommand:CommandType:=adCmdStoredProc oCommand:CommandText:="Sp_Job1" oCommand:Parameters:Append(oCommand:CreateParameter("Ename",ad...
by sajith
Tue May 05, 2009 10:38 am
Forum: FiveWin for Harbour/xHarbour
Topic: Problem in ADODB.Command
Replies: 20
Views: 2783

Re: Problem in ADODB.Command

Many thanks for ur great help, Try oCommand:=CreateObject("ADODB.Command") oCommand:ActiveConnection:=oCon oCommand:CommandType:=adCmdStoredProc oCommand:CommandText:="Sp_Job1" MsgInfo(oCommand)//here object is clarified oCommand:Parameters:Append(oCommand:CreateParameter("E...
by sajith
Tue May 05, 2009 10:06 am
Forum: FiveWin for Harbour/xHarbour
Topic: Problem in ADODB.Command
Replies: 20
Views: 2783

Re: Problem in ADODB.Command

Many Thanks for ur great Advice, oCon:= GetConnection() oCommand:=CreateObject("ADODB.Command") oCommand:ActiveConnection:=oCon oCommand:CommandType:=adCmdStoredProc oCommand:CommandText:="Sp_Job1" Try    oCommand:Parameters:Append(oCommand:CreateParameter("Ename",adVar...
by sajith
Tue May 05, 2009 7:31 am
Forum: FiveWin for Harbour/xHarbour
Topic: Problem in ADODB.Command
Replies: 20
Views: 2783

Re: Problem in ADODB.Command

Many thanks for ur valuable reply, When i run this code iam getting a error:Unknown name CreateParameter is my code correct oCommand:=CreateObject("ADODB.Command") oCommand:ActiveConnection:=oCon oCommand:CommandType:=adCmdStoredProc oCommand:CommandText:="Sp_Job1" oCommand:Param...
by sajith
Mon May 04, 2009 12:30 pm
Forum: FiveWin for Harbour/xHarbour
Topic: Problem in ADODB.Command
Replies: 20
Views: 2783

Problem in ADODB.Command

Can some one help me, i want to return a value frm storedprocedure as "output parameter" iam using following code   oParameter:=CreateObject("ADODB.Parameter") oCommand:=CreateObject("ADODB.Command") oCommand:ActiveConnection = oCon oCommand:CommandText:="Sp_Job1&q...
by sajith
Thu Mar 26, 2009 9:02 am
Forum: FiveWin for Harbour/xHarbour
Topic: How to add Selective Columns to XBrowse
Replies: 2
Views: 359

Re: How to add Selective Columns to XBrowse

Many thanks :D
Regards,
Sajith
by sajith
Tue Mar 24, 2009 7:56 am
Forum: FiveWin for Harbour/xHarbour
Topic: Stored Procedure/Function of MySql
Replies: 10
Views: 1253

Re: Stored Procedure/Function of MySql

Here is the sample to create and Execute StoredProcedure in Mysql

Code: Select all

create Procedure Sp_Item(IN name varchar(25))//Here name is parameter
Begin
 select * from Item where Item.name=name;
 end;
Command to Execute Procedure Sp_Item

Code: Select all

CALL Sp_Item('Computer');
Regards,
Sajith
by sajith
Sat Mar 14, 2009 11:36 am
Forum: FiveWin for Harbour/xHarbour
Topic: How to add Selective Columns to XBrowse
Replies: 2
Views: 359

How to add Selective Columns to XBrowse

Hi,
I want to add selective columns to XBrowse. Not at the time of Definition.
Please give sample for adding Columns to XBrowse .What are the use of

Code: Select all

aCols,;  aDisplay,;  aSelected,;  aArrayData
How can i implement it in XBrowse.
Regards,
Sajith

Go to advanced search