Rhys
The best way to do imports in InstantDB is to create the table in
advance. That way, you won't need a schema file.
Pete
----- Original Message -----
From: Rhys Thomas <rthomas@sysreal.com.au>
Date: Wednesday, February 7, 2001 9:06 am
Subject: InstantDB: Importing tables with Primary Keys
> Am I correct that you cannot import a table schema that has with it
> primary key definitions? By that I mean the table imports but the
> primary key, uniqueness and null properties do not.
>
> I was trying the schema in the file TestImport.txt............
>
>
> [TestKey.txt]
> ColNameHeader=True
> CharacterSet=ANSI
> Format=CSVDelimited
>
> Col1=Test_id Integer UNIQUE PRIMARY KEY NOT NULL
> Col2=name Char Width 30
>
> with data in the file TestKey.txt....
>
>
> Test_id, name
> 1,Newmarket
> 2,Kedron
> 3,Kelvin
> 4,Kuraby
> 5,Wilston
>
>
> using the command.........
>
> IMPORT TestKey FROM "database/import/TestKey.txt" USING
> "database/import/TestImport.txt"
> Regards
>
> Rhys Thomas
> -------------------------------------------------------------------
> ----------
> To unsubscribe from this mailing list, send email to
> majordomo@enhydra.orgwith the text "unsubscribe instantdb" in the
> body of the email.
> If you have other questions regarding this mailing list, send
> email to
> the list admin at owner-instantdb@enhydra.org.
>
-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.
|