Idea for importing!

[Greg Olson-Hyde]

Hi all,

When I export my data from SQLite, ALL fields are enclosed with "".  
When imported into Valentina the integer fields seem to cause  
Valentina to quit.

However, if I make all fields VarChar or Text, the import goes fine.  
Ruslan says he doesn't recommend changing form VarChar to Long or  
Short while the fields contain data, so, I was thinking this may be a  
good idea:

1. Create a table of all VarChar with my correct field names.

2. Import the data.

3. Change the field types to Long, Short and Date as required.

4. Export the data - no more "" enclosing Long, Short and Date fields.

5. Scrap the table.

6. Create a new table with correct field names and types.

7. Re-import the data - done!

Anyone see any problems with this - will it screw up the data or cause  
any other problems?

Cheers

Greg Olson-Hyde
Sydney Australia

2.8 GHz Quad-Core Mac Pro
Mac OS X 10.5.8
RB 2009 r2.1 Pro
Valentina Studio Pro 4.2 trial