o
k
q
u
e
s
t
i
o
n
s
.
c
o
m

Roudning (Up, Down, Truncate) -

Does .5 round to 0 or 1????

Rounding is kinda confusing. It seems some functions just truncate(Int,Fix), some round up, some round down, and some round to the closet even number(CInt,CLng).

I need to make my visual basic program compatible with a perl script. Is there any way to control the rounding???

Does anyone know of any more information on this?
Any information at all would be helpful.

Thanks.

 

Roudning (Up, Down, Truncate) -
Does .5 round to 0 or 1???? Rounding is kinda confusing. It seems some functions just truncate(Int,Fix), some round up, some round down, and some round to the closet even number(CInt,CLng). I need to make my visual basic program compatible with a perl script. Is there any way to

Keeping output from a formula aligned. -
I have a formula which outputs a time bewteen 2 dates in the format Days Hours Minutes. I have a formula which calculates this and this is the line for the output: truncate(dd) & " D " & truncate(hh) & " H " & truncate(mm) & " M";

Truncate Vs Delete -
Is there any wway to roll back the data after executing Truncate statement...? Why can't we Delete the records instead of Truncating. What are the advantages over the other...? Thanks in Advance

SQL Server 2005 Truncate Table -
On my server at home, I get this error when I try to truncate a table: Cannot truncate table 'dbo.*****' because it is being referenced by a FOREIGN KEY constraint. Yes, it is referenced with a foreign key, but there is no data in the other table ! so there is nothing to complain a

truncate integer in string -
hello, is it possible to truncate or get the value of a number in a string? i have a combobox that displays varchar values from the database for example MNG-5. i want to get the number 5 and maybe put it in a label or a textbox, is it possible? thanks.

truncate an access table -
Hi I have an access table,I want to delete all its records with ressetting the autonumber index to 1. In SQL server 2000, i used Truncate table tablename how can i do the same operation in access? thanks

Fastest way to delete all rows in MS Access -
I've heard that using TRUNCATE to delete all the rows of a table is faster than using DELETE because TRUNCATE doesn't do logging (but therefore can't be rolled back) while DELETE does do logging (and can be rolled back). I don't care about rolling back, metadata, or anything like that

How to truncate Text based on the control width -
Hi, I want to truncate a Text and add ellipsis at the end based on the width of the panel in a status bar control. For example: If the text is "123456789" and if the panel can't show all the text, then I want to know where to truncate, so that I can show the charcters t

Truncate a string -
This should be simple, but I can't find a solution. I want to truncate a long string to a certain amount of characters, like 100. I tried using myString.Remove(100) and myString.Substring(0,100), but the problem with those is that it throws an exception if the string is less than 100

Truncate data from relational DB -
Hi guys .. how r u all ? am facing a problem, I need to truncate data from a table which has relations with other tables !! and I can't empty it .. should I destroy evey single relationship in order to empty my table ?? or there is a syntax that could help ?? am u

[2005] Which command variable to assign truncate sql to -
I have a sql statement like so: Code: TRUNCATE TABLE mytable it's in a stored procedure, but I dont know which one to assign it to? a) .DeleteCommand or b) .UpdateCommand of the SqlDataAdapter. Thanks, Justin Fox

How to make a RichTextBox truncate text -
Well everyone...I have been in a VB slump the last 2 days and have had to ask many ?'s....so here's another: I have RTB that only views 7 lines at a time. The 4th line (middle) is changed to a font size larger and a different color to specify that is the current line in use. I had t

Problem with ToWords function -
I using this piece of code in a formula field for diplaying the amount in words (In indian Currency).. its giving "Rupees One Crore one lakh negative fifty-three thousand six hundred fourty-four only" .. can anyone tell me y it is showing 'Negative' while using toWords?? (

Convert Seconds to Days Hour Minutes Seconds Crystal -
This code was orginally designed to convert total seconds to Hours:Minutes:Seconds and display a total. However my fields get so big I need to add a day conversion and I might be the worst person at math ever. I have added the Days portion of this and it shows the days but I can't

Trimming network path from drivelist -
Ok, I am making an FTP program. I have a drivelist box that lists all drives... regular, CDROM, and network. However, when I switch to a network drive, it doesn't load the files from there, and I think I know why. The Drive1.Drive includes the network path. This must be confusing

MSHFlexgrid truncate text -
Hi all, I am using a MSHFlexgrid control and allow user resizing by columns. My question is: If a users resizes a column to less that the original width how do you truncate the text replacing the letter characters with ..... For example: A column header has the text &quo

truncate sum -
what does the truncatesum function do?

[RESOVED]Textbox Truncate &/or Mask -
I have a text box that is going to take input from a magnetic card (like a credit card), or in my case a Players card from a casino. Each card has a specific number tied to the card but is encoded with some proprietary data that identifies the casino and division. Example: on the fro

I think we need to do this -
TRUNCATE TABLE ChitChat; hehe

How in the world do you.... -
truncate a number!!! For example... 8.9893823 truncated is 8

SQL Admin question--Transaction log problem -
A SQL7 DB has following transaction log setting Space allocated 11 MB Maxmium size 18MB Used 2.44MB Free 10.24MB Database option: Truncate log on checkpoint (checked) But when I tried to do a modification of a table with 14K records (eg. add one more column)

*RESOLVED* Truncating a field before inserting into a new table -
Okay, here's the simplified version of my problem in SQL 2000: I've got table X with field 1, where the length of field 1 is 100 characters. I've got table Y with field 2, where the length of field 2 is 55 characters. I want to insert the data in X.1 into Y.2 with an insert qu

DTS Copy Problem -
Hello, I am using SQL Server 2000 and have created what I would consider a really simple DTS package. I have an Access database that is housed on a mapped drive on a different server from my SQL server. The Access database is still a live database but I am converting it to SQL Ser

SQL Server Transaction Log problem.... -
Hi, I m having a DB on the web server with a hosting company.. The DB had been working fine and all of a sudden i get the Transaction Log is full error and i checked the size of the Trans Log and its 17 MB that is the max size allocated by the hosting guys. I checked the siz

Truncating a File -
Hi, How do I truncate a file which I have already opened in binary mode. thanks, inaam

Sql Server job how to make the TruncateLogOnCheckpoint on job -
hello Everybody, Is there a way to shrink the database or all the databases on my sql server and do the Truncate Log On Checkpoint on a job that will run at night Thank you in advance, ERAN

File Name Checker -
Hi Folks, Can someone help me out to create a VB applicateion that can truncate the file name of all the files in a folder if it is more than 24 characters. Any leads also would be appreciated, Thanks, Lonely

overflow vertical only -
ok here's what i want 2 do ... i have a div with OVERFLOW set to AUTO, so i get a scrolling effect - but i want it to scroll vertically only and truncate the right side if it exceeds the width of the div... can this be done??? thanks in advance Kris

casting question! Is this roudning to the nearest integer.:Resolved:. -
Hello everyone! I'm reading some exericses and it wants me to round the number to the nearest integer. Okay this is quite easy I thought, but does this mean if i have: 34.6 to print 34 or does it mean 34.6 to print 35? my code does the first thing, it prints 34 not 35. Cod

Truncating string values -
Can anyone help me with this.... I have a variable declared as string type and i want to truncate the string value to take only a certain section of the string value. Any suggestions peeps ?

Truncate + Insert Into Question -
Hey, I got a routine in my program that truncates a table then does a insert into that table. I have noticed increments missing in my PKey. ex. Recs 29 30 31 33 Anyone know why this might be happening?

Extremely Long Words -
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0000000000000000000000000 This is really annoying. How could I have my scripts

Adding a User-Defined Type to a Collection -
How can you add a User-Defined Type to a Collection? Here is what I am doing: Code: Public colDirs As Collection Public Type aDir DirectoryPath As String ShortPath As String End Type Dim aNewDir As aDir With aNewDir .DirectoryPath = Expression .Shor

Help Calculating differences -
HELP!!!! Can someone look over my coding and tell me where I went wrong! Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click 'Later you will learn to put all this code into a function which will make your program bett

Truncating markup text while Reserving html tags -
I am not a php programmer, and I need help with a code snippet that can truncate some text to a certain number of words, for example: "Hello my name is Zaid, I am a nice guy!", would be truncated to 4 words as: "Hello my name is ..." But here is the problem: Say

Round... -
how do I let to cut a number with more than 4 decimal numbers? Es I have 4,34445555 I want that It give me 4,3444 I have tried with: variabile = Round(variabile,4) but it doesn't work at times well the number it changes me it is not limited to truncate me him

replace function in access-query -
how to use a replace fnction of vb in access-query. or what is any alternative for it to truncate middle spaces.

Truncating Strings -
Hello, Does anyone know how to get a string of say 35 chars and truncate it to be only 30 chars? ie. removing the last 5 chars (or whatever number over 30 it is) I dont think most of the VB functions for this kind of thing work in vbscript. Any ideas , ??? Thanks Dave

Pinnacle-BPS Graph Control truncates decimals -
I am using this Graph Control from a previous programmers work, and the control seems to truncate decimals -- which is skewing my data. Anyone know about this? I am trying Google and not coming up with much there. Sure could use some experience.. with this or cust might be upset.

adding/subtracting variables -
hi guys, I'm trying to add/subtract variables in vb6 but for some reason the program truncates the decimal number. for example if i have a number say 8 - 4 then it works correctly however if i have 8 - 4.5 the system truncates the '.5'. Any idea on what i should do so that the sytem