Search:

its working fine now,,, thank you very much

greetings

I used convert function in sql server with no problem, but when i try to use in in vb6 for my quiry it does not recognize the convert function

vdate=cdate("30/01/2011")
rst.open...

after populating the MsFlexgrid, how i can move to the cell in row 2

thanks
cyrus

how I can sum a particular group

say;

grp A 15
grp A 10
grpb 5
grpb 3

totalgroup A 25

Greetings,

I have added a new project within an existing project, it looks like, the modules,components,references and dataevenironment from the first project are not being shared. (cannot be used...

greeting,

how EXE can close by itself , if no activity on a certain period of time.

thnks
cyrus

is there a way to print SQL table and its Field names,

10x
cyrus

greeting Gurus'

how can you supress zero value in datareport. (if its 0 it should not print)

rgds
cyrus

I copied form1 from proj_A to Proj_B, proj_ A, form1 after its been used it unloads the mdiform_proj_A.

how can I unload mdiform_proj_B when i use from1 within prodj_B


rgds
cyrus

app has been running for months suddenly app crashes with error message 'CLASS NOT REGISTERED' this when printing a report.

I cannot reproduce the error from raw source, anybody had experience...

Class not Registered

what does this mean...

I've deployed exe. and it works in some work station...
others is prompted with this msg when they select to print a report...

i've check...

I created a datareport having two group section
second group footer cannot find datasource on the property window to select field name.

any guidance is much appreciated

tkns

cyrus

i'm a experience vb6 developer, I'm looking into switching to ASP.NET C#,
what is the best way for me to start, can u suggest books, tutorial etc, for me to have a very good understanding as a...

Report.Database.LogOnServer "PDSODBC.DLL", "servername",
"dbasename", "user", "password"

i',m getting connection failed.

what could be the problem.

what is "PDSODBC.DLL"

rgds

thanks all gurus, i've use the split(.......) and works fine for me

I have 2 project and have group it, is it possible to share one modules and other resources in project GROUP, how ?

thks cyrus

how can i set CR to VB syntax

i've used inner join to join 2 tables Table_A and Table_B, when I tried to update field only found in Table_A my application crashes.

is it possible to update flds whe two tables are joined ?
...

Following ur suggestion problem has been resolve,by maintaining the query for selection criteria of data to be reported.

thnks

Dim Report As New CrystalReport36
Dim strselectionformula As String
Dim vReconDate As Date
Private Sub Form_Load()
vReconDate = CDate(Daily_Route_Recon.MaskEdBox1(0).Text)
Report.ReportTitle =...

I have written app using sql server as backend, it just a simple reporting,
i have created a X table to store data taken from various table and use the X table as source for reporting, if one user...

I have join two tables using inner join as

select A.*,B.fld1 from table1 as A inner join Table 2 as B on A.fld=B.fld

the problem is i need to update a fldname on table1, but my app crashes...

I'am using msflexgrid to display records from my table, after it display all, how can I set to display from the first record

thanks
cyrus

DLL is new to me, and i did the following thru VB6

class1(myfristclassdll)

Option Explicit
Public i As Integer
Public vCounter As Long
Public vRecCount As Long
Public vValue As Long

I followed instruction to 'USING SQL SERV3ER MANAGEMNT STUDIO" to create a new link server, to store Xls to a Sql Table,

when i try to run the query i was prompted by this error:

OLE DB...