There is no sql for a filemaker insert that I know of. For kicks, though I tried it...When I put <@SQL> on the error page for the insert action, all I got was a blank screen.
No I am not trying to insert into an auto-increment field. All fields are text fields. FileMaker does not have a character length limitation, so that is not the issue either. I dunno... Just whenever I change the insert action, it stops working if I save. The work around that I have discovered is to save as, then replace the old file with the new (save as) file. Sounds like a server cache issue maybe? On 6/5/02 4:14 PM, "Ben Johansen" <[EMAIL PROTECTED]> wrote: > Can you post the SQL to the list? > Are you trying to insert a value into an autoincrement field? > > Ben Johansen - http://www.pcforge.com > Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm > Latest downloads & List Archives @ http://www.witango.ws > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] On Behalf Of Tom Carr > Sent: Wednesday, June 05, 2002 2:06 PM > To: Multiple recipients of list witango-talk > Subject: Witango-Talk: Insert error > > Anyone have an idea why an insert keeps messing up? > > Error > An error occurred while processing your request: > > File: recipesubmission.taf > Position: Insert > Class: Internal > Main Error Number: -101 > Secondary Error Number: -105 > > > Debugging does not tell me anything. I have recreated the datasource, > reset > the insert action datasource, checked the datasource password, recreated > the > insert action with no luck. This happened yesterday, and I messed with > it > enough that it got fixed until I added another column to the insert > today. > And now I can't fix it. I am doing all the same things as I did > yesterday to > no avail? > > Any ideas? > > > Tango editor: v4.0.136/MacOS 8.6 > Connecting to fmp 3 datasource > Server: v4.05.019 plug-in/WebStar4/MacOS 8.6 > > > > --> [groundZERĜ] > --> [t:o:m:c:a:r:r] > --> [[EMAIL PROTECTED]] > --> [847:757:4188] > > > ________________________________________________________________________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body > > > ________________________________________________________________________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body --> [groundZERĜ] --> [t:o:m:c:a:r:r] --> [[EMAIL PROTECTED]] --> [847:757:4188] ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body