.csv Dates in 20-Oct-06 fomat won't import/translate into VStuido

[Barry G. Sumpter]

Solved.

I used excel and formatted date columns in dd/mm/yyyy format.
Then saved to .csv
And imported with vStudio into a VarChar(200) fields table.
Then wrote an INSERT INTO / SELECT query.
Once I got it into VStudio it was easier.

I wonder now that I'm writing this if we can add a mapping listbox
To use like the import date into a table procedure.
Where we would be able to define the new table layout and save it 
Etc..


Is it me or is data conversions from one DB to another a pain.
Not just field types but field matching as well.
It's not a next day delivery kind of project.
I'm thinking it's the grunt end of IT.


  Thanks,
     Barry G. Sumpter



-----Original Message-----
From: valentina-studio-bounces+barry=noodlebox.com.au at lists.macserve.net
[mailto:valentina-studio-bounces+barry=noodlebox.com.au at lists.macserve.net]
On Behalf Of Ruslan Zasukhin
Sent: Thursday, 14 August 2008 4:16 AM
To: valentina-studio at lists.macserve.net
Subject: Re: .csv Dates in 20-Oct-06 fomat won't import/translate into
VStuido

On 8/13/08 3:36 AM, "Barry G. Sumpter" <barry at noodlebox.com.au> wrote:

Hi Barry.,

IMPORTANT to understand:

When data are stored INSIDE of db, they do not have any format!
Format of string plays only when numbers are converted to/from strings

> In VStuido I've got a VarChar field which contains a date in the format of
> 20-Oct-06.

Field DO NOT contains it in this format.
    it only convert to it on the fly to display
    

> It's the only way I could get the data in a VStuido DB.
> 
> VStuido can't translate the data by simple changing the field type to
date.
> 
> Does anyone have a SQL statement to change the format into 20/08/2006 ?

Select database in Schema Editor
In the property inspector -- should be few parameters related to date/time
format/ Check them 

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]


_______________________________________________
Valentina-studio mailing list
Valentina-studio at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina-studio