Visual Basic

31-Jan-06 19:18

The following code in VB shows the error : "Undefined function 'round' in expression".

[CODE]

DataEnvironment1.Commands(1).CommandText="Select Round(Altitude,2) from Alt"

[\CODE]

Here, Altitude is a variable of type 'Number-Double'

Alt is a table in MS-Access Database.

Help me regarding this.

Thanks in advance.

-- modified at 2:18 Wednesday 1st February, 2006

Mekong River31-Jan-06 20:37

31-Jan-06 20:37

Try:

DataEnvironment1.Commands(1).CommandText="Select Round(" & Altitude & ", 2) from Alt"

PremalathaP31-Jan-06 21:34

31-Jan-06 21:34

Altitude is not a variable used in VB. Altitude is a Field in table Alt.

Guffa31-Jan-06 21:58

Guffa

31-Jan-06 21:58

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; }

PremalathaP31-Jan-06 22:48

31-Jan-06 22:48

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

Guffa1-Feb-06 0:40

Guffa

1-Feb-06 0:40

What is the complete error message?

What databasedriver are you using, e.g. what does your connectionstring look like?

---
b { font-weight: normal; }

PremalathaP1-Feb-06 0:44

1-Feb-06 0:44

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

Mekong River2-Feb-06 12:41

2-Feb-06 12:41

PremalathaP wrote:
Select Round(Altitude,2) from Alt

Try:

SELECT ROUND(Alt.[Altitute], 2) FROM Alt

AviCap

jasonpb31-Jan-06 18:10

jasonpb

31-Jan-06 18:10

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

Mekong River31-Jan-06 20:48

31-Jan-06 20:48

jasonpb wrote:
how to capture webcam images

http://www.codearchive.com/rate.php?rid=1752&go=1012[^]

jasonpb wrote:
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

Get text image from clipboard.[^]

Clear clipboard.[^]

jasonpb31-Jan-06 21:02

jasonpb

31-Jan-06 21:02

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

Mekong River3-Feb-06 5:29

http://www.devx.com/dotnet/Article/30375[^]

3-Feb-06 5:29

Re: REGARDING TABLE CONTROL

jasonpb3-Feb-06 8:26

jasonpb

3-Feb-06 8:26

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

REGARDING TABLE CONTROL

nagalakshmibasireddy31-Jan-06 18:05

nagalakshmibasireddy

31-Jan-06 18:05

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

Colin Angus Mackay31-Jan-06 22:16

Colin Angus Mackay

31-Jan-06 22:16

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

Running VB.NET without .NET??

Sathiyaraj Ganesan31-Jan-06 17:21

Sathiyaraj Ganesan

31-Jan-06 17:21

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

Steve Pullan31-Jan-06 17:33

Steve Pullan

31-Jan-06 17:33

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 Sigh | :sigh:

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 Smile | :)

Mekong River31-Jan-06 18:07

31-Jan-06 18:07

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.

mayhem_rules31-Jan-06 19:40

mayhem_rules

31-Jan-06 19:40

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

Mekong River31-Jan-06 20:30