Re: Frontbase
Re: Frontbase
- Subject: Re: Frontbase
- From: David Holt <email@hidden>
- Date: Mon, 2 Oct 2006 12:21:28 -0700
Hmmmm. The data browser in EOModeler isn't showing the inserted
records either. I'll take a closer look at the data as you suggest.
Thanks,
David
On 2 Oct 2006, at 12:18 PM, Chuck Hill wrote:
I would then guess that the flat file import may have appended
spaces to the String/Varchar values. Dates may have also gone in
differently than they do from the app.
Check the SQL that your app is generating. Try it in FrontBase
Manager. See which part of the WHERE clause is failing to match.
After that it sounds like you will have some data cleanup to do.
Regards,
Chuck
On Oct 2, 2006, at 12:13 PM, David Holt wrote:
Hi Chuck,
On 2 Oct 2006, at 12:05 PM, Chuck Hill wrote:
On Oct 2, 2006, at 11:55 AM, David Holt wrote:
Frontbase generates Primary Keys starting at 1000000. I have
just imported a bunch of records with PKs below that range using
Frontbase manager.
What exactly did you do here? I don't see any Import function in
FB manager. Do you mean that you created a new database from
the result of a WRITE ALL?
If you connect to the database there is a flat file importer under
File>Import...
The database already exists and contains several records starting
in the 1000000 range.
I imported a .csv file using the text file import. The primary
keys of the records are from 20000 to 20130. There are several
records that I have inserted through the WO application interface.
Any additional records that I upload show up in the app and in
Frontbase manager.
My WO app will not fetch these additional records, and I can't
figure out why. Is there a mechanism behind the scenes that I
have to reset?
The fetching should have nothing to do with the PK.
This was my assumption!!
You can easily edit the DDL from EOModeler to start PK generation
at 1 instead of 1000000. The only other thing I can think of is
that the import did not update the indexes.
I tried dropping and recreating the index. It didn't have any effect.
Chuck
--
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve
specific problems. http://www.global-village.net/products/
practical_webobjects
--
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems. http://www.global-village.net/products/
practical_webobjects
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden