"CREATE TABLE" for files *.dbf with a custom float column

"CREATE TABLE" for files *.dbf with a custom float column

Post by news.micro » Wed, 25 Feb 2004 22:22:49



How to create dbase file based on SQL-92 which have a FLOAT column like
float(14,2):

=> xxxxxxxxxxxxxx,xx <=

Thanks in advance,
Patrice
 
 
 

"CREATE TABLE" for files *.dbf with a custom float column

Post by Luis Camac » Sat, 28 Feb 2004 05:47:10

N(14,2)

"news.microsoft.com" < XXXX@XXXXX.COM > escribien el mensaje
>> >> How to create dbase file based on SQL-92 which have a FLOAT column like >> float(14,2): >> >> >> xxxxxxxxxxxxxx,xx<<= >> >> Thanks in advance, >> Patrice >> >>

 
 
 

"CREATE TABLE" for files *.dbf with a custom float column

Post by news.micro » Sat, 28 Feb 2004 18:04:49

this solution doesn't run. it makes a float column of (20,4).

With more precision, i test this with odbc.net from Framework.NET v1.1

"Luis Camacho" < XXXX@XXXXX.COM > a rit dans le message de

>>>> >>>> How to create dbase file based on SQL-92 which have a FLOAT column like >>>> float(14,2): >>>> >>>> >> xxxxxxxxxxxxxx,xx<<= >>>> >>>> Thanks in advance, >>>> Patrice >>>> >>>> >> >>
 
 
 

"CREATE TABLE" for files *.dbf with a custom float column

Post by Andre » Sun, 29 Feb 2004 04:44:34

N(14,2): This does not work and gives a syntax error on command.

AndreB.

"Luis Camacho" < XXXX@XXXXX.COM > a rit dans le message de

>>>> >>>> How to create dbase file based on SQL-92 which have a FLOAT column like >>>> float(14,2): >>>> >>>> >> xxxxxxxxxxxxxx,xx<<= >>>> >>>> Thanks in advance, >>>> Patrice >>>> >>>> >> >>
 
 
 

"CREATE TABLE" for files *.dbf with a custom float column

Post by viki » Sat, 06 Mar 2004 21:29:47

If i good know, then float is not supported. Use insead double or numeric.
The precision of them always (20,5).

by,
Viktor

"news.microsoft.com" < XXXX@XXXXX.COM > az albiakat ta a
ketkezhenetben: u37grkt# XXXX@XXXXX.COM ... >> >> How to create dbase file based on SQL-92 which have a FLOAT column like >> float(14,2): >> >> >> xxxxxxxxxxxxxx,xx<<= >> >> Thanks in advance, >> Patrice >> >>