schema info file

[Guest]

hello everyone,

how do i specify a decimal position for a certain field in my schema file?

(for example:
Col1="AMT" Double Width 10
)
the amount field in the data file does not contain a decimal (i guess it's
assumed).

when i try to import using text provider there is no decimal point. is there
a way i can get that to work?

 

[Cor Ligthert]

Mattie,

Maybe I should know this, however what kind of schema?

Cor

 

[Paul Clement]

¤ hello everyone,
¤
¤ how do i specify a decimal position for a certain field in my schema file?
¤
¤ (for example:
¤ Col1="AMT" Double Width 10
¤ )
¤ the amount field in the data file does not contain a decimal (i guess it's
¤ assumed).
¤
¤ when i try to import using text provider there is no decimal point. is there
¤ a way i can get that to work?

See the following:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcjetschema_ini_file.asp


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)

 

[Guest]

this is the exact article i'm reviewing: my question is
under the topic Specifying Data Type Formats and Conversions
how do you specify those options?

 

[Andy O'Neill]

hello everyone,

how do i specify a decimal position for a certain field in my schema file?

(for example:
Col1="AMT" Double Width 10
)
the amount field in the data file does not contain a decimal (i guess it's
assumed).

Not by the schema.
Your assumption is incorrect.
There can be no assumed or implied decimal point using this method.

when i try to import using text provider there is no decimal point. is
there
a way i can get that to work?

The data file must have a point in numeric fields, or whatever character you
specify using DecimalSymbol
You need to go back to whatever generated the text file and change the
process so it puts decimal places in.
Or, if the decimal place is defiinitely implied to (say) 2 places then
import to a table and then divide by 100.

If you're from one of those countries uses commas for decimal points then
you'll also want to consider fixed width fields as comma delimited will be a
bit of a problem.

 

[Paul Clement]

¤ this is the exact article i'm reviewing: my question is
¤ under the topic Specifying Data Type Formats and Conversions
¤ how do you specify those options?

What is the format of the text for this particular value in the file? In other words, in what
position of the value does the decimal position appear?


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)

 

[Guest]

thanks this helped.

Not by the schema.
Your assumption is incorrect.
There can be no assumed or implied decimal point using this method.


The data file must have a point in numeric fields, or whatever character you
specify using DecimalSymbol
You need to go back to whatever generated the text file and change the
process so it puts decimal places in.
Or, if the decimal place is defiinitely implied to (say) 2 places then
import to a table and then divide by 100.

If you're from one of those countries uses commas for decimal points then
you'll also want to consider fixed width fields as comma delimited will be a
bit of a problem.