Re: [pilot-db-list] Using DB-Editor or JPilot and Pilot-db

[Madoc T. <ma...@rt...>]

I start w/ a CSV database w/

ScheduleDB:
ID    ServiceID   AttendanceCode  QuantityUnits   TimeIn   TimeOut  Date
123         1              3           10          3:00     5:00   8/2/04

I have entries for these already that give a specific time some ID person
is supposed to be in out and also a lot of other relevant information.

All of these are defaulted to String when I use DB Editor to import a CSV
file.

What I did, was on the palm pilot, Change ID, ServiceID, AttendanceCode
and QuantityUnits to type link to 4 other databases.

nameDB:
ID   Lastname  Firstname

serviceDB:
SID  SName

attendanceDB:
AID  AName

unitDB:
UID  UName

These databases also have predetermined values.

I then added 5 fields all of linked (Lastname, Firstname, ServiceName,
AttendName, UnitName)

I did it this way because I wanted to be able to get a CSV with a schedule
already in there, and be able to create a View that is more user friendly.

ID Lastname Firstname SID AID UID TimeI TimeO Date SName AName UName

NOW, all the links are linked, and the linked are linked. When I am in any
View, even the All one, the values of Lastname, Firstname, SName, AName,
and UName do not show up.
When I select a row to edit, the values do show up, and it asks me if I
want to save.

I know the link/linked are ok. What I want to do is find a way to have it
appear without having to select every row and saving it.

> Hi Madoc,
>
> On Fri, Sep 03, 2004 at 08:53:53AM -0700, Madoc Tsang wrote:
>> Hello,
>>
>> My set up is to have 5 different databases.
>> 4 of them are just for reference.
>>
>> I set up "link"s for the IDs contained in the 5th to the other 4.
>> I created new fields and "linked" to the "link"s I have.
>>
>> When i am viewing the entries by just selecting this database, I am left
>> with my original information (which is all information I need), but the
>> new "linked" fields I created are empty. (which is probably
>> understandable
>> with the way I created this database). What I would like is to be able
>> to
>> have all of those empty fields be set up.
>>
>> Is there any program I can use that will do this? Or is it possible that
>> anyone knows which file/line of the CVS version of pilot-db contains the
>> correct code to determines the values of "linked" fields like editing a
>> row does? When I select a row to view/edit, the correct values are in
>> that, In which case it will ask me to save.
>>
>> To wrap this up, I'm trying to have that already there to make it more
>> user friendly for someone who doesn't know how to use the palm pilot
>> well,
>> or for someone who doesn't want to have to click through all of them to
>> get the correct entries? Maybe there's a program that could rebuild the
>> database?
>
> I must sadly say I did not completely understand your problem, but if
> rebuilding the database would help, it's already there - it's in the
> menu. If it's not enough, can you give a detailed example? Maybe your
> DBs with only 1-2 fictitious rows and a list of operations to try?
> --
> Didi
>
>

-- 
Madoc Tsang