T1 is the table alias name – it’s only used to reference the columns to the table (after the work SELECT). The table name should be “Table”
That query is simple, so it should work. Unless there is no layout named “Table”. From: Wayne Irvine [mailto:[email protected]] Sent: Sunday, March 06, 2011 10:39 PM To: [email protected] Subject: Re: Witango-Talk: xDBC? On 07/03/2011, at 1:03 PM, Robert Shubert wrote: That error is being returned from the FileMaker JDBC layer, which means that the configuration in Witango is good and you are now talking to FMP. Yay! Unfortunately there’s not enough information there to know what the problem is. Try a few things: Turn on debug so that you can see what the actual query is. Return debug info but pertinent line is: [Query] [23] SELECT T1.ROWID,T1.Date,T1.Time,T1.Comment FROM Table T1 Is 'T1' the default name for the first table? Try a simple Select action just getting one column from one table, something really simple. Verify the names of the database, layout, and column. I'll get onto that. Wayne _____ To unsubscribe from this list, please send an email to [email protected] with "unsubscribe witango-talk" in the body. ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe witango-talk" in the body.
