Mikko
Different ways
a) if you have a small amount of data you can put it in a MAC program
- see below
b) if you have a largish amount of data why not keep it in a MS Access
database and then just use update queries within MS Access to populate
the Cache database
to get the "correct" update order make sets of queries and then either
run them manually or write a little VB project in Access to update
them
Peter
exaple for update small amounts of data in a MAC routine
set li=0,done=0
while 'done {
set li=li+1
set st=$piece($text(data+li),";;",2)
if st="" set done=1 continue
set x1=$p(st,";",1)
set x2=$p(st,";",2)
set x3=$p(st,";",3)
set x4=$p(st,";",4)
do something with the values
}
data ;;
;;item1;aaaa;bbbbb;cccc;
;;item2;aaaa;bbbbb;cccc;
;;item3;aaaa;bbbbb;cccc;
;;item4;aaaa;bbbbb;cccc;
;;;;
On Mon, 23 Aug 2004 22:18:41 +0300, Mikko Harjula <[EMAIL PROTECTED]>
wrote:
>I begin to have a lot of static configuration/initialization data in
>my application. With relational DB's I used to create sql command
>files to initialize my tables. Is there a way to do this with Cache?
>Note, I don't want random data as with populate but static predefined
>values.
>
>The data initialization should be ascii (well iso-8859-1 :-) so that I
>can easily copy and edit it to create different starting situations.
>Also it should be immune to the internal storage order of properties.
>The manual fiddling of field order with the import/export of sql
>manager for each class is just too much labor. In sql manager there
>is an option to export the field names in the first row but that seems
>to be ignored in import!? Am I missing the obvious solution?
