how can i open a report or form which is in activex dll file ( which i use it like com object) ( as i have explained in report interface in dll file Thread) as vbmodal.i have done this
this is coded in Main project which produce exe file
Set ObjRptTemp = CreateObject("PrjReport.clsReport")...
i have coded a program which all of the form and reports are in a project(UIProj) and all of the database actvities for forms are in a activex dll prject (FormPrj) and all of the report database actvities is in a activex dll prject (ReportPrj). I thought maybe it is better the Reports itself in...
i know this is a strange question, and answering it needs to know more about the project , but i ask it anyway.
i have a project which all of the forms are in the one projects, and i have created 2 other activex dll project to code all server section in that project. the size of the first...
i have this stored procedure
CREATE PROCEDURE CheckPRF_PV_Date @projId2 int,@TotalDelivered int,@Result varchar(100) output
AS
declare PRF_Cursor Cursor
For SELECT Quantity,DeadLine FROM dbo.VGoods WHERE (dbo.VGoods.PrjId = @projId2)
open PRF_Cursor
Fetch PRF_Cursor into...
i have a procedure in my application which i use it almost in all form. it changes the values of some textboxes in each form.now my question is that. which one these two methos is better for having better performance.
if i program these procedure as public procedure and call just this one...
i have a procedure like this
CREATE PROCEDURE GetFieldPath @FieldName varchar(10), @ReturnField varchar(10) output
AS
Select @ReturnField=@FieldName FROM TblPath
it doesn't work , i want to have field as a variable to pass it different field
which part is wrong?
if i can do a part of process (like a few select query to get a value) in a view and in a stored procedure, which one is best for getting better performance?
I have a table which has a row with four column, when ever i want these values (4 columns) i connect to the database and get the specified values through the stored procedure.
these 4 values could be used in any part or any form in application.
now my question is that for having better...
i have a procedure like this
CREATE PROCEDURE GetFieldPath @FieldName varchar(10), @ReturnField varchar(10) output
AS
Select @ReturnField=@FieldName FROM TblPath
it doesn't work , i want to have field as a variable to pass it different field
which part is wrong?
I have programmed an application which every thing on the my pc . i mean the application and also sql server . after testing i should use it on the network, but i think it is just a little slow. now i want to know is there any software or policy which i can get where on the program cause...
i have defined 3 varibale in Global section of my project
'************ Global **********
Public ProjectPath As New Collection
Public PInterval As New Collection
Public PrjFinish As New Collection
'************ End of Global **********
in Other form of my project named FrmMain , i have...
I have a table which all data in it have been stored with codepage 1256 . now i want to convert data to codepage unicode. i don't what should do. can anyone help me?
I have a listview and dataGrid and a recordset. when a user select an item from listview, that item is added into recordset and will be set to datagrid datasource
the brief code is like that.
'Defining recordset
Set rstDG = New ADODB.Recordset
rstDG.Fields.Append "Id", adDouble...
I am defining a recordset like this
Set rstDG = New ADODB.Recordset
rstDG.Fields.Append "Id", adDouble
rstDG.Fields.Append "GoodsName", adVarChar, 255
rstDG.Fields.Append "GoodsId", adDouble
rstDG.Fields.Append "TypDesig", adVarChar, 255
rstDG.Fields.Append "TypeId", adDouble...
I have a data Grid which is bound to a Recordset named (rstDG), the only difference is that datagrid has a one more field named (Item) which is the first column. after setting the datasource of the datagrid to rstDG, i want to fill the item cell to Row Id.
so i did so
grdGood.Columns(0).Text =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.