Search results for query: *

I have a VARCHAR2(366) field called TERM_TEXT in an Oracle Database that when it is displayed in Crystal Reports 8 is shown as a memo field. I want to write a formula find the number of occurances of the character "X" in this field. I've looked at previous answers to this problem and...

Many thanks Jim thats solved it! I've got to cope with orphans, step parents, foster parents etc I just wanted to keep it simple to understand the theory but now you solved that I should be able to apply it to all possible permutations. Many thanks again Gary Frost

My report consists of the following. I am using 3 tables : Schools, Pupils and Parents A School has many pupils an a pupil has 0,1or 2 parents The report looks as follows Group Header 1 Schools Group Header 2 Pupil Details Pupil details and Parent details @IsFather @IsMother Group Footer 2...

I have the following piece of VB code rptComp.ReportFileName = gsRptComparator rptComp.RetrieveDataFiles f = rptComp.PrintReport rptComp.ReportFileName = "" rtpComp is a Crystal Report ActiveX control on the form gsRptComparator is just a string variable containing...

I did have the reference of "Microsoft ActiveX Data Object 2.0 Library" After changing the connection string to OLEDB.4.0 I changed the reference to "Microsoft ActiveX Data Object 2.5 Library" and I also tried 2.1 and 2.6. All work but the performance is nowhere as fast as...

I used to have code that looks like the following cnnConnection.Provider = "Microsoft.Jet.OLEDB.3.51" cnnConnection.Open gsDatabaseName lsSQL = "SELECT * FROM BLAH WHERE [Keyfield] = '" & lsSelectedKey & "' " rstRecSet.Open lsSQL, cnnConnection, adOpenDynamic...