|
Try:
DataEnvironment1.Commands(1).CommandText="Select Round(" & Altitude & ", 2) from Alt"
|
|
|
|
|
Altitude is not a variable used in VB. Altitude is a Field in table Alt.
|
|
|
|
|
I tried using Round in a query in Access, and that works fine, just as expected.
Are you sure that it is an Access database that the connection is connecting to?
Are you sure that the query that you have shown is causing the error? The code you show can never cause that error by itself, there has to be som code that runs the query also.
---
b { font-weight: normal; }
|
|
|
|
|
It is in access database only.
I am getting the values if i use the query without using round function.
It is showing error when i use the round function
|
|
|
|
|
What is the complete error message?
What databasedriver are you using, e.g. what does your connectionstring look like?
---
b { font-weight: normal; }
|
|
|
|
|
Error Message : "Undefined function 'round' in expression".
Connection String : Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Premalatha\30_01_06-VrefAnalysis\VrefAnalysis.mdb; Persist Security Info=False
Database Driver : Microsofy.Jet.OLEDB.4.0
-- modified at 7:07 Wednesday 1st February, 2006
|
|
|
|
|
PremalathaP wrote: Select Round(Altitude,2) from Alt
Try:
SELECT ROUND(Alt.[Altitute], 2) FROM Alt
|
|
|
|
|
Does anyone know how to capture webcam images using avicap32.dll and not save the images to the clipboard. I would like to be able to actually stream the images 'into' the a picture box or any other control capable of holding an image, and then retrieve an image at any given time by way of the Image property. I do not want to use the clipboard because in my app a user may be using it for other things such as text editing, etc.. I have used DirectShow but avicap32.dll in my case would be better suited.
Any help at all would be appreciated.
-Jason
|
|
|
|
|
|
My whole post was about avoiding the clipboard, when reading the documentation, it says there are alternatives to the clipboard, but i have yet to make any of them work.
Since my app should allow for text editing in other areas of the app, I do not want to use the clipboard, for this reason...
I was using the clipboard to start, but then when testing, i realized that I was losing some stuff that I had copied and had been replaced with an image.
So then I decided as a workaround to right before I save the image to clipboard, I would copy the contents in the clipboard to memory, then send the image to it, retrieve the image back, then reset the contents of the clipboard back to its original contents. Most of the testing I did like this worked ok, but every now and then, the contents would get mixed up and where it should be saving an image it was saving text that was copied into the clipboard and vice versa.
The documentation states that you can save it to some sort of an independant bitmap, but I do know how to go about doing that.
Any suggestions?
-Jason
|
|
|
|
|
|
Thanks for the link, but I had already found that and it like many others use the clipboard for capturing still shots. For example, that articles code for the function to capture an image uses...
'---copy the image to the clipboard---
SendMessage(hWnd, WM_CAP_EDIT_COPY, 0, 0)
'---retrieve the image from clipboard and convert it
' to the bitmap format
data = Clipboard.GetDataObject()
I have found an alternative to that scheme but now I am having problems forcing that window to paint it self or atleast think it is painted when it is hidded, as sometimes i get a black capture image.
-Jason
|
|
|
|
|
hello,
i am making use of table control and when i am creating a new cell ia setting colors ,height,width dynamically but it is not effecting please can anybody tell how to convert table cell string into float i have used convert function but it is showing me error
thanks & regards
Nagalakshmi
|
|
|
|
|
Your request does not make any sense. Perhaps it would be better if you split it up to use many sentences instead of one very long sentence.
ColinMackay.net
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell
|
|
|
|
|
My comp is a Product based company,i have developed a project in VB.NET,i need to include my project in our existing product.I dont have that much space to include .NET Framework into the package. Is't sufficient that only with the supporting DLL's to run the project,so that no need to include .NET framwork inside the package
Sathiyaraj Ganesan
|
|
|
|
|
Sathiyaraj Ganesan wrote: Is't sufficient that only with the supporting DLL's to run the project,so that no need to include .NET framwork inside the package
I really don't know where some of you guys who ask such questions get the idea that you can take short cuts like this 
You have developed a program in VB.NET - right? VB.NET uses the .NET Framework - right? The 'supporting DLLs' ARE the framework - right? Ergo you need the .NET Framework on the client machines - right?!
If it is not already installed, you need to get the user to somehow install it - whether you include this in your distributable package or not (if permissable by your Microsoft agreement) or let the user download it from Microsoft is irrelevant. You MUST have the framework to run your program.
...Steve
"Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." (Translation: I'll show you the way, but not write the code for you.) I read that somewhere once 
|
|
|
|
|
What kind of media that you are going to distribute? CD-ROM or post on the web? If you distribute via the CDROM and the size is not enough then, distribute it into 2 CDROM and make your installation process require for disk 1 and disk 2.
|
|
|
|
|
Hey, you have mentioned "i need to include my project in our existing product". Now can you be clear on what exacly means your product.
With Best Regards,
Mayur
|
|
|
|
|
|
Hi -
I am currently developing a vb.net application (product) that will have mulitple end customers. I would like to add each customer's icon to the splash screen, but I do not want to recompile the application for each customer. Is there a "best practice" method of doing something like this?
Thank you in advance for any suggestions or ideas!
brian
|
|
|
|
|
|
I'm sorry...I probably didn't explain it clearly.
The splash screen has the customer's icon on it. Each version or flavor of the application is customized for the particular customer by putting their logo on the screen. It's only one logo and one customer per splash screen. If there are 10 ultimate customers, I don't want to have 10 splash screens. I would like to be able to have a setting that would cause the appropriate logo to be shown on the screen. I guess I am thinking along the lines of how localization is done. Maybe I am way off here, in which case I'd appreciate someone bringing me back to reality
Thanks to anyone/everyone who takes the time to reply...I appreciate it!
brian
|
|
|
|
|
You don't have to recompile it. All you need to do is load the image from a file and put it in a picture box. You could even have this as a configuration option. If the option is not present, just show a default picture.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Would you suggest putting the image(s) in a resource file? Would the configuration option (i.e. which customer is this) go in the app.config?
Do you think there's a more object-oriented or "best practice" way of doing this?
Nevertheless, I like your previous advice...thank you!
brian
|
|
|
|
|
If you put the images in a resource file, you'll have to either recompile the app each time you change the customer and supplies that customers resource file.
Ummmmm.....I get the feeling you're thinking about putting all of your customer's logos in the same resource file and loading the image based on the customer that has it. DO NOT DO THIS! Logo images are Copyrighted and Trademarked and you're more than likely violating the terms of using those images. Consult with your customers first before even thinking of do this. Besides, companies change their logos from time to time. In order to change the logo after this, you'ld have to recompile the app with the new image. And the customer will probably DEMAND you do it.
You'll be much better off just loading the image from a customer supplied file. Let the customer customize their copy of the app. You'll avoid both a support nightmare and a legal mess doing it this way.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
