|
When i try to run an exe it gives error saying \\abc\d\e.mdb is not a valid path
So i made a folder where the exe was called abc in it sub folder d and in it pasted e.mdb still it gave me same error
Also when i tried to open the code it gave error that crviewer9.dll was missing
so i downloaded and registered the dll
but then when i click on any file in project with .dsr extention it can't open it
also when i try to compile the code it gives Unexpected Error 50003
I am using VB 6 and Crystal Reports 8.0
Don't know with what version of reports was the present code written
I tried ver 10 but got error saying not able to load files with dsr extention
Atleast with ver 8.0 it opens without any problem but am not able to complie
Thanks
-- modified at 8:59 Wednesday 16th August, 2006
|
|
|
|
|
Hi Everyone,
How to check the OS during installation, Dll varies and Registration depending upon OS. Can any one help me in this regard.
Regards,
Manowj
|
|
|
|
|
Hi All
I am using MS SQL Serve 2000 as back end data storage. One of the column in one particular table is of type TEXT. Here the problem is I am not able to view the entire content of the column by any mean. I am storing a large amount of data in that particular column. Select query returns initial small portion of the stored data. Even if I open the table through Enterprise manager also I am not able to see. Moreover while saving if I trace it through profiler there also I will be able to view very small portion of original data. So can anybody sagest me, how can I view the data?
Thanks in advance,
Regards,
Krishnaraj
|
|
|
|
|
The Enterprise Manager and the Visual Studio debugger does not show the entire value, but your code have access to all the data. If you need to see the full value, output it from your program.
---
b { font-weight: normal; }
|
|
|
|
|
I have a app with a form that has a lot of controls on it.
when showing the form there can be a delay of several seconds which is too much.
I've narrowed down most of this time to the form's InitializeComponent.
i Could really use some helpful hints about how to improve performance.
|
|
|
|
|
Your best option is to lower the number of controls on the form. Controls are heavy-weight objects and creating large numbers of controls takes time. There's very little you can do to speed it up.
In the past, the only GOOD suggestion in cases like this is to rethink your interface. For example, do you REALLY need 50 buttons and 100 textboxes on a form? More than likely not. Break up your interface into multiple forms as logical containers encapsulating related chunks of your data.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Thanks for the reply.
The form unfortunately includes a Tab control with 7 tab pages on it, each of which has a bunch of controls. I could problably reuse most of the controls on the diffrent tabs, at the expense of lowering the readabillity of my code.
I dont have many options tho, the customer wants exactly the same app, just in .NET.
NB. Dont know if this info is important but, the code was ported from VB6 to VB.net and corrections have been made to make it work.
-- modified at 8:57 Wednesday 16th August, 2006
|
|
|
|
|
Michael Andersson wrote: Tab control with 7 tab pages on it, each of which has a bunch of controls.
Option - you could create the controls on the tab page dynamically when the page is first called. It'll mean more coding but would probably shave some time off.
Another idea would be to create a "Please Wait..." form which is a simple matter of creating a form with a progress bar control and a timer. It's just a simple way of keeping your user informed that your app is actually doing something.
|
|
|
|
|
I have a value in my access databse which is tick and untick , i think the value is YES/NO. In VB i try to set the value but i having this error....
anyone know wat it mean?
Error:
Run-time error '91':
object variable or with block variable not set
Highlight error:
DB.Execute "UPDATE Dono SET InvoicePrint = " & yes & _
" WHERE [NO] = " & "'" & Dorder.dono.Text & "'"
original code:
Dim message, dialog, title, answer
message = "Print Invoice?"
dialogtype = vbYesNo + vbQuestion
title = "Print invoice?"
answer = MsgBox(message, dialogtype, title)
If answer = vbYes Then
DB.Execute "UPDATE Dono SET InvoicePrint = " & yes & _
" WHERE [NO] = " & "'" & Dorder.dono.Text & "'"
MsgBox ("record updated successfully...")
End If
|
|
|
|
|
Hi campbells,
Please check and confirm that you have declared db as a new connection, and when you pass a string into a database , use '[single Quotes] before and after a string ok. This might solve your problem, Again if you find problem, reply me
Regards,
Manowj
Regards,
Manowj
|
|
|
|
|
DB.Execute "UPDATE Dono SET InvoicePrint = " & "'" & True & "'" & _
" WHERE [NO] = " & "'" & Dorder.dono.Text & "'"
is it correct with the Single Quotes i using? i have try to change the value as ON,1,YES or TRUE but not working
|
|
|
|
|
and i cant declared it as new~
i use this
Private DB As Database
is it ok?
|
|
|
|
|
Use the value 1 for "yes"/"true"/"on" and 0 for "no"/"false"/"off".
---
b { font-weight: normal; }
|
|
|
|
|
Dear All,
Currently we are working on a project by using Visual Studio.net as an interface, MS-SQL as data store, and ReportViewer 8 as data view. We want to display our local unicode characters. And it seems that the display on the report is not correct at all.
For your further understadning, we would like to tell you that we are working on Cambodian Character (Khmer Unicode). Our characters are some what different from English. We have consonant and subconsonant which displays just right below the normal consonant. We also have vowels, and sub-vowels which dislay on the left, right, upper part , up upper part, lower part and low lower part of the consonant or even the sub-consonant. The disiplay is OK on the interface itself. But when we view it with report viewer, the character all spreaded out.
I hope someone out there is kind enough to help me with this.
Regards,
Sithy
Sithy
|
|
|
|
|
Please help me. I have a program I wrote in VB.net My database is in Ms Access.
I want to produce a report. I am using Crystal report XI.
Data for the report are in 9 different tables (all in the same database).There is no way I can limit the number of tables. My SQL select statement joins and selects information from all the 9 tables base on a field data_ID that is common to all.
The problem is this:
When data exists in all the 9 tables the SQL select statement works fine, but if data does not exist in all the tables (some table have data , some table may not have data) the SQL statement does not work at all.
I would like the retrieval mechanism to be such that data in available tables are retrieved and displayed in the report, irrespective of the absence of data in another table.
I have tried producing a report that consist of several sub-reports but on printing the final report is more than one A1 paper.
The final report must not be greater than one A1 sheet of paper.
Thank you.
ihe
|
|
|
|
|
Check your joins in the SQL statement and ensure that you show all data in the parent tables.
Example:-
SELECT FROM Id, CompanyName FROM CompanyTable RIGHT OUTER JOIN Contacts ON Contacts.CompanyId = Company.Id
Steve Jowett
|
|
|
|
|
Thank you.
The tables in my database are:
1. BitsNozzles
2. BottomHoleAssembly
3. ComplusoryFields
4. DataIdentity
5. DrillingMudProperty
6. DrillingPumps
7. PressureLoss
8. Reports
9. TotalValues
How would I join them?
Your example:
SELECT FROM Id, CompanyName FROM CompanyTable RIGHT OUTER JOIN Contacts
ON Contacts.CompanyId = Company.Id
Used two tables but I have 9 tables.
ihe
|
|
|
|
|
Which tables link to which now? Post the SQL code you have now and I'll modify it for you
Steve Jowett
|
|
|
|
|
Thank you very much
The tables are:
1. BitsNozzles
2. BottomHoleAssembly
3. ComplusoryFields
4. DataIdentity
5. DrillingMudProperty
6. DrillingPumps
7. PressureLoss
8. Reports
9. TotalValues
It works like this, on starting the program you must supply
1. Wellname (a string)
2. Date (DateTime)
3. report type ( a string)
4. and the values for the ComplusoryFields
The report type may be AM or PM. (AM represents a morning report and PM an evening report. Reports are produced twice a day.).
When you submit these information .The program would do the following
1. The program generates a string (The data_id) and check if this Data_ID already exist in the database.)
2. Save the values for ComplusoryFields into the ComplusoryFields table. This table contains information that almost all the other tables need to calculate some values or the other.
With the Data_ID you now have access to the other tab pages .Each tab page represent a table .You may now save, edit, delete into/out of the database .Each table is linked by the Data_ID
When you wish to produce a report, you click a button. This button would do the following.
1. Run a private sub GetTotal .
GetTotal would calculate the totals from several tables and overwrite the data in the TotalValue table. (There is no need to store calculated values)
I intend to use an Update SQL statement here. Is this right?
2 Run a private sub GetReportData .The sub would get the data from the 8 other tables and the TotalValue table that now contain data for the selected Data_ID.
The SQL statement below is the one I used before your first letter.
SELECT BitsNozzles.BisNozzleRecordsID, BitsNozzles.TotalBitsUsed, BitsNozzles.TotalNozzlesUsed, BitsNozzles.BitsID, BitsNozzles.BitsType, BitsNozzles.BitsSize, BitsNozzles.NumberOfNozzle, BitsNozzles.NozzleSize, BitsNozzles.DataID AS BitsNozzles_DataID, BottomHoleAssembly.BHARecordID, BottomHoleAssembly.HoleOrCasingType, BottomHoleAssembly.HoleInnerDiameter, BottomHoleAssembly.PipeOrCollarType, BottomHoleAssembly.PipeInnerDiameter, BottomHoleAssembly.PipeOuterDiameter, BottomHoleAssembly.PipeAndCasingLength, BottomHoleAssembly.DataID AS BottomHoleAssembly_DataID, ComplusoryFields.ComplusoryRecordID, ComplusoryFields.DataID AS ComplusoryFields_DataID, ComplusoryFields.CFactor, ComplusoryFields.MudWeight, ComplusoryFields.CirculationRate, ComplusoryFields.CurrencyForMudCost, DataIdentity.IdentityRecordsID, DataIdentity.Measurement, DataIdentity.DataID AS DataIdentity_DataID, DataIdentity.WellName, DataIdentity.DataDate, DataIdentity.ReportType, DrillingMudProperty.DrillingMudRecordsID, DrillingMudProperty.Alkanity, DrillingMudProperty.DataID AS DrillingMudProperty_DataID, DrillingMudProperty.API, DrillingMudProperty.Chlorides, DrillingMudProperty.FlowLineTemperature, DrillingMudProperty.Gel0Mins, DrillingMudProperty.Gel10Mins, DrillingMudProperty.HTHPFilterates, DrillingMudProperty.MBT, DrillingMudProperty.YP, DrillingMudProperty.PV, DrillingMudProperty.MudWeightIn, DrillingMudProperty.MudWeightOut, DrillingMudProperty.Water, DrillingMudProperty.Solids, DrillingMudProperty.Oil, DrillingMudProperty.AveROP, DrillingMudProperty.MaxROP, DrillingMudProperty.VIS, DrillingMudProperty.ShaleDensity, DrillingMudProperty.ShaleFactor, DrillingPumps.DrillingPumpsRecordsID, DrillingPumps.PumpNumber, DrillingPumps.RodDiameter, DrillingPumps.StrokeLength, DrillingPumps.Efficency, DrillingPumps.DataID AS DrillingPumps_DataID, DrillingPumps.PumpOutPut, DrillingPumps.PumpSize, DrillingPumps.LinearDiameter, DrillingPumps.PumpType, DrillingPumps.PumpStatus, PressureLosses.PressureRecordsID, PressureLosses.DxC, PressureLosses.DataID AS PressureLosses_DataID, PressureLosses.EMWLOT, PressureLosses.EstOverBurden, PressureLosses.EstFratureLoss, PressureLosses.EstPorePressureLoss, PressureLosses.MWDPressureLoss, PressureLosses.PipeRunSpeed, PressureLosses.CasingShoePressureLoss, PressureLosses.DxTrend, Reports.ReportRecordsID, Reports.ADT1, Reports.ADT2, Reports.Operator, Reports.Contractor, Reports.TVDDepth, Reports.MDDepth, Reports.DataID AS Reports_DataID, Reports.Rig, Reports.Operation, Reports.ImagePath, Reports.SpudDate, TotalValues.TotalRecordsID, TotalValues.PropertyName, TotalValues.TotalValue, TotalValues.DataID AS TotalValues_DataID
FROM TotalValues INNER JOIN (Reports INNER JOIN (PressureLosses INNER JOIN (DrillingPumps INNER JOIN (DrillingMudProperty INNER JOIN (ComplusoryFields INNER JOIN (BottomHoleAssembly INNER JOIN (BitsNozzles INNER JOIN DataIdentity ON BitsNozzles.DataID = DataIdentity.DataID) ON BottomHoleAssembly.DataID = DataIdentity.DataID) ON ComplusoryFields.DataID = DataIdentity.DataID) ON DrillingMudProperty.DataID = DataIdentity.DataID) ON DrillingPumps.DataID = DataIdentity.DataID) ON PressureLosses.DataID = DataIdentity.DataID) ON Reports.DataID = DataIdentity.DataID) ON TotalValues.DataID = DataIdentity.DataID;
would changing all the INNER JOIN to OUTER JOIN help?
ihe
|
|
|
|
|
Yes, change the joins to OUTER rather than INNER.
An OUTER JOIN is one in which each row of the result set does not necessarily have to contain a row from both tables begins joined; one or both tables are retreated as optional.
An INNER JOIN relates each row in one table to one more corresponding rows in another table. Each result row from an inner join represents the combination of values from two related rows, one from each of the tables being joined.
Steve Jowett
|
|
|
|
|
Thank you I will try that and get back if an error occurs.
ihe
|
|
|
|
|
I'm currently working on a project that requires the user to move files from one client system to another for the purpose of synchronization. I want these files compressed/zipped/archived so that the user gets to move just one file (i.e the zipped file) and at the other end, I want to be able to decompress/unzip the file and start necessary processing.
What is the best way to achieve this?
Regards,
Luther
Object-Oriented Programmer
lutherium - feel the weight of object-oriented programming
|
|
|
|
|
|
Hi Manowj,
Thanks for the help. The link was quite helpful. I have however found an alternative means of handling it.
Regards,
Luther.
lutherium - feel the weight of object-oriented programming
|
|
|
|
|
If you are not looking specifically to zip format and want good compression like winrar then try using zlib.dll its open source and free
Their site is zlib.net
|
|
|
|
|