|
by: Batista, Facundo |
last post by:
Here I send it.
Suggestions and all kinds of recomendations are more than welcomed.
If it all goes ok, it'll be a PEP when I finish writing/modifying the code.
Thank you.
.. Facundo
|
by: piero |
last post by:
Hi,
I have a Excel sheet that have a column with mixed data:
column can contain data like "892-234-32A" or like "892298343233432"
I need to get all data column such as "text" to avoid numeric field show as
exponential number.
I'm trying with:
SELECT CAST (CODICE as bigint(25)) FROM
OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel
|
by: David Garamond |
last post by:
In Interbase and Firebird, NUMERIC is implemented as 64-bit integer.
This limits the range to NUMERIC(18, *) but for many uses that's
adequate. And moreover it's fast and efficient.
Is there a way in PostgreSQL to do something similar, i.e. I want to:
- use 64-bit ints, not string bits or arbitrary precision which is
dubbed as "much slower than ints" in the documentation;
- use decimals, like NUMERIC(18,4);
|
by: Oliver Stratmann |
last post by:
Hello All!
I'm looking for a description of the needs of space for a certain data-type.
How much space does e.g. a NUMERIC(1,0)- field take? (??? Bytes?)
Is there a listing in the DB2-online-documentation?
I couldn't find any?
I'm sorry to bother you folks!
Bye!
|
by: Marc Heravi |
last post by:
Hello NG,
for overflow reasons on numerical accumulation
of an int column during SELECTion i have to
change the data type of a column from "int"
to "bigint".
However that doesn't apply to the HOST based DB2,
the customer's administrator told me there is no
"bigint" data type. So which data type would you
propose as an alternative to "bigint" on host
|
|
by: Ken Varn |
last post by:
I have an unknown numeric Type object passed into a function. I want to run
a conversion on a string to convert the string to that Type object and
return an object of that type. Is there some way to do a generic cast or
conversion on the type?
Here is sort of what I want to do:
object MyFunc(Type T, String Str)
{
object o;
|
by: M.A. Oude Kotte |
last post by:
Hi All,
I hope this is the correct mailing list for this question. But neither
postgresql.org nor google could help me out on this subject.
I did find one disturbing topic on the mailing list archives
(http://archives.postgresql.org/pgsql-admin/2000-05/msg00032.php), but
since it was quite old I'm posting my question anyway.
I'm writing a generic database layer that should support a fixed number
of generic numeric types on a number of...
|
by: Pavils Jurjans |
last post by:
Hello,
I am somewhat lost in the implicit/expicit possible/impossible type casting
in C#...
I need to write a class, which among other things, must have wat to read a
numeric value type, and internally convert it so that it could be saved in
database as real number (float). I plan to provide property(set) interface
for reading the value.
|
by: MMcCarthy |
last post by:
Type MemSize RetVal of VarType() Declaration Char Conversion
Boolean 2b vbBoolean(11) CBool()
Byte 1b vbByte(17) CByte()
Currency 8b vbCurrency(6) @ CCur()
Date 8b vbDate(7) CDate()
Decimal 14b vbDecimal(14) CDec()
Integer 2b vbInteger(2) ...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|