-returnfield causing Filemaker error connecting to FMS16

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

-returnfield causing Filemaker error connecting to FMS16

Tim Taplin
Trying to track down why database queries seem to be able to write to but not read from Filemaker16 Server db’s.

Narrowed down to inlines containing -returnfield trigger an error on the Filemaker side.

I notice from an archeological dig thru LassoTalk archives that apparently returnfield doesn’t do anything for Filemaker datasource anyway, but I would expect it to either silently do nothing, or popup a Lasso error  so that we know what’s going on.

Any thoughts or workarounds known ?

Thanks

Tim Taplin


#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: -returnfield causing Filemaker error connecting to FMS16

Jolle Carlestam-2
12 mars 2018 kl. 11:39 skrev Tim Taplin <[hidden email]>:
>
> Trying to track down why database queries seem to be able to write to but not read from Filemaker16 Server db’s.
>
> Narrowed down to inlines containing -returnfield trigger an error on the Filemaker side.
>
> I notice from an archeological dig thru LassoTalk archives that apparently returnfield doesn’t do anything for Filemaker datasource anyway, but I would expect it to either silently do nothing, or popup a Lasso error  so that we know what’s going on.
>
> Any thoughts or workarounds known ?

In theory, should it not work with DS instead of inlines?

HDB
Jolle

#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: -returnfield causing Filemaker error connecting to FMS16

stevepiercy
In reply to this post by Tim Taplin
Create a new layout containing only the fields that you want to
return, and update your inline -table or -layout parameter
accordingly.  Requires code rewrite, but it will improve
performance since less data gets serialized and returned.

--steve


On 3/12/18 at 4:39 AM, [hidden email] (Tim Taplin) pronounced:

>Trying to track down why database queries seem to be able to
>write to but not read from Filemaker16 Server db’s.
>Narrowed down to inlines containing -returnfield trigger an
>error on the Filemaker side.
>I notice from an archeological dig thru LassoTalk archives that
>apparently returnfield doesn’t do anything for Filemaker
>datasource anyway, but I would expect it to either silently do
>nothing, or popup a Lasso error  so that we know what’s going on.
>
>Any thoughts or workarounds known ?
>Thanks
>
>Tim Taplin
>
>
>#############################################################
>
>This message is sent to you because you are subscribed to
>the mailing list Lasso [hidden email]
>Official list archives available at http://www.lassotalk.com
>To unsubscribe, E-mail to: <[hidden email]>
>Send administrative queries to  <[hidden email]>

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Steve Piercy              Website Builder              Eugene, OR
<[hidden email]>               <http://www.stevepiercy.com/>


#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: -returnfield causing Filemaker error connecting to FMS16

stevepiercy
In reply to this post by Jolle Carlestam-2
On 3/12/18 at 11:45 AM, [hidden email] (Jolle Carlestam) pronounced:

>In theory, should it not work with DS instead of inlines?

ds does not support FM queries, just SQL queries.

AFAIK, FM does not support SQL queries into its datasource, only
from FM to external SQL datasources.

--steve

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Steve Piercy              Website Builder              Eugene, OR
<[hidden email]>               <http://www.stevepiercy.com/>


#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: -returnfield causing Filemaker error connecting to FMS16

Tim Taplin
Digging a bit deeper into the Filemaker error and comparing the xml query string to some documentation on Filemaker’s Web Publishing, it looks like Lasso is turning the -returnfield keyword into a -field “query parameter” in Filemaker’s xml query syntax, and that parameter is intended to be used in accessing data in container fields.

Still no useful error is displayed, or logged, and no explanation why this worked up until we upgraded from FM11 to FM16. I see the same information in the FM10 documentation as in the FM16 documentation.

Tim Taplin

> On Mar 12, 2018, at 4:54 AM, Steve Piercy - Website Builder <[hidden email]> wrote:
>
> On 3/12/18 at 11:45 AM, [hidden email] (Jolle Carlestam) pronounced:
>
>> In theory, should it not work with DS instead of inlines?
>
> ds does not support FM queries, just SQL queries.
>
> AFAIK, FM does not support SQL queries into its datasource, only from FM to external SQL datasources.
>
> --steve
>
> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> Steve Piercy              Website Builder              Eugene, OR
> <[hidden email]>               <http://www.stevepiercy.com/>
>
>
> #############################################################
>
> This message is sent to you because you are subscribed to
> the mailing list Lasso [hidden email]
> Official list archives available at http://www.lassotalk.com
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>


#############################################################

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>