Topic profile page for Truncate.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: Truncate.
Topic "Truncate" was discussed 5,303 times on 827 sites in last 3 months
Started 4 days, 17 hours ago (2009-12-01 07:32:00)
by evaleah
When I execute the following I get the following error: PLS-00103: Encountered the symbol "TABLE" when expecting one of the following: := . ( @ % ; on the "truncate table BASELINE;" line in the following: CREATE OR REPLACE PROCEDURE TransferData IS BEGIN --clear current tables to allow for clean data truncate table BASELINE;...
Started 1 week, 2 days ago (2009-11-26 21:33:00)
by udeffcv
Hi All, For the Read Only InputText I want to truncate the content at some extent (For Eg:30px). I wrote custom class like : .Truncate af|inputText:read-only.truncate af|inputText::content{ width:50px; height:12px; background-color:InactiveCaptiontext; border:1px Black dotted ; overflow:hidden ; } -- But Its not working For...
Started 1 week, 2 days ago (2009-11-26 05:12:27)
by shobhakazipeta
hi, am using asp.net3.5,c# according my choice,i have to enter Account(col name) data by adding prefix ">" into the column. means like.. >Commission in code behind i have to truncate > from that field . not from sqlserver. how can do this? shobha..
Started 2 weeks, 1 day ago (2009-11-20 09:52:00)
by Rahul
Hi, Sql Server 2005 I am using table variable with in a stored procedure and within a table variable i am using identity field. Sometimes I required to truncate the table variable to rseed the identity, but truncate table variable, dbcc checkident are not working. Any idea... Declare @Columns Table(id Int Identity(1,1), [Name] VarChar(155)); Insert Into @Columns([Name]) Select 'A' Union All ...
Started 2 weeks, 1 day ago (2009-11-20 02:26:00)
by Rahul
Hi, Sql Server 2005 I am using table variable with in a stored procedure and within a table variable i am using identity field. Sometimes I required to truncate the table variable to rseed the identity, but truncate table variable, dbcc checkident are not working. Any idea... Declare @Columns Table(id ...
Started 1 week ago (2009-11-28 13:24:00)
by user8648084
JE 4.0.71, Ubuntu 9.10, JRE 6u16, 2GB JVM Memory, Jboss 5.1.0.GA (je.jar is a local jar in an EAR file). DB will always lock if this is run. In the log the transaction locks on itself??? Am I doing something wrong or misunderstanding the usage of truncateDatabase()? As a workaround I do an uncommitted read of the keys in the DB and then run a ...
Started 4 days ago (2009-12-02 00:28:00)
by atseochat
I have a tool from http://www.hubspot.com and it is telling me that my meta descriptions are longer than 150 characters, and that search engines will truncate them. My meta descriptions come from my auto generated excerpts in wordpress. Is this a problem, or could it be affecting my seo? Any ideas?
Started 2 days, 16 hours ago (2009-12-03 08:20:00)
by Jan Kara
When ext3_write_begin fails after allocating some blocks or generic_perform_write fails to copy data to write, we truncate blocks already instantiated beyond i_size. Although these blocks were never inside i_size, we have to truncate pagecache of these blocks so that corresponding buffers get unmapped. Otherwise subsequent __block_prepare_write (called because we are retrying the...
Started 3 days, 8 hours ago (2009-12-02 16:49:00)
by sprog
Hello there I have a formula in one of my reports: whileprintingrecords; numbervar result; result := truncate({@Balance}); if {@Balance} - result > = 0.5 then result := result +0.5; result; I have been using this report for a couple of years now and just "refresh" after each pay fortnight. Today it is not working and brings the formula up on the screen with the ({@balance}) part ...
Started 3 days, 10 hours ago (2009-12-02 15:10:00)
by Jan Kara
( When ext3_write_begin fails after allocating some blocks or generic_perform_write fails to copy data to write, we truncate blocks already instantiated beyond i_size. Although these blocks were never inside i_size, we have to truncate pagecache of these blocks so that corresponding buffers get unmapped. Otherwise subsequent __block_prepare_write \(called because we are ...
Started 4 days, 3 hours ago (2009-12-01 21:13:00)
by KMCNM
I just want to creat a plain slideshow, one that will not truncate my photos or project them at strange angles or overlap them. I would like to have chapters, so I can organize the slides by city (can I do this with drop zones ?). I do not want any of the preformat-ed shows. How can I do this? intel...
Started 4 days, 10 hours ago (2009-12-01 14:16:00)
by curios_Lee
We're trying to pull a bunch of tables from an Informix SE 7.25 database, truncate some tables on an Oracle schema, and import the Informix tables into the Oracle system. We don't need to modify the data -- just pull from one, truncate, and import into the other system. What's the most efficient (and simple!) way to accomplish this via a Java executable? Thank you.
Started 2 days, 23 hours ago (2009-12-03 01:16:00)
by sgrebs
Hello. Some users write long poems into About me field. In small profile I use to truncate About me field text, but into user profile I show all words. I think it's needed to limit text lenght and adding a characters counter to help the users to stay within the limit while writing.
Started 4 days, 17 hours ago (2009-12-01 07:38:00)
by neel_s
Try this CREATE OR REPLACE PROCEDURE TransferData IS BEGIN --clear current tables to allow for clean data execute immediate 'truncate table BASELINE'; execute immediate 'truncate table TREATMENT'; execute immediate 'truncate table FOLLOWUP'; execute immediate 'truncate table WITHDRAW'; END; truncate is DDL, so ...
Started 6 days, 15 hours ago (2009-11-29 09:45:00)
by pacerier
Re: math.truncate no.. i wasn't talking about a few keystrokes of cos EDIT: i've tested it wrongly, seems like Truncate is faster than Fix den Last edited by pacerier; Yesterday at 09:53 AM .
